|
Lines 2324-2329
CREATE TABLE `creator_templates` (
Link Here
|
| 2324 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2324 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2325 |
/*!40101 SET character_set_client = @saved_cs_client */; |
2325 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 2326 |
|
2326 |
|
|
|
2327 |
-- |
| 2328 |
-- Table structure for table `curbside_pickup_policy` |
| 2329 |
-- |
| 2330 |
|
| 2331 |
DROP TABLE IF EXISTS `curbside_pickup_policy`; |
| 2332 |
CREATE TABLE `curbside_pickup_policy` ( |
| 2333 |
`id` int(11) NOT NULL auto_increment, |
| 2334 |
`branchcode` varchar(10) NOT NULL, |
| 2335 |
`enabled` TINYINT(1) NOT NULL DEFAULT 0, |
| 2336 |
`pickup_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, |
| 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`), |
| 2369 |
UNIQUE KEY (`branchcode`), |
| 2370 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE ON UPDATE CASCADE |
| 2371 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2372 |
|
| 2373 |
-- |
| 2374 |
-- Table structure for table `curbside_pickups` |
| 2375 |
-- |
| 2376 |
|
| 2377 |
DROP TABLE IF EXISTS `curbside_pickups`; |
| 2378 |
CREATE TABLE `curbside_pickups` ( |
| 2379 |
`id` int(11) NOT NULL auto_increment, |
| 2380 |
`borrowernumber` int(11) NOT NULL, |
| 2381 |
`branchcode` varchar(10) NOT NULL, |
| 2382 |
`scheduled_pickup_datetime` datetime NOT NULL, |
| 2383 |
`staged_datetime` datetime NULL DEFAULT NULL, |
| 2384 |
`staged_by` int(11) NULL DEFAULT NULL, |
| 2385 |
`arrival_datetime` datetime NULL DEFAULT NULL, |
| 2386 |
`delivered_datetime` datetime NULL DEFAULT NULL, |
| 2387 |
`delivered_by` int(11) NULL DEFAULT NULL, |
| 2388 |
`notes` text NULL DEFAULT NULL, |
| 2389 |
PRIMARY KEY (`id`), |
| 2390 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2391 |
FOREIGN KEY (borrowernumber) REFERENCES borrowers(borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2392 |
FOREIGN KEY (staged_by) REFERENCES borrowers(borrowernumber) ON DELETE SET NULL ON UPDATE CASCADE |
| 2393 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2394 |
|
| 2395 |
-- |
| 2396 |
-- Table structure for table `curbside_pickup_issues` |
| 2397 |
-- |
| 2398 |
|
| 2399 |
DROP TABLE IF EXISTS `curbside_pickup_issues`; |
| 2400 |
CREATE TABLE `curbside_pickup_issues` ( |
| 2401 |
`id` int(11) NOT NULL auto_increment, |
| 2402 |
`curbside_pickup_id` int(11) NOT NULL, |
| 2403 |
`issue_id` int(11) NOT NULL, |
| 2404 |
`reserve_id` int(11) NOT NULL, |
| 2405 |
PRIMARY KEY (`id`), |
| 2406 |
FOREIGN KEY (curbside_pickup_id) REFERENCES curbside_pickups(id) ON DELETE CASCADE ON UPDATE CASCADE |
| 2407 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2408 |
|
| 2327 |
-- |
2409 |
-- |
| 2328 |
-- Table structure for table `currency` |
2410 |
-- Table structure for table `currency` |
| 2329 |
-- |
2411 |
-- |
| 2330 |
- |
|
|