|
Lines 373-378
CREATE TABLE `cities` ( -- authorized values for cities/states/countries to choo
Link Here
|
| 373 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
373 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 374 |
|
374 |
|
| 375 |
-- |
375 |
-- |
|
|
376 |
-- Table structure for table desks |
| 377 |
-- |
| 378 |
|
| 379 |
DROP TABLE IF EXISTS desks; |
| 380 |
CREATE TABLE desks ( -- authorized values for desks available in a Library |
| 381 |
desk_id int(11) NOT NULL auto_increment, -- unique identifier |
| 382 |
desk_name varchar(100) NOT NULL default '', -- name of the desk |
| 383 |
branchcode varchar(10) NOT NULL, -- Library the desk is located into |
| 384 |
PRIMARY KEY (desk_id), |
| 385 |
KEY `fk_desks_branchcode` (branchcode), |
| 386 |
CONSTRAINT `fk_desks_branchcode` FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE |
| 387 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 388 |
|
| 389 |
-- |
| 376 |
-- Table structure for table `class_sort_rules` |
390 |
-- Table structure for table `class_sort_rules` |
| 377 |
-- |
391 |
-- |
| 378 |
|
392 |
|
| 379 |
- |
|
|