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 4161-4166 CREATE TABLE library_groups ( Link Here
4161
    UNIQUE KEY title ( title )
4161
    UNIQUE KEY title ( title )
4162
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4162
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4163
4163
4164
--
4165
-- Table structure for table illcomments
4166
--
4167
4168
DROP TABLE IF EXISTS illcomments;
4169
CREATE TABLE illcomments (
4170
    illcomment_id int(11) NOT NULL AUTO_INCREMENT, -- Unique ID of the comment
4171
    illrequest_id bigint(20) unsigned NOT NULL,    -- ILL request number
4172
    borrowernumber integer DEFAULT NULL,           -- Link to the user who made the comment (could be librarian, patron or ILL partner library)
4173
    comment text DEFAULT NULL,                     -- The text of the comment
4174
    timestamp timestamp DEFAULT CURRENT_TIMESTAMP, -- Date and time when the comment was made
4175
    PRIMARY KEY  ( illcomment_id ),
4176
    CONSTRAINT illcomments_bnfk
4177
      FOREIGN KEY ( borrowernumber )
4178
      REFERENCES  borrowers  ( borrowernumber )
4179
      ON UPDATE CASCADE ON DELETE CASCADE,
4180
    CONSTRAINT illcomments_ifk
4181
      FOREIGN KEY (illrequest_id)
4182
      REFERENCES illrequests ( illrequest_id )
4183
      ON UPDATE CASCADE ON DELETE CASCADE
4184
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4185
4164
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4186
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4165
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4187
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4166
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4188
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4167
- 

Return to bug 18591