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

(-)a/installer/data/mysql/atomicupdate/bug-33075.pl (+12 lines)
Lines 13-22 return { Link Here
13
            });
13
            });
14
        }
14
        }
15
15
16
        unless (column_exists('deleteditems', 'floating')) {
17
            $dbh->do(q{
18
                ALTER TABLE `deleteditems` ADD COLUMN `floating` TINYINT NOT NULL DEFAULT 0 COMMENT 'if set, the item does not return to its homebranch after being returned (overrides circulation rules)' AFTER withdrawn_on
19
            });
20
        }
21
16
        unless (column_exists('items', 'floating_on')) {
22
        unless (column_exists('items', 'floating_on')) {
17
            $dbh->do(q{
23
            $dbh->do(q{
18
                ALTER TABLE `items` ADD COLUMN `floating_on` DATETIME NULL DEFAULT NULL COMMENT 'the date and time an item was last marked as floating, NULL if not floating' AFTER floating
24
                ALTER TABLE `items` ADD COLUMN `floating_on` DATETIME NULL DEFAULT NULL COMMENT 'the date and time an item was last marked as floating, NULL if not floating' AFTER floating
19
            });
25
            });
20
        }
26
        }
27
28
        unless (column_exists('deleteditems', 'floating_on')) {
29
            $dbh->do(q{
30
                ALTER TABLE `deleteditems` ADD COLUMN `floating_on` DATETIME NULL DEFAULT NULL COMMENT 'the date and time an item was last marked as floating, NULL if not floating' AFTER floating
31
            });
32
        }
21
    },
33
    },
22
};
34
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 2782-2787 CREATE TABLE `deleteditems` ( Link Here
2782
  `itemlost_on` datetime DEFAULT NULL COMMENT 'the date and time an item was last marked as lost, NULL if not lost',
2782
  `itemlost_on` datetime DEFAULT NULL COMMENT 'the date and time an item was last marked as lost, NULL if not lost',
2783
  `withdrawn` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as withdrawn (MARC21 952$0)',
2783
  `withdrawn` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'authorized value defining this item as withdrawn (MARC21 952$0)',
2784
  `withdrawn_on` datetime DEFAULT NULL COMMENT 'the date and time an item was last marked as withdrawn, NULL if not withdrawn',
2784
  `withdrawn_on` datetime DEFAULT NULL COMMENT 'the date and time an item was last marked as withdrawn, NULL if not withdrawn',
2785
  `floating` TINYINT NOT NULL DEFAULT 0 COMMENT 'if set, the item does not return to its homebranch after being returned (overrides circulation rules)',
2786
  `floating_on` DATETIME NULL DEFAULT NULL COMMENT 'the date and time an item was last marked as floating, NULL if not floating',
2785
  `itemcallnumber` varchar(255) DEFAULT NULL COMMENT 'call number for this item (MARC21 952$o)',
2787
  `itemcallnumber` varchar(255) DEFAULT NULL COMMENT 'call number for this item (MARC21 952$o)',
2786
  `coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)',
2788
  `coded_location_qualifier` varchar(10) DEFAULT NULL COMMENT 'coded location qualifier(MARC21 952$f)',
2787
  `issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out',
2789
  `issues` smallint(6) DEFAULT 0 COMMENT 'number of times this item has been checked out',
2788
- 

Return to bug 33075