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

(-)a/installer/data/mysql/kohastructure.sql (-1 lines)
Lines 2169-2175 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
2169
  `publicationyear` smallint(6) default 0,
2169
  `publicationyear` smallint(6) default 0,
2170
  `place` varchar(255) default NULL, -- publication place of the suggested item
2170
  `place` varchar(255) default NULL, -- publication place of the suggested item
2171
  `isbn` varchar(30) default NULL, -- isbn of the suggested item
2171
  `isbn` varchar(30) default NULL, -- isbn of the suggested item
2172
  `mailoverseeing` smallint(1) default 0,
2173
  `biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered
2172
  `biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered
2174
  `reason` text, -- reason for accepting or rejecting the suggestion
2173
  `reason` text, -- reason for accepting or rejecting the suggestion
2175
  `patronreason` text, -- reason for making the suggestion
2174
  `patronreason` text, -- reason for making the suggestion
(-)a/installer/data/mysql/ru-RU/optional/sample_user_suggestions.sql (-2 / +2 lines)
Lines 1-4 Link Here
1
TRUNCATE suggestions;
1
TRUNCATE suggestions;
2
2
3
INSERT INTO `suggestions` (`suggestionid`, `suggestedby`, `managedby`, `STATUS`, `note`, `author`, `title`, `copyrightdate`, `publishercode`, `date`, `volumedesc`, `publicationyear`, `place`, `isbn`, `mailoverseeing`, `biblionumber`, `reason`) 
3
INSERT INTO `suggestions` (`suggestionid`, `suggestedby`, `managedby`, `STATUS`, `note`, `author`, `title`, `copyrightdate`, `publishercode`, `date`, `volumedesc`, `publicationyear`, `place`, `isbn`, `biblionumber`, `reason`) 
4
VALUES (1,0,NULL,'ASKED','нужна для УКЕ','','Мифы нашего времени',2008,'Часы','2008-05-01 08:02:26',NULL,NULL,NULL,NULL,0,0,NULL);
4
VALUES (1,0,NULL,'ASKED','нужна для УКЕ','','Мифы нашего времени',2008,'Часы','2008-05-01 08:02:26',NULL,NULL,NULL,NULL,0,NULL);
(-)a/installer/data/mysql/uk-UA/optional/sample_user_suggestions.sql (-2 / +2 lines)
Lines 1-4 Link Here
1
TRUNCATE suggestions;
1
TRUNCATE suggestions;
2
2
3
INSERT INTO `suggestions` (`suggestionid`, `suggestedby`, `managedby`, `STATUS`, `note`, `author`, `title`, `copyrightdate`, `publishercode`, `date`, `volumedesc`, `publicationyear`, `place`, `isbn`, `mailoverseeing`, `biblionumber`, `reason`) 
3
INSERT INTO `suggestions` (`suggestionid`, `suggestedby`, `managedby`, `STATUS`, `note`, `author`, `title`, `copyrightdate`, `publishercode`, `date`, `volumedesc`, `publicationyear`, `place`, `isbn`, `biblionumber`, `reason`) 
4
VALUES (1,0,NULL,'ASKED','потрібна для УКЕ','','Міфи нашого часу',2008,'Час','2008-05-01 08:02:26',NULL,NULL,NULL,NULL,0,0,NULL);
4
VALUES (1,0,NULL,'ASKED','потрібна для УКЕ','','Міфи нашого часу',2008,'Час','2008-05-01 08:02:26',NULL,NULL,NULL,NULL,0,NULL);
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +9 lines)
Lines 8781-8786 if ( CheckVersion($DBversion) ) { Link Here
8781
    SetVersion($DBversion);
8781
    SetVersion($DBversion);
8782
}
8782
}
8783
8783
8784
8785
$DBversion = '3.17.00.XXX';
8786
if ( CheckVersion($DBversion) ) {
8787
    $dbh->do(q{
8788
        ALTER TABLE suggestions DROP COLUMN mailoverseeing;
8789
    });
8790
    print "Upgrade to $DBversion done (Bug 13006: Drop column suggestion.mailoverseeing)";
8791
    SetVersion($DBversion);
8792
}
8784
=head1 FUNCTIONS
8793
=head1 FUNCTIONS
8785
8794
8786
=head2 TableExists($table)
8795
=head2 TableExists($table)
8787
- 

Return to bug 13006