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