Update of /cvsroot/koha/koha In directory usw-pr-cvs1:/tmp/cvs-serv18536 Modified Files: database.mysql Log Message: added branchrelations table and changed branchcategories table to allow admin/branches.pl to work properly. Index: database.mysql =================================================================== RCS file: /cvsroot/koha/koha/database.mysql,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -r1.3 -r1.4 *** database.mysql 29 Apr 2002 05:25:41 -0000 1.3 --- database.mysql 2 May 2002 00:23:26 -0000 1.4 *************** *** 305,310 **** CREATE TABLE branchcategories ( categorycode char(2) DEFAULT '' NOT NULL, ! branchcode char(4) DEFAULT '' NOT NULL, ! branchholding int(11) ); --- 305,319 ---- CREATE TABLE branchcategories ( categorycode char(2) DEFAULT '' NOT NULL, ! categoryname text, ! codedescription text, ! PRIMARY KEY (categorycode) ! ); ! ! # ! # Table structure for table 'branchrelations' ! # ! CREATE TABLE branchrelations ( ! branchcode varchar(4) DEFAULT '' NOT NULL, ! categorycode varchar(4) DEFAULT '' NOT NULL ); *************** *** 330,336 **** CREATE TABLE branchtransfers ( itemnumber int(11) DEFAULT '0' NOT NULL, ! datesent date DEFAULT '0000-00-00' NOT NULL, frombranch varchar(4), ! datearrived date, tobranch varchar(4), comments text --- 339,345 ---- CREATE TABLE branchtransfers ( itemnumber int(11) DEFAULT '0' NOT NULL, ! datesent datetime DEFAULT '0000-00-00' NOT NULL, frombranch varchar(4), ! datearrived datetime, tobranch varchar(4), comments text