Lines 2336-2375
CREATE TABLE `curbside_pickup_policy` (
Link Here
|
2336 |
`pickup_interval` INT(2) NOT NULL DEFAULT 0, |
2336 |
`pickup_interval` INT(2) NOT NULL DEFAULT 0, |
2337 |
`patrons_per_interval` INT(2) NOT NULL DEFAULT 0, |
2337 |
`patrons_per_interval` INT(2) NOT NULL DEFAULT 0, |
2338 |
`patron_scheduled_pickup` TINYINT(1) NOT NULL DEFAULT 0, |
2338 |
`patron_scheduled_pickup` TINYINT(1) NOT NULL DEFAULT 0, |
2339 |
`sunday_start_hour` INT(2) NULL DEFAULT NULL, |
|
|
2340 |
`sunday_start_minute` INT(2) NULL DEFAULT NULL, |
2341 |
`sunday_end_hour` INT(2) NULL DEFAULT NULL, |
2342 |
`sunday_end_minute` INT(2) NULL DEFAULT NULL, |
2343 |
`monday_start_hour` INT(2) NULL DEFAULT NULL, |
2344 |
`monday_start_minute` INT(2) NULL DEFAULT NULL, |
2345 |
`monday_end_hour` INT(2) NULL DEFAULT NULL, |
2346 |
`monday_end_minute` INT(2) NULL DEFAULT NULL, |
2347 |
`tuesday_start_hour` INT(2) NULL DEFAULT NULL, |
2348 |
`tuesday_start_minute` INT(2) NULL DEFAULT NULL, |
2349 |
`tuesday_end_hour` INT(2) NULL DEFAULT NULL, |
2350 |
`tuesday_end_minute` INT(2) NULL DEFAULT NULL, |
2351 |
`wednesday_start_hour` INT(2) NULL DEFAULT NULL, |
2352 |
`wednesday_start_minute` INT(2) NULL DEFAULT NULL, |
2353 |
`wednesday_end_hour` INT(2) NULL DEFAULT NULL, |
2354 |
`wednesday_end_minute` INT(2) NULL DEFAULT NULL, |
2355 |
`thursday_start_hour` INT(2) NULL DEFAULT NULL, |
2356 |
`thursday_start_minute` INT(2) NULL DEFAULT NULL, |
2357 |
`thursday_end_hour` INT(2) NULL DEFAULT NULL, |
2358 |
`thursday_end_minute` INT(2) NULL DEFAULT NULL, |
2359 |
`friday_start_hour` INT(2) NULL DEFAULT NULL, |
2360 |
`friday_start_minute` INT(2) NULL DEFAULT NULL, |
2361 |
`friday_end_hour` INT(2) NULL DEFAULT NULL, |
2362 |
`friday_end_minute` INT(2) NULL DEFAULT NULL, |
2363 |
`saturday_start_hour` INT(2) NULL DEFAULT NULL, |
2364 |
`saturday_start_minute` INT(2) NULL DEFAULT NULL, |
2365 |
`saturday_end_hour` INT(2) NULL DEFAULT NULL, |
2366 |
`saturday_end_minute` INT(2) NULL DEFAULT NULL, |
2367 |
`patron_scheduled_pickup` TINYINT(1) NOT NULL DEFAULT 0, |
2368 |
PRIMARY KEY (`id`), |
2339 |
PRIMARY KEY (`id`), |
2369 |
UNIQUE KEY (`branchcode`), |
2340 |
UNIQUE KEY (`branchcode`), |
2370 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE ON UPDATE CASCADE |
2341 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE ON UPDATE CASCADE |
2371 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2342 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2372 |
|
2343 |
|
|
|
2344 |
-- |
2345 |
-- Table structure for table `curbside_pickup_opening_slots` |
2346 |
-- |
2347 |
|
2348 |
DROP TABLE IF EXISTS `curbside_pickup_opening_slots`; |
2349 |
CREATE TABLE `curbside_pickup_opening_slots` ( |
2350 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
2351 |
`curbside_pickup_policy_id` INT(11) NOT NULL, |
2352 |
`day` TINYINT(1) NOT NULL, |
2353 |
`start_hour` INT(2) NOT NULL, |
2354 |
`start_minute` INT(2) NOT NULL, |
2355 |
`end_hour` INT(2) NOT NULL, |
2356 |
`end_minute` INT(2) NOT NULL, |
2357 |
PRIMARY KEY (`id`), |
2358 |
FOREIGN KEY (curbside_pickup_policy_id) REFERENCES curbside_pickup_policy(id) ON DELETE CASCADE ON UPDATE CASCADE |
2359 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2360 |
|
2373 |
-- |
2361 |
-- |
2374 |
-- Table structure for table `curbside_pickups` |
2362 |
-- Table structure for table `curbside_pickups` |
2375 |
-- |
2363 |
-- |
2376 |
- |
|
|