Lines 4206-4211
CREATE TABLE `oauth_access_tokens` (
Link Here
|
4206 |
`client_id` VARCHAR(191) NOT NULL, -- the client id the access token belongs to |
4206 |
`client_id` VARCHAR(191) NOT NULL, -- the client id the access token belongs to |
4207 |
`expires` INT NOT NULL, -- expiration time in seconds |
4207 |
`expires` INT NOT NULL, -- expiration time in seconds |
4208 |
PRIMARY KEY (`access_token`) |
4208 |
PRIMARY KEY (`access_token`) |
|
|
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 |
4209 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4229 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
4210 |
|
4230 |
|
4211 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4231 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4212 |
- |
|
|