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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2140-2146 DROP TABLE IF EXISTS `suggestions`; Link Here
2140
CREATE TABLE `suggestions` ( -- purchase suggestions
2140
CREATE TABLE `suggestions` ( -- purchase suggestions
2141
  `suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha
2141
  `suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha
2142
  `suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table
2142
  `suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table
2143
  `suggesteddate` date NOT NULL default 0, -- date the suggestion was submitted
2143
  `suggesteddate` date NOT NULL, -- date the suggestion was submitted
2144
  `managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table
2144
  `managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table
2145
  `manageddate` date default NULL, -- date the suggestion was updated
2145
  `manageddate` date default NULL, -- date the suggestion was updated
2146
   acceptedby INT(11) default NULL, -- borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table
2146
   acceptedby INT(11) default NULL, -- borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7824-7829 if ( CheckVersion($DBversion) ) { Link Here
7824
    SetVersion($DBversion);
7824
    SetVersion($DBversion);
7825
}
7825
}
7826
7826
7827
$DBversion = "3.15.00.XXX";
7828
if ( CheckVersion($DBversion) ) {
7829
    $dbh->do(q{
7830
        ALTER TABLE suggestions MODIFY suggesteddate DATE NOT NULL
7831
    });
7832
    print "Upgrade to $DBversion done (Bug 11391) - drop default value on suggestions.suggesteddate column)\n";
7833
    SetVersion($DBversion);
7834
}
7827
7835
7828
=head1 FUNCTIONS
7836
=head1 FUNCTIONS
7829
7837
7830
- 

Return to bug 11391