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