|
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 |
- |
|
|