

#
# Table structure for table domain
#

CREATE TABLE `domain` (
  `id` varchar(32) collate utf8_unicode_ci NOT NULL,
  `domain_name` varchar(200) collate utf8_unicode_ci NOT NULL,
  `cloud_customer_id` int(11) NOT NULL,
  `account_user_id` varchar(32) collate utf8_unicode_ci NOT NULL,
  `create_date` datetime default NULL,
  `update_date` datetime default NULL,
  `flow` tinyint(1) NOT NULL,
  `plan` tinyint(1) NOT NULL,
  `ssl` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

#
# Table structure for table cloud_customer
#

CREATE TABLE `cloud_customer` (
  `id` int(11) NOT NULL auto_increment,
  `customer_name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `customer_id` int(11) NOT NULL,
  `create_date` datetime default NULL,
  `update_date` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#/*!40000 ALTER TABLE `cloud_customer` ENABLE KEYS */;

#/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
#/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
#/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
#/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

#
# Table structure for table cms_language
#
CREATE TABLE IF NOT EXISTS `cms_language` (
  `id` varchar(32) NOT NULL COMMENT 'データベース内の全データを一意に識別するための番号',
  `name` text NOT NULL COMMENT '名称',
  `language` varchar(10) NOT NULL COMMENT '言語の略称',
  `status` int(2) NOT NULL COMMENT '状態を表す番号(0=作成済み,1=公開中,2=差し戻し,3=編集済み,4=承認中,5=編集中,6=未公開)',
  `date_format` varchar(20) NOT NULL COMMENT '日付表示フォーマット',
  `sort` int(3) NOT NULL COMMENT '表示順',
  `date_update` varchar(19) NOT NULL COMMENT '最終更新日',
  `date_create` varchar(19) NOT NULL COMMENT '作成日時',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- テーブルのデータをダンプしています `cms_language`
--

INSERT INTO `cms_language` (`id`, `name`, `language`, `status`, `date_format`, `sort`, `date_update`, `date_create`) VALUES
('1', 'Japanese', 'ja', 1, 'YYYY/MM/DD', 1, '2011/10/26', '2011/10/26'),
('2', 'Chinese(simplified)', 'zh', 1, 'YYYY/MM/DD', 1, '2011/10/26    ', '2011/10/26'),
('3', 'Chinese(Traditional)', 'zh-tw', 1, 'YYYY/MM/DD', 1, '2011/10/26', '2011/10/26'),
('4', 'English', 'en', 6, 'MM/DD/YYYY', 4, '2011/10/26', '2011/10/26'),
('5', 'Vietnamese', 'vi', 6, 'DD/MM/YYYY', 5, '2011/10/26', '2011/10/26');