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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2147-2153 DROP TABLE IF EXISTS `suggestions`; Link Here
2147
CREATE TABLE `suggestions` ( -- purchase suggestions
2147
CREATE TABLE `suggestions` ( -- purchase suggestions
2148
  `suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha
2148
  `suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha
2149
  `suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table
2149
  `suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table
2150
  `suggesteddate` date NOT NULL default 0, -- date the suggestion was submitted
2150
  `suggesteddate` date NOT NULL, -- date the suggestion was submitted
2151
  `managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table
2151
  `managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table
2152
  `manageddate` date default NULL, -- date the suggestion was updated
2152
  `manageddate` date default NULL, -- date the suggestion was updated
2153
   acceptedby INT(11) default NULL, -- borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table
2153
   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 / +9 lines)
Lines 7853-7858 if ( CheckVersion($DBversion) ) { Link Here
7853
   SetVersion ($DBversion);
7853
   SetVersion ($DBversion);
7854
}
7854
}
7855
7855
7856
$DBversion = "3.15.00.XXX";
7857
if ( CheckVersion($DBversion) ) {
7858
    $dbh->do(q{
7859
        ALTER TABLE suggestions MODIFY suggesteddate DATE NOT NULL
7860
    });
7861
    print "Upgrade to $DBversion done (Bug 11391) - drop default value on suggestions.suggesteddate column)\n";
7862
    SetVersion($DBversion);
7863
}
7864
7856
=head1 FUNCTIONS
7865
=head1 FUNCTIONS
7857
7866
7858
=head2 TableExists($table)
7867
=head2 TableExists($table)
7859
- 

Return to bug 11391