Lines 4161-4166
CREATE TABLE library_groups (
Link Here
|
4161 |
UNIQUE KEY title ( title ) |
4161 |
UNIQUE KEY title ( title ) |
4162 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4162 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4163 |
|
4163 |
|
|
|
4164 |
-- |
4165 |
-- Table structure for table illcomments |
4166 |
-- |
4167 |
|
4168 |
DROP TABLE IF EXISTS illcomments; |
4169 |
CREATE TABLE illcomments ( |
4170 |
illcomment_id int(11) NOT NULL AUTO_INCREMENT, -- Unique ID of the comment |
4171 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
4172 |
borrowernumber integer DEFAULT NULL, -- Link to the user who made the comment (could be librarian, patron or ILL partner library) |
4173 |
comment text DEFAULT NULL, -- The text of the comment |
4174 |
timestamp timestamp DEFAULT CURRENT_TIMESTAMP, -- Date and time when the comment was made |
4175 |
PRIMARY KEY ( illcomment_id ), |
4176 |
CONSTRAINT illcomments_bnfk |
4177 |
FOREIGN KEY ( borrowernumber ) |
4178 |
REFERENCES borrowers ( borrowernumber ) |
4179 |
ON UPDATE CASCADE ON DELETE CASCADE, |
4180 |
CONSTRAINT illcomments_ifk |
4181 |
FOREIGN KEY (illrequest_id) |
4182 |
REFERENCES illrequests ( illrequest_id ) |
4183 |
ON UPDATE CASCADE ON DELETE CASCADE |
4184 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4185 |
|
4164 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4186 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4165 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4187 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4166 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4188 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4167 |
- |
|
|