xoonips-library/sql/mysql.sql

#
# $Revision: 1.00
#
# Table structure for table `xnparticle_item_detail`
#

CREATE TABLE xnparticle_item_detail (
  article_id int(10) unsigned NOT NULL,
  title varchar(255) default NULL,
  title_kana varchar(255) default NULL,
  title_romaji varchar(255) default NULL,
  edition varchar(255) default NULL,
  publish_place varchar(255) default NULL,
  publisher varchar(255),
  publisher_kana varchar(255) default NULL,
  publisher_romaji varchar(255) default NULL,
  year_f varchar(20),
  year_t varchar(20),
  date_create varchar(20),
  date_update varchar(20),
  date_record varchar(20),
  jtitle varchar(255),
  jtitle_translation varchar(255),
  jtitle_volume varchar(255),
  jtitle_issue varchar(255),
  jtitle_year varchar(255),
  jtitle_month varchar(255),
  jtitle_spage varchar(255),
  jtitle_epage varchar(255),
  abstract text,
  table_of_contents text,
  type_of_resource text,
  genre varchar(255) default NULL,
  access_condition text,
  link varchar(255) default NULL,
  PRIMARY KEY  (article_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_sub_title (
  article_child_sub_title_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  sub_title_name varchar(255) default NULL,
  sub_title_kana varchar(255) default NULL,
  sub_title_romaji varchar(255) default NULL,
  sub_title_order int(10) unsigned,
  PRIMARY KEY  (article_child_sub_title_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_author (
  article_child_author_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  author_id   varchar(255) NOT NULL,
  author_name varchar(255) NOT NULL,
  author_kana varchar(255) NOT NULL,
  author_romaji varchar(255) NOT NULL,
  author_affiliation varchar(255) NOT NULL,
  author_affiliation_translation varchar(255) NOT NULL,
  author_role varchar(255) NOT NULL,
  author_link varchar(255) NOT NULL,
  author_order int(10) unsigned,
  PRIMARY KEY  (article_child_author_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_keywords (
  article_child_keywords_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  keywords text,
  keywords_order int(10) unsigned,
  PRIMARY KEY  (article_child_keywords_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_ndc_classifications (
  article_child_ndc_classifications_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  ndc_classifications varchar(50),
  ndc_classifications_order int(10) unsigned,
  PRIMARY KEY  (article_child_ndc_classifications_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_physical_descriptions (
  article_child_physical_descriptions_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  physical_descriptions varchar(255),
  physical_descriptions_order int(10) unsigned,
  PRIMARY KEY  (article_child_physical_descriptions_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_langs (
  article_child_langs_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  langs varchar(50),
  langs_order int(10) unsigned,
  PRIMARY KEY  (article_child_langs_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_id_issns (
  article_child_id_issns_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  id_issns varchar(50),
  id_issns_order int(10) unsigned,
  PRIMARY KEY  (article_child_id_issns_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_id_isbns (
  article_child_id_isbns_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  id_isbns varchar(50),
  id_isbns_order int(10) unsigned,
  PRIMARY KEY  (article_child_id_isbns_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_id_dois (
  article_child_id_dois_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  id_dois varchar(50),
  id_dois_order int(10) unsigned,
  PRIMARY KEY  (article_child_id_dois_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_id_uris (
  article_child_id_uris_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  id_uris varchar(50),
  id_uris_order int(10) unsigned,
  PRIMARY KEY  (article_child_id_uris_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_id_locals (
  article_child_id_locals_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  id_locals varchar(50),
  id_locals_order int(10) unsigned,
  PRIMARY KEY  (article_child_id_locals_id)
) TYPE=MyISAM;

CREATE TABLE xnparticle_item_detail_child_uris (
  article_child_uris_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  article_id int(10) unsigned NOT NULL,
  uris varchar(50),
  uris_order int(10) unsigned,
  PRIMARY KEY  (article_child_uris_id)
) TYPE=MyISAM;
