From 1b8157ddd23aa4a8e71b1474c5105c906bb92395 Mon Sep 17 00:00:00 2001
From: tipaul <tipaul>
Date: Fri, 21 Jun 2002 08:56:46 +0000
Subject: [PATCH] MERGE 1-2 and main branches Still a few diffs :
 311,320c311,312 <   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 --- >   branchcode
 char(4) DEFAULT '' NOT NULL, >   branchholding int(11) 344c336 <   datesent
 datetime DEFAULT '0000-00-00' NOT NULL, --- >   datesent date DEFAULT
 '0000-00-00' NOT NULL, 346c338 <   datearrived datetime, --- >   datearrived
 date, 553a546 >

---
 database.mysql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/database.mysql b/database.mysql
index c6c10664dc..c78d49a4e5 100644
--- a/database.mysql
+++ b/database.mysql
@@ -804,6 +804,18 @@ CREATE TABLE users (
   level smallint(6)
 );
 
+#
+# Table structure for table 'websites'
+#
+
+CREATE TABLE websites (
+  websitenumber int(11) NOT NULL auto_increment,
+  biblionumber int(11) NOT NULL default '0',
+  title text,
+  description text,
+  url varchar(255),
+  PRIMARY KEY (websitenumber)
+) TYPE=ISAM PACK_KEYS=1;
 
 CREATE TABLE uploadedmarc (
   id int(11) NOT NULL auto_increment,
-- 
2.39.5