2 if( CheckVersion( $DBversion ) ) {
3 unless (TableExists('illcomments')) {
5 CREATE TABLE illcomments (
6 illcomment_id int(11) NOT NULL AUTO_INCREMENT, -- Unique ID of the comment
7 illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number
8 borrowernumber integer DEFAULT NULL, -- Link to the user who made the comment (could be librarian, patron or ILL partner library)
9 comment text DEFAULT NULL, -- The text of the comment
10 timestamp timestamp DEFAULT CURRENT_TIMESTAMP, -- Date and time when the comment was made
11 PRIMARY KEY ( illcomment_id ),
12 CONSTRAINT illcomments_bnfk
13 FOREIGN KEY ( borrowernumber )
14 REFERENCES borrowers ( borrowernumber )
15 ON UPDATE CASCADE ON DELETE CASCADE,
16 CONSTRAINT illcomments_ifk
17 FOREIGN KEY (illrequest_id)
18 REFERENCES illrequests ( illrequest_id )
19 ON UPDATE CASCADE ON DELETE CASCADE
20 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
24 SetVersion( $DBversion );
25 print "Upgrade to $DBversion done (Bug 18591 - Add comments to ILL requests)\n";