|
Lines 4207-4212
CREATE TABLE `oauth_access_tokens` (
Link Here
|
| 4207 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4207 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4208 |
|
4208 |
|
| 4209 |
-- |
4209 |
-- |
|
|
4210 |
-- Table structure for table illcomments |
| 4211 |
-- |
| 4212 |
|
| 4213 |
DROP TABLE IF EXISTS `illcomments`; |
| 4214 |
CREATE TABLE illcomments ( |
| 4215 |
illcomment_id int(11) NOT NULL AUTO_INCREMENT, -- Unique ID of the comment |
| 4216 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
| 4217 |
borrowernumber integer DEFAULT NULL, -- Link to the user who made the comment (could be librarian, patron or ILL partner library) |
| 4218 |
comment text DEFAULT NULL, -- The text of the comment |
| 4219 |
timestamp timestamp DEFAULT CURRENT_TIMESTAMP, -- Date and time when the comment was made |
| 4220 |
PRIMARY KEY ( illcomment_id ), |
| 4221 |
CONSTRAINT illcomments_bnfk |
| 4222 |
FOREIGN KEY ( borrowernumber ) |
| 4223 |
REFERENCES borrowers ( borrowernumber ) |
| 4224 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 4225 |
CONSTRAINT illcomments_ifk |
| 4226 |
FOREIGN KEY (illrequest_id) |
| 4227 |
REFERENCES illrequests ( illrequest_id ) |
| 4228 |
ON UPDATE CASCADE ON DELETE CASCADE |
| 4229 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4230 |
|
| 4231 |
-- |
| 4210 |
-- Table structure for table `circulation_rules` |
4232 |
-- Table structure for table `circulation_rules` |
| 4211 |
-- |
4233 |
-- |
| 4212 |
|
4234 |
|
| 4213 |
- |
|
|