CREATE TABLE `st_lookup` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '',
  `code` SMALLINT(3) NOT NULL DEFAULT 0,
  `type` varchar(128) NOT NULL DEFAULT '',
  `position` int(11) NOT NULL DEFAULT 0,
  `language` TINYINT(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO st_lookup (name, code, type, position, language)
	VALUES ('zh-CN', 1, 'Language', 1, 1) 
		,('en-US', 2, 'Language', 2, 1)
		;
CREATE TABLE `st_taxonomy` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(80) NOT NULL DEFAULT '',
  `category` varchar(80) NOT NULL DEFAULT '',
  `note` varchar(200) NOT NULL DEFAULT '',
  `parent` bigint(20) NOT NULL DEFAULT 0,
  `position` int(11) NOT NULL DEFAULT 0,
  `language` TINYINT(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO st_taxonomy (name, slug, category, position, language)
	VALUES ('人造金刚石微粉', 'synthetic-diamond-micro-powder', 'ProductCategory', 1, 1) 
		,('人造金刚石研磨膏', 'grinding-paste', 'ProductCategory', 2, 1)
		,('人造金刚石破碎料', 'grinding-grits', 'ProductCategory', 3, 1)
		,('金刚石镀覆产品', 'coated-products', 'ProductCategory', 4, 1)
		,('砂轮磨盘', 'grinding-wheel', 'ProductCategory', 5, 1)
		;
CREATE TABLE `st_product` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(80) NOT NULL DEFAULT '',
  `introduction` TEXT NOT NULL DEFAULT '',
  `characteristic` TEXT NOT NULL DEFAULT '',
  `parameter` TEXT NOT NULL DEFAULT '',
  `category` BIGINT(20) NOT NULL DEFAULT 0,
  `language` TINYINT(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE `st_file` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(200) NOT NULL DEFAULT '',
  `name` varchar(200) NOT NULL DEFAULT '',
  `type` SMALLINT(3) NOT NULL DEFAULT 0,
  `category` SMALLINT(3) NOT NULL DEFAULT 0,
  `key` BIGINT(20) NOT NULL DEFAULT 0,
  `c_id` int(5) NOT NULL DEFAULT 0,
  `c_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE `st_post` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL DEFAULT '',
  `content` TEXT NOT NULL DEFAULT '',
  `category` SMALLINT(3) NOT NULL DEFAULT 0,
  `c_id` int(5) NOT NULL DEFAULT 0,
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
