Lines 4286-4292
CREATE TABLE library_groups (
Link Here
|
4286 |
PRIMARY KEY id ( id ), |
4286 |
PRIMARY KEY id ( id ), |
4287 |
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, |
4287 |
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, |
4288 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE, |
4288 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE, |
4289 |
UNIQUE KEY title ( title ) |
4289 |
UNIQUE KEY title ( title ), |
|
|
4290 |
UNIQUE KEY library_groups_uniq_2 ( parent_id, branchcode ) |
4290 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4291 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4291 |
|
4292 |
|
4292 |
-- |
4293 |
-- |
4293 |
- |
|
|