[Koha-devel] CVS: koha database.mysql,1.3,1.4

[Finlay Thompson]

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