Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

37 lines (33 sloc) 1.238 kB
CREATE TABLE marc_subfield_table (
subfieldid bigint(20) unsigned NOT NULL auto_increment,
tagid bigint(20) NOT NULL default '0',
tag char(3) NOT NULL default '',
bibid bigint(20) NOT NULL default '0',
subfieldorder tinyint(4) NOT NULL default '0',
subfieldcode char(1) NOT NULL default '',
subfieldvalue varchar(255) default NULL,
valuebloblink bigint(20) default NULL,
PRIMARY KEY (subfieldid),
KEY (bibid,tagid,tag,subfieldcode),
KEY (bibid,tag,subfieldcode,subfieldvalue)
) TYPE=MyISAM;
CREATE TABLE marc_field_table_sergey (
fieldid bigint(20) unsigned NOT NULL auto_increment,
bibid bigint(20) NOT NULL default '0',
tagid bigint(20) NOT NULL default '0',
tag char(3) NOT NULL default '',
PRIMARY KEY (fieldid),
KEY (bibid),
KEY (tagid),
KEY (tag)
);
CREATE TABLE marc_subfield_table_sergey (
subfieldid bigint(20) unsigned NOT NULL auto_increment,
fieldid bigint(20),
subfieldorder tinyint(4) NOT NULL default '0',
subfieldcode char(1) NOT NULL default '',
subfieldvalue varchar(255) default NULL,
valuebloblink bigint(20) default NULL,
PRIMARY KEY (subfieldid),
KEY (fieldid)
);
Jump to Line
Something went wrong with that request. Please try again.