Update of /cvsroot/koha/koha/marc In directory usw-pr-cvs1:/tmp/cvs-serv15276/koha/marc Modified Files: marcschema.sql Log Message: Changed search interface to allow searches on Illustrator. This is apparently a common search in elementary school libraries. Index: marcschema.sql =================================================================== RCS file: /cvsroot/koha/koha/marc/marcschema.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -r1.1 -r1.2 *** marcschema.sql 2001/06/25 18:52:33 1.1 --- marcschema.sql 2001/10/05 20:13:20 1.2 *************** *** 1,7 **** create table Resource_Table (Resource_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, ! Date_Added TIMESTAMP, Date_Modified TIMESTAMP, Record_ID INT UNSIGNED, Statement_ID INT UNSIGNED, Scope_ID INT UNSIGNED, Container_ID INT UNSIGNED, ! primary key(Resource_ID)); create table Schema_Table (Schema_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, --- 1,8 ---- create table Resource_Table (Resource_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, ! Date_Added TIMESTAMP, Date_Modified TIMESTAMP, Record_ID INT UNSIGNED NOT NULL, Statement_ID INT UNSIGNED, Scope_ID INT UNSIGNED, Container_ID INT UNSIGNED, ! primary key(Resource_ID), ! key(Record_ID)); create table Schema_Table (Schema_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, *************** *** 40,57 **** create table Bib_Table (Bib_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, Record_ID INT UNSIGNED NOT NULL, ! Date_Added TIMESTAMP, Date_Modified TIMESTAMP, Control_ID INT UNSIGNED, ! Tag_0XX_ID INT UNSIGNED, Tag_1XX_ID INT UNSIGNED, Tag_2XX_ID INT ! UNSIGNED, Tag_3XX_ID INT UNSIGNED, Tag_4XX_ID INT UNSIGNED, Tag_5XX_ID ! INT UNSIGNED, Tag_6XX_ID INT UNSIGNED, Tag_7XX_ID INT UNSIGNED, ! Tag_8XX_ID INT UNSIGNED, Tag_9XX_ID INT UNSIGNED, Storage_ID INT ! UNSIGNED, Holdings_ID INT UNSIGNED, ! KEY ID_Index(Record_ID), primary key(Bib_ID)); create table 0XX_Tag_Table (Tag_Key INT UNSIGNED NOT NULL AUTO_INCREMENT, Tag_ID INT UNSIGNED NOT NULL, Indicator1 CHAR(1) NOT NULL, Indicator2 CHAR(1) NOT NULL, ! Tag CHAR(3) NOT NULL, Subfield_ID INT UNSIGNED, Authority_ID INT UNSIGNED, ! Link_Flag ENUM('Y','N','B'), Storage_ID INT UNSIGNED, KEY ID_Index(Tag_ID), KEY Tag_Index (Tag(3)), primary key(Tag_Key)); --- 41,61 ---- create table Bib_Table (Bib_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, Record_ID INT UNSIGNED NOT NULL, ! Date_Added TIMESTAMP, Date_Modified TIMESTAMP, Control_ID INT UNSIGNED NOT NULL, ! Tag_0XX_ID INT UNSIGNED NOT NULL, Tag_1XX_ID INT UNSIGNED NOT NULL, Tag_2XX_ID INT ! UNSIGNED NOT NULL, Tag_3XX_ID INT UNSIGNED NOT NULL, Tag_4XX_ID INT UNSIGNED NOT NULL, Tag_5XX_ID ! INT UNSIGNED NOT NULL, Tag_6XX_ID INT UNSIGNED NOT NULL, Tag_7XX_ID INT UNSIGNED NOT NULL, ! Tag_8XX_ID INT UNSIGNED NOT NULL, Tag_9XX_ID INT UNSIGNED NOT NULL, Storage_ID INT ! UNSIGNED NOT NULL, Holdings_ID INT UNSIGNED NOT NULL, ! KEY ID_Index(Record_ID), primary key(Bib_ID), ! key (TAG_0XX_ID), key (TAG_1XX_ID), key (TAG_2XX_ID), key (TAG_3XX_ID), key (TAG_4XX_ID), key (TAG_5XX_ID), key (TAG_6XX_ID), key (TAG_7XX_ID), key (TAG_8XX_ID), key (TAG_9XX_ID), key (Storage_ID), key (Holdings_ID)); create table 0XX_Tag_Table (Tag_Key INT UNSIGNED NOT NULL AUTO_INCREMENT, Tag_ID INT UNSIGNED NOT NULL, Indicator1 CHAR(1) NOT NULL, Indicator2 CHAR(1) NOT NULL, ! Tag CHAR(3) NOT NULL, Subfield_ID INT UNSIGNED NOT NULL, Authority_ID INT UNSIGNED, ! Link_Flag ENUM('Y','N','B'), Storage_ID INT UNSIGNED NOT NULL, KEY ID_Index(Tag_ID), + key (Subfield_ID), + key (Storage_ID), KEY Tag_Index (Tag(3)), primary key(Tag_Key)); *************** *** 67,73 **** Tag_ID INT UNSIGNED NOT NULL, Indicator1 CHAR(1) NOT NULL, Indicator2 CHAR(1) NOT NULL, ! Tag CHAR(3) NOT NULL, Subfield_ID INT UNSIGNED, Authority_ID INT UNSIGNED, ! Link_Flag ENUM('Y','N','B'), Storage_ID INT UNSIGNED, KEY ID_Index(Tag_ID), KEY Tag_Index (Tag(3)), primary key(Tag_Key)); --- 71,78 ---- Tag_ID INT UNSIGNED NOT NULL, Indicator1 CHAR(1) NOT NULL, Indicator2 CHAR(1) NOT NULL, ! Tag CHAR(3) NOT NULL, Subfield_ID INT UNSIGNED NOT NULL, Authority_ID INT UNSIGNED, ! Link_Flag ENUM('Y','N','B'), Storage_ID INT UNSIGNED NOT NULL, KEY ID_Index(Tag_ID), + key (Subfield_ID), key (Storage_ID), KEY Tag_Index (Tag(3)), primary key(Tag_Key));