· 8 years ago · Nov 28, 2017, 04:40 PM
1CREATE TABLE IF NOT EXISTS `Users` (
2 `idUsers` INT NOT NULL,
3 `Name` VARCHAR(45) NOT NULL,
4 `password` VARCHAR(45) NOT NULL,
5 `email` VARCHAR(45) NOT NULL,
6 `Phone` INT NOT NULL,
7 `Address` VARCHAR(45) NOT NULL,
8 PRIMARY KEY (`idUsers`));
9
10CREATE TABLE `Part` (
11 `idPart` INT NOT NULL,
12 `PartType` INT NOT NULL,
13 `PartName` VARCHAR(45) NOT NULL,
14 `Owner` INT NOT NULL,
15 `Autotype` INT NOT NULL,
16 PRIMARY KEY (`idPart`),
17 INDEX `PartOwner_idx` (`Owner` ASC),
18 CONSTRAINT `PartOwner`
19 FOREIGN KEY (`Owner`)
20 REFERENCES `Users` (`idUsers`)
21 ON DELETE NO ACTION
22 ON UPDATE NO ACTION);
23
24CREATE TABLE IF NOT EXISTS `Car` (
25 `idCar` INT NOT NULL,
26 `name` VARCHAR(45) NOT NULL,
27 `typeid` VARCHAR(45) NOT NULL,
28 `color` VARCHAR(45) NOT NULL,
29 `enginevolume` VARCHAR(45) NOT NULL,
30 `mileage` INT NOT NULL,
31 `customs` BINARY(1) NOT NULL,
32 `ownerid` INT NOT NULL,
33 `year` YEAR NOT NULL,
34 `brand` VARCHAR(45) NOT NULL,
35 `generation` VARCHAR(45) NOT NULL,
36 PRIMARY KEY (`idCar`),
37 INDEX `owner_idx` (`ownerid` ASC),
38 CONSTRAINT `owner`
39 FOREIGN KEY (`ownerid`)
40 REFERENCES `Users` (`idUsers`)
41 ON DELETE NO ACTION
42 ON UPDATE NO ACTION);
43
44
45CREATE TABLE IF NOT EXISTS `ad` (
46 `idad` INT NOT NULL,
47 `name` VARCHAR(45) NOT NULL,
48 `date` DATE NOT NULL,
49 `price` DOUBLE NOT NULL,
50 `itemid` INT NOT NULL,
51 `userid` INT NOT NULL,
52 `address` VARCHAR(45) NOT NULL,
53 `imagepath` VARCHAR(45) NOT NULL,
54 PRIMARY KEY (`idad`),
55 INDEX `Item_idx` (`itemid` ASC),
56 INDEX `userid_idx` (`userid` ASC),
57 CONSTRAINT `Item`
58 FOREIGN KEY (`itemid`)
59 REFERENCES `Part` (`idPart`)
60 ON DELETE NO ACTION
61 ON UPDATE NO ACTION,
62 CONSTRAINT `carid`
63 FOREIGN KEY (`itemid`)
64 REFERENCES `Car` (`idCar`)
65 ON DELETE NO ACTION
66 ON UPDATE NO ACTION,
67 CONSTRAINT `userid`
68 FOREIGN KEY (`userid`)
69 REFERENCES `Users` (`idUsers`)
70 ON DELETE NO ACTION
71 ON UPDATE NO ACTION);