· 6 years ago · Jun 03, 2019, 07:52 AM
1-- MySQL Script generated by MySQL Workbench
2-- 05/01/19 20:01:51
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema sporters_db
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema sporters_db
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `sporters_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
18USE `sporters_db` ;
19
20-- -----------------------------------------------------
21-- Table `sporters_db`.`users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `sporters_db`.`users` (
24 `userId` INT NOT NULL AUTO_INCREMENT COMMENT '',
25 `email` VARCHAR(45) NOT NULL COMMENT '',
26 `pseudo` VARCHAR(15) NOT NULL COMMENT '',
27 `password` VARCHAR(64) NOT NULL COMMENT '',
28 `firstname` VARCHAR(45) NOT NULL COMMENT '',
29 `lastname` VARCHAR(45) NOT NULL COMMENT '',
30 `userAddress` VARCHAR(45) NULL COMMENT '',
31 `postalCode` CHAR(5) NULL COMMENT '',
32 `phoneNumber` CHAR(10) NULL COMMENT '',
33 `city` VARCHAR(45) NULL COMMENT '',
34 `confirmationToken` VARCHAR(60) NULL COMMENT '',
35 `confirmedAt` DATE NULL COMMENT '',
36 `userProfilePic` VARCHAR(100) NULL COMMENT '',
37 `accountStatus` INT NULL DEFAULT 0 COMMENT '',
38 `membershipStatus` INT NULL DEFAULT 0 COMMENT '',
39 `banTime` INT NULL COMMENT '',
40 PRIMARY KEY (`userId`, `email`) COMMENT '')
41ENGINE = InnoDB;
42
43
44-- -----------------------------------------------------
45-- Table `sporters_db`.`admin`
46-- -----------------------------------------------------
47CREATE TABLE IF NOT EXISTS `sporters_db`.`admin` (
48 `idadmin` INT NOT NULL AUTO_INCREMENT COMMENT '',
49 `adminPseudo` VARCHAR(45) NOT NULL COMMENT '',
50 `adminPassword` VARCHAR(64) NOT NULL COMMENT '',
51 `adminPrivilege` INT NOT NULL COMMENT '',
52 PRIMARY KEY (`idadmin`) COMMENT '')
53ENGINE = InnoDB;
54
55
56-- -----------------------------------------------------
57-- Table `sporters_db`.`faq`
58-- -----------------------------------------------------
59CREATE TABLE IF NOT EXISTS `sporters_db`.`faq` (
60 `faqId` INT NOT NULL AUTO_INCREMENT COMMENT '',
61 `questions` LONGTEXT NOT NULL COMMENT '',
62 `answers` LONGTEXT NOT NULL COMMENT '',
63 `admin_idadmin` INT NOT NULL COMMENT '',
64 PRIMARY KEY (`faqId`, `admin_idadmin`) COMMENT '',
65 CONSTRAINT `fk_faq_admin1`
66 FOREIGN KEY (`admin_idadmin`)
67 REFERENCES `sporters_db`.`admin` (`idadmin`)
68 ON DELETE NO ACTION
69 ON UPDATE NO ACTION)
70ENGINE = InnoDB;
71
72CREATE INDEX `fk_faq_admin1_idx` ON `sporters_db`.`faq` (`admin_idadmin` ASC) COMMENT '';
73
74
75-- -----------------------------------------------------
76-- Table `sporters_db`.`fields`
77-- -----------------------------------------------------
78CREATE TABLE IF NOT EXISTS `sporters_db`.`fields` (
79 `fieldId` INT NOT NULL AUTO_INCREMENT COMMENT '',
80 `fieldAddress` VARCHAR(45) NOT NULL COMMENT '',
81 `fieldName` VARCHAR(45) NOT NULL COMMENT '',
82 `fieldPostalCode` CHAR(5) NULL COMMENT '',
83 `fieldSport` VARCHAR(45) NULL COMMENT '',
84 `fieldSchedule` VARCHAR(45) NULL COMMENT '',
85 `subField` VARCHAR(45) NULL COMMENT '',
86 PRIMARY KEY (`fieldId`, `fieldAddress`) COMMENT '')
87ENGINE = InnoDB;
88
89
90-- -----------------------------------------------------
91-- Table `sporters_db`.`games`
92-- -----------------------------------------------------
93CREATE TABLE IF NOT EXISTS `sporters_db`.`games` (
94 `gameId` INT NOT NULL AUTO_INCREMENT COMMENT '',
95 `gameName` VARCHAR(45) NULL COMMENT '',
96 `gameDate` DATE NULL COMMENT '',
97 `gameSport` VARCHAR(45) NULL COMMENT '',
98 `slotAvailable` INT NULL COMMENT '',
99 `fields_fieldId` INT NOT NULL COMMENT '',
100 `fields_fieldAddress` VARCHAR(45) NOT NULL COMMENT '',
101 `users_userId` INT NOT NULL COMMENT '',
102 `users_email` VARCHAR(45) NOT NULL COMMENT '',
103 PRIMARY KEY (`gameId`, `fields_fieldId`, `fields_fieldAddress`, `users_userId`, `users_email`) COMMENT '',
104 CONSTRAINT `fk_games_fields1`
105 FOREIGN KEY (`fields_fieldId` , `fields_fieldAddress`)
106 REFERENCES `sporters_db`.`fields` (`fieldId` , `fieldAddress`)
107 ON DELETE NO ACTION
108 ON UPDATE NO ACTION,
109 CONSTRAINT `fk_games_users1`
110 FOREIGN KEY (`users_userId` , `users_email`)
111 REFERENCES `sporters_db`.`users` (`userId` , `email`)
112 ON DELETE NO ACTION
113 ON UPDATE NO ACTION)
114ENGINE = InnoDB;
115
116CREATE INDEX `fk_games_fields1_idx` ON `sporters_db`.`games` (`fields_fieldId` ASC, `fields_fieldAddress` ASC) COMMENT '';
117
118CREATE INDEX `fk_games_users1_idx` ON `sporters_db`.`games` (`users_userId` ASC, `users_email` ASC) COMMENT '';
119
120
121-- -----------------------------------------------------
122-- Table `sporters_db`.`events`
123-- -----------------------------------------------------
124CREATE TABLE IF NOT EXISTS `sporters_db`.`events` (
125 `eventId` INT NOT NULL AUTO_INCREMENT COMMENT '',
126 `eventName` VARCHAR(45) NULL COMMENT '',
127 `eventDate` DATE NULL COMMENT '',
128 `eventSport` VARCHAR(45) NULL COMMENT '',
129 `eventSlot` INT NULL COMMENT '',
130 `eventPrice` FLOAT NULL COMMENT '',
131 `users_userId` INT NOT NULL COMMENT '',
132 `users_email` VARCHAR(45) NOT NULL COMMENT '',
133 `fields_fieldId` INT NOT NULL COMMENT '',
134 `fields_fieldAddress` VARCHAR(45) NOT NULL COMMENT '',
135 PRIMARY KEY (`eventId`, `users_userId`, `users_email`, `fields_fieldId`, `fields_fieldAddress`) COMMENT '',
136 CONSTRAINT `fk_events_users1`
137 FOREIGN KEY (`users_userId` , `users_email`)
138 REFERENCES `sporters_db`.`users` (`userId` , `email`)
139 ON DELETE NO ACTION
140 ON UPDATE NO ACTION,
141 CONSTRAINT `fk_events_fields1`
142 FOREIGN KEY (`fields_fieldId` , `fields_fieldAddress`)
143 REFERENCES `sporters_db`.`fields` (`fieldId` , `fieldAddress`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION)
146ENGINE = InnoDB;
147
148CREATE INDEX `fk_events_users1_idx` ON `sporters_db`.`events` (`users_userId` ASC, `users_email` ASC) COMMENT '';
149
150CREATE INDEX `fk_events_fields1_idx` ON `sporters_db`.`events` (`fields_fieldId` ASC, `fields_fieldAddress` ASC) COMMENT '';
151
152
153-- -----------------------------------------------------
154-- Table `sporters_db`.`groups`
155-- -----------------------------------------------------
156CREATE TABLE IF NOT EXISTS `sporters_db`.`groups` (
157 `groupId` INT NOT NULL AUTO_INCREMENT COMMENT '',
158 `groupName` VARCHAR(45) NULL COMMENT '',
159 `groupSport` VARCHAR(45) NULL COMMENT '',
160 `groupOwner` VARCHAR(45) NULL COMMENT '',
161 `users_userId` INT NOT NULL COMMENT '',
162 `users_email` VARCHAR(45) NOT NULL COMMENT '',
163 PRIMARY KEY (`groupId`, `users_userId`, `users_email`) COMMENT '',
164 CONSTRAINT `fk_groups_users1`
165 FOREIGN KEY (`users_userId` , `users_email`)
166 REFERENCES `sporters_db`.`users` (`userId` , `email`)
167 ON DELETE NO ACTION
168 ON UPDATE NO ACTION)
169ENGINE = InnoDB;
170
171CREATE INDEX `fk_groups_users1_idx` ON `sporters_db`.`groups` (`users_userId` ASC, `users_email` ASC) COMMENT '';
172
173
174-- -----------------------------------------------------
175-- Table `sporters_db`.`notifications`
176-- -----------------------------------------------------
177CREATE TABLE IF NOT EXISTS `sporters_db`.`notifications` (
178 `notifId` INT NOT NULL AUTO_INCREMENT COMMENT '',
179 `notifMessage` LONGTEXT NULL COMMENT '',
180 `notifType` VARCHAR(255) NULL COMMENT '',
181 `notifDest` VARCHAR(255) NULL COMMENT '',
182 PRIMARY KEY (`notifId`) COMMENT '')
183ENGINE = InnoDB;
184
185
186-- -----------------------------------------------------
187-- Table `sporters_db`.`products`
188-- -----------------------------------------------------
189CREATE TABLE IF NOT EXISTS `sporters_db`.`products` (
190 `productID` INT NOT NULL AUTO_INCREMENT COMMENT '',
191 `productName` VARCHAR(80) NULL COMMENT '',
192 `productBrand` VARCHAR(45) NULL COMMENT '',
193 `productType` VARCHAR(45) NULL COMMENT '',
194 `productGender` VARCHAR(10) NULL COMMENT '',
195 `productStock` INT NULL COMMENT '',
196 `productPrice` FLOAT NULL COMMENT '',
197 `productDescription` LONGTEXT NULL COMMENT '',
198 `productSport` VARCHAR(45) NULL COMMENT '',
199 `productScore` FLOAT NULL COMMENT '',
200 `productImg` VARCHAR(100) NULL COMMENT '',
201 PRIMARY KEY (`productID`) COMMENT '')
202ENGINE = InnoDB;
203
204
205-- -----------------------------------------------------
206-- Table `sporters_db`.`games_history`
207-- -----------------------------------------------------
208CREATE TABLE IF NOT EXISTS `sporters_db`.`games_history` (
209 `users_userId` INT NOT NULL COMMENT '',
210 `users_email` VARCHAR(45) NOT NULL COMMENT '',
211 `games_gameId` INT NOT NULL COMMENT '',
212 PRIMARY KEY (`users_userId`, `users_email`, `games_gameId`) COMMENT '',
213 CONSTRAINT `fk_users_has_games_users`
214 FOREIGN KEY (`users_userId` , `users_email`)
215 REFERENCES `sporters_db`.`users` (`userId` , `email`)
216 ON DELETE NO ACTION
217 ON UPDATE NO ACTION,
218 CONSTRAINT `fk_users_has_games_games1`
219 FOREIGN KEY (`games_gameId`)
220 REFERENCES `sporters_db`.`games` (`gameId`)
221 ON DELETE NO ACTION
222 ON UPDATE NO ACTION)
223ENGINE = InnoDB;
224
225CREATE INDEX `fk_users_has_games_games1_idx` ON `sporters_db`.`games_history` (`games_gameId` ASC) COMMENT '';
226
227CREATE INDEX `fk_users_has_games_users_idx` ON `sporters_db`.`games_history` (`users_userId` ASC, `users_email` ASC) COMMENT '';
228
229
230-- -----------------------------------------------------
231-- Table `sporters_db`.`groups_history`
232-- -----------------------------------------------------
233CREATE TABLE IF NOT EXISTS `sporters_db`.`groups_history` (
234 `users_userId` INT NOT NULL COMMENT '',
235 `users_email` VARCHAR(45) NOT NULL COMMENT '',
236 `groups_groupId` INT NOT NULL COMMENT '',
237 PRIMARY KEY (`users_userId`, `users_email`, `groups_groupId`) COMMENT '',
238 CONSTRAINT `fk_users_has_groups_users1`
239 FOREIGN KEY (`users_userId` , `users_email`)
240 REFERENCES `sporters_db`.`users` (`userId` , `email`)
241 ON DELETE NO ACTION
242 ON UPDATE NO ACTION,
243 CONSTRAINT `fk_users_has_groups_groups1`
244 FOREIGN KEY (`groups_groupId`)
245 REFERENCES `sporters_db`.`groups` (`groupId`)
246 ON DELETE NO ACTION
247 ON UPDATE NO ACTION)
248ENGINE = InnoDB;
249
250CREATE INDEX `fk_users_has_groups_groups1_idx` ON `sporters_db`.`groups_history` (`groups_groupId` ASC) COMMENT '';
251
252CREATE INDEX `fk_users_has_groups_users1_idx` ON `sporters_db`.`groups_history` (`users_userId` ASC, `users_email` ASC) COMMENT '';
253
254
255-- -----------------------------------------------------
256-- Table `sporters_db`.`orders`
257-- -----------------------------------------------------
258CREATE TABLE IF NOT EXISTS `sporters_db`.`orders` (
259 `order_id` INT NOT NULL AUTO_INCREMENT COMMENT '',
260 `users_userId` INT NOT NULL COMMENT '',
261 `users_email` VARCHAR(45) NOT NULL COMMENT '',
262 `products_productID` INT NOT NULL COMMENT '',
263 `order_date` DATETIME NOT NULL COMMENT '',
264 `order_token` CHAR(5) NOT NULL COMMENT '',
265 PRIMARY KEY (`order_id`, `users_userId`, `users_email`, `products_productID`) COMMENT '',
266 CONSTRAINT `fk_orders_users1`
267 FOREIGN KEY (`users_userId` , `users_email`)
268 REFERENCES `sporters_db`.`users` (`userId` , `email`)
269 ON DELETE NO ACTION
270 ON UPDATE NO ACTION,
271 CONSTRAINT `fk_orders_products1`
272 FOREIGN KEY (`products_productID`)
273 REFERENCES `sporters_db`.`products` (`productID`)
274 ON DELETE NO ACTION
275 ON UPDATE NO ACTION)
276ENGINE = InnoDB;
277
278CREATE INDEX `fk_orders_users1_idx` ON `sporters_db`.`orders` (`users_userId` ASC, `users_email` ASC) COMMENT '';
279
280CREATE INDEX `fk_orders_products1_idx` ON `sporters_db`.`orders` (`products_productID` ASC) COMMENT '';
281
282
283-- -----------------------------------------------------
284-- Table `sporters_db`.`notifications_history`
285-- -----------------------------------------------------
286CREATE TABLE IF NOT EXISTS `sporters_db`.`notifications_history` (
287 `users_userId` INT NOT NULL COMMENT '',
288 `users_email` VARCHAR(45) NOT NULL COMMENT '',
289 `notifications_notifId` INT NOT NULL COMMENT '',
290 PRIMARY KEY (`users_userId`, `users_email`, `notifications_notifId`) COMMENT '',
291 CONSTRAINT `fk_users_has_notifications_users1`
292 FOREIGN KEY (`users_userId` , `users_email`)
293 REFERENCES `sporters_db`.`users` (`userId` , `email`)
294 ON DELETE NO ACTION
295 ON UPDATE NO ACTION,
296 CONSTRAINT `fk_users_has_notifications_notifications1`
297 FOREIGN KEY (`notifications_notifId`)
298 REFERENCES `sporters_db`.`notifications` (`notifId`)
299 ON DELETE NO ACTION
300 ON UPDATE NO ACTION)
301ENGINE = InnoDB;
302
303CREATE INDEX `fk_users_has_notifications_notifications1_idx` ON `sporters_db`.`notifications_history` (`notifications_notifId` ASC) COMMENT '';
304
305CREATE INDEX `fk_users_has_notifications_users1_idx` ON `sporters_db`.`notifications_history` (`users_userId` ASC, `users_email` ASC) COMMENT '';
306
307
308-- -----------------------------------------------------
309-- Table `sporters_db`.`groups_notifications`
310-- -----------------------------------------------------
311CREATE TABLE IF NOT EXISTS `sporters_db`.`groups_notifications` (
312 `notifications_notifId` INT NOT NULL COMMENT '',
313 `groups_groupId` INT NOT NULL COMMENT '',
314 PRIMARY KEY (`notifications_notifId`, `groups_groupId`) COMMENT '',
315 CONSTRAINT `fk_notifications_has_groups_notifications1`
316 FOREIGN KEY (`notifications_notifId`)
317 REFERENCES `sporters_db`.`notifications` (`notifId`)
318 ON DELETE NO ACTION
319 ON UPDATE NO ACTION,
320 CONSTRAINT `fk_notifications_has_groups_groups1`
321 FOREIGN KEY (`groups_groupId`)
322 REFERENCES `sporters_db`.`groups` (`groupId`)
323 ON DELETE NO ACTION
324 ON UPDATE NO ACTION)
325ENGINE = InnoDB;
326
327CREATE INDEX `fk_notifications_has_groups_groups1_idx` ON `sporters_db`.`groups_notifications` (`groups_groupId` ASC) COMMENT '';
328
329CREATE INDEX `fk_notifications_has_groups_notifications1_idx` ON `sporters_db`.`groups_notifications` (`notifications_notifId` ASC) COMMENT '';
330
331
332-- -----------------------------------------------------
333-- Table `sporters_db`.`admin_fields_history`
334-- -----------------------------------------------------
335CREATE TABLE IF NOT EXISTS `sporters_db`.`admin_fields_history` (
336 `admin_idadmin` INT NOT NULL COMMENT '',
337 `fields_fieldId` INT NOT NULL COMMENT '',
338 `fields_fieldAddress` VARCHAR(45) NOT NULL COMMENT '',
339 PRIMARY KEY (`admin_idadmin`, `fields_fieldId`, `fields_fieldAddress`) COMMENT '',
340 CONSTRAINT `fk_admin_has_fields_admin1`
341 FOREIGN KEY (`admin_idadmin`)
342 REFERENCES `sporters_db`.`admin` (`idadmin`)
343 ON DELETE NO ACTION
344 ON UPDATE NO ACTION,
345 CONSTRAINT `fk_admin_has_fields_fields1`
346 FOREIGN KEY (`fields_fieldId` , `fields_fieldAddress`)
347 REFERENCES `sporters_db`.`fields` (`fieldId` , `fieldAddress`)
348 ON DELETE NO ACTION
349 ON UPDATE NO ACTION)
350ENGINE = InnoDB;
351
352CREATE INDEX `fk_admin_has_fields_fields1_idx` ON `sporters_db`.`admin_fields_history` (`fields_fieldId` ASC, `fields_fieldAddress` ASC) COMMENT '';
353
354CREATE INDEX `fk_admin_has_fields_admin1_idx` ON `sporters_db`.`admin_fields_history` (`admin_idadmin` ASC) COMMENT '';
355
356
357-- -----------------------------------------------------
358-- Table `sporters_db`.`events_history`
359-- -----------------------------------------------------
360CREATE TABLE IF NOT EXISTS `sporters_db`.`events_history` (
361 `users_userId` INT NOT NULL COMMENT '',
362 `users_email` VARCHAR(45) NOT NULL COMMENT '',
363 `events_eventId` INT NOT NULL COMMENT '',
364 `events_groups_groupId` INT NOT NULL COMMENT '',
365 `events_users_userId` INT NOT NULL COMMENT '',
366 `events_users_email` VARCHAR(45) NOT NULL COMMENT '',
367 PRIMARY KEY (`users_userId`, `users_email`, `events_eventId`, `events_groups_groupId`, `events_users_userId`, `events_users_email`) COMMENT '',
368 CONSTRAINT `fk_users_has_events_users1`
369 FOREIGN KEY (`users_userId` , `users_email`)
370 REFERENCES `sporters_db`.`users` (`userId` , `email`)
371 ON DELETE NO ACTION
372 ON UPDATE NO ACTION,
373 CONSTRAINT `fk_users_has_events_events1`
374 FOREIGN KEY (`events_eventId` , `events_users_userId` , `events_users_email`)
375 REFERENCES `sporters_db`.`events` (`eventId` , `users_userId` , `users_email`)
376 ON DELETE NO ACTION
377 ON UPDATE NO ACTION)
378ENGINE = InnoDB;
379
380CREATE INDEX `fk_users_has_events_events1_idx` ON `sporters_db`.`events_history` (`events_eventId` ASC, `events_groups_groupId` ASC, `events_users_userId` ASC, `events_users_email` ASC) COMMENT '';
381
382CREATE INDEX `fk_users_has_events_users1_idx` ON `sporters_db`.`events_history` (`users_userId` ASC, `users_email` ASC) COMMENT '';
383
384
385-- -----------------------------------------------------
386-- Table `sporters_db`.`groups_events`
387-- -----------------------------------------------------
388CREATE TABLE IF NOT EXISTS `sporters_db`.`groups_events` (
389 `groups_groupId` INT NOT NULL COMMENT '',
390 `groups_users_userId` INT NOT NULL COMMENT '',
391 `groups_users_email` VARCHAR(45) NOT NULL COMMENT '',
392 `events_eventId` INT NOT NULL COMMENT '',
393 `events_users_userId` INT NOT NULL COMMENT '',
394 `events_users_email` VARCHAR(45) NOT NULL COMMENT '',
395 PRIMARY KEY (`groups_groupId`, `groups_users_userId`, `groups_users_email`, `events_eventId`, `events_users_userId`, `events_users_email`) COMMENT '',
396 CONSTRAINT `fk_groups_has_events_groups1`
397 FOREIGN KEY (`groups_groupId` , `groups_users_userId` , `groups_users_email`)
398 REFERENCES `sporters_db`.`groups` (`groupId` , `users_userId` , `users_email`)
399 ON DELETE NO ACTION
400 ON UPDATE NO ACTION,
401 CONSTRAINT `fk_groups_has_events_events1`
402 FOREIGN KEY (`events_eventId` , `events_users_userId` , `events_users_email`)
403 REFERENCES `sporters_db`.`events` (`eventId` , `users_userId` , `users_email`)
404 ON DELETE NO ACTION
405 ON UPDATE NO ACTION)
406ENGINE = InnoDB;
407
408CREATE INDEX `fk_groups_has_events_events1_idx` ON `sporters_db`.`groups_events` (`events_eventId` ASC, `events_users_userId` ASC, `events_users_email` ASC) COMMENT '';
409
410CREATE INDEX `fk_groups_has_events_groups1_idx` ON `sporters_db`.`groups_events` (`groups_groupId` ASC, `groups_users_userId` ASC, `groups_users_email` ASC) COMMENT '';
411
412
413-- -----------------------------------------------------
414-- Table `sporters_db`.`cgu`
415-- -----------------------------------------------------
416CREATE TABLE IF NOT EXISTS `sporters_db`.`cgu` (
417 `cgu_id` INT NOT NULL AUTO_INCREMENT COMMENT '',
418 `article` LONGTEXT NOT NULL COMMENT '',
419 `admin_id` INT NOT NULL COMMENT '',
420 PRIMARY KEY (`cgu_id`, `admin_id`) COMMENT '',
421 CONSTRAINT `fk_cgu_admin1`
422 FOREIGN KEY (`admin_id`)
423 REFERENCES `sporters_db`.`admin` (`idadmin`)
424 ON DELETE NO ACTION
425 ON UPDATE NO ACTION)
426ENGINE = InnoDB;
427
428CREATE INDEX `fk_cgu_admin1_idx` ON `sporters_db`.`cgu` (`admin_id` ASC) COMMENT '';
429
430
431SET SQL_MODE=@OLD_SQL_MODE;
432SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
433SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;