ywtvpjsd

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
5
6-- -----------------------------------------------------
7-- Table `Sooduskaart`
8-- -----------------------------------------------------
9DROP TABLE IF EXISTS `Sooduskaart` ;
10
11SHOW WARNINGS;
12CREATE  TABLE IF NOT EXISTS `Sooduskaart` (
13  `Nr(ID)` INT NOT NULL AUTO_INCREMENT ,
14  `Tase` INT NOT NULL DEFAULT 0 ,
15  `Nimi` VARCHAR(100) NULL DEFAULT NULL ,
16  `Aadress` VARCHAR(100) NULL DEFAULT NULL ,
17  `Telefon` INT NULL DEFAULT NULL ,
18  PRIMARY KEY (`Nr(ID)`) )
19ENGINE = InnoDB
20DEFAULT CHARACTER SET = utf8
21COLLATE = utf8_estonian_ci;
22
23SHOW WARNINGS;
24
25-- -----------------------------------------------------
26-- Table `Toode`
27-- -----------------------------------------------------
28DROP TABLE IF EXISTS `Toode` ;
29
30SHOW WARNINGS;
31CREATE  TABLE IF NOT EXISTS `Toode` (
32  `Triipkood` INT NOT NULL AUTO_INCREMENT ,
33  `Tooteinfo` VARCHAR(4500) NULL ,
34  `Hind` FLOAT NOT NULL ,
35  `Kohal` INT NULL ,
36  `Laos` INT NULL ,
37  PRIMARY KEY (`Triipkood`) )
38ENGINE = InnoDB
39DEFAULT CHARACTER SET = ucs2
40COLLATE = ucs2_estonian_ci;
41
42SHOW WARNINGS;
43
44-- -----------------------------------------------------
45-- Table `Myyk`
46-- -----------------------------------------------------
47DROP TABLE IF EXISTS `Myyk` ;
48
49SHOW WARNINGS;
50CREATE  TABLE IF NOT EXISTS `Myyk` (
51  `TsekiNrID` INT NOT NULL AUTO_INCREMENT ,
52  `Kuupaev` TIMESTAMP NOT NULL ,
53  `Koguhind` FLOAT NOT NULL ,
54  `Lopphind` FLOAT NOT NULL ,
55  `Sooduskaart` INT NOT NULL ,
56  `Soodustase` INT NOT NULL ,
57  PRIMARY KEY (`TsekiNrID`) ,
58  CONSTRAINT `Sooduskaart`
59    FOREIGN KEY (`Sooduskaart` )
60    REFERENCES `mydb`.`Sooduskaart` (`Nr(ID)` )
61    ON DELETE NO ACTION
62    ON UPDATE NO ACTION,
63  CONSTRAINT `Soodustase`
64    FOREIGN KEY (`Soodustase` )
65    REFERENCES `mydb`.`Sooduskaart` (`Tase` )
66    ON DELETE NO ACTION
67    ON UPDATE NO ACTION)
68ENGINE = InnoDB;
69
70SHOW WARNINGS;
71CREATE INDEX `Sooduskaart` ON `Myyk` (`Sooduskaart` ASC) ;
72
73SHOW WARNINGS;
74CREATE INDEX `Soodustase` ON `Myyk` (`Soodustase` ASC) ;
75
76SHOW WARNINGS;
77
78-- -----------------------------------------------------
79-- Table `Toode_2_Myyk`
80-- -----------------------------------------------------
81DROP TABLE IF EXISTS `Toode_2_Myyk` ;
82
83SHOW WARNINGS;
84CREATE  TABLE IF NOT EXISTS `Toode_2_Myyk` (
85  `Toode_Triipkood` INT NOT NULL ,
86  `Myyk_TsekiNrID` INT NOT NULL ,
87  PRIMARY KEY (`Toode_Triipkood`, `Myyk_TsekiNrID`) ,
88  CONSTRAINT `fk_Toode_has_Myyk_Toode`
89    FOREIGN KEY (`Toode_Triipkood` )
90    REFERENCES `mydb`.`Toode` (`Triipkood` )
91    ON DELETE NO ACTION
92    ON UPDATE NO ACTION,
93  CONSTRAINT `fk_Toode_has_Myyk_Myyk`
94    FOREIGN KEY (`Myyk_TsekiNrID` )
95    REFERENCES `mydb`.`Myyk` (`TsekiNrID` )
96    ON DELETE NO ACTION
97    ON UPDATE NO ACTION);
98
99SHOW WARNINGS;
100CREATE INDEX `fk_Toode_has_Myyk_Toode` ON `Toode_2_Myyk` (`Toode_Triipkood` ASC) ;
101
102SHOW WARNINGS;
103CREATE INDEX `fk_Toode_has_Myyk_Myyk` ON `Toode_2_Myyk` (`Myyk_TsekiNrID` ASC) ;
104
105SHOW WARNINGS;
106
107-- -----------------------------------------------------
108-- Data for table `Sooduskaart`
109-- -----------------------------------------------------
110SET AUTOCOMMIT=0;
111INSERT INTO `Sooduskaart` (`Nr(ID)`, `Tase`, `Nimi`, `Aadress`, `Telefon`) VALUES (0000, 0, '', '', 0);
112INSERT INTO `Sooduskaart` (`Nr(ID)`, `Tase`, `Nimi`, `Aadress`, `Telefon`) VALUES (0001, 1, 'Helina Pirukas', 'Kanepi', 455587538);
113INSERT INTO `Sooduskaart` (`Nr(ID)`, `Tase`, `Nimi`, `Aadress`, `Telefon`) VALUES (0002, 3, 'Alar Laheuss', 'Saue', 35737539);
114INSERT INTO `Sooduskaart` (`Nr(ID)`, `Tase`, `Nimi`, `Aadress`, `Telefon`) VALUES (0003, 2, 'Mikk Rõõmurull', 'Tartu', 37484575);
115
116COMMIT;
117
118-- -----------------------------------------------------
119-- Data for table `Toode`
120-- -----------------------------------------------------
121SET AUTOCOMMIT=0;
122INSERT INTO `Toode` (`Triipkood`, `Tooteinfo`, `Hind`, `Kohal`, `Laos`) VALUES (0000, 'Kitarr', 200, 3, 6);
123INSERT INTO `Toode` (`Triipkood`, `Tooteinfo`, `Hind`, `Kohal`, `Laos`) VALUES (0001, 'Rammstein plaat', 20, 20, 200);
124INSERT INTO `Toode` (`Triipkood`, `Tooteinfo`, `Hind`, `Kohal`, `Laos`) VALUES (0002, 'Mediaatoor', 0.05, 500, 5000);
125INSERT INTO `Toode` (`Triipkood`, `Tooteinfo`, `Hind`, `Kohal`, `Laos`) VALUES (0003, 'Mikrofon', 10, 5, 10);
126INSERT INTO `Toode` (`Triipkood`, `Tooteinfo`, `Hind`, `Kohal`, `Laos`) VALUES (000, 'Opik', 20, 3, 5);
127
128COMMIT;
129
130
131SET SQL_MODE=@OLD_SQL_MODE;
132SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
133SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;