rck5YZ1q

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7
8
9CREATE SCHEMA IF NOT EXISTS `traveltemp` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
10
11USE `traveltemp` ;
12
13
14
15-- -----------------------------------------------------
16
17-- Table `traveltemp`.`pnr`
18
19-- -----------------------------------------------------
20
21CREATE  TABLE IF NOT EXISTS `traveltemp`.`pnr` (
22
23  `id` INT NOT NULL AUTO_INCREMENT ,
24
25  `service` TEXT NULL ,
26
27  `dateStart` DATE NULL ,
28
29  `dateStop` DATE NULL ,
30
31  `traveler` TEXT NULL ,
32
33  `totalPrice` TEXT NULL ,
34
35  `dateCreation` DATE NULL ,
36
37  `status` TEXT NULL ,
38
39  PRIMARY KEY (`id`) )
40
41ENGINE = InnoDB;
42
43
44
45
46
47
48
49SET SQL_MODE=@OLD_SQL_MODE;
50
51SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
52
53SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;