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

(-)a/installer/data/mysql/atomicupdate/bug-4461_add-problem-reports-table.perl (-1 / +1 lines)
Lines 9-15 if( CheckVersion( $DBversion ) ) { Link Here
9 
            borrowernumber int(11) NOT NULL default 0, -- the user who created the problem report
 9 
            borrowernumber int(11) NOT NULL default 0, -- the user who created the problem report
10 
            branchcode varchar(10) NOT NULL default '', -- borrower's branch
 10 
            branchcode varchar(10) NOT NULL default '', -- borrower's branch
11 
            username varchar(75) default NULL, -- OPAC username
 11 
            username varchar(75) default NULL, -- OPAC username
12 
            problempage varchar(255) default NULL, -- page the user triggered the problem report form from
 12 
            problempage TEXT default NULL, -- page the user triggered the problem report form from
13 
            recipient enum('admin','library') NOT NULL default 'library', -- the 'to-address' of the problem report
 13 
            recipient enum('admin','library') NOT NULL default 'library', -- the 'to-address' of the problem report
14 
            created_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- timestamp of report submission
 14 
            created_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- timestamp of report submission
15 
            status varchar(6) NOT NULL default 'New', -- status of the report. New, Viewed, Closed
 15 
            status varchar(6) NOT NULL default 'New', -- status of the report. New, Viewed, Closed
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 4448-4454 CREATE TABLE `problem_reports` ( Link Here
4448 
    `borrowernumber` int(11) NOT NULL default 0, -- the user who created the problem report
 4448 
    `borrowernumber` int(11) NOT NULL default 0, -- the user who created the problem report
4449 
    `branchcode` varchar(10) NOT NULL default '', -- borrower's branch
 4449 
    `branchcode` varchar(10) NOT NULL default '', -- borrower's branch
4450 
    `username` varchar(75) default NULL, -- OPAC username
 4450 
    `username` varchar(75) default NULL, -- OPAC username
4451 
    `problempage` varchar(255) default NULL, -- page the user triggered the problem report form from
 4451 
    `problempage` TEXT default NULL, -- page the user triggered the problem report form from
4452 
    `recipient` enum('admin','library') NOT NULL default 'library', -- the 'to-address' of the problem report
 4452 
    `recipient` enum('admin','library') NOT NULL default 'library', -- the 'to-address' of the problem report
4453 
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- timestamp of report submission
 4453 
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- timestamp of report submission
4454 
    `status` varchar(6) NOT NULL default 'New', -- status of the report. New, Viewed, Closed
 4454 
    `status` varchar(6) NOT NULL default 'New', -- status of the report. New, Viewed, Closed
4455 
-

Return to bug 4461