Lines 4152-4158
CREATE TABLE library_groups (
Link Here
|
4152 |
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, |
4152 |
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, |
4153 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE, |
4153 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE, |
4154 |
UNIQUE KEY title ( title ) |
4154 |
UNIQUE KEY title ( title ) |
4155 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4155 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4156 |
|
4156 |
|
4157 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4157 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4158 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4158 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4159 |
- |
|
|