· 8 years ago · Mar 04, 2018, 01:22 AM
1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `default_schema` ;
6USE `default_schema` ;
7
8-- -----------------------------------------------------
9-- Table `default_schema`.`thesisType`
10-- -----------------------------------------------------
11DROP TABLE IF EXISTS `default_schema`.`thesisType` ;
12
13CREATE TABLE IF NOT EXISTS `default_schema`.`thesisType` (
14 `thesisType` INT NOT NULL DEFAULT NULL ,
15 `type` VARCHAR(100) NULL DEFAULT NULL ,
16 PRIMARY KEY (`thesisType`) );
17
18
19-- -----------------------------------------------------
20-- Table `default_schema`.`title`
21-- -----------------------------------------------------
22DROP TABLE IF EXISTS `default_schema`.`title` ;
23
24CREATE TABLE IF NOT EXISTS `default_schema`.`title` (
25 `title` INT NOT NULL DEFAULT NULL ,
26 `language` VARCHAR(100) NULL DEFAULT NULL ,
27 `name` VARCHAR(100) NULL DEFAULT NULL ,
28 PRIMARY KEY (`title`) );
29
30
31-- -----------------------------------------------------
32-- Table `default_schema`.`author`
33-- -----------------------------------------------------
34DROP TABLE IF EXISTS `default_schema`.`author` ;
35
36CREATE TABLE IF NOT EXISTS `default_schema`.`author` (
37 `author` INT NOT NULL DEFAULT NULL ,
38 `name` VARCHAR(100) NULL DEFAULT NULL ,
39 `university` VARCHAR(100) NULL DEFAULT NULL ,
40 `study` VARCHAR(100) NULL DEFAULT NULL ,
41 `course` VARCHAR(100) NULL DEFAULT NULL ,
42 `examinationDate` DATE NULL DEFAULT NULL ,
43 `email` VARCHAR(100) NULL DEFAULT NULL ,
44 PRIMARY KEY (`author`) );
45
46
47-- -----------------------------------------------------
48-- Table `default_schema`.`signatureThesis`
49-- -----------------------------------------------------
50DROP TABLE IF EXISTS `default_schema`.`signatureThesis` ;
51
52CREATE TABLE IF NOT EXISTS `default_schema`.`signatureThesis` (
53 `signatureThesis` INT NOT NULL DEFAULT NULL ,
54 `cooporatedCompany` VARCHAR(100) NULL DEFAULT NULL ,
55 `publicAccessible` TINYINT(1) NULL DEFAULT NULL ,
56 `lockedUntil` DATE NULL DEFAULT NULL ,
57 PRIMARY KEY (`signatureThesis`) );
58
59
60-- -----------------------------------------------------
61-- Table `default_schema`.`attachmentType`
62-- -----------------------------------------------------
63DROP TABLE IF EXISTS `default_schema`.`attachmentType` ;
64
65CREATE TABLE IF NOT EXISTS `default_schema`.`attachmentType` (
66 `attachmentType` INT NOT NULL DEFAULT NULL ,
67 `name` VARCHAR(100) NULL DEFAULT NULL ,
68 PRIMARY KEY (`attachmentType`) );
69
70
71-- -----------------------------------------------------
72-- Table `default_schema`.`attachment`
73-- -----------------------------------------------------
74DROP TABLE IF EXISTS `default_schema`.`attachment` ;
75
76CREATE TABLE IF NOT EXISTS `default_schema`.`attachment` (
77 `attachment` INT NOT NULL DEFAULT NULL ,
78 `attachmentType` INT NULL DEFAULT NULL ,
79 `signatur` VARCHAR(100) NULL DEFAULT NULL ,
80 `name` VARCHAR(255) NULL DEFAULT NULL ,
81 PRIMARY KEY (`attachment`) ,
82 INDEX `FK_attachmentType` (`attachmentType` ASC) ,
83 CONSTRAINT `FK_attachmentType`
84 FOREIGN KEY (`attachmentType` )
85 REFERENCES `default_schema`.`attachmentType` (`attachmentType` )
86 ON DELETE NO ACTION
87 ON UPDATE NO ACTION);
88
89
90-- -----------------------------------------------------
91-- Table `default_schema`.`examinatorType`
92-- -----------------------------------------------------
93DROP TABLE IF EXISTS `default_schema`.`examinatorType` ;
94
95CREATE TABLE IF NOT EXISTS `default_schema`.`examinatorType` (
96 `examinatorType` INT NOT NULL DEFAULT NULL ,
97 `name` VARCHAR(100) NULL DEFAULT NULL ,
98 PRIMARY KEY (`examinatorType`) );
99
100
101-- -----------------------------------------------------
102-- Table `default_schema`.`examinator`
103-- -----------------------------------------------------
104DROP TABLE IF EXISTS `default_schema`.`examinator` ;
105
106CREATE TABLE IF NOT EXISTS `default_schema`.`examinator` (
107 `examinator` INT NOT NULL DEFAULT NULL ,
108 `givename` VARCHAR(50) NULL DEFAULT NULL ,
109 `surname` VARCHAR(50) NULL DEFAULT NULL ,
110 `title` VARCHAR(50) NULL DEFAULT NULL ,
111 `universityMember` INT(1) NULL DEFAULT NULL ,
112 `email` VARCHAR(100) NULL DEFAULT NULL ,
113 `eximinatorType` INT NULL DEFAULT NULL ,
114 PRIMARY KEY (`examinator`) ,
115 INDEX `FK_examinatorType` (`eximinatorType` ASC) ,
116 CONSTRAINT `FK_examinatorType`
117 FOREIGN KEY (`eximinatorType` )
118 REFERENCES `default_schema`.`examinatorType` (`examinatorType` )
119 ON DELETE NO ACTION
120 ON UPDATE NO ACTION);
121
122
123-- -----------------------------------------------------
124-- Table `default_schema`.`thesis`
125-- -----------------------------------------------------
126DROP TABLE IF EXISTS `default_schema`.`thesis` ;
127
128CREATE TABLE IF NOT EXISTS `default_schema`.`thesis` (
129 `thesisType` INT NULL DEFAULT NULL ,
130 `title` INT NULL DEFAULT NULL ,
131 `author` INT NULL DEFAULT NULL ,
132 `completedYear` INT(4) NULL DEFAULT NULL ,
133 `signatureThesis` INT NULL DEFAULT NULL ,
134 `attachment` INT NULL DEFAULT NULL ,
135 `examinator` INT NULL DEFAULT NULL ,
136 INDEX `FK_thesisType` (`thesisType` ASC) ,
137 INDEX `FK_title` (`title` ASC) ,
138 INDEX `FK_author` (`author` ASC) ,
139 INDEX `FK_signatureThesis` (`signatureThesis` ASC) ,
140 INDEX `FK_attachment` (`attachment` ASC) ,
141 INDEX `FK_examinator` (`examinator` ASC) ,
142 CONSTRAINT `FK_thesisType`
143 FOREIGN KEY (`thesisType` )
144 REFERENCES `default_schema`.`thesisType` (`thesisType` )
145 ON DELETE NO ACTION
146 ON UPDATE NO ACTION,
147 CONSTRAINT `FK_title`
148 FOREIGN KEY (`title` )
149 REFERENCES `default_schema`.`title` (`title` )
150 ON DELETE NO ACTION
151 ON UPDATE NO ACTION,
152 CONSTRAINT `FK_author`
153 FOREIGN KEY (`author` )
154 REFERENCES `default_schema`.`author` (`author` )
155 ON DELETE NO ACTION
156 ON UPDATE NO ACTION,
157 CONSTRAINT `FK_signatureThesis`
158 FOREIGN KEY (`signatureThesis` )
159 REFERENCES `default_schema`.`signatureThesis` (`signatureThesis` )
160 ON DELETE NO ACTION
161 ON UPDATE NO ACTION,
162 CONSTRAINT `FK_attachment`
163 FOREIGN KEY (`attachment` )
164 REFERENCES `default_schema`.`attachment` (`attachment` )
165 ON DELETE NO ACTION
166 ON UPDATE NO ACTION,
167 CONSTRAINT `FK_examinator`
168 FOREIGN KEY (`examinator` )
169 REFERENCES `default_schema`.`examinator` (`examinator` )
170 ON DELETE NO ACTION
171 ON UPDATE NO ACTION);
172
173
174
175SET SQL_MODE=@OLD_SQL_MODE;
176SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
177SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;