xnpphoto/sql/mysql.sql

#
# $Revision: $
#
# Table structure for table `xnpphoto_item_detail`
#

CREATE TABLE xnpphoto_item_detail (
  photo_id int(10) unsigned NOT NULL,
  title varchar(255) default NULL,
  title_translation 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  (photo_id)
) TYPE=MyISAM;

CREATE TABLE xnpphoto_item_detail_child_author (
  photo_child_author_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  photo_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  (photo_child_author_id)
) TYPE=MyISAM;

CREATE TABLE xnpphoto_item_detail_child_keywords (
  photo_child_keywords_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  photo_id int(10) unsigned NOT NULL,
  keywords text,
  keywords_order int(10) unsigned,
  PRIMARY KEY  (photo_child_keywords_id)
) TYPE=MyISAM;

CREATE TABLE xnpphoto_item_detail_child_free_keywords (
  photo_child_free_keywords_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  photo_id int(10) unsigned NOT NULL,
  free_keywords text,
  free_keywords_order int(10) unsigned,
  PRIMARY KEY  (photo_child_free_keywords_id)
) TYPE=MyISAM;