1 DROP SCHEMA metabib CASCADE;
6 CREATE TABLE metabib.metarecord (
7 id BIGSERIAL PRIMARY KEY,
8 fingerprint TEXT NOT NULL,
12 CREATE INDEX metabib_metarecord_master_record_idx ON metabib.metarecord (master_record);
13 CREATE INDEX metabib_metarecord_fingerprint_idx ON metabib.metarecord (fingerprint);
15 CREATE TABLE metabib.title_field_entry (
16 id BIGSERIAL PRIMARY KEY,
17 source BIGINT NOT NULL,
20 index_vector tsvector NOT NULL
22 CREATE TRIGGER metabib_title_field_entry_fti_trigger
23 BEFORE UPDATE OR INSERT ON metabib.title_field_entry
24 FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('title');
26 CREATE INDEX metabib_title_field_entry_index_vector_idx ON metabib.title_field_entry USING GIST (index_vector);
29 CREATE TABLE metabib.author_field_entry (
30 id BIGSERIAL PRIMARY KEY,
31 source BIGINT NOT NULL,
34 index_vector tsvector NOT NULL
36 CREATE TRIGGER metabib_author_field_entry_fti_trigger
37 BEFORE UPDATE OR INSERT ON metabib.author_field_entry
38 FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('author');
40 CREATE INDEX metabib_author_field_entry_index_vector_idx ON metabib.author_field_entry USING GIST (index_vector);
43 CREATE TABLE metabib.subject_field_entry (
44 id BIGSERIAL PRIMARY KEY,
45 source BIGINT NOT NULL,
48 index_vector tsvector NOT NULL
50 CREATE TRIGGER metabib_subject_field_entry_fti_trigger
51 BEFORE UPDATE OR INSERT ON metabib.subject_field_entry
52 FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('subject');
54 CREATE INDEX metabib_subject_field_entry_index_vector_idx ON metabib.subject_field_entry USING GIST (index_vector);
57 CREATE TABLE metabib.keyword_field_entry (
58 id BIGSERIAL PRIMARY KEY,
59 source BIGINT NOT NULL,
62 index_vector tsvector NOT NULL
64 CREATE TRIGGER metabib_keyword_field_entry_fti_trigger
65 BEFORE UPDATE OR INSERT ON metabib.keyword_field_entry
66 FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('keyword');
68 CREATE INDEX metabib_keyword_field_entry_index_vector_idx ON metabib.keyword_field_entry USING GIST (index_vector);
71 CREATE TABLE metabib.series_field_entry (
72 id BIGSERIAL PRIMARY KEY,
73 source BIGINT NOT NULL,
76 index_vector tsvector NOT NULL
78 CREATE TRIGGER metabib_series_field_entry_fti_trigger
79 BEFORE UPDATE OR INSERT ON metabib.series_field_entry
80 FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('series');
82 CREATE INDEX metabib_series_field_entry_index_vector_idx ON metabib.series_field_entry USING GIST (index_vector);
85 CREATE TABLE metabib.rec_descriptor (
86 id BIGSERIAL PRIMARY KEY,
102 CREATE INDEX metabib_rec_descriptor_record_idx ON metabib.rec_descriptor (record);
103 /* We may not need these...
105 CREATE INDEX metabib_rec_descriptor_item_type_idx ON metabib.rec_descriptor (item_type);
106 CREATE INDEX metabib_rec_descriptor_item_form_idx ON metabib.rec_descriptor (item_form);
107 CREATE INDEX metabib_rec_descriptor_bib_level_idx ON metabib.rec_descriptor (bib_level);
108 CREATE INDEX metabib_rec_descriptor_control_type_idx ON metabib.rec_descriptor (control_type);
109 CREATE INDEX metabib_rec_descriptor_char_encoding_idx ON metabib.rec_descriptor (char_encoding);
110 CREATE INDEX metabib_rec_descriptor_enc_level_idx ON metabib.rec_descriptor (enc_level);
111 CREATE INDEX metabib_rec_descriptor_audience_idx ON metabib.rec_descriptor (audience);
112 CREATE INDEX metabib_rec_descriptor_lit_form_idx ON metabib.rec_descriptor (lit_form);
113 CREATE INDEX metabib_rec_descriptor_cat_form_idx ON metabib.rec_descriptor (cat_form);
114 CREATE INDEX metabib_rec_descriptor_pub_status_idx ON metabib.rec_descriptor (pub_status);
115 CREATE INDEX metabib_rec_descriptor_item_lang_idx ON metabib.rec_descriptor (item_lang);
116 CREATE INDEX metabib_rec_descriptor_vr_format_idx ON metabib.rec_descriptor (vr_format);
121 CREATE TABLE metabib.full_rec (
122 id BIGSERIAL PRIMARY KEY,
123 record BIGINT NOT NULL,
124 tag CHAR(3) NOT NULL,
129 index_vector tsvector NOT NULL
131 CREATE INDEX metabib_full_rec_record_idx ON metabib.full_rec (record);
132 CREATE TRIGGER metabib_full_rec_fti_trigger
133 BEFORE UPDATE OR INSERT ON metabib.full_rec
134 FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('default');
136 CREATE INDEX metabib_full_rec_index_vector_idx ON metabib.full_rec USING GIST (index_vector);
139 CREATE TABLE metabib.metarecord_source_map (
140 id BIGSERIAL PRIMARY KEY,
141 metarecord BIGINT NOT NULL,
142 source BIGINT NOT NULL
144 CREATE INDEX metabib_metarecord_source_map_metarecord_idx ON metabib.metarecord_source_map (metarecord);
145 CREATE INDEX metabib_metarecord_source_map_source_record_idx ON metabib.metarecord_source_map (source);