From 86392dde00908b530c45e109a79e9b0693c3fcf9 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Wed, 11 Jul 2012 23:17:38 -0400 Subject: [PATCH] Bug 6716: Document branchtransfers table --- installer/data/mysql/kohastructure.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 57e3dcffd7..9578164def 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -389,13 +389,13 @@ CREATE TABLE `branchrelations` ( -- this table links libraries/branches to group -- DROP TABLE IF EXISTS `branchtransfers`; -CREATE TABLE `branchtransfers` ( - `itemnumber` int(11) NOT NULL default 0, - `datesent` datetime default NULL, - `frombranch` varchar(10) NOT NULL default '', - `datearrived` datetime default NULL, - `tobranch` varchar(10) NOT NULL default '', - `comments` mediumtext, +CREATE TABLE `branchtransfers` ( -- information for items that are in transit between branches + `itemnumber` int(11) NOT NULL default 0, -- the itemnumber that it is in transit (items.itemnumber) + `datesent` datetime default NULL, -- the date the transfer was initialized + `frombranch` varchar(10) NOT NULL default '', -- the branch the transfer is coming from + `datearrived` datetime default NULL, -- the date the transfer arrived at its destination + `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to + `comments` mediumtext, -- any comments related to the transfer KEY `frombranch` (`frombranch`), KEY `tobranch` (`tobranch`), KEY `itemnumber` (`itemnumber`), -- 2.39.2