[Koha-cvs] CVS: koha/marc marcschema.sql,1.15,1.16

[Steve Tonnesen]

Update of /cvsroot/koha/koha/marc
In directory usw-pr-cvs1:/tmp/cvs-serv21498

Modified Files:
        marcschema.sql 
Log Message:
Added bibliothesaurus table


Index: marcschema.sql
===================================================================
RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -r1.15 -r1.16
*** marcschema.sql      24 Jul 2002 15:52:53 -0000      1.15
--- marcschema.sql      30 Aug 2002 17:26:14 -0000      1.16
***************
*** 2,5 ****
--- 2,8 ----
  #  
  #  $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,126 ****
--- 127,141 ----
                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;