From 637c64680f9d453be7e3ce6dc0702b2c1998379f Mon Sep 17 00:00:00 2001
From: tonnesen <tonnesen>
Date: Fri, 30 Aug 2002 17:26:14 +0000
Subject: [PATCH] Added bibliothesaurus table

---
 marc/marcschema.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

diff --git a/marc/marcschema.sql b/marc/marcschema.sql
index e9eefb7860..409aff7bfb 100644
--- a/marc/marcschema.sql
+++ b/marc/marcschema.sql
@@ -1,6 +1,9 @@
 #  $Id$
 #  
 #  $Log$
+#  Revision 1.16  2002/08/30 17:26:14  tonnesen
+#  Added bibliothesaurus table
+#
 #  Revision 1.15  2002/07/24 15:52:53  tipaul
 #  1st scripts for MARC-DB.
 #
@@ -124,3 +127,15 @@ CREATE TABLE marc_subfield_table (
 		KEY sndx_word (sndx_word)
 		) TYPE=MyISAM;
 
+
+CREATE TABLE bibliothesaurus ( 
+   code bigint(20) NOT NULL auto_increment, 
+   freelib char(255) NOT NULL default '', 
+   stdlib char(255) NOT NULL default '', 
+   type char(80) NOT NULL default '', 
+   PRIMARY KEY  (code), 
+   KEY freelib (freelib), 
+   KEY stdlib (stdlib), 
+   KEY type (type) 
+ ) TYPE=MyISAM; 
+
-- 
2.20.1