Lines 4280-4286
CREATE TABLE library_groups (
Link Here
|
4280 |
PRIMARY KEY id ( id ), |
4280 |
PRIMARY KEY id ( id ), |
4281 |
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, |
4281 |
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, |
4282 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE, |
4282 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE, |
4283 |
UNIQUE KEY title ( title ) |
4283 |
UNIQUE KEY title ( title ), |
|
|
4284 |
UNIQUE KEY library_groups_uniq_2 ( parent_id, branchcode ) |
4284 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4285 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4285 |
|
4286 |
|
4286 |
-- |
4287 |
-- |
4287 |
- |
|
|