|
Lines 2284-2323
CREATE TABLE `curbside_pickup_policy` (
Link Here
|
| 2284 |
`pickup_interval` INT(2) NOT NULL DEFAULT 0, |
2284 |
`pickup_interval` INT(2) NOT NULL DEFAULT 0, |
| 2285 |
`patrons_per_interval` INT(2) NOT NULL DEFAULT 0, |
2285 |
`patrons_per_interval` INT(2) NOT NULL DEFAULT 0, |
| 2286 |
`patron_scheduled_pickup` TINYINT(1) NOT NULL DEFAULT 0, |
2286 |
`patron_scheduled_pickup` TINYINT(1) NOT NULL DEFAULT 0, |
| 2287 |
`sunday_start_hour` INT(2) NULL DEFAULT NULL, |
|
|
| 2288 |
`sunday_start_minute` INT(2) NULL DEFAULT NULL, |
| 2289 |
`sunday_end_hour` INT(2) NULL DEFAULT NULL, |
| 2290 |
`sunday_end_minute` INT(2) NULL DEFAULT NULL, |
| 2291 |
`monday_start_hour` INT(2) NULL DEFAULT NULL, |
| 2292 |
`monday_start_minute` INT(2) NULL DEFAULT NULL, |
| 2293 |
`monday_end_hour` INT(2) NULL DEFAULT NULL, |
| 2294 |
`monday_end_minute` INT(2) NULL DEFAULT NULL, |
| 2295 |
`tuesday_start_hour` INT(2) NULL DEFAULT NULL, |
| 2296 |
`tuesday_start_minute` INT(2) NULL DEFAULT NULL, |
| 2297 |
`tuesday_end_hour` INT(2) NULL DEFAULT NULL, |
| 2298 |
`tuesday_end_minute` INT(2) NULL DEFAULT NULL, |
| 2299 |
`wednesday_start_hour` INT(2) NULL DEFAULT NULL, |
| 2300 |
`wednesday_start_minute` INT(2) NULL DEFAULT NULL, |
| 2301 |
`wednesday_end_hour` INT(2) NULL DEFAULT NULL, |
| 2302 |
`wednesday_end_minute` INT(2) NULL DEFAULT NULL, |
| 2303 |
`thursday_start_hour` INT(2) NULL DEFAULT NULL, |
| 2304 |
`thursday_start_minute` INT(2) NULL DEFAULT NULL, |
| 2305 |
`thursday_end_hour` INT(2) NULL DEFAULT NULL, |
| 2306 |
`thursday_end_minute` INT(2) NULL DEFAULT NULL, |
| 2307 |
`friday_start_hour` INT(2) NULL DEFAULT NULL, |
| 2308 |
`friday_start_minute` INT(2) NULL DEFAULT NULL, |
| 2309 |
`friday_end_hour` INT(2) NULL DEFAULT NULL, |
| 2310 |
`friday_end_minute` INT(2) NULL DEFAULT NULL, |
| 2311 |
`saturday_start_hour` INT(2) NULL DEFAULT NULL, |
| 2312 |
`saturday_start_minute` INT(2) NULL DEFAULT NULL, |
| 2313 |
`saturday_end_hour` INT(2) NULL DEFAULT NULL, |
| 2314 |
`saturday_end_minute` INT(2) NULL DEFAULT NULL, |
| 2315 |
`patron_scheduled_pickup` TINYINT(1) NOT NULL DEFAULT 0, |
| 2316 |
PRIMARY KEY (`id`), |
2287 |
PRIMARY KEY (`id`), |
| 2317 |
UNIQUE KEY (`branchcode`), |
2288 |
UNIQUE KEY (`branchcode`), |
| 2318 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE ON UPDATE CASCADE |
2289 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE ON UPDATE CASCADE |
| 2319 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2290 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2320 |
|
2291 |
|
|
|
2292 |
-- |
| 2293 |
-- Table structure for table `curbside_pickup_opening_slots` |
| 2294 |
-- |
| 2295 |
|
| 2296 |
DROP TABLE IF EXISTS `curbside_pickup_opening_slots`; |
| 2297 |
CREATE TABLE `curbside_pickup_opening_slots` ( |
| 2298 |
`id` INT(11) NOT NULL AUTO_INCREMENT, |
| 2299 |
`curbside_pickup_policy_id` INT(11) NOT NULL, |
| 2300 |
`day` TINYINT(1) NOT NULL, |
| 2301 |
`start_hour` INT(2) NOT NULL, |
| 2302 |
`start_minute` INT(2) NOT NULL, |
| 2303 |
`end_hour` INT(2) NOT NULL, |
| 2304 |
`end_minute` INT(2) NOT NULL, |
| 2305 |
PRIMARY KEY (`id`), |
| 2306 |
FOREIGN KEY (curbside_pickup_policy_id) REFERENCES curbside_pickup_policy(id) ON DELETE CASCADE ON UPDATE CASCADE |
| 2307 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2308 |
|
| 2321 |
-- |
2309 |
-- |
| 2322 |
-- Table structure for table `curbside_pickups` |
2310 |
-- Table structure for table `curbside_pickups` |
| 2323 |
-- |
2311 |
-- |
| 2324 |
- |
|
|