· 4 years ago · Feb 02, 2021, 10:20 PM
1-- MySQL Script generated by MySQL Workbench
2-- Tue Feb 2 23:13:04 2021
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`RENTED`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`RENTED` (
24 `idRENTED` INT NOT NULL,
25 `Y/N` TINYINT NULL,
26 PRIMARY KEY (`idRENTED`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`PARKING`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`PARKING` (
34 `idPARKING` INT NOT NULL,
35 `level` INT NULL,
36 `place_nr` VARCHAR(45) NULL,
37 PRIMARY KEY (`idPARKING`))
38ENGINE = InnoDB;
39
40
41-- -----------------------------------------------------
42-- Table `mydb`.`INSURANCE`
43-- -----------------------------------------------------
44CREATE TABLE IF NOT EXISTS `mydb`.`INSURANCE` (
45 `idINSURANCE` INT NOT NULL,
46 `policy` VARCHAR(45) NULL,
47 PRIMARY KEY (`idINSURANCE`))
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `mydb`.`RENTAL AGREEMENTS`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `mydb`.`RENTAL AGREEMENTS` (
55 `idRENTAL AGREEMENTS` INT NOT NULL,
56 PRIMARY KEY (`idRENTAL AGREEMENTS`))
57ENGINE = InnoDB;
58
59
60-- -----------------------------------------------------
61-- Table `mydb`.`CUSTOMER`
62-- -----------------------------------------------------
63CREATE TABLE IF NOT EXISTS `mydb`.`CUSTOMER` (
64 `idCUSTOMER` INT NOT NULL,
65 `name` VARCHAR(45) NULL,
66 `surname` VARCHAR(45) NULL,
67 `pin` INT NULL,
68 PRIMARY KEY (`idCUSTOMER`))
69ENGINE = InnoDB;
70
71
72-- -----------------------------------------------------
73-- Table `mydb`.`CAR`
74-- -----------------------------------------------------
75CREATE TABLE IF NOT EXISTS `mydb`.`CAR` (
76 `idCAR` INT NOT NULL,
77 `brand` VARCHAR(45) NULL,
78 `plates` INT NULL,
79 `months` INT NULL,
80 `RENTED_idRENTED` INT NOT NULL,
81 `PARKING_idPARKING` INT NOT NULL,
82 `RENTAL AGREEMENTS_idRENTAL AGREEMENTS` INT NOT NULL,
83 `INSURANCE_idINSURANCE` INT NOT NULL,
84 `CUSTOMER_idCUSTOMER` INT NOT NULL,
85 PRIMARY KEY (`idCAR`, `RENTAL AGREEMENTS_idRENTAL AGREEMENTS`, `INSURANCE_idINSURANCE`),
86 INDEX `fk_CAR_RENTED_idx` (`RENTED_idRENTED` ASC) VISIBLE,
87 INDEX `fk_CAR_PARKING1_idx` (`PARKING_idPARKING` ASC) VISIBLE,
88 INDEX `fk_CAR_RENTAL AGREEMENTS1_idx` (`RENTAL AGREEMENTS_idRENTAL AGREEMENTS` ASC) VISIBLE,
89 INDEX `fk_CAR_INSURANCE1_idx` (`INSURANCE_idINSURANCE` ASC) VISIBLE,
90 INDEX `fk_CAR_CUSTOMER1_idx` (`CUSTOMER_idCUSTOMER` ASC) VISIBLE,
91 CONSTRAINT `fk_CAR_RENTED`
92 FOREIGN KEY (`RENTED_idRENTED`)
93 REFERENCES `mydb`.`RENTED` (`idRENTED`)
94 ON DELETE NO ACTION
95 ON UPDATE NO ACTION,
96 CONSTRAINT `fk_CAR_PARKING1`
97 FOREIGN KEY (`PARKING_idPARKING`)
98 REFERENCES `mydb`.`PARKING` (`idPARKING`)
99 ON DELETE NO ACTION
100 ON UPDATE NO ACTION,
101 CONSTRAINT `fk_CAR_RENTAL AGREEMENTS1`
102 FOREIGN KEY (`RENTAL AGREEMENTS_idRENTAL AGREEMENTS`)
103 REFERENCES `mydb`.`RENTAL AGREEMENTS` (`idRENTAL AGREEMENTS`)
104 ON DELETE NO ACTION
105 ON UPDATE NO ACTION,
106 CONSTRAINT `fk_CAR_INSURANCE1`
107 FOREIGN KEY (`INSURANCE_idINSURANCE`)
108 REFERENCES `mydb`.`INSURANCE` (`idINSURANCE`)
109 ON DELETE NO ACTION
110 ON UPDATE NO ACTION,
111 CONSTRAINT `fk_CAR_CUSTOMER1`
112 FOREIGN KEY (`CUSTOMER_idCUSTOMER`)
113 REFERENCES `mydb`.`CUSTOMER` (`idCUSTOMER`)
114 ON DELETE NO ACTION
115 ON UPDATE NO ACTION)
116ENGINE = InnoDB;
117
118
119-- -----------------------------------------------------
120-- Table `mydb`.`CAR CONDITIONS`
121-- -----------------------------------------------------
122CREATE TABLE IF NOT EXISTS `mydb`.`CAR CONDITIONS` (
123 `idCAR CONDITIONS` INT NOT NULL,
124 `desc_date` DATETIME NULL,
125 `CAR_idCAR` INT NOT NULL,
126 PRIMARY KEY (`idCAR CONDITIONS`, `CAR_idCAR`),
127 INDEX `fk_CAR CONDITIONS_CAR1_idx` (`CAR_idCAR` ASC) VISIBLE,
128 CONSTRAINT `fk_CAR CONDITIONS_CAR1`
129 FOREIGN KEY (`CAR_idCAR`)
130 REFERENCES `mydb`.`CAR` (`idCAR`)
131 ON DELETE NO ACTION
132 ON UPDATE NO ACTION)
133ENGINE = InnoDB;
134
135
136-- -----------------------------------------------------
137-- Table `mydb`.`RENTAL HISTORY`
138-- -----------------------------------------------------
139CREATE TABLE IF NOT EXISTS `mydb`.`RENTAL HISTORY` (
140 `idRENTAL HISTORUY` INT NOT NULL,
141 `date_from` DATETIME NULL,
142 `date_to` DATETIME NULL,
143 `CUSTOMER_idCUSTOMER` INT NOT NULL,
144 PRIMARY KEY (`idRENTAL HISTORUY`),
145 INDEX `fk_RENTAL HISTORY_CUSTOMER1_idx` (`CUSTOMER_idCUSTOMER` ASC) VISIBLE,
146 CONSTRAINT `fk_RENTAL HISTORY_CUSTOMER1`
147 FOREIGN KEY (`CUSTOMER_idCUSTOMER`)
148 REFERENCES `mydb`.`CUSTOMER` (`idCUSTOMER`)
149 ON DELETE NO ACTION
150 ON UPDATE NO ACTION)
151ENGINE = InnoDB;
152
153
154-- -----------------------------------------------------
155-- Table `mydb`.`DISCOUNT`
156-- -----------------------------------------------------
157CREATE TABLE IF NOT EXISTS `mydb`.`DISCOUNT` (
158 `idDISCOUNT` INT NOT NULL,
159 `percent` INT NULL,
160 `CUSTOMER_idCUSTOMER` INT NOT NULL,
161 PRIMARY KEY (`idDISCOUNT`),
162 INDEX `fk_DISCOUNT_CUSTOMER1_idx` (`CUSTOMER_idCUSTOMER` ASC) VISIBLE,
163 CONSTRAINT `fk_DISCOUNT_CUSTOMER1`
164 FOREIGN KEY (`CUSTOMER_idCUSTOMER`)
165 REFERENCES `mydb`.`CUSTOMER` (`idCUSTOMER`)
166 ON DELETE NO ACTION
167 ON UPDATE NO ACTION)
168ENGINE = InnoDB;
169
170
171-- -----------------------------------------------------
172-- Table `mydb`.`RENTAL DAYS`
173-- -----------------------------------------------------
174CREATE TABLE IF NOT EXISTS `mydb`.`RENTAL DAYS` (
175 `idRENTAL DAYS` INT NOT NULL,
176 `days` INT NULL,
177 `CUSTOMER_idCUSTOMER` INT NOT NULL,
178 PRIMARY KEY (`idRENTAL DAYS`, `CUSTOMER_idCUSTOMER`),
179 INDEX `fk_RENTAL DAYS_CUSTOMER1_idx` (`CUSTOMER_idCUSTOMER` ASC) VISIBLE,
180 CONSTRAINT `fk_RENTAL DAYS_CUSTOMER1`
181 FOREIGN KEY (`CUSTOMER_idCUSTOMER`)
182 REFERENCES `mydb`.`CUSTOMER` (`idCUSTOMER`)
183 ON DELETE NO ACTION
184 ON UPDATE NO ACTION)
185ENGINE = InnoDB;
186
187
188-- -----------------------------------------------------
189-- Table `mydb`.`INSURANCE TYPE`
190-- -----------------------------------------------------
191CREATE TABLE IF NOT EXISTS `mydb`.`INSURANCE TYPE` (
192 `idINSURANCE TYPE` INT NOT NULL,
193 `date_from` DATETIME NULL,
194 `date_to` DATETIME NULL,
195 `INSURANCE_idINSURANCE` INT NOT NULL,
196 PRIMARY KEY (`idINSURANCE TYPE`, `INSURANCE_idINSURANCE`),
197 INDEX `fk_INSURANCE TYPE_INSURANCE1_idx` (`INSURANCE_idINSURANCE` ASC) VISIBLE,
198 CONSTRAINT `fk_INSURANCE TYPE_INSURANCE1`
199 FOREIGN KEY (`INSURANCE_idINSURANCE`)
200 REFERENCES `mydb`.`INSURANCE` (`idINSURANCE`)
201 ON DELETE NO ACTION
202 ON UPDATE NO ACTION)
203ENGINE = InnoDB;
204
205
206-- -----------------------------------------------------
207-- Table `mydb`.`HIRED TIMES`
208-- -----------------------------------------------------
209CREATE TABLE IF NOT EXISTS `mydb`.`HIRED TIMES` (
210 `idHIRED TIMES` INT NOT NULL,
211 `date_from` DATETIME NULL,
212 `date_to` DATETIME NULL,
213 `CAR_idCAR` INT NOT NULL,
214 PRIMARY KEY (`idHIRED TIMES`, `CAR_idCAR`),
215 INDEX `fk_HIRED TIMES_CAR1_idx` (`CAR_idCAR` ASC) VISIBLE,
216 CONSTRAINT `fk_HIRED TIMES_CAR1`
217 FOREIGN KEY (`CAR_idCAR`)
218 REFERENCES `mydb`.`CAR` (`idCAR`)
219 ON DELETE NO ACTION
220 ON UPDATE NO ACTION)
221ENGINE = InnoDB;
222
223
224-- -----------------------------------------------------
225-- Table `mydb`.`OPINION`
226-- -----------------------------------------------------
227CREATE TABLE IF NOT EXISTS `mydb`.`OPINION` (
228 `idOPINION` INT NOT NULL,
229 `desc` VARCHAR(45) NULL,
230 `CUSTOMER_idCUSTOMER` INT NOT NULL,
231 PRIMARY KEY (`idOPINION`, `CUSTOMER_idCUSTOMER`),
232 INDEX `fk_OPINION_CUSTOMER1_idx` (`CUSTOMER_idCUSTOMER` ASC) VISIBLE,
233 CONSTRAINT `fk_OPINION_CUSTOMER1`
234 FOREIGN KEY (`CUSTOMER_idCUSTOMER`)
235 REFERENCES `mydb`.`CUSTOMER` (`idCUSTOMER`)
236 ON DELETE NO ACTION
237 ON UPDATE NO ACTION)
238ENGINE = InnoDB;
239
240
241-- -----------------------------------------------------
242-- Table `mydb`.`CAR HIRE AGENCY`
243-- -----------------------------------------------------
244CREATE TABLE IF NOT EXISTS `mydb`.`CAR HIRE AGENCY` (
245 `idCAR HIRE AGENCY` INT NOT NULL,
246 `city` VARCHAR(45) NULL,
247 `address` VARCHAR(45) NULL,
248 PRIMARY KEY (`idCAR HIRE AGENCY`))
249ENGINE = InnoDB;
250
251
252-- -----------------------------------------------------
253-- Table `mydb`.`FIND CAR`
254-- -----------------------------------------------------
255CREATE TABLE IF NOT EXISTS `mydb`.`FIND CAR` (
256 `idFIND CARcol` INT NOT NULL,
257 `CAR_idCAR` INT NOT NULL,
258 `CAR HIRE AGENCY_idCAR HIRE AGENCY` INT NOT NULL,
259 PRIMARY KEY (`idFIND CARcol`, `CAR_idCAR`, `CAR HIRE AGENCY_idCAR HIRE AGENCY`),
260 INDEX `fk_CAR_has_CAR HIRE AGENCY_CAR HIRE AGENCY1_idx` (`CAR HIRE AGENCY_idCAR HIRE AGENCY` ASC) VISIBLE,
261 INDEX `fk_CAR_has_CAR HIRE AGENCY_CAR1_idx` (`CAR_idCAR` ASC) VISIBLE,
262 CONSTRAINT `fk_CAR_has_CAR HIRE AGENCY_CAR1`
263 FOREIGN KEY (`CAR_idCAR`)
264 REFERENCES `mydb`.`CAR` (`idCAR`)
265 ON DELETE NO ACTION
266 ON UPDATE NO ACTION,
267 CONSTRAINT `fk_CAR_has_CAR HIRE AGENCY_CAR HIRE AGENCY1`
268 FOREIGN KEY (`CAR HIRE AGENCY_idCAR HIRE AGENCY`)
269 REFERENCES `mydb`.`CAR HIRE AGENCY` (`idCAR HIRE AGENCY`)
270 ON DELETE NO ACTION
271 ON UPDATE NO ACTION)
272ENGINE = InnoDB;
273
274
275-- -----------------------------------------------------
276-- Table `mydb`.`RENTAL AGREEMENTS_has_CUSTOMER`
277-- -----------------------------------------------------
278CREATE TABLE IF NOT EXISTS `mydb`.`RENTAL AGREEMENTS_has_CUSTOMER` (
279 `idRENTAL AGREEMENTS_has_CUSTOMERcol` VARCHAR(45) NOT NULL,
280 `RENTAL AGREEMENTS_idRENTAL AGREEMENTS` INT NOT NULL,
281 `CUSTOMER_idCUSTOMER` INT NOT NULL,
282 PRIMARY KEY (`idRENTAL AGREEMENTS_has_CUSTOMERcol`, `RENTAL AGREEMENTS_idRENTAL AGREEMENTS`, `CUSTOMER_idCUSTOMER`),
283 INDEX `fk_RENTAL AGREEMENTS_has_CUSTOMER_CUSTOMER1_idx` (`CUSTOMER_idCUSTOMER` ASC) VISIBLE,
284 INDEX `fk_RENTAL AGREEMENTS_has_CUSTOMER_RENTAL AGREEMENTS1_idx` (`RENTAL AGREEMENTS_idRENTAL AGREEMENTS` ASC) VISIBLE,
285 CONSTRAINT `fk_RENTAL AGREEMENTS_has_CUSTOMER_RENTAL AGREEMENTS1`
286 FOREIGN KEY (`RENTAL AGREEMENTS_idRENTAL AGREEMENTS`)
287 REFERENCES `mydb`.`RENTAL AGREEMENTS` (`idRENTAL AGREEMENTS`)
288 ON DELETE NO ACTION
289 ON UPDATE NO ACTION,
290 CONSTRAINT `fk_RENTAL AGREEMENTS_has_CUSTOMER_CUSTOMER1`
291 FOREIGN KEY (`CUSTOMER_idCUSTOMER`)
292 REFERENCES `mydb`.`CUSTOMER` (`idCUSTOMER`)
293 ON DELETE NO ACTION
294 ON UPDATE NO ACTION)
295ENGINE = InnoDB;
296
297
298-- -----------------------------------------------------
299-- Table `mydb`.`CAR CONDITIONS_accordting_HIRED TIMES`
300-- -----------------------------------------------------
301CREATE TABLE IF NOT EXISTS `mydb`.`CAR CONDITIONS_accordting_HIRED TIMES` (
302 `CAR CONDITIONS_accordting_HIRED TIMEScol` VARCHAR(45) NOT NULL,
303 `CAR CONDITIONS_idCAR CONDITIONS` INT NOT NULL,
304 `CAR CONDITIONS_CAR_idCAR` INT NOT NULL,
305 `HIRED TIMES_idHIRED TIMES` INT NOT NULL,
306 `HIRED TIMES_CAR_idCAR` INT NOT NULL,
307 PRIMARY KEY (`CAR CONDITIONS_accordting_HIRED TIMEScol`, `CAR CONDITIONS_idCAR CONDITIONS`, `CAR CONDITIONS_CAR_idCAR`, `HIRED TIMES_idHIRED TIMES`, `HIRED TIMES_CAR_idCAR`),
308 INDEX `fk_CAR CONDITIONS_has_HIRED TIMES_HIRED TIMES1_idx` (`HIRED TIMES_idHIRED TIMES` ASC, `HIRED TIMES_CAR_idCAR` ASC) VISIBLE,
309 INDEX `fk_CAR CONDITIONS_has_HIRED TIMES_CAR CONDITIONS1_idx` (`CAR CONDITIONS_idCAR CONDITIONS` ASC, `CAR CONDITIONS_CAR_idCAR` ASC) VISIBLE,
310 CONSTRAINT `fk_CAR CONDITIONS_has_HIRED TIMES_CAR CONDITIONS1`
311 FOREIGN KEY (`CAR CONDITIONS_idCAR CONDITIONS` , `CAR CONDITIONS_CAR_idCAR`)
312 REFERENCES `mydb`.`CAR CONDITIONS` (`idCAR CONDITIONS` , `CAR_idCAR`)
313 ON DELETE NO ACTION
314 ON UPDATE NO ACTION,
315 CONSTRAINT `fk_CAR CONDITIONS_has_HIRED TIMES_HIRED TIMES1`
316 FOREIGN KEY (`HIRED TIMES_idHIRED TIMES` , `HIRED TIMES_CAR_idCAR`)
317 REFERENCES `mydb`.`HIRED TIMES` (`idHIRED TIMES` , `CAR_idCAR`)
318 ON DELETE NO ACTION
319 ON UPDATE NO ACTION)
320ENGINE = InnoDB;
321
322
323-- -----------------------------------------------------
324-- Table `mydb`.`CAR CONDITIONS_accordting_HIRED TIMES_has_INSURANCE TYPE`
325-- -----------------------------------------------------
326CREATE TABLE IF NOT EXISTS `mydb`.`CAR CONDITIONS_accordting_HIRED TIMES_has_INSURANCE TYPE` (
327 `idCAR CONDITIONS_accordting_HIRED TIMES_has_INSURANCE TYPEcol` VARCHAR(45) NOT NULL,
328 `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_accordting_HIRED TIMEScol` VARCHAR(45) NOT NULL,
329 `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_idCAR CONDITIONS` INT NOT NULL,
330 `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_CAR_idCAR` INT NOT NULL,
331 `CAR CONDITIONS_accordting_HIRED TIMES_HIRED TIMES_idHIRED TIMES` INT NOT NULL,
332 `CAR CONDITIONS_accordting_HIRED TIMES_HIRED TIMES_CAR_idCAR` INT NOT NULL,
333 `INSURANCE TYPE_idINSURANCE TYPE` INT NOT NULL,
334 `INSURANCE TYPE_INSURANCE_idINSURANCE` INT NOT NULL,
335 PRIMARY KEY (`idCAR CONDITIONS_accordting_HIRED TIMES_has_INSURANCE TYPEcol`, `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_accordting_HIRED TIMEScol`, `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_idCAR CONDITIONS`, `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_CAR_idCAR`, `CAR CONDITIONS_accordting_HIRED TIMES_HIRED TIMES_idHIRED TIMES`, `CAR CONDITIONS_accordting_HIRED TIMES_HIRED TIMES_CAR_idCAR`, `INSURANCE TYPE_idINSURANCE TYPE`, `INSURANCE TYPE_INSURANCE_idINSURANCE`),
336 INDEX `fk_CAR CONDITIONS_accordting_HIRED TIMES_has_INSURANCE TYPE_idx` (`INSURANCE TYPE_idINSURANCE TYPE` ASC, `INSURANCE TYPE_INSURANCE_idINSURANCE` ASC) VISIBLE,
337 INDEX `fk_CAR CONDITIONS_accordting_HIRED TIMES_has_INSURANCE TYPE_idx1` (`CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_accordting_HIRED TIMEScol` ASC, `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_idCAR CONDITIONS` ASC, `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_CAR_idCAR` ASC, `CAR CONDITIONS_accordting_HIRED TIMES_HIRED TIMES_idHIRED TIMES` ASC, `CAR CONDITIONS_accordting_HIRED TIMES_HIRED TIMES_CAR_idCAR` ASC) VISIBLE,
338 CONSTRAINT `fk_CAR CONDITIONS_accordting_HIRED TIMES_has_INSURANCE TYPE_C1`
339 FOREIGN KEY (`CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_accordting_HIRED TIMEScol` , `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_idCAR CONDITIONS` , `CAR CONDITIONS_accordting_HIRED TIMES_CAR CONDITIONS_CAR_idCAR` , `CAR CONDITIONS_accordting_HIRED TIMES_HIRED TIMES_idHIRED TIMES` , `CAR CONDITIONS_accordting_HIRED TIMES_HIRED TIMES_CAR_idCAR`)
340 REFERENCES `mydb`.`CAR CONDITIONS_accordting_HIRED TIMES` (`CAR CONDITIONS_accordting_HIRED TIMEScol` , `CAR CONDITIONS_idCAR CONDITIONS` , `CAR CONDITIONS_CAR_idCAR` , `HIRED TIMES_idHIRED TIMES` , `HIRED TIMES_CAR_idCAR`)
341 ON DELETE NO ACTION
342 ON UPDATE NO ACTION,
343 CONSTRAINT `fk_CAR CONDITIONS_accordting_HIRED TIMES_has_INSURANCE TYPE_I1`
344 FOREIGN KEY (`INSURANCE TYPE_idINSURANCE TYPE` , `INSURANCE TYPE_INSURANCE_idINSURANCE`)
345 REFERENCES `mydb`.`INSURANCE TYPE` (`idINSURANCE TYPE` , `INSURANCE_idINSURANCE`)
346 ON DELETE NO ACTION
347 ON UPDATE NO ACTION)
348ENGINE = InnoDB;
349
350
351SET SQL_MODE=@OLD_SQL_MODE;
352SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
353SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;