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 3561-3567 DROP TABLE IF EXISTS `item_groups`; Link Here
3561
/*!40101 SET character_set_client = utf8 */;
3561
/*!40101 SET character_set_client = utf8 */;
3562
CREATE TABLE `item_groups` (
3562
CREATE TABLE `item_groups` (
3563
  `item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group',
3563
  `item_group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id for the items group',
3564
  `biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'id for the bibliographic record the group belongs to',
3564
  `biblio_id` int(11) NOT NULL COMMENT 'id for the bibliographic record the group belongs to',
3565
  `display_order` int(4) NOT NULL DEFAULT 0 COMMENT 'The ''sort order'' for item_groups',
3565
  `display_order` int(4) NOT NULL DEFAULT 0 COMMENT 'The ''sort order'' for item_groups',
3566
  `description` mediumtext DEFAULT NULL COMMENT 'A group description',
3566
  `description` mediumtext DEFAULT NULL COMMENT 'A group description',
3567
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the group was created',
3567
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the group was created',
Lines 4841-4847 CREATE TABLE `recalls` ( Link Here
4841
  `recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall',
4841
  `recall_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unique identifier for this recall',
4842
  `patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall',
4842
  `patron_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for patron who requested recall',
4843
  `created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested',
4843
  `created_date` datetime DEFAULT NULL COMMENT 'Date the recall was requested',
4844
  `biblio_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Identifier for bibliographic record that has been recalled',
4844
  `biblio_id` int(11) NOT NULL COMMENT 'Identifier for bibliographic record that has been recalled',
4845
  `pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library',
4845
  `pickup_library_id` varchar(10) DEFAULT NULL COMMENT 'Identifier for recall pickup library',
4846
  `completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)',
4846
  `completed_date` datetime DEFAULT NULL COMMENT 'Date the recall is completed (fulfilled, cancelled or expired)',
4847
  `notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall',
4847
  `notes` mediumtext DEFAULT NULL COMMENT 'Notes related to the recall',
4848
- 

Return to bug 33053