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