Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # ************************************************************
- # Sequel Pro SQL dump
- # Version 4135
- #
- # http://www.sequelpro.com/
- # http://code.google.com/p/sequel-pro/
- #
- # Host: 127.0.0.1 (MySQL 5.6.25)
- # Database: tfg
- # Generation Time: 2015-08-30 09:49:34 +0000
- # ************************************************************
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- # Dump of table projects
- # ------------------------------------------------------------
- DROP TABLE IF EXISTS `projects`;
- CREATE TABLE `projects` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `description` varchar(200) COLLATE utf8_spanish_ci DEFAULT NULL,
- `name` varchar(90) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
- LOCK TABLES `projects` WRITE;
- /*!40000 ALTER TABLE `projects` DISABLE KEYS */;
- INSERT INTO `projects` (`id`, `description`, `name`)
- VALUES
- (1,'test','test');
- /*!40000 ALTER TABLE `projects` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table professor_users
- # ------------------------------------------------------------
- DROP TABLE IF EXISTS `professor_users`;
- CREATE TABLE `professor_users` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `professor_id` int(11) unsigned NOT NULL,
- PRIMARY KEY (`id`),
- KEY `user_id` (`professor_id`),
- CONSTRAINT `professor_users_ibfk_1` FOREIGN KEY (`professor_id`) REFERENCES `users` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
- LOCK TABLES `professor_users` WRITE;
- /*!40000 ALTER TABLE `professor_users` DISABLE KEYS */;
- INSERT INTO `professor_users` (`id`, `professor_id`)
- VALUES
- (1,2);
- /*!40000 ALTER TABLE `professor_users` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table project_users
- # ------------------------------------------------------------
- DROP TABLE IF EXISTS `project_users`;
- CREATE TABLE `project_users` (
- `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `project_id` int(11) unsigned NOT NULL,
- `user_id` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id`),
- KEY `project_id` (`project_id`),
- KEY `professor_id` (`user_id`),
- CONSTRAINT `project_users_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`),
- CONSTRAINT `project_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
- LOCK TABLES `project_users` WRITE;
- /*!40000 ALTER TABLE `project_users` DISABLE KEYS */;
- INSERT INTO `project_users` (`id`, `project_id`, `user_id`)
- VALUES
- (1,1,2),
- (2,1,1);
- /*!40000 ALTER TABLE `project_users` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table student_users
- # ------------------------------------------------------------
- DROP TABLE IF EXISTS `student_users`;
- CREATE TABLE `student_users` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `student_id` int(11) unsigned NOT NULL,
- PRIMARY KEY (`id`),
- KEY `user_id` (`student_id`),
- CONSTRAINT `student_users_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `users` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
- LOCK TABLES `student_users` WRITE;
- /*!40000 ALTER TABLE `student_users` DISABLE KEYS */;
- INSERT INTO `student_users` (`id`, `student_id`)
- VALUES
- (1,1);
- /*!40000 ALTER TABLE `student_users` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table users
- # ------------------------------------------------------------
- DROP TABLE IF EXISTS `users`;
- CREATE TABLE `users` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(20) COLLATE utf8_spanish_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
- LOCK TABLES `users` WRITE;
- /*!40000 ALTER TABLE `users` DISABLE KEYS */;
- INSERT INTO `users` (`id`, `name`)
- VALUES
- (1,'Kate'),
- (2,'John');
- /*!40000 ALTER TABLE `users` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement