· 5 years ago · Mar 08, 2020, 05:00 PM
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema storage_host
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema storage_host
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `storage_host` ;
15USE `storage_host` ;
16
17-- -----------------------------------------------------
18-- Table `storage_host`.`products`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `storage_host`.`products` (
21 `ref_id` VARCHAR(255) NOT NULL,
22 `title` VARCHAR(255) NULL,
23 `created_at` DATETIME NULL,
24 `updated_at` DATETIME NULL,
25 PRIMARY KEY (`ref_id`),
26 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `storage_host`.`categories`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `storage_host`.`categories` (
34 `ref_id` VARCHAR(255) NOT NULL,
35 `title` VARCHAR(255) NOT NULL,
36 `products_ref_id` VARCHAR(255) NOT NULL,
37 `created_at` DATETIME NULL,
38 `updated_at` DATETIME NULL,
39 PRIMARY KEY (`ref_id`, `products_ref_id`),
40 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC),
41 INDEX `fk_categories_products1_idx` (`products_ref_id` ASC),
42 CONSTRAINT `fk_categories_products1`
43 FOREIGN KEY (`products_ref_id`)
44 REFERENCES `storage_host`.`products` (`ref_id`)
45 ON DELETE NO ACTION
46 ON UPDATE NO ACTION)
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `storage_host`.`sub_categories`
52-- -----------------------------------------------------
53CREATE TABLE IF NOT EXISTS `storage_host`.`sub_categories` (
54 `ref_id` VARCHAR(255) NOT NULL,
55 `title` VARCHAR(255) NOT NULL,
56 `categories_ref_id` VARCHAR(255) NOT NULL,
57 `created_at` DATETIME NULL,
58 `updated_at` DATETIME NULL,
59 PRIMARY KEY (`ref_id`, `categories_ref_id`),
60 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC),
61 INDEX `fk_sub_categories_categories1_idx` (`categories_ref_id` ASC),
62 CONSTRAINT `fk_sub_categories_categories1`
63 FOREIGN KEY (`categories_ref_id`)
64 REFERENCES `storage_host`.`categories` (`ref_id`)
65 ON DELETE NO ACTION
66 ON UPDATE NO ACTION)
67ENGINE = InnoDB;
68
69
70-- -----------------------------------------------------
71-- Table `storage_host`.`videos`
72-- -----------------------------------------------------
73CREATE TABLE IF NOT EXISTS `storage_host`.`videos` (
74 `ref_id` VARCHAR(255) NOT NULL,
75 `title` VARCHAR(255) NOT NULL,
76 `description` VARCHAR(255) NULL,
77 `video_url` VARCHAR(255) NULL,
78 `created_at` DATETIME NULL,
79 `updated_at` DATETIME NULL,
80 `sub_categories_ref_id` VARCHAR(255) NOT NULL,
81 PRIMARY KEY (`ref_id`, `sub_categories_ref_id`),
82 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC),
83 INDEX `fk_videos_sub_categories1_idx` (`sub_categories_ref_id` ASC),
84 CONSTRAINT `fk_videos_sub_categories1`
85 FOREIGN KEY (`sub_categories_ref_id`)
86 REFERENCES `storage_host`.`sub_categories` (`ref_id`)
87 ON DELETE NO ACTION
88 ON UPDATE NO ACTION)
89ENGINE = InnoDB;
90
91
92-- -----------------------------------------------------
93-- Table `storage_host`.`admins`
94-- -----------------------------------------------------
95CREATE TABLE IF NOT EXISTS `storage_host`.`admins` (
96 `ref_id` VARCHAR(255) NOT NULL,
97 `username` VARCHAR(45) NOT NULL,
98 `email` VARCHAR(45) NOT NULL,
99 `password` VARCHAR(255) NOT NULL,
100 `created_at` DATETIME NULL,
101 `updated_at` DATETIME NULL,
102 PRIMARY KEY (`ref_id`),
103 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC),
104 UNIQUE INDEX `username_UNIQUE` (`username` ASC),
105 UNIQUE INDEX `email_UNIQUE` (`email` ASC))
106ENGINE = InnoDB;
107
108
109-- -----------------------------------------------------
110-- Table `storage_host`.`clients`
111-- -----------------------------------------------------
112CREATE TABLE IF NOT EXISTS `storage_host`.`clients` (
113 `ref_id` VARCHAR(255) NOT NULL,
114 `first_name` VARCHAR(255) NULL,
115 `last_name` VARCHAR(45) NULL,
116 `username` VARCHAR(45) NULL,
117 `email` VARCHAR(45) NULL,
118 `password` VARCHAR(45) NULL,
119 `created_at` DATETIME NULL,
120 `updated_at` DATETIME NULL,
121 PRIMARY KEY (`ref_id`),
122 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC))
123ENGINE = InnoDB;
124
125
126-- -----------------------------------------------------
127-- Table `storage_host`.`viewers`
128-- -----------------------------------------------------
129CREATE TABLE IF NOT EXISTS `storage_host`.`viewers` (
130 `ref_id` VARCHAR(255) NOT NULL,
131 `first_name` VARCHAR(45) NULL,
132 `last_name` VARCHAR(45) NULL,
133 `username` VARCHAR(45) NULL,
134 `email` VARCHAR(45) NULL,
135 `password` VARCHAR(45) NULL,
136 `created_at` DATETIME NULL,
137 `updated_at` DATETIME NULL,
138 PRIMARY KEY (`ref_id`),
139 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC))
140ENGINE = InnoDB;
141
142
143-- -----------------------------------------------------
144-- Table `storage_host`.`likes`
145-- -----------------------------------------------------
146CREATE TABLE IF NOT EXISTS `storage_host`.`likes` (
147 `ref_id` VARCHAR(22) NOT NULL,
148 `count` INT NOT NULL,
149 `created_at` DATETIME NULL,
150 `updated_at` DATETIME NULL,
151 PRIMARY KEY (`ref_id`),
152 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC))
153ENGINE = InnoDB;
154
155
156-- -----------------------------------------------------
157-- Table `storage_host`.`comments`
158-- -----------------------------------------------------
159CREATE TABLE IF NOT EXISTS `storage_host`.`comments` (
160 `ref_id` VARCHAR(255) NOT NULL,
161 `comment` VARCHAR(255) NULL,
162 `created_at` DATETIME NULL,
163 `updated_at` DATETIME NULL,
164 PRIMARY KEY (`ref_id`),
165 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC))
166ENGINE = InnoDB;
167
168
169-- -----------------------------------------------------
170-- Table `storage_host`.`biding`
171-- -----------------------------------------------------
172CREATE TABLE IF NOT EXISTS `storage_host`.`biding` (
173 `ref_id` VARCHAR(45) NOT NULL,
174 `sub_categories_ref_id` VARCHAR(255) NOT NULL,
175 `position` VARCHAR(45) NULL,
176 `bid_amount` VARCHAR(45) NULL,
177 `clients_ref_id` VARCHAR(255) NOT NULL,
178 `created_at` DATETIME NULL,
179 `updated_at` DATETIME NULL,
180 PRIMARY KEY (`sub_categories_ref_id`, `ref_id`, `clients_ref_id`),
181 INDEX `fk_biding_sub_categories1_idx` (`sub_categories_ref_id` ASC),
182 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC),
183 INDEX `fk_biding_clients1_idx` (`clients_ref_id` ASC),
184 CONSTRAINT `fk_biding_sub_categories1`
185 FOREIGN KEY (`sub_categories_ref_id`)
186 REFERENCES `storage_host`.`sub_categories` (`ref_id`)
187 ON DELETE NO ACTION
188 ON UPDATE NO ACTION,
189 CONSTRAINT `fk_biding_clients1`
190 FOREIGN KEY (`clients_ref_id`)
191 REFERENCES `storage_host`.`clients` (`ref_id`)
192 ON DELETE NO ACTION
193 ON UPDATE NO ACTION)
194ENGINE = InnoDB;
195
196
197-- -----------------------------------------------------
198-- Table `storage_host`.`subscription`
199-- -----------------------------------------------------
200CREATE TABLE IF NOT EXISTS `storage_host`.`subscription` (
201 `ref_id` VARCHAR(255) NOT NULL,
202 `subscription` VARCHAR(255) NULL,
203 `created_at` DATETIME NULL,
204 `updated_at` DATETIME NULL,
205 PRIMARY KEY (`ref_id`),
206 UNIQUE INDEX `ref_id_UNIQUE` (`ref_id` ASC))
207ENGINE = InnoDB;
208
209
210SET SQL_MODE=@OLD_SQL_MODE;
211SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
212SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;