--
-- 表的结构 `ecs_attribute`
--
CREATE TABLE IF NOT EXISTS `ecs_attribute` (
`attr_id` smallint(5) unsigned NOT NULL auto_increment,
`cat_id` smallint(5) unsigned NOT NULL default '0',
`attr_name` varchar(60) NOT NULL default '',
`attr_input_type` tinyint(1) unsigned NOT NULL default '1',
`attr_type` tinyint(1) unsigned NOT NULL default '1',
`attr_values` text NOT NULL,
`attr_index` tinyint(1) unsigned NOT NULL default '0',
`sort_order` tinyint(3) unsigned NOT NULL default '0',
`is_linked` tinyint(1) unsigned NOT NULL default '0',
`attr_group` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`attr_id`),
KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=211 ;
--
-- 表的结构 `ecs_goods_attr`
--
CREATE TABLE IF NOT EXISTS `ecs_goods_attr` (
`goods_attr_id` int(10) unsigned NOT NULL auto_increment,
`goods_id` mediumint(8) unsigned NOT NULL default '0',
`attr_id` smallint(5) unsigned NOT NULL default '0',
`attr_value` text NOT NULL,
`attr_price` varchar(255) NOT NULL default '',
PRIMARY KEY (`goods_attr_id`),
KEY `goods_id` (`goods_id`),
KEY `attr_id` (`attr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=251 ;