xnpbulletin/sql/mysql.sql

#
# $Revision: 1.4 $
#
# Table structure for table `xnpbulletin_item_detail`
#

CREATE TABLE xnpbulletin_item_detail (
  bulletin_id int(10) unsigned NOT NULL,
  title varchar(255) default NULL,
  title_kana varchar(255) default NULL,
  title_romaji varchar(255) default NULL,
  journal varchar(255) default NULL,
  journal_translation varchar(255) default NULL,
  volume varchar(30),
  number varchar(30),
  page varchar(30),
  publisher varchar(255),
  issn char(24),
  isbn char(24),
  abstract text,
  lang char(3) default 'eng',
  physical_description text,
  type_of_resource text,
  genre varchar(255) default NULL,
  link varchar(255) default NULL,
  PRIMARY KEY  (bulletin_id)
) TYPE=MyISAM;

CREATE TABLE xnpbulletin_item_detail_child_sub_title (
  bulletin_child_sub_title_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  bulletin_id int(10) unsigned NOT NULL,
  sub_title_translation varchar(255) default NULL,
  sub_title 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  (bulletin_child_sub_title_id)
) TYPE=MyISAM;

CREATE TABLE xnpbulletin_item_detail_child_author (
  bulletin_child_author_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  bulletin_id int(10) unsigned NOT NULL,
  author_name varchar(255) NOT NULL,
  author_romaji varchar(255) NOT NULL,
  author_affiliation varchar(255) NOT NULL,
  author_affiliation_translation varchar(255) NOT NULL,
  author_order int(10) unsigned,
  PRIMARY KEY  (bulletin_child_author_id)
) TYPE=MyISAM;

CREATE TABLE xnpbulletin_item_detail_child_keywords (
  bulletin_child_keywords_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  bulletin_id int(10) unsigned NOT NULL,
  keywords text,
  keywords_order int(10) unsigned,
  PRIMARY KEY  (bulletin_child_keywords_id)
) TYPE=MyISAM;

CREATE TABLE xnpbulletin_item_detail_child_free_keywords (
  bulletin_child_free_keywords_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  bulletin_id int(10) unsigned NOT NULL,
  free_keywords text,
  free_keywords_order int(10) unsigned,
  PRIMARY KEY  (bulletin_child_free_keywords_id)
) TYPE=MyISAM;