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