1 CREATE TABLE marc_subfield_table (
2 subfieldid bigint(20) unsigned NOT NULL auto_increment,
3 tagid bigint(20) NOT NULL default '0',
4 tag char(3) NOT NULL default '',
5 bibid bigint(20) NOT NULL default '0',
6 subfieldorder tinyint(4) NOT NULL default '0',
7 subfieldcode char(1) NOT NULL default '',
8 subfieldvalue varchar(255) default NULL,
9 valuebloblink bigint(20) default NULL,
10 PRIMARY KEY (subfieldid),
11 KEY (bibid,tagid,tag,subfieldcode),
12 KEY (bibid,tag,subfieldcode,subfieldvalue)
16 CREATE TABLE marc_field_table_sergey (
17 fieldid bigint(20) unsigned NOT NULL auto_increment,
18 bibid bigint(20) NOT NULL default '0',
19 tagid bigint(20) NOT NULL default '0',
20 tag char(3) NOT NULL default '',
21 PRIMARY KEY (fieldid),
27 CREATE TABLE marc_subfield_table_sergey (
28 subfieldid bigint(20) unsigned NOT NULL auto_increment,
30 subfieldorder tinyint(4) NOT NULL default '0',
31 subfieldcode char(1) NOT NULL default '',
32 subfieldvalue varchar(255) default NULL,
33 valuebloblink bigint(20) default NULL,
34 PRIMARY KEY (subfieldid),