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