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

(-)a/installer/data/mysql/atomicupdate/bug_33053.pl (+16 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "33053",
5
    description => "Remove default from biblio_id for item_groups and recalls tables",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
10
            ALTER TABLE item_groups CHANGE COLUMN `biblio_id` `biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the group belongs to'`
11
        });
12
        $dbh->do(q{
13
            ALTER TABLE recalls CHANGE COLUMN `biblio_id` `biblio_id` int(11) NOT NULL COMMENT 'Identifier for bibliographic record that has been recalled'
14
        });
15
    },
16
};
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 3566-3572 DROP TABLE IF EXISTS `item_groups`; Link Here
3566
/*!40101 SET character_set_client = utf8 */;
3566
/*!40101 SET character_set_client = utf8 */;
3567
CREATE TABLE `item_groups` (
3567
CREATE TABLE `item_groups` (
3568
  `item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group',
3568
  `item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group',
3569
  `biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id for the bibliographic record the group belongs to',
3569
  `biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the group belongs to',
3570
  `display_order` int(4) NOT NULL DEFAULT 0 COMMENT 'The ''sort order'' for item_groups',
3570
  `display_order` int(4) NOT NULL DEFAULT 0 COMMENT 'The ''sort order'' for item_groups',
3571
  `description` mediumtext DEFAULT NULL COMMENT 'A group description',
3571
  `description` mediumtext DEFAULT NULL COMMENT 'A group description',
3572
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the group was created',
3572
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the group was created',
Lines 4846-4852 CREATE TABLE `recalls` ( Link Here
4846
  `recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall',
4846
  `recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall',
4847
  `patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall',
4847
  `patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall',
4848
  `created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested',
4848
  `created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested',
4849
  `biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for bibliographic record that has been recalled',
4849
  `biblio_id` int(11) NOT NULL COMMENT 'Identifier for bibliographic record that has been recalled',
4850
  `pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library',
4850
  `pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library',
4851
  `completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)',
4851
  `completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)',
4852
  `notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall',
4852
  `notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall',
4853
- 

Return to bug 33053