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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 1861-1867 CREATE TABLE `suggestions` ( -- purchase suggestions Link Here
1861
  `isbn` varchar(30) default NULL, -- isbn of the suggested item
1861
  `isbn` varchar(30) default NULL, -- isbn of the suggested item
1862
  `mailoverseeing` smallint(1) default 0,
1862
  `mailoverseeing` smallint(1) default 0,
1863
  `biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered
1863
  `biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered
1864
  `reason` text, -- reason for making the suggestion
1864
  `reason` text, -- reason for accepting or rejecting the suggestion
1865
  `patronreason` text, -- reason for making the suggestion
1865
   budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table
1866
   budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table
1866
   branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table
1867
   branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table
1867
   collectiontitle text default NULL, -- collection name for the suggested item
1868
   collectiontitle text default NULL, -- collection name for the suggested item
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +7 lines)
Lines 4550-4555 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4550
    SetVersion ($DBversion);
4550
    SetVersion ($DBversion);
4551
}
4551
}
4552
4552
4553
$DBversion = "3.06.00.XXX";
4554
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4555
    $dbh->do("ALTER TABLE  `suggestions` ADD  `patronreason` TEXT NULL AFTER  `reason`");
4556
    print "Upgrade to $DBversion done (Add column to suggestions table to store patrons' reasons for submitting a suggestion. )\n";
4557
    SetVersion($DBversion);
4558
}
4559
4553
=head1 FUNCTIONS
4560
=head1 FUNCTIONS
4554
4561
4555
=head2 DropAllForeignKeys($table)
4562
=head2 DropAllForeignKeys($table)
4556
- 

Return to bug 6880