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 |
- |
|
|