soobic.sql

全新且完善的强大网上商店系统

# --------------------------------------------------------

#
# 表的结构 `bsp_customers_basket_attributes`
#

DROP TABLE IF EXISTS `bsp_customers_basket_attributes`;
CREATE TABLE `bsp_customers_basket_attributes` (
  `customers_basket_attributes_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `products_id` tinytext NOT NULL,
  `products_options_id` int(11) NOT NULL default '0',
  `products_options_value_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`customers_basket_attributes_id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

#
# 导出表中的数据 `bsp_customers_basket_attributes`
#

INSERT INTO `bsp_customers_basket_attributes` VALUES (9, 2, '5{5}14', 5, 14);
INSERT INTO `bsp_customers_basket_attributes` VALUES (10, 2, '7{3}3', 3, 3);
INSERT INTO `bsp_customers_basket_attributes` VALUES (11, 12, '7{3}3', 3, 3);

# --------------------------------------------------------

#
# 表的结构 `bsp_featured`
#

DROP TABLE IF EXISTS `bsp_featured`;
CREATE TABLE `bsp_featured` (
  `featured_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL default '0',
  `featured_date_added` datetime default NULL,
  `featured_last_modified` datetime default NULL,
  `expires_date` datetime default NULL,
  `date_status_change` datetime default NULL,
  `status` int(1) default '1',
  PRIMARY KEY  (`featured_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# 导出表中的数据 `bsp_featured`
#

INSERT INTO `bsp_featured` VALUES (4, 3, '2005-04-12 16:45:40', NULL, '2005-04-27 00:00:00', NULL, 1);
INSERT INTO `bsp_featured` VALUES (5, 5, '2005-04-15 16:25:14', '2005-04-18 08:56:57', '0000-00-00 00:00:00', NULL, 1);

# --------------------------------------------------------

#
# 表的结构 `bsp_geo_zones`
#

DROP TABLE IF EXISTS `bsp_geo_zones`;
CREATE TABLE `bsp_geo_zones` (
  `geo_zone_id` int(11) NOT NULL auto_increment,
  `geo_zone_name` varchar(32) NOT NULL default '',
  `geo_zone_description` varchar(255) NOT NULL default '',
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`geo_zone_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# 导出表中的数据 `bsp_geo_zones`
#

INSERT INTO `bsp_geo_zones` VALUES (1, '华中地区', '华中地区（根据您的需要作相应修改）', '2005-04-12 14:28:15', '2004-10-09 23:18:49');
INSERT INTO `bsp_geo_zones` VALUES (3, '华北地区', '华北地区（根据您的需要作相应修改）', '2005-04-12 14:28:27', '2005-04-12 14:28:27');
INSERT INTO `bsp_geo_zones` VALUES (4, '华南地区', '华南地区（根据您的需要作相应修必）', '2005-04-12 14:29:01', '2005-04-12 14:29:01');

# --------------------------------------------------------

#
# 表的结构 `bsp_languages`
#

DROP TABLE IF EXISTS `bsp_languages`;
CREATE TABLE `bsp_languages` (
  `languages_id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `code` char(2) NOT NULL default '',
  `image` varchar(64) default NULL,
  `directory` varchar(32) default NULL,
  `sort_order` int(3) default NULL,
  PRIMARY KEY  (`languages_id`),
  KEY `IDX_LANGUAGES_NAME` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=33 ;

#
# 导出表中的数据 `bsp_languages`
#

INSERT INTO `bsp_languages` VALUES (4, '中文', 'zh', 'icon.gif', 'chinese', 1);

# --------------------------------------------------------

#
# 表的结构 `bsp_manudiscount`
#

DROP TABLE IF EXISTS `bsp_manudiscount`;
CREATE TABLE `bsp_manudiscount` (
  `manudiscount_id` int(11) NOT NULL auto_increment,
  `manudiscount_name` varchar(128) NOT NULL default '',
  `manudiscount_groups_id` int(11) NOT NULL default '0',
  `manudiscount_customers_id` int(11) NOT NULL default '0',
  `manudiscount_manufacturers_id` int(11) NOT NULL default '0',
  `manudiscount_discount` decimal(8,2) NOT NULL default '-0.00',
  PRIMARY KEY  (`manudiscount_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# 导出表