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

(-)a/installer/data/mysql/kohastructure.sql (-8 / +7 lines)
Lines 389-401 CREATE TABLE `branchrelations` ( -- this table links libraries/branches to group Link Here
389
--
389
--
390
390
391
DROP TABLE IF EXISTS `branchtransfers`;
391
DROP TABLE IF EXISTS `branchtransfers`;
392
CREATE TABLE `branchtransfers` (
392
CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches
393
  `itemnumber` int(11) NOT NULL default 0,
393
  `itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber)
394
  `datesent` datetime default NULL,
394
  `datesent` datetime default NULL, -- the date the transfer was initialized
395
  `frombranch` varchar(10) NOT NULL default '',
395
  `frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from
396
  `datearrived` datetime default NULL,
396
  `datearrived` datetime default NULL, -- the date the transfer arrived at its destination
397
  `tobranch` varchar(10) NOT NULL default '',
397
  `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to
398
  `comments` mediumtext,
398
  `comments` mediumtext, -- any comments related to the transfer
399
  KEY `frombranch` (`frombranch`),
399
  KEY `frombranch` (`frombranch`),
400
  KEY `tobranch` (`tobranch`),
400
  KEY `tobranch` (`tobranch`),
401
  KEY `itemnumber` (`itemnumber`),
401
  KEY `itemnumber` (`itemnumber`),
402
- 

Return to bug 6716