soobic.sql

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

# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# 主机: localhost
# 生成日期: 2005 年 04 月 27 日 18:36
# 服务器版本: 4.0.20
# PHP 版本: 4.3.8
# 
# 数据库 : `soobic`
# 

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

#
# 表的结构 `bsp_address_book`
#

DROP TABLE IF EXISTS `bsp_address_book`;
CREATE TABLE `bsp_address_book` (
  `address_book_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `entry_gender` char(1) NOT NULL default '',
  `entry_company` varchar(32) default NULL,
  `entry_firstname` varchar(32) NOT NULL default '',
  `entry_lastname` varchar(32) NOT NULL default '',
  `entry_street_address` varchar(64) NOT NULL default '',
  `entry_suburb` varchar(32) default NULL,
  `entry_postcode` varchar(10) NOT NULL default '',
  `entry_city` varchar(32) NOT NULL default '',
  `entry_state` varchar(32) default NULL,
  `entry_country_id` int(11) NOT NULL default '0',
  `entry_zone_id` int(11) NOT NULL default '0',
  `entry_tel_regular` varchar(32) NOT NULL default '',
  `entry_tel_mobile` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`address_book_id`),
  KEY `idx_address_book_customers_id` (`customers_id`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

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

INSERT INTO `bsp_address_book` VALUES (1, 2, '', NULL, 'Soolan', '', '湖北荆州长江大学汉科学苑', NULL, '434000', '荆州', '', 44, 193, '0716-4305182', '13476967698');
INSERT INTO `bsp_address_book` VALUES (7, 10, '', NULL, 'Soolan2', '', '湖北荆州长江大学汉科学苑', NULL, '434000', '荆州', '', 44, 193, '0716-4305182', '13476967698');
INSERT INTO `bsp_address_book` VALUES (8, 12, '', NULL, 'fffffffff', '', 'fffddddddddddddd', NULL, 'ffdddd', 'ffDSF', '', 44, 183, 'fddddd', '');
INSERT INTO `bsp_address_book` VALUES (9, 13, '', NULL, 'soolan2', '', 'saffffffffffffffffffff', NULL, 'ffffffffff', 'fasfasf', '', 44, 212, 'dddddddddddddd', '');

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

#
# 表的结构 `bsp_categories`
#

DROP TABLE IF EXISTS `bsp_categories`;
CREATE TABLE `bsp_categories` (
  `categories_id` int(11) NOT NULL auto_increment,
  `categories_image` varchar(64) default NULL,
  `parent_id` int(11) NOT NULL default '0',
  `sort_order` int(3) default NULL,
  `date_added` datetime default NULL,
  `last_modified` datetime default NULL,
  PRIMARY KEY  (`categories_id`),
  KEY `idx_categories_parent_id` (`parent_id`)
) TYPE=MyISAM AUTO_INCREMENT=48 ;

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

INSERT INTO `bsp_categories` VALUES (44, '1113222904.gif', 0, 3, '2005-04-02 10:00:58', '2005-04-11 08:35:04');

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

#
# 表的结构 `bsp_categories_description`
#

DROP TABLE IF EXISTS `bsp_categories_description`;
CREATE TABLE `bsp_categories_description` (
  `categories_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `categories_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`categories_id`,`language_id`),
  KEY `idx_categories_name` (`categories_name`)
) TYPE=MyISAM;

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

INSERT INTO `bsp_categories_description` VALUES (44, 4, '默认分类');

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

#
# 表的结构 `bsp_configuration`
#

DROP TABLE IF EXISTS `bsp_configuration`;
CREATE TABLE `bsp_configuration` (
  `configuration_id` int(11) NOT NULL auto_increment,
  `configuration_title` varchar(64) NOT NULL default '',
  `configuration_key` varchar(64) NOT NULL default '',
  `configuration_value` varchar(255) NOT NULL default '',
  `configuration_description` text NOT NULL,
  `configuration_group_id` int(11) NOT NULL default '0',
  `sort_order` int(5) default NULL,
  `last_modified` datetime default NULL,
  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `use_function` varchar(255) default NULL,
  `set_function` varchar(255) default NULL,
  PRIMARY KEY  (`configuration_id`)
) TYPE=MyISAM AUTO_INCREMENT=335 ;

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