XXQDCg3E

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema clothes
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `clothes` ;
14
15-- -----------------------------------------------------
16-- Schema clothes
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `clothes` DEFAULT CHARACTER SET utf8 ;
19USE `clothes` ;
20
21-- -----------------------------------------------------
22-- Table `clothes`.`categories`
23-- -----------------------------------------------------
24CREATE TABLE IF NOT EXISTS `clothes`.`categories` (
25  `id` INT(11) NOT NULL AUTO_INCREMENT,
26  `name` VARCHAR(255) NOT NULL,
27  `createdAt` DATETIME NOT NULL,
28  `updatedAt` DATETIME NOT NULL,
29  PRIMARY KEY (`id`),
30  INDEX `nameIndex` (`name` ASC))
31ENGINE = MyISAM
32AUTO_INCREMENT = 101
33DEFAULT CHARACTER SET = utf8;
34
35
36-- -----------------------------------------------------
37-- Table `clothes`.`categoryparams`
38-- -----------------------------------------------------
39CREATE TABLE IF NOT EXISTS `clothes`.`categoryparams` (
40  `id` INT(11) NOT NULL AUTO_INCREMENT,
41  `categoryId` INT(11) NOT NULL,
42  `paramId` INT(11) NOT NULL,
43  `createdAt` DATETIME NOT NULL,
44  `updatedAt` DATETIME NOT NULL,
45  PRIMARY KEY (`id`))
46ENGINE = MyISAM
47AUTO_INCREMENT = 101
48DEFAULT CHARACTER SET = utf8;
49
50
51-- -----------------------------------------------------
52-- Table `clothes`.`orders`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `clothes`.`orders` (
55  `id` INT(11) NOT NULL AUTO_INCREMENT,
56  `userId` INT(11) NOT NULL,
57  `date` DATETIME NOT NULL,
58  `createdAt` DATETIME NOT NULL,
59  `updatedAt` DATETIME NOT NULL,
60  PRIMARY KEY (`id`))
61ENGINE = MyISAM
62AUTO_INCREMENT = 101
63DEFAULT CHARACTER SET = utf8;
64
65
66-- -----------------------------------------------------
67-- Table `clothes`.`params`
68-- -----------------------------------------------------
69CREATE TABLE IF NOT EXISTS `clothes`.`params` (
70  `id` INT(11) NOT NULL AUTO_INCREMENT,
71  `name` VARCHAR(255) NOT NULL,
72  `createdAt` DATETIME NOT NULL,
73  `updatedAt` DATETIME NOT NULL,
74  PRIMARY KEY (`id`))
75ENGINE = MyISAM
76AUTO_INCREMENT = 101
77DEFAULT CHARACTER SET = utf8;
78
79
80-- -----------------------------------------------------
81-- Table `clothes`.`productparams`
82-- -----------------------------------------------------
83CREATE TABLE IF NOT EXISTS `clothes`.`productparams` (
84  `id` INT(11) NOT NULL AUTO_INCREMENT,
85  `productId` INT(11) NOT NULL,
86  `paramId` INT(11) NOT NULL,
87  `paramValue` TEXT NOT NULL,
88  `createdAt` DATETIME NOT NULL,
89  `updatedAt` DATETIME NOT NULL,
90  PRIMARY KEY (`id`))
91ENGINE = MyISAM
92AUTO_INCREMENT = 101
93DEFAULT CHARACTER SET = utf8;
94
95
96-- -----------------------------------------------------
97-- Table `clothes`.`products`
98-- -----------------------------------------------------
99CREATE TABLE IF NOT EXISTS `clothes`.`products` (
100  `id` INT(11) NOT NULL AUTO_INCREMENT,
101  `name` VARCHAR(255) NOT NULL,
102  `categoryId` INT(11) NOT NULL,
103  `price` INT(11) NOT NULL,
104  `stock` INT(11) NOT NULL,
105  `description` TEXT NOT NULL,
106  `imageLink` VARCHAR(255) NOT NULL,
107  `createdAt` DATETIME NOT NULL,
108  `updatedAt` DATETIME NOT NULL,
109  PRIMARY KEY (`id`),
110  INDEX `nameIndex` (`name` ASC),
111  INDEX `categoryIndex` (`categoryId` ASC))
112ENGINE = MyISAM
113AUTO_INCREMENT = 101
114DEFAULT CHARACTER SET = utf8;
115
116
117-- -----------------------------------------------------
118-- Table `clothes`.`producttoorders`
119-- -----------------------------------------------------
120CREATE TABLE IF NOT EXISTS `clothes`.`producttoorders` (
121  `id` INT(11) NOT NULL AUTO_INCREMENT,
122  `productId` INT(11) NOT NULL,
123  `orderId` INT(11) NOT NULL,
124  `createdAt` DATETIME NOT NULL,
125  `updatedAt` DATETIME NOT NULL,
126  PRIMARY KEY (`id`))
127ENGINE = MyISAM
128AUTO_INCREMENT = 101
129DEFAULT CHARACTER SET = utf8;
130
131
132-- -----------------------------------------------------
133-- Table `clothes`.`reviews`
134-- -----------------------------------------------------
135CREATE TABLE IF NOT EXISTS `clothes`.`reviews` (
136  `id` INT(11) NOT NULL AUTO_INCREMENT,
137  `userId` INT(11) NOT NULL,
138  `date` DATETIME NOT NULL,
139  `description` TEXT NOT NULL,
140  `productId` INT(11) NOT NULL,
141  `createdAt` DATETIME NOT NULL,
142  `updatedAt` DATETIME NOT NULL,
143  PRIMARY KEY (`id`))
144ENGINE = MyISAM
145AUTO_INCREMENT = 101
146DEFAULT CHARACTER SET = utf8;
147
148
149-- -----------------------------------------------------
150-- Table `clothes`.`users`
151-- -----------------------------------------------------
152CREATE TABLE IF NOT EXISTS `clothes`.`users` (
153  `id` INT(11) NOT NULL AUTO_INCREMENT,
154  `username` VARCHAR(255) NOT NULL,
155  `birthday` DATETIME NOT NULL,
156  `name` VARCHAR(40) NULL DEFAULT NULL,
157  `email` VARCHAR(40) NULL DEFAULT NULL,
158  `password` VARCHAR(40) NULL DEFAULT NULL,
159  `role` VARCHAR(255) NOT NULL,
160  `createdAt` DATETIME NOT NULL,
161  `updatedAt` DATETIME NOT NULL,
162  PRIMARY KEY (`id`),
163  INDEX `nameEmailIndex` (`name` ASC, `email` ASC))
164ENGINE = MyISAM
165AUTO_INCREMENT = 101
166DEFAULT CHARACTER SET = utf8;
167
168
169SET SQL_MODE=@OLD_SQL_MODE;
170SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
171SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;