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

(-)a/installer/data/mysql/atomicupdate/bug_20447-add_holdings_tables.perl (-1 / +1 lines)
Lines 10-16 if( CheckVersion( $DBversion ) ) { Link Here
10
                `location` varchar(80) default NULL, -- authorized value for the shelving location for this record (MARC21 852$b)
10
                `location` varchar(80) default NULL, -- authorized value for the shelving location for this record (MARC21 852$b)
11
                `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 852$g)
11
                `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 852$g)
12
                `callnumber` varchar(255) default NULL, -- call number (852$h+$i in MARC21)
12
                `callnumber` varchar(255) default NULL, -- call number (852$h+$i in MARC21)
13
                `suppress` tinyint(1) default NULL, -- Boolean indicating whether the record is suppressed in OPAC
13
                `suppress` tinyint(1) NOT NULL DEFAULT 0, -- Boolean indicating whether the record is suppressed in OPAC
14
                `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
14
                `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this record was last touched
15
                `datecreated` DATE NOT NULL, -- the date this record was added to Koha
15
                `datecreated` DATE NOT NULL, -- the date this record was added to Koha
16
                `deleted_on` DATETIME DEFAULT NULL, -- the date this record was deleted
16
                `deleted_on` DATETIME DEFAULT NULL, -- the date this record was deleted
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 2651-2657 CREATE TABLE `holdings` ( Link Here
2651
  `location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this record (MARC21 852$b)',
2651
  `location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this record (MARC21 852$b)',
2652
  `ccode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the collection code associated with this item (MARC21 852$g)',
2652
  `ccode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the collection code associated with this item (MARC21 852$g)',
2653
  `callnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'call number (852$h+$i in MARC21)',
2653
  `callnumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'call number (852$h+$i in MARC21)',
2654
  `suppress` tinyint(1) DEFAULT NULL COMMENT 'Boolean indicating whether the record is suppressed in OPAC',
2654
  `suppress` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Boolean indicating whether the record is suppressed in OPAC',
2655
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched',
2655
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this record was last touched',
2656
  `datecreated` date NOT NULL COMMENT 'the date this record was added to Koha',
2656
  `datecreated` date NOT NULL COMMENT 'the date this record was added to Koha',
2657
  `deleted_on` datetime DEFAULT NULL COMMENT 'the date this record was deleted',
2657
  `deleted_on` datetime DEFAULT NULL COMMENT 'the date this record was deleted',
2658
- 

Return to bug 20447