Attachment #41148 for bug #11023

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




    SetVersion($DBversion);
}

$DBversion = "3.21.00.XXX";
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
    $dbh->do(q{
        ALTER TABLE `items` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
    });
    $dbh->do(q{
        ALTER TABLE `deleteditems` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
    });
    print "Upgrade to $DBversion done (Bug 11023: Adds field 'new' in items and deleteditems tables)\n";
    SetVersion($DBversion);
}


# DEVELOPER PROCESS, search for anything to execute in the db_update directory
# SEE bug 13068
# if there is anything in the atomicupdate, read and execute it.
- 

Return to bug 11023

Lines 10704-10709 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +13 lines)
10704	SetVersion($DBversion);	10704	SetVersion($DBversion);
10705	}	10705	}
10706		10706
		10707	$DBversion = "3.21.00.XXX";
		10708	if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
		10709	$dbh->do(q{
		10710	ALTER TABLE `items` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
		10711	});
		10712	$dbh->do(q{
		10713	ALTER TABLE `deleteditems` ADD `new` VARCHAR(32) NULL AFTER `stocknumber`;
		10714	});
		10715	print "Upgrade to $DBversion done (Bug 11023: Adds field 'new' in items and deleteditems tables)\n";
		10716	SetVersion($DBversion);
		10717	}
		10718
		10719
10707	# DEVELOPER PROCESS, search for anything to execute in the db_update directory	10720	# DEVELOPER PROCESS, search for anything to execute in the db_update directory
10708	# SEE bug 13068	10721	# SEE bug 13068
10709	# if there is anything in the atomicupdate, read and execute it.	10722	# if there is anything in the atomicupdate, read and execute it.
10710	-

Lines 949-954 CREATE TABLE `deleteditems` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
949	`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)	949	`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
950	`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)	950	`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
951	`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)	951	`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
		952	`new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
952	PRIMARY KEY (`itemnumber`),	953	PRIMARY KEY (`itemnumber`),
953	KEY `delitembarcodeidx` (`barcode`),	954	KEY `delitembarcodeidx` (`barcode`),
954	KEY `delitemstocknumberidx` (`stocknumber`),	955	KEY `delitemstocknumberidx` (`stocknumber`),
Lines 1251-1256 CREATE TABLE `items` ( -- holdings/item information Link Here
1251	`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)	1252	`enumchron` text default NULL, -- serial enumeration/chronology for the item (MARC21 952$h)
1252	`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)	1253	`copynumber` varchar(32) default NULL, -- copy number (MARC21 952$t)
1253	`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)	1254	`stocknumber` varchar(32) default NULL, -- inventory number (MARC21 952$i)
		1255	`new` VARCHAR(32) DEFAULT NULL, -- 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
1254	PRIMARY KEY (`itemnumber`),	1256	PRIMARY KEY (`itemnumber`),
1255	UNIQUE KEY `itembarcodeidx` (`barcode`),	1257	UNIQUE KEY `itembarcodeidx` (`barcode`),
1256	KEY `itemstocknumberidx` (`stocknumber`),	1258	KEY `itemstocknumberidx` (`stocknumber`),