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=utf8 COLLATE=utf8_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 4175-4180 CREATE TABLE illrequestattributes ( Link Here
4175
      ON UPDATE CASCADE ON DELETE CASCADE
4175
      ON UPDATE CASCADE ON DELETE CASCADE
4176
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4176
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4177
4177
4178
--
4179
-- Table structure for table illcomments
4180
--
4181
4182
DROP TABLE IF EXISTS illcomments;
4183
CREATE TABLE illcomments (
4184
    illcomment_id int(11) NOT NULL AUTO_INCREMENT, -- Unique ID of the comment
4185
    illrequest_id bigint(20) unsigned NOT NULL,    -- ILL request number
4186
    borrowernumber integer DEFAULT NULL,           -- Link to the user who made the comment (could be librarian, patron or ILL partner library)
4187
    comment text DEFAULT NULL,                     -- The text of the comment
4188
    timestamp timestamp DEFAULT CURRENT_TIMESTAMP, -- Date and time when the comment was made
4189
    PRIMARY KEY  ( illcomment_id ),
4190
    CONSTRAINT illcomments_bnfk
4191
      FOREIGN KEY ( borrowernumber )
4192
      REFERENCES  borrowers  ( borrowernumber )
4193
      ON UPDATE CASCADE ON DELETE CASCADE,
4194
    CONSTRAINT illcomments_ifk
4195
      FOREIGN KEY (illrequest_id)
4196
      REFERENCES illrequests ( illrequest_id )
4197
      ON UPDATE CASCADE ON DELETE CASCADE
4198
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4199
4178
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4200
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4179
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4201
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4180
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4202
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
4181
- 

Return to bug 18591