From 23a8694aaaf7b2d8a8cef28e8a7bc100b1d76014 Mon Sep 17 00:00:00 2001
From: finlayt <finlayt>
Date: Thu, 2 May 2002 00:23:26 +0000
Subject: [PATCH] added branchrelations table and changed branchcategories
 table to allow admin/branches.pl to work properly.

---
 database.mysql | 17 +++++++++++++----
 1 file changed, 13 insertions(+), 4 deletions(-)

diff --git a/database.mysql b/database.mysql
index 90b9d55323..5971c2f923 100644
--- a/database.mysql
+++ b/database.mysql
@@ -304,8 +304,17 @@ CREATE TABLE borrowers (
 #
 CREATE TABLE branchcategories (
   categorycode char(2) DEFAULT '' NOT NULL,
-  branchcode char(4) DEFAULT '' NOT NULL,
-  branchholding int(11)
+  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
 );
 
 #
@@ -329,9 +338,9 @@ CREATE TABLE branches (
 #
 CREATE TABLE branchtransfers (
   itemnumber int(11) DEFAULT '0' NOT NULL,
-  datesent date DEFAULT '0000-00-00' NOT NULL,
+  datesent datetime DEFAULT '0000-00-00' NOT NULL,
   frombranch varchar(4),
-  datearrived date,
+  datearrived datetime,
   tobranch varchar(4),
   comments text
 );
-- 
2.39.5