Lines 4175-4180
CREATE TABLE illrequestattributes (
Link Here
|
4175 |
ON UPDATE CASCADE ON DELETE CASCADE |
4175 |
ON UPDATE CASCADE ON DELETE CASCADE |
4176 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4176 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4177 |
|
4177 |
|
|
|
4178 |
-- |
4179 |
-- Table structure for table illcomments |
4180 |
-- |
4181 |
|
4182 |
DROP TABLE IF EXISTS illcomments; |
4183 |
CREATE TABLE illcomments ( |
4184 |
illcomment_id int(11) NOT NULL AUTO_INCREMENT, -- Unique ID of the comment |
4185 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
4186 |
borrowernumber integer DEFAULT NULL, -- Link to the user who made the comment (could be librarian, patron or ILL partner library) |
4187 |
comment text DEFAULT NULL, -- The text of the comment |
4188 |
timestamp timestamp DEFAULT CURRENT_TIMESTAMP, -- Date and time when the comment was made |
4189 |
PRIMARY KEY ( illcomment_id ), |
4190 |
CONSTRAINT illcomments_bnfk |
4191 |
FOREIGN KEY ( borrowernumber ) |
4192 |
REFERENCES borrowers ( borrowernumber ) |
4193 |
ON UPDATE CASCADE ON DELETE CASCADE, |
4194 |
CONSTRAINT illcomments_ifk |
4195 |
FOREIGN KEY (illrequest_id) |
4196 |
REFERENCES illrequests ( illrequest_id ) |
4197 |
ON UPDATE CASCADE ON DELETE CASCADE |
4198 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4199 |
|
4178 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4200 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4179 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4201 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4180 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4202 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4181 |
- |
|
|