Attachment #36101 for bug #13743

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





DROP TABLE IF EXISTS `issues`;
CREATE TABLE `issues` ( -- information related to check outs or issues
  `issuesid` int(12) NOT NULL auto_increment,
  `borrowernumber` int(11), -- foreign key, linking this to the borrowers table for the patron this item was checked out to
  `itemnumber` int(11), -- foreign key, linking this to the items table for the item that was checked out
  `date_due` datetime default NULL, -- datetime the item is due (yyyy-mm-dd hh:mm::ss)

  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
  `issuedate` datetime default NULL, -- date the item was checked out or issued
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
  PRIMARY KEY (`issuesid`),
  KEY `issuesborridx` (`borrowernumber`),
  KEY `itemnumber_idx` (`itemnumber`),
  KEY `branchcode_idx` (`branchcode`),


DROP TABLE IF EXISTS `old_issues`;
CREATE TABLE `old_issues` ( -- lists items that were checked out and have been returned
  `issuesid` int(12) NOT NULL auto_increment,
  `borrowernumber` int(11) default NULL, -- foreign key, linking this to the borrowers table for the patron this item was checked out to
  `itemnumber` int(11) default NULL, -- foreign key, linking this to the items table for the item that was checked out
  `date_due` datetime default NULL, -- date the item is due (yyyy-mm-dd)

  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
  `issuedate` datetime default NULL, -- date the item was checked out or issued
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
  PRIMARY KEY (`issuesid`),
  KEY `old_issuesborridx` (`borrowernumber`),
  KEY `old_issuesitemidx` (`itemnumber`),
  KEY `branchcode_idx` (`branchcode`),

Lines 6661-6666 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
6661	SetVersion ($DBversion);	6661	SetVersion ($DBversion);
6662	}	6662	}
6663		6663
		6664	$DBversion = "3.19.00.XXX";
		6665	if ( CheckVersion($DBversion) ) {
		6666	$dbh->do("ALTER TABLE issues ADD COLUMN issuesid int(12) NOT NULL auto_increment FIRST, ADD CONSTRAINT PRIMARY KEY (issuesid);");
		6667	$dbh->do("ALTER TABLE old_issues ADD COLUMN issuesid int(12) NOT NULL auto_increment FIRST, ADD CONSTRAINT PRIMARY KEY (issuesid);");
		6668	print "Upgrade to $DBversion done (Bug 13743 - Primary key for issues-table)\n";
		6669	SetVersion ($DBversion);
		6670	}
		6671
6664	$DBversion = "3.11.00.108";	6672	$DBversion = "3.11.00.108";
6665	if ( CheckVersion($DBversion) ) {	6673	if ( CheckVersion($DBversion) ) {
6666	$dbh->do("ALTER TABLE action_logs CHANGE timestamp timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;");	6674	$dbh->do("ALTER TABLE action_logs CHANGE timestamp timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;");
6667	-

Return to bug 13743

Lines 1140-1145 CREATE TABLE `import_items` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (+4 lines)
1140		1140
1141	DROP TABLE IF EXISTS `issues`;	1141	DROP TABLE IF EXISTS `issues`;
1142	CREATE TABLE `issues` ( -- information related to check outs or issues	1142	CREATE TABLE `issues` ( -- information related to check outs or issues
		1143	`issuesid` int(12) NOT NULL auto_increment,
1143	`borrowernumber` int(11), -- foreign key, linking this to the borrowers table for the patron this item was checked out to	1144	`borrowernumber` int(11), -- foreign key, linking this to the borrowers table for the patron this item was checked out to
1144	`itemnumber` int(11), -- foreign key, linking this to the items table for the item that was checked out	1145	`itemnumber` int(11), -- foreign key, linking this to the items table for the item that was checked out
1145	`date_due` datetime default NULL, -- datetime the item is due (yyyy-mm-dd hh:mm::ss)	1146	`date_due` datetime default NULL, -- datetime the item is due (yyyy-mm-dd hh:mm::ss)
Lines 1153-1158 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1153	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched	1154	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1154	`issuedate` datetime default NULL, -- date the item was checked out or issued	1155	`issuedate` datetime default NULL, -- date the item was checked out or issued
1155	`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag	1156	`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
		1157	PRIMARY KEY (`issuesid`),
1156	KEY `issuesborridx` (`borrowernumber`),	1158	KEY `issuesborridx` (`borrowernumber`),
1157	KEY `itemnumber_idx` (`itemnumber`),	1159	KEY `itemnumber_idx` (`itemnumber`),
1158	KEY `branchcode_idx` (`branchcode`),	1160	KEY `branchcode_idx` (`branchcode`),
Lines 1614-1619 CREATE TABLE `oai_sets_biblios` ( Link Here
1614		1616
1615	DROP TABLE IF EXISTS `old_issues`;	1617	DROP TABLE IF EXISTS `old_issues`;
1616	CREATE TABLE `old_issues` ( -- lists items that were checked out and have been returned	1618	CREATE TABLE `old_issues` ( -- lists items that were checked out and have been returned
		1619	`issuesid` int(12) NOT NULL auto_increment,
1617	`borrowernumber` int(11) default NULL, -- foreign key, linking this to the borrowers table for the patron this item was checked out to	1620	`borrowernumber` int(11) default NULL, -- foreign key, linking this to the borrowers table for the patron this item was checked out to
1618	`itemnumber` int(11) default NULL, -- foreign key, linking this to the items table for the item that was checked out	1621	`itemnumber` int(11) default NULL, -- foreign key, linking this to the items table for the item that was checked out
1619	`date_due` datetime default NULL, -- date the item is due (yyyy-mm-dd)	1622	`date_due` datetime default NULL, -- date the item is due (yyyy-mm-dd)
Lines 1627-1632 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1627	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched	1630	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1628	`issuedate` datetime default NULL, -- date the item was checked out or issued	1631	`issuedate` datetime default NULL, -- date the item was checked out or issued
1629	`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag	1632	`onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
		1633	PRIMARY KEY (`issuesid`),
1630	KEY `old_issuesborridx` (`borrowernumber`),	1634	KEY `old_issuesborridx` (`borrowernumber`),
1631	KEY `old_issuesitemidx` (`itemnumber`),	1635	KEY `old_issuesitemidx` (`itemnumber`),
1632	KEY `branchcode_idx` (`branchcode`),	1636	KEY `branchcode_idx` (`branchcode`),