· 6 years ago · May 15, 2019, 11:00 AM
1-- MySQL Script generated by MySQL Workbench
2-- dom 12 may 2019 14:07:16 CEST
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema PBE
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `PBE` ;
14
15-- -----------------------------------------------------
16-- Schema PBE
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `PBE` DEFAULT CHARACTER SET utf8 ;
19SHOW WARNINGS;
20USE `PBE` ;
21
22-- -----------------------------------------------------
23-- Table `timetables`
24-- -----------------------------------------------------
25DROP TABLE IF EXISTS `timetables` ;
26
27SHOW WARNINGS;
28CREATE TABLE IF NOT EXISTS `timetables` (
29 `idtimetables` VARCHAR(45) NOT NULL,
30 `day` TINYTEXT NULL,
31 `hour` VARCHAR(45) NULL,
32 `subject` TINYTEXT NULL,
33 `room` VARCHAR(45) NULL,
34 PRIMARY KEY (`idtimetables`))
35ENGINE = InnoDB
36DEFAULT CHARACTER SET = utf8;
37
38SHOW WARNINGS;
39
40-- -----------------------------------------------------
41-- Table `tasks`
42-- -----------------------------------------------------
43DROP TABLE IF EXISTS `tasks` ;
44
45SHOW WARNINGS;
46CREATE TABLE IF NOT EXISTS `tasks` (
47 `idtasks` VARCHAR(45) NOT NULL DEFAULT '',
48 `date` DATE NULL,
49 `subject` TINYTEXT NULL,
50 `name` VARCHAR(45) NULL,
51 PRIMARY KEY (`idtasks`))
52ENGINE = InnoDB
53DEFAULT CHARACTER SET = utf8;
54
55SHOW WARNINGS;
56
57-- -----------------------------------------------------
58-- Table `marks`
59-- -----------------------------------------------------
60DROP TABLE IF EXISTS `marks` ;
61
62SHOW WARNINGS;
63CREATE TABLE IF NOT EXISTS `marks` (
64 `idmarks` VARCHAR(45) NOT NULL,
65 `subject` TINYTEXT NULL,
66 `name` MEDIUMTEXT NULL,
67 `mark` FLOAT NULL,
68 PRIMARY KEY (`idmarks`))
69ENGINE = InnoDB;
70
71SHOW WARNINGS;
72
73-- -----------------------------------------------------
74-- Table `students`
75-- -----------------------------------------------------
76DROP TABLE IF EXISTS `students` ;
77
78SHOW WARNINGS;
79CREATE TABLE IF NOT EXISTS `students` (
80 `idstudents` INT NOT NULL,
81 `uid` VARCHAR(45) NULL DEFAULT NULL,
82 PRIMARY KEY (`idstudents`))
83ENGINE = InnoDB
84DEFAULT CHARACTER SET = utf8;
85
86SHOW WARNINGS;
87
88-- -----------------------------------------------------
89-- Data for table `timetables`
90-- -----------------------------------------------------
91START TRANSACTION;
92USE `PBE`;
93INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Tue', '08:00:00', 'TD', 'A4-105');
94INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Tue', '10:00:00', 'PSAVC', 'A4-105');
95INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Tue', '11:00:00', 'DSBM', 'A4-105');
96INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Tue', '12:00:00', 'RP', 'A4-105');
97INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Wed', '08:00:00', 'Lab PBE', 'C4-S10');
98INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Thu', '08:00:00', 'PBE', 'A4-105');
99INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Thu', '10:00:00', 'TD', 'A4-105');
100INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Thu', '12:00:00', 'PSAVC', 'A4-105');
101INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Fri', '08:00:00', 'RP', 'A4-105');
102INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Fri', '10:00:00', 'TD', 'A4-105');
103INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Fri', '11:00:00', 'DSBM', 'A4-105');
104INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Mon', '08:00:00', 'Lab RP', 'D3-006');
105INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Mon', '10:00:00', 'PSAVC', 'A4-105');
106INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, 'Mon', '12:00:00', 'Lab DSBM', 'D3-006');
107INSERT INTO `timetables` (`idtimetables`, `day`, `hour`, `subject`, `room`) VALUES (DEFAULT, '', NULL, NULL, NULL);
108
109COMMIT;
110
111
112-- -----------------------------------------------------
113-- Data for table `tasks`
114-- -----------------------------------------------------
115START TRANSACTION;
116USE `PBE`;
117INSERT INTO `tasks` (`idtasks`, `date`, `subject`, `name`) VALUES (DEFAULT, '2018-09-30', 'AST', 'Prà ctica 1');
118INSERT INTO `tasks` (`idtasks`, `date`, `subject`, `name`) VALUES (DEFAULT, '2018-10-08', 'PBE', 'Project Plan ');
119INSERT INTO `tasks` (`idtasks`, `date`, `subject`, `name`) VALUES (DEFAULT, '2018-10-10', 'AST', 'Prà ctica 2');
120INSERT INTO `tasks` (`idtasks`, `date`, `subject`, `name`) VALUES (DEFAULT, '2018-10-22', 'PBE', 'Requiriment Specification');
121INSERT INTO `tasks` (`idtasks`, `date`, `subject`, `name`) VALUES (DEFAULT, '2018-11-25', 'PBE', 'Critical Design Report');
122INSERT INTO `tasks` (`idtasks`, `date`, `subject`, `name`) VALUES (DEFAULT, '2018-12-05', 'AST', 'Prà ctica 3');
123INSERT INTO `tasks` (`idtasks`, `date`, `subject`, `name`) VALUES (DEFAULT, '2018-12-08', 'AST', 'Prà ctica 4');
124INSERT INTO `tasks` (`idtasks`, `date`, `subject`, `name`) VALUES (DEFAULT, '2018-12-13', 'PBE', 'Final Report');
125
126COMMIT;
127
128
129-- -----------------------------------------------------
130-- Data for table `marks`
131-- -----------------------------------------------------
132START TRANSACTION;
133USE `PBE`;
134INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'AST', 'control teoria', 7.5);
135INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'AST', 'Lab1', 3.2);
136INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'AST', 'Lab2', 4.7);
137INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'AST', 'final', 8.6);
138INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'PBE', 'puzzle1', 2.8);
139INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'PBE', 'puzzle2', 8.4);
140INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'PBE', 'control', 7.3);
141INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'PBE', 'CDR', 8);
142INSERT INTO `marks` (`idmarks`, `subject`, `name`, `mark`) VALUES (DEFAULT, 'PBE', 'FR', 9);
143
144COMMIT;
145
146
147-- -----------------------------------------------------
148-- Data for table `students`
149-- -----------------------------------------------------
150START TRANSACTION;
151USE `PBE`;
152INSERT INTO `students` (`idstudents`, `uid`) VALUES (Néstor GarcÃa Platas, '8d7ed4f6');
153INSERT INTO `students` (`idstudents`, `uid`) VALUES (Santiago Muñoz GarcÃa, 'e9af6348');
154INSERT INTO `students` (`idstudents`, `uid`) VALUES (Javi León Lopez, 'c3868024');
155INSERT INTO `students` (`idstudents`, `uid`) VALUES (Pablo Sanchez de Movellan, 'a69c5c17');
156
157COMMIT;
158
159
160SET SQL_MODE=@OLD_SQL_MODE;
161SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
162SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;