--
-- データベーススキーマ
--

--
-- 記事データ
--

CREATE TABLE IF NOT EXISTS `btg_article` (
  `article_id` bigint(6) NOT NULL AUTO_INCREMENT,
  `article_type` varchar(1)  NOT NULL DEFAULT '0',
  `article_releasedate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `article_title` varchar(255)  NOT NULL,
  `article_content_type` varchar(1)  NOT NULL DEFAULT '0',
  `article_content` longtext ,
  `article_pdf` varchar(255)  DEFAULT NULL,
  `article_pdffilename` varchar(255)  DEFAULT NULL,
  `article_url` varchar(255)  DEFAULT NULL,
  `article_target` varchar(1)  NOT NULL DEFAULT '0',
  `article_status` varchar(1)  DEFAULT '0',
  `article_delete` varchar(1)  DEFAULT '0',
  `registered_user` varchar(16)  DEFAULT NULL,
  `registered_date` timestamp NULL DEFAULT NULL,
  `update_user` varchar(16)  DEFAULT NULL,
  `lastmodified_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 職種データ
--
CREATE TABLE IF NOT EXISTS `btg_occupationcategory` (
  `occupation_id` bigint(6) NOT NULL AUTO_INCREMENT,
  `occupation_name` varchar(255)  NOT NULL,
  `occupation_title1` varchar(255)  DEFAULT NULL,
  `occupation_title2` varchar(255)  DEFAULT NULL,
  `occupation_title3` varchar(255)  DEFAULT NULL,
  `occupation_content1` mediumtext ,
  `occupation_content2` mediumtext ,
  `occupation_content3` mediumtext ,
  `occupation_image1` varchar(255)  DEFAULT NULL,
  `occupation_imagename1` varchar(255)  DEFAULT NULL,
  `occupation_image2` varchar(255)  DEFAULT NULL,
  `occupation_imagename2` varchar(255)  DEFAULT NULL,
  `occupation_regular` varchar(1)  DEFAULT '0',
  `occupation_parttime` varchar(1)  DEFAULT '0',
  `occupation_urgentrecruitment` varchar(1)  DEFAULT '0',
  `occupation_sort` varchar(8)  DEFAULT '0',
  `occupation_status` varchar(1)  DEFAULT '0',
  `occupation_delete` varchar(1)  DEFAULT '0',
  `registered_user` varchar(16)  DEFAULT NULL,
  `registered_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_user` varchar(16)  DEFAULT NULL,
  `lastmodified_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`occupation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
