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 / +8 lines)
Lines 8800-8805 if ( CheckVersion($DBversion) ) { Link Here
8800
    SetVersion($DBversion);
8800
    SetVersion($DBversion);
8801
}
8801
}
8802
8802
8803
$DBversion = '3.17.00.XXX';
8804
if ( CheckVersion($DBversion) ) {
8805
    $dbh->do(q{
8806
        ALTER TABLE suggestions DROP COLUMN mailoverseeing;
8807
    });
8808
    print "Upgrade to $DBversion done (Bug 13006: Drop column suggestion.mailoverseeing)";
8809
    SetVersion($DBversion);
8810
}
8803
8811
8804
=head1 FUNCTIONS
8812
=head1 FUNCTIONS
8805
8813
8806
- 

Return to bug 13006