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 subfieldmark 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,subfieldmark),