View | Details | Raw Unified | Return to bug 18591
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug18591-ill-comments.perl (+26 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    unless (TableExists('illcomments')) {
4
        $dbh->do(q{
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;
21
        });
22
    }
23
24
    SetVersion( $DBversion );
25
    print "Upgrade to $DBversion done (Bug 18591 - Add comments to ILL requests)\n";
26
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +22 lines)
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
- 

Return to bug 18591