· 8 years ago · Dec 13, 2017, 07:28 PM
1-- Valentina Studio --
2-- MySQL dump --
3-- ---------------------------------------------------------
4
5
6/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
7/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
8/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
9/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
10/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
11-- ---------------------------------------------------------
12
13
14-- CREATE TABLE "auth_assignment" --------------------------
15-- DROP TABLE "auth_assignment" --------------------------------
16DROP TABLE IF EXISTS `auth_assignment` CASCADE;
17-- -------------------------------------------------------------
18
19
20-- CREATE TABLE "auth_assignment" ------------------------------
21CREATE TABLE `auth_assignment` (
22 `item_name` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
23 `user_id` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
24 `created_at` Int( 11 ) NULL,
25 PRIMARY KEY ( `item_name`, `user_id` ) )
26CHARACTER SET = utf8
27COLLATE = utf8_unicode_ci
28ENGINE = InnoDB;
29-- -------------------------------------------------------------
30-- ---------------------------------------------------------
31
32
33-- CREATE TABLE "auth_item" --------------------------------
34-- DROP TABLE "auth_item" --------------------------------------
35DROP TABLE IF EXISTS `auth_item` CASCADE;
36-- -------------------------------------------------------------
37
38
39-- CREATE TABLE "auth_item" ------------------------------------
40CREATE TABLE `auth_item` (
41 `name` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
42 `type` Int( 11 ) NOT NULL,
43 `description` Text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
44 `rule_name` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
45 `data` Text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
46 `created_at` Int( 11 ) NULL,
47 `updated_at` Int( 11 ) NULL,
48 PRIMARY KEY ( `name` ) )
49CHARACTER SET = utf8
50COLLATE = utf8_unicode_ci
51ENGINE = InnoDB;
52-- -------------------------------------------------------------
53-- ---------------------------------------------------------
54
55
56-- CREATE TABLE "auth_item_child" --------------------------
57-- DROP TABLE "auth_item_child" --------------------------------
58DROP TABLE IF EXISTS `auth_item_child` CASCADE;
59-- -------------------------------------------------------------
60
61
62-- CREATE TABLE "auth_item_child" ------------------------------
63CREATE TABLE `auth_item_child` (
64 `parent` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
65 `child` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
66 PRIMARY KEY ( `parent`, `child` ) )
67CHARACTER SET = utf8
68COLLATE = utf8_unicode_ci
69ENGINE = InnoDB;
70-- -------------------------------------------------------------
71-- ---------------------------------------------------------
72
73
74-- CREATE TABLE "auth_rule" --------------------------------
75-- DROP TABLE "auth_rule" --------------------------------------
76DROP TABLE IF EXISTS `auth_rule` CASCADE;
77-- -------------------------------------------------------------
78
79
80-- CREATE TABLE "auth_rule" ------------------------------------
81CREATE TABLE `auth_rule` (
82 `name` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
83 `data` Text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
84 `created_at` Int( 11 ) NULL,
85 `updated_at` Int( 11 ) NULL,
86 PRIMARY KEY ( `name` ) )
87CHARACTER SET = utf8
88COLLATE = utf8_unicode_ci
89ENGINE = InnoDB;
90-- -------------------------------------------------------------
91-- ---------------------------------------------------------
92
93
94-- CREATE TABLE "category" ---------------------------------
95-- DROP TABLE "category" ---------------------------------------
96DROP TABLE IF EXISTS `category` CASCADE;
97-- -------------------------------------------------------------
98
99
100-- CREATE TABLE "category" -------------------------------------
101CREATE TABLE `category` (
102 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
103 `title` VarChar( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
104 `description` Text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
105 `create_time` DateTime NULL,
106 `update_time` DateTime NULL,
107 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
108 `delete_time` DateTime NULL,
109 PRIMARY KEY ( `id` ) )
110CHARACTER SET = utf8
111COLLATE = utf8_general_ci
112ENGINE = InnoDB
113AUTO_INCREMENT = 4;
114-- -------------------------------------------------------------
115-- ---------------------------------------------------------
116
117
118-- CREATE TABLE "opt_client_status" ------------------------
119-- DROP TABLE "opt_client_status" ------------------------------
120DROP TABLE IF EXISTS `opt_client_status` CASCADE;
121-- -------------------------------------------------------------
122
123
124-- CREATE TABLE "opt_client_status" ----------------------------
125CREATE TABLE `opt_client_status` (
126 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
127 `option` VarChar( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
128 `style` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
129 `create_time` DateTime NULL,
130 `update_time` DateTime NULL,
131 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
132 `delete_time` DateTime NULL,
133 PRIMARY KEY ( `id` ) )
134CHARACTER SET = utf8
135COLLATE = utf8_general_ci
136ENGINE = InnoDB
137AUTO_INCREMENT = 3;
138-- -------------------------------------------------------------
139-- ---------------------------------------------------------
140
141
142-- CREATE TABLE "opt_delivery_status" ----------------------
143-- DROP TABLE "opt_delivery_status" ----------------------------
144DROP TABLE IF EXISTS `opt_delivery_status` CASCADE;
145-- -------------------------------------------------------------
146
147
148-- CREATE TABLE "opt_delivery_status" --------------------------
149CREATE TABLE `opt_delivery_status` (
150 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
151 `option` VarChar( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
152 `style` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
153 `create_time` DateTime NULL,
154 `update_time` DateTime NULL,
155 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
156 `delete_time` DateTime NULL,
157 PRIMARY KEY ( `id` ) )
158CHARACTER SET = utf8
159COLLATE = utf8_general_ci
160ENGINE = InnoDB
161AUTO_INCREMENT = 4;
162-- -------------------------------------------------------------
163-- ---------------------------------------------------------
164
165
166-- CREATE TABLE "opt_pickup_status" ------------------------
167-- DROP TABLE "opt_pickup_status" ------------------------------
168DROP TABLE IF EXISTS `opt_pickup_status` CASCADE;
169-- -------------------------------------------------------------
170
171
172-- CREATE TABLE "opt_pickup_status" ----------------------------
173CREATE TABLE `opt_pickup_status` (
174 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
175 `option` VarChar( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
176 `style` VarChar( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
177 `create_time` DateTime NULL,
178 `update_time` DateTime NULL,
179 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
180 `delete_time` DateTime NULL,
181 PRIMARY KEY ( `id` ) )
182CHARACTER SET = utf8
183COLLATE = utf8_general_ci
184ENGINE = InnoDB
185AUTO_INCREMENT = 4;
186-- -------------------------------------------------------------
187-- ---------------------------------------------------------
188
189
190-- CREATE TABLE "profile" ----------------------------------
191-- DROP TABLE "profile" ----------------------------------------
192DROP TABLE IF EXISTS `profile` CASCADE;
193-- -------------------------------------------------------------
194
195
196-- CREATE TABLE "profile" --------------------------------------
197CREATE TABLE `profile` (
198 `user_id` Int( 11 ) NOT NULL,
199 `name` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
200 `public_email` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
201 `gravatar_email` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
202 `gravatar_id` VarChar( 32 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
203 `location` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
204 `website` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
205 `bio` Text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
206 `timezone` VarChar( 40 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
207 `promis_username` VarChar( 128 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
208 PRIMARY KEY ( `user_id` ) )
209CHARACTER SET = utf8
210COLLATE = utf8_unicode_ci
211ENGINE = InnoDB;
212-- -------------------------------------------------------------
213-- ---------------------------------------------------------
214
215
216-- CREATE TABLE "token" ------------------------------------
217-- DROP TABLE "token" ------------------------------------------
218DROP TABLE IF EXISTS `token` CASCADE;
219-- -------------------------------------------------------------
220
221
222-- CREATE TABLE "token" ----------------------------------------
223CREATE TABLE `token` (
224 `user_id` Int( 11 ) NOT NULL,
225 `code` VarChar( 32 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
226 `created_at` Int( 11 ) NOT NULL,
227 `type` Smallint( 6 ) NOT NULL,
228 CONSTRAINT `token_unique` UNIQUE( `user_id`, `code`, `type` ) )
229CHARACTER SET = utf8
230COLLATE = utf8_unicode_ci
231ENGINE = InnoDB;
232-- -------------------------------------------------------------
233-- ---------------------------------------------------------
234
235
236-- CREATE TABLE "user" -------------------------------------
237-- DROP TABLE "user" -------------------------------------------
238DROP TABLE IF EXISTS `user` CASCADE;
239-- -------------------------------------------------------------
240
241
242-- CREATE TABLE "user" -----------------------------------------
243CREATE TABLE `user` (
244 `id` Int( 11 ) AUTO_INCREMENT NOT NULL,
245 `username` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
246 `email` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
247 `password_hash` VarChar( 60 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
248 `auth_key` VarChar( 32 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
249 `confirmed_at` Int( 11 ) NULL,
250 `unconfirmed_email` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
251 `blocked_at` Int( 11 ) NULL,
252 `registration_ip` VarChar( 45 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
253 `created_at` Int( 11 ) NOT NULL,
254 `updated_at` Int( 11 ) NOT NULL,
255 `flags` Int( 11 ) NOT NULL DEFAULT '0',
256 PRIMARY KEY ( `id` ),
257 CONSTRAINT `user_unique_email` UNIQUE( `email` ),
258 CONSTRAINT `user_unique_username` UNIQUE( `username` ) )
259CHARACTER SET = utf8
260COLLATE = utf8_unicode_ci
261ENGINE = InnoDB
262AUTO_INCREMENT = 3;
263-- -------------------------------------------------------------
264-- ---------------------------------------------------------
265
266
267-- CREATE TABLE "food" -------------------------------------
268-- DROP TABLE "food" -------------------------------------------
269DROP TABLE IF EXISTS `food` CASCADE;
270-- -------------------------------------------------------------
271
272
273-- CREATE TABLE "food" -----------------------------------------
274CREATE TABLE `food` (
275 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
276 `category_id` Int( 11 ) UNSIGNED NOT NULL,
277 `title` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
278 `description` Text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
279 `create_time` DateTime NULL,
280 `update_time` DateTime NULL,
281 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
282 `delete_time` DateTime NULL,
283 PRIMARY KEY ( `id` ) )
284CHARACTER SET = utf8
285COLLATE = utf8_general_ci
286ENGINE = InnoDB
287AUTO_INCREMENT = 1;
288-- -------------------------------------------------------------
289-- ---------------------------------------------------------
290
291
292-- CREATE TABLE "food_donor" -------------------------------
293-- DROP TABLE "food_donor" -------------------------------------
294DROP TABLE IF EXISTS `food_donor` CASCADE;
295-- -------------------------------------------------------------
296
297
298-- CREATE TABLE "food_donor" -----------------------------------
299CREATE TABLE `food_donor` (
300 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
301 `name` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
302 `description` Text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
303 `create_time` DateTime NULL,
304 `update_time` DateTime NULL,
305 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
306 `delete_time` DateTime NULL,
307 `telephone` VarChar( 11 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
308 `location_id` Int( 11 ) UNSIGNED NOT NULL,
309 PRIMARY KEY ( `id` ) )
310CHARACTER SET = utf8
311COLLATE = utf8_general_ci
312ENGINE = InnoDB
313AUTO_INCREMENT = 1;
314-- -------------------------------------------------------------
315-- ---------------------------------------------------------
316
317
318-- CREATE TABLE "food_recipients" --------------------------
319-- DROP TABLE "food_recipients" --------------------------------
320DROP TABLE IF EXISTS `food_recipients` CASCADE;
321-- -------------------------------------------------------------
322
323
324-- CREATE TABLE "food_recipients" ------------------------------
325CREATE TABLE `food_recipients` (
326 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
327 `name` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
328 `telephone` VarChar( 11 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
329 `description` Text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
330 `create_time` DateTime NULL,
331 `update_time` DateTime NULL,
332 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
333 `delete_time` DateTime NULL,
334 `location_id` Int( 11 ) UNSIGNED NOT NULL,
335 PRIMARY KEY ( `id` ) )
336CHARACTER SET = utf8
337COLLATE = utf8_general_ci
338ENGINE = InnoDB
339AUTO_INCREMENT = 1;
340-- -------------------------------------------------------------
341-- ---------------------------------------------------------
342
343
344-- CREATE TABLE "schedule" ---------------------------------
345-- DROP TABLE "schedule" ---------------------------------------
346DROP TABLE IF EXISTS `schedule` CASCADE;
347-- -------------------------------------------------------------
348
349
350-- CREATE TABLE "schedule" -------------------------------------
351CREATE TABLE `schedule` (
352 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
353 `schedule_number` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
354 `date` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
355 `driver` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
356 `description` Text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
357 `create_time` DateTime NULL,
358 `update_time` DateTime NULL,
359 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
360 `delete_time` DateTime NULL,
361 PRIMARY KEY ( `id` ) )
362CHARACTER SET = utf8
363COLLATE = utf8_general_ci
364ENGINE = InnoDB
365AUTO_INCREMENT = 1;
366-- -------------------------------------------------------------
367-- ---------------------------------------------------------
368
369
370-- CREATE TABLE "location" ---------------------------------
371-- DROP TABLE "location" ---------------------------------------
372DROP TABLE IF EXISTS `location` CASCADE;
373-- -------------------------------------------------------------
374
375
376-- CREATE TABLE "location" -------------------------------------
377CREATE TABLE `location` (
378 `id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
379 `location` Int( 11 ) UNSIGNED NOT NULL,
380 `create_time` DateTime NULL,
381 `update_time` DateTime NULL,
382 `deleted` TinyInt( 1 ) UNSIGNED NOT NULL,
383 `delete_time` DateTime NULL,
384 PRIMARY KEY ( `id` ) )
385CHARACTER SET = utf8
386COLLATE = utf8_general_ci
387ENGINE = InnoDB
388AUTO_INCREMENT = 1;
389-- -------------------------------------------------------------
390-- ---------------------------------------------------------
391
392
393-- Dump data of "auth_assignment" --------------------------
394BEGIN;
395
396INSERT INTO `auth_assignment`(`item_name`,`user_id`,`created_at`) VALUES ( 'Admin', '1', '1513167999' );
397COMMIT;
398-- ---------------------------------------------------------
399
400
401-- Dump data of "auth_item" --------------------------------
402BEGIN;
403
404INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( '/category/*', '2', '/category/*', NULL, NULL, '1513167952', '1513167952' );
405INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( '/opt-client-status/*', '2', '/opt-client-status/*', NULL, NULL, '1513168233', '1513168233' );
406INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( '/opt-delivery-status/*', '2', '/opt-delivery-status/*', NULL, NULL, '1513168243', '1513168243' );
407INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( '/opt-pickup-status/*', '2', '/opt-pickup-status/*', NULL, NULL, '1513168256', '1513168256' );
408INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( '/site/error', '2', '/site/error', NULL, NULL, '1513167884', '1513167884' );
409INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( '/site/index', '2', '/site/index', NULL, NULL, '1513167903', '1513167903' );
410INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( '/site/login', '2', '/site/login', NULL, NULL, '1513167913', '1513167913' );
411INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( '/site/logout', '2', '/site/logout', NULL, NULL, '1513167923', '1513167923' );
412INSERT INTO `auth_item`(`name`,`type`,`description`,`rule_name`,`data`,`created_at`,`updated_at`) VALUES ( 'Admin', '1', 'Hands for Hunger - Admin', NULL, NULL, '1513167851', '1513168265' );
413COMMIT;
414-- ---------------------------------------------------------
415
416
417-- Dump data of "auth_item_child" --------------------------
418BEGIN;
419
420INSERT INTO `auth_item_child`(`parent`,`child`) VALUES ( 'Admin', '/category/*' );
421INSERT INTO `auth_item_child`(`parent`,`child`) VALUES ( 'Admin', '/opt-client-status/*' );
422INSERT INTO `auth_item_child`(`parent`,`child`) VALUES ( 'Admin', '/opt-delivery-status/*' );
423INSERT INTO `auth_item_child`(`parent`,`child`) VALUES ( 'Admin', '/opt-pickup-status/*' );
424INSERT INTO `auth_item_child`(`parent`,`child`) VALUES ( 'Admin', '/site/error' );
425INSERT INTO `auth_item_child`(`parent`,`child`) VALUES ( 'Admin', '/site/index' );
426INSERT INTO `auth_item_child`(`parent`,`child`) VALUES ( 'Admin', '/site/login' );
427INSERT INTO `auth_item_child`(`parent`,`child`) VALUES ( 'Admin', '/site/logout' );
428COMMIT;
429-- ---------------------------------------------------------
430
431
432-- Dump data of "auth_rule" --------------------------------
433-- ---------------------------------------------------------
434
435
436-- Dump data of "category" ---------------------------------
437BEGIN;
438
439INSERT INTO `category`(`id`,`title`,`description`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '1', 'Fresh', 'Fresh Food', '2017-12-13 13:36:40', '2017-12-13 13:36:40', '0', NULL );
440INSERT INTO `category`(`id`,`title`,`description`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '2', 'Frozen', 'Frozen Food', '2017-12-13 13:36:55', '2017-12-13 13:36:55', '0', NULL );
441INSERT INTO `category`(`id`,`title`,`description`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '3', 'Prepared', 'Prepared Food', '2017-12-13 13:37:14', '2017-12-13 13:37:14', '0', NULL );
442COMMIT;
443-- ---------------------------------------------------------
444
445
446-- Dump data of "opt_client_status" ------------------------
447BEGIN;
448
449INSERT INTO `opt_client_status`(`id`,`option`,`style`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '1', 'Client Status 1', 'default', '2017-12-13 13:34:22', '2017-12-13 13:34:22', '0', NULL );
450INSERT INTO `opt_client_status`(`id`,`option`,`style`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '2', 'Client Status 2', 'warning', '2017-12-13 13:34:33', '2017-12-13 13:34:33', '0', NULL );
451COMMIT;
452-- ---------------------------------------------------------
453
454
455-- Dump data of "opt_delivery_status" ----------------------
456BEGIN;
457
458INSERT INTO `opt_delivery_status`(`id`,`option`,`style`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '1', 'Pending', 'warning', '2017-12-13 13:34:58', '2017-12-13 13:34:58', '0', NULL );
459INSERT INTO `opt_delivery_status`(`id`,`option`,`style`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '2', 'Delivered', 'default', '2017-12-13 13:35:14', '2017-12-13 13:35:14', '0', NULL );
460INSERT INTO `opt_delivery_status`(`id`,`option`,`style`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '3', 'Canceled', 'danger', '2017-12-13 13:35:23', '2017-12-13 13:35:23', '0', NULL );
461COMMIT;
462-- ---------------------------------------------------------
463
464
465-- Dump data of "opt_pickup_status" ------------------------
466BEGIN;
467
468INSERT INTO `opt_pickup_status`(`id`,`option`,`style`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '1', 'Pending', 'warning', '2017-12-13 13:35:32', '2017-12-13 13:35:32', '0', NULL );
469INSERT INTO `opt_pickup_status`(`id`,`option`,`style`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '2', 'Picked up', 'default', '2017-12-13 13:35:43', '2017-12-13 13:35:43', '0', NULL );
470INSERT INTO `opt_pickup_status`(`id`,`option`,`style`,`create_time`,`update_time`,`deleted`,`delete_time`) VALUES ( '3', 'Canceled', 'danger', '2017-12-13 13:35:51', '2017-12-13 13:35:51', '0', NULL );
471COMMIT;
472-- ---------------------------------------------------------
473
474
475-- Dump data of "profile" ----------------------------------
476BEGIN;
477
478INSERT INTO `profile`(`user_id`,`name`,`public_email`,`gravatar_email`,`gravatar_id`,`location`,`website`,`bio`,`timezone`,`promis_username`) VALUES ( '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL );
479COMMIT;
480-- ---------------------------------------------------------
481
482
483-- Dump data of "token" ------------------------------------
484-- ---------------------------------------------------------
485
486
487-- Dump data of "user" -------------------------------------
488BEGIN;
489
490INSERT INTO `user`(`id`,`username`,`email`,`password_hash`,`auth_key`,`confirmed_at`,`unconfirmed_email`,`blocked_at`,`registration_ip`,`created_at`,`updated_at`,`flags`) VALUES ( '1', 'admin', 'menno@orangecay.com', '$2y$10$dwuJpnh0er8ZzPpr0t/3KO0GZg6u25mLwIWk7mCqicZfpgAPYDQWu', 'AQoP1qZl2kRRQveCTAdGyMF7VeOrJ_rz', '1482582840', NULL, NULL, NULL, '1482582840', '1513168866', '0' );
491COMMIT;
492-- ---------------------------------------------------------
493
494
495-- Dump data of "food" -------------------------------------
496-- ---------------------------------------------------------
497
498
499-- Dump data of "food_donor" -------------------------------
500-- ---------------------------------------------------------
501
502
503-- Dump data of "food_recipients" --------------------------
504-- ---------------------------------------------------------
505
506
507-- Dump data of "schedule" ---------------------------------
508-- ---------------------------------------------------------
509
510
511-- Dump data of "location" ---------------------------------
512-- ---------------------------------------------------------
513
514
515-- CREATE INDEX "idx-auth_item-type" -----------------------
516-- CREATE INDEX "idx-auth_item-type" ---------------------------
517CREATE INDEX `idx-auth_item-type` USING BTREE ON `auth_item`( `type` );
518-- -------------------------------------------------------------
519-- ---------------------------------------------------------
520
521
522-- CREATE INDEX "rule_name" --------------------------------
523-- CREATE INDEX "rule_name" ------------------------------------
524CREATE INDEX `rule_name` USING BTREE ON `auth_item`( `rule_name` );
525-- -------------------------------------------------------------
526-- ---------------------------------------------------------
527
528
529-- CREATE INDEX "child" ------------------------------------
530-- CREATE INDEX "child" ----------------------------------------
531CREATE INDEX `child` USING BTREE ON `auth_item_child`( `child` );
532-- -------------------------------------------------------------
533-- ---------------------------------------------------------
534
535
536-- CREATE INDEX "fk_category" ------------------------------
537-- CREATE INDEX "fk_category" ----------------------------------
538CREATE INDEX `fk_category` USING BTREE ON `food`( `category_id` );
539-- -------------------------------------------------------------
540-- ---------------------------------------------------------
541
542
543-- CREATE INDEX "fk_donor_location" ------------------------
544-- CREATE INDEX "fk_donor_location" ----------------------------
545CREATE INDEX `fk_donor_location` USING BTREE ON `food_donor`( `location_id` );
546-- -------------------------------------------------------------
547-- ---------------------------------------------------------
548
549
550-- CREATE INDEX "fk_recipients_location" -------------------
551-- CREATE INDEX "fk_recipients_location" -----------------------
552CREATE INDEX `fk_recipients_location` USING BTREE ON `food_recipients`( `location_id` );
553-- -------------------------------------------------------------
554-- ---------------------------------------------------------
555
556-- CREATE LINK "auth_assignment_ibfk_1" ------------------------
557ALTER TABLE `auth_assignment`
558 ADD CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY ( `item_name` )
559 REFERENCES `auth_item`( `name` )
560 ON DELETE Cascade
561 ON UPDATE Cascade;
562-- -------------------------------------------------------------
563-- ---------------------------------------------------------
564
565-- CREATE LINK "auth_item_ibfk_1" ------------------------------
566ALTER TABLE `auth_item`
567 ADD CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY ( `rule_name` )
568 REFERENCES `auth_rule`( `name` )
569 ON DELETE Set NULL
570 ON UPDATE Cascade;
571-- -------------------------------------------------------------
572-- ---------------------------------------------------------
573
574-- CREATE LINK "auth_item_child_ibfk_1" ------------------------
575ALTER TABLE `auth_item_child`
576 ADD CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY ( `parent` )
577 REFERENCES `auth_item`( `name` )
578 ON DELETE Cascade
579 ON UPDATE Cascade;
580-- -------------------------------------------------------------
581-- ---------------------------------------------------------
582
583-- CREATE LINK "auth_item_child_ibfk_2" ------------------------
584ALTER TABLE `auth_item_child`
585 ADD CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY ( `child` )
586 REFERENCES `auth_item`( `name` )
587 ON DELETE Cascade
588 ON UPDATE Cascade;
589-- -------------------------------------------------------------
590-- ---------------------------------------------------------
591
592-- CREATE LINK "profile_ibfk_1" --------------------------------
593ALTER TABLE `profile`
594 ADD CONSTRAINT `profile_ibfk_1` FOREIGN KEY ( `user_id` )
595 REFERENCES `user`( `id` )
596 ON DELETE Restrict
597 ON UPDATE Cascade;
598-- -------------------------------------------------------------
599-- ---------------------------------------------------------
600
601-- CREATE LINK "fk_user_token" ---------------------------------
602ALTER TABLE `token`
603 ADD CONSTRAINT `fk_user_token` FOREIGN KEY ( `user_id` )
604 REFERENCES `user`( `id` )
605 ON DELETE Cascade
606 ON UPDATE Restrict;
607-- -------------------------------------------------------------
608-- ---------------------------------------------------------
609
610-- CREATE LINK "fk_category" -----------------------------------
611ALTER TABLE `food`
612 ADD CONSTRAINT `fk_category` FOREIGN KEY ( `category_id` )
613 REFERENCES `category`( `id` )
614 ON DELETE Restrict
615 ON UPDATE Cascade;
616-- -------------------------------------------------------------
617-- ---------------------------------------------------------
618
619-- CREATE LINK "fk_donor_location" -----------------------------
620ALTER TABLE `food_donor`
621 ADD CONSTRAINT `fk_donor_location` FOREIGN KEY ( `location_id` )
622 REFERENCES `location`( `id` )
623 ON DELETE Restrict
624 ON UPDATE Restrict;
625-- -------------------------------------------------------------
626-- ---------------------------------------------------------
627
628-- CREATE LINK "fk_recipients_location" ------------------------
629ALTER TABLE `food_recipients`
630 ADD CONSTRAINT `fk_recipients_location` FOREIGN KEY ( `location_id` )
631 REFERENCES `location`( `id` )
632 ON DELETE Restrict
633 ON UPDATE Restrict;
634-- -------------------------------------------------------------
635-- ---------------------------------------------------------
636
637
638/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
639/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
640/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
641/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
642/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
643-- ---------------------------------------------------------