soobic.sql

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

INSERT INTO `bsp_configuration_group` VALUES (12, '电子邮件选项', 'General setting for E-Mail transport and HTML E-Mails', 12, 1);
INSERT INTO `bsp_configuration_group` VALUES (14, 'GZip 压缩', 'GZip compression options', 15, 1);
INSERT INTO `bsp_configuration_group` VALUES (15, '会话管理', 'Session options', 16, 1);
INSERT INTO `bsp_configuration_group` VALUES (16, '会员积分', '设定会员消费多少金额，可换一点积分', 17, 1);
INSERT INTO `bsp_configuration_group` VALUES (20, '特色商品', '特色商品', 18, 1);
INSERT INTO `bsp_configuration_group` VALUES (25, '特价商品', '特价商品', 19, 1);
INSERT INTO `bsp_configuration_group` VALUES (26, '订单信息', '订单信息', 21, 1);
INSERT INTO `bsp_configuration_group` VALUES (27, '最新商品', '最新商品', 20, 1);

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

#
# 表的结构 `bsp_countries`
#

DROP TABLE IF EXISTS `bsp_countries`;
CREATE TABLE `bsp_countries` (
  `countries_id` int(11) NOT NULL auto_increment,
  `countries_name` varchar(64) NOT NULL default '',
  `countries_iso_code_2` char(2) NOT NULL default '',
  `countries_iso_code_3` char(3) NOT NULL default '',
  `address_format_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`countries_id`),
  KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) TYPE=MyISAM AUTO_INCREMENT=49 ;

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

INSERT INTO `bsp_countries` VALUES (44, '中国', 'CN', 'CHN', 0);

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

#
# 表的结构 `bsp_currencies`
#

DROP TABLE IF EXISTS `bsp_currencies`;
CREATE TABLE `bsp_currencies` (
  `currencies_id` int(11) NOT NULL auto_increment,
  `title` varchar(32) NOT NULL default '',
  `code` char(3) NOT NULL default '',
  `symbol_left` varchar(12) default NULL,
  `symbol_right` varchar(12) default NULL,
  `decimal_point` char(1) default NULL,
  `thousands_point` char(1) default NULL,
  `decimal_places` char(1) default NULL,
  `value` float(13,8) default NULL,
  `last_updated` datetime default NULL,
  PRIMARY KEY  (`currencies_id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

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

INSERT INTO `bsp_currencies` VALUES (1, 'USD;Dollar', 'USD', '$', '', '.', ',', '2', '8.10000038', '2004-10-09 23:18:49');
INSERT INTO `bsp_currencies` VALUES (3, 'RMB', 'RMB', '￥', '元', '.', ',', '2', '1.00000000', NULL);

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

#
# 表的结构 `bsp_customers`
#

DROP TABLE IF EXISTS `bsp_customers`;
CREATE TABLE `bsp_customers` (
  `customers_id` int(11) NOT NULL auto_increment,
  `customers_gender` char(1) NOT NULL default '',
  `customers_firstname` varchar(32) NOT NULL default '',
  `customers_dob` datetime NOT NULL default '0000-00-00 00:00:00',
  `customers_email_address` varchar(96) NOT NULL default '',
  `customers_default_address_id` int(11) NOT NULL default '0',
  `customers_fax` varchar(32) default NULL,
  `customers_password` varchar(40) NOT NULL default '',
  `customers_newsletter` char(1) default NULL,
  `status` enum('Operator','Member','ViceAdmin','Admin') NOT NULL default 'Member',
  `credit` int(10) NOT NULL default '0',
  `regdate` int(10) unsigned NOT NULL default '0',
  `lastvisit` int(10) unsigned NOT NULL default '0',
  `global_product_notifications` int(11) NOT NULL default '0',
  PRIMARY KEY  (`customers_id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

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

INSERT INTO `bsp_customers` VALUES (2, 'm', 'Soolan', '0000-00-00 00:00:00', '[e-mail]', 1, '0716-4305182', '122bde80cffca41e96fcf5dde567f38e', '1', 'Admin', 0, 0, 0, 1);

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

#
# 表的结构 `bsp_customers_basket`
#

DROP TABLE IF EXISTS `bsp_customers_basket`;
CREATE TABLE `bsp_customers_basket` (
  `customers_basket_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `products_id` tinytext NOT NULL,
  `customers_basket_quantity` int(2) NOT NULL default '0',
  `final_price` decimal(15,4) NOT NULL default '0.0000',
  `customers_basket_date_added` varchar(8) default NULL,
  PRIMARY KEY  (`customers_basket_id`)
) TYPE=MyISAM AUTO_INCREMENT=15 ;

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

INSERT INTO `bsp_customers_basket` VALUES (1, 3, '12', 1, '0.0000', '20050302');
INSERT INTO `bsp_customers_basket` VALUES (2, 3, '32', 2, '0.0000', '20050302');
INSERT INTO `bsp_customers_basket` VALUES (11, 2, '5{5}14', 1, '0.0000', '20050417');
INSERT INTO `bsp_customers_basket` VALUES (12, 2, '7{3}3', 1, '0.0000', '20050427');
INSERT INTO `bsp_customers_basket` VALUES (13, 12, '7{3}3', 2, '0.0000', '20050427');