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

(-)a/installer/data/mysql/atomicupdate/bug_extended_attr_modification.sql (+12 lines)
Line 0 Link Here
1
ALTER TABLE borrower_modifications ADD COLUMN extended_attributes text DEFAULT NULL AFTER privacy;
2
3
-- $DBversion = "16.12.00.XXX";
4
-- if ( CheckVersion($DBversion) ) {
5
--
6
--     $dbh->do( "ALTER TABLE borrower_modifications
7
--                      ADD COLUMN extended_attributes text DEFAULT NULL
8
--                      AFTER privacy" );
9
--     print "Upgrade to $DBversion done (Bug 8835). Everything is fine.\n";
10
--
11
--     SetVersion($DBversion);
12
-- }
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 3424-3429 CREATE TABLE IF NOT EXISTS `borrower_modifications` ( Link Here
3424
  `altcontactphone` varchar(50) DEFAULT NULL,
3424
  `altcontactphone` varchar(50) DEFAULT NULL,
3425
  `smsalertnumber` varchar(50) DEFAULT NULL,
3425
  `smsalertnumber` varchar(50) DEFAULT NULL,
3426
  `privacy` int(11) DEFAULT NULL,
3426
  `privacy` int(11) DEFAULT NULL,
3427
  `extended_attributes` text DEFAULT NULL,
3427
  PRIMARY KEY (`verification_token`,`borrowernumber`),
3428
  PRIMARY KEY (`verification_token`,`borrowernumber`),
3428
  KEY `verification_token` (`verification_token`),
3429
  KEY `verification_token` (`verification_token`),
3429
  KEY `borrowernumber` (`borrowernumber`)
3430
  KEY `borrowernumber` (`borrowernumber`)
3430
- 

Return to bug 17767