shopex商品数据表学习

最新推荐文章于 2021-10-03 16:13:25 发布
最新推荐文章于 2021-10-03 16:13:25 发布
阅读量2.9k 收藏 2
点赞数
分类专栏： myphp


SKU后端界面


SKU前端界面


商品表


SKU表


SKU数据值表


SKU商品表



关联表（上面所有表的关联）




数据表：

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2014 年 07 月 22 日 10:02
-- 服务器版本: 5.5.8
-- PHP 版本: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- 数据库: `shopex52`
--

-- --------------------------------------------------------

--
-- 表的结构 `sdb_admin_roles`
--

CREATE TABLE IF NOT EXISTS `sdb_admin_roles` (
  `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) NOT NULL DEFAULT '',
  `role_memo` text,
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`role_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_advance_logs`
--

CREATE TABLE IF NOT EXISTS `sdb_advance_logs` (
  `log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `money` decimal(20,3) NOT NULL DEFAULT '0.000',
  `message` varchar(255) DEFAULT NULL,
  `mtime` int(10) unsigned NOT NULL DEFAULT '0',
  `payment_id` varchar(20) DEFAULT NULL,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `paymethod` varchar(100) DEFAULT NULL,
  `memo` varchar(100) DEFAULT NULL,
  `import_money` decimal(20,3) NOT NULL DEFAULT '0.000',
  `explode_money` decimal(20,3) NOT NULL DEFAULT '0.000',
  `member_advance` decimal(20,3) NOT NULL DEFAULT '0.000',
  `shop_advance` decimal(20,3) NOT NULL DEFAULT '0.000',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`log_id`),
  KEY `ind_mtime` (`mtime`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_articles`
--

CREATE TABLE IF NOT EXISTS `sdb_articles` (
  `article_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `node_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `content` longtext,
  `uptime` int(10) unsigned DEFAULT NULL,
  `ifpub` enum('0','1') DEFAULT NULL,
  `align` varchar(12) DEFAULT NULL,
  `filetype` varchar(15) DEFAULT NULL,
  `filename` varchar(80) DEFAULT NULL,
  `orderlist` mediumint(6) DEFAULT NULL,
  `ordernum` int(10) DEFAULT '50',
  `pubtime` int(10) unsigned DEFAULT NULL,
  `disabled` enum('true','false') DEFAULT 'false',
  `goodsinfo` text,
  PRIMARY KEY (`article_id`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_orderlist` (`orderlist`),
  KEY `ind_ifpub` (`ifpub`),
  KEY `ind_uptime` (`uptime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_autosync_rule`
--

CREATE TABLE IF NOT EXISTS `sdb_autosync_rule` (
  `rule_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_op_id` tinyint(3) NOT NULL DEFAULT '0',
  `local_op_id` tinyint(3) NOT NULL DEFAULT '0',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `memo` varchar(255) DEFAULT NULL,
  `rule_name` varchar(255) NOT NULL,
  PRIMARY KEY (`rule_id`),
  KEY `index_1` (`rule_id`,`local_op_id`,`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_autosync_rule_relation`
--

CREATE TABLE IF NOT EXISTS `sdb_autosync_rule_relation` (
  `rule_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `pline_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `memo` text,
  KEY `rsp_index` (`rule_id`,`supplier_id`,`pline_id`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_autosync_task`
--

CREATE TABLE IF NOT EXISTS `sdb_autosync_task` (
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `command_id` int(10) unsigned NOT NULL DEFAULT '0',
  `local_op_id` mediumint(8) unsigned DEFAULT '0',
  PRIMARY KEY (`supplier_id`,`command_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_brand`
--

CREATE TABLE IF NOT EXISTS `sdb_brand` (
  `brand_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_id` int(10) unsigned DEFAULT NULL,
  `supplier_brand_id` mediumint(8) unsigned DEFAULT NULL,
  `brand_name` varchar(50) NOT NULL,
  `brand_url` varchar(255) DEFAULT NULL,
  `brand_desc` longtext,
  `brand_logo` varchar(255) DEFAULT NULL,
  `brand_keywords` longtext,
  `disabled` enum('true','false') DEFAULT 'false',
  `ordernum` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`brand_id`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_ordernum` (`ordernum`),
  KEY `ind_supplier_brand` (`supplier_id`,`supplier_brand_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_cachemgr`
--

CREATE TABLE IF NOT EXISTS `sdb_cachemgr` (
  `cname` varchar(30) NOT NULL DEFAULT '',
  `modified` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cname`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_comments`
--

CREATE TABLE IF NOT EXISTS `sdb_comments` (
  `comment_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `for_comment_id` mediumint(8) unsigned DEFAULT NULL,
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `object_type` enum('ask','discuss','buy') NOT NULL DEFAULT 'ask',
  `author_id` mediumint(8) unsigned DEFAULT NULL,
  `author` varchar(100) DEFAULT NULL,
  `levelname` varchar(50) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `mem_read_status` enum('true','false') NOT NULL DEFAULT 'false',
  `adm_read_status` enum('true','false') NOT NULL DEFAULT 'false',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `lastreply` int(10) unsigned NOT NULL DEFAULT '0',
  `reply_name` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `comment` longtext,
  `ip` varchar(15) DEFAULT NULL,
  `display` enum('true','false') NOT NULL DEFAULT 'false',
  `p_index` enum('1','0') DEFAULT '0',
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`comment_id`),
  KEY `ind_goods` (`goods_id`),
  KEY `ind_member` (`author_id`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_pindex` (`p_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_cost_sync`
--

CREATE TABLE IF NOT EXISTS `sdb_cost_sync` (
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `bn` varchar(30) NOT NULL,
  `cost` decimal(20,3) NOT NULL DEFAULT '0.000',
  `version_id` int(10) unsigned NOT NULL DEFAULT '0',
  `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`supplier_id`,`bn`),
  KEY `spid_gid` (`supplier_id`,`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_coupons`
--

CREATE TABLE IF NOT EXISTS `sdb_coupons` (
  `cpns_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cpns_name` varchar(255) DEFAULT NULL,
  `pmt_id` mediumint(8) unsigned DEFAULT NULL,
  `cpns_prefix` varchar(50) NOT NULL DEFAULT '',
  `cpns_gen_quantity` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `cpns_key` varchar(20) NOT NULL DEFAULT '',
  `cpns_status` enum('0','1') NOT NULL DEFAULT '1',
  `cpns_type` enum('0','1','2') NOT NULL DEFAULT '1',
  `cpns_point` mediumint(8) unsigned DEFAULT NULL,
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`cpns_id`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_cpns_prefix` (`cpns_prefix`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_coupons_p_items`
--

CREATE TABLE IF NOT EXISTS `sdb_coupons_p_items` (
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `cpns_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `cpns_name` varchar(255) DEFAULT NULL,
  `nums` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`order_id`,`cpns_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_coupons_u_items`
--

CREATE TABLE IF NOT EXISTS `sdb_coupons_u_items` (
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `cpns_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `cpns_name` varchar(255) DEFAULT NULL,
  `memc_code` varchar(255) DEFAULT NULL,
  `cpns_type` enum('0','1','2') DEFAULT NULL,
  PRIMARY KEY (`order_id`,`cpns_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_ctlmap`
--

CREATE TABLE IF NOT EXISTS `sdb_ctlmap` (
  `controller` varchar(100) NOT NULL,
  `plugin` varchar(100) NOT NULL,
  PRIMARY KEY (`controller`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_currency`
--

CREATE TABLE IF NOT EXISTS `sdb_currency` (
  `cur_code` varchar(8) NOT NULL DEFAULT '',
  `cur_name` varchar(20) NOT NULL DEFAULT '',
  `cur_sign` varchar(5) DEFAULT NULL,
  `cur_rate` decimal(10,4) NOT NULL DEFAULT '1.0000',
  `def_cur` enum('true','false') NOT NULL DEFAULT 'false',
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`cur_code`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_dapi`
--

CREATE TABLE IF NOT EXISTS `sdb_dapi` (
  `func` varchar(60) NOT NULL,
  `last_update` int(10) unsigned NOT NULL DEFAULT '0',
  `checksum` varchar(32) DEFAULT NULL,
  `code` text NOT NULL,
  PRIMARY KEY (`func`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_dbver`
--

CREATE TABLE IF NOT EXISTS `sdb_dbver` (
  `dbver` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_delivery`
--

CREATE TABLE IF NOT EXISTS `sdb_delivery` (
  `delivery_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `member_id` mediumint(8) unsigned DEFAULT NULL,
  `money` decimal(20,3) NOT NULL DEFAULT '0.000',
  `type` enum('return','delivery') NOT NULL DEFAULT 'delivery',
  `is_protect` enum('true','false') NOT NULL DEFAULT 'false',
  `delivery` varchar(20) DEFAULT NULL,
  `logi_id` varchar(50) DEFAULT NULL,
  `logi_name` varchar(100) DEFAULT NULL,
  `logi_no` varchar(50) DEFAULT NULL,
  `ship_name` varchar(50) DEFAULT NULL,
  `ship_area` varchar(255) DEFAULT NULL,
  `ship_addr` varchar(100) DEFAULT NULL,
  `ship_zip` varchar(20) DEFAULT NULL,
  `ship_tel` varchar(30) DEFAULT NULL,
  `ship_mobile` varchar(50) DEFAULT NULL,
  `ship_email` varchar(150) DEFAULT NULL,
  `t_begin` int(10) unsigned DEFAULT NULL,
  `t_end` int(10) unsigned DEFAULT NULL,
  `op_name` varchar(50) DEFAULT NULL,
  `status` enum('succ','failed','cancel','lost','progress','timeout','ready') NOT NULL DEFAULT 'ready',
  `memo` longtext,
  `disabled` enum('true','false') DEFAULT 'false',
  `supplier_id` int(10) unsigned DEFAULT NULL,
  `supplier_delivery_id` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`delivery_id`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_logi_no` (`logi_no`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=120090312000002 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_delivery_item`
--

CREATE TABLE IF NOT EXISTS `sdb_delivery_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `item_type` enum('goods','gift','adjunct','pkg') NOT NULL DEFAULT 'goods',
  `product_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `product_bn` varchar(30) DEFAULT NULL,
  `product_name` varchar(200) DEFAULT NULL,
  `number` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_dly_area`
--

CREATE TABLE IF NOT EXISTS `sdb_dly_area` (
  `area_id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `disabled` enum('true','false') DEFAULT 'false',
  `ordernum` smallint(4) unsigned DEFAULT NULL,
  PRIMARY KEY (`area_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_dly_center`
--

CREATE TABLE IF NOT EXISTS `sdb_dly_center` (
  `dly_center_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `address` varchar(200) NOT NULL,
  `region` varchar(255) DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `uname` varchar(100) DEFAULT NULL,
  `cellphone` varchar(100) DEFAULT NULL,
  `sex` enum('female','male') DEFAULT NULL,
  `memo` longtext,
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`dly_center_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_dly_corp`
--

CREATE TABLE IF NOT EXISTS `sdb_dly_corp` (
  `corp_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(6) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `disabled` enum('true','false') DEFAULT 'false',
  `ordernum` smallint(4) unsigned DEFAULT NULL,
  `website` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`corp_id`),
  KEY `ind_type` (`type`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_ordernum` (`ordernum`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_dly_h_area`
--

CREATE TABLE IF NOT EXISTS `sdb_dly_h_area` (
  `dha_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `dt_id` mediumint(8) unsigned DEFAULT NULL,
  `area_id` mediumint(6) unsigned DEFAULT '0',
  `price` varchar(100) DEFAULT '0',
  `has_cod` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `areaname_group` longtext,
  `areaid_group` longtext,
  `config` varchar(255) DEFAULT NULL,
  `expressions` varchar(255) DEFAULT NULL,
  `ordernum` smallint(4) unsigned DEFAULT NULL,
  PRIMARY KEY (`dha_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_dly_type`
--

CREATE TABLE IF NOT EXISTS `sdb_dly_type` (
  `dt_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `dt_name` varchar(50) DEFAULT NULL,
  `dt_config` longtext,
  `dt_expressions` longtext,
  `detail` longtext,
  `price` longtext NOT NULL,
  `type` enum('0','1') NOT NULL DEFAULT '1',
  `gateway` mediumint(8) unsigned DEFAULT '0',
  `protect` enum('0','1') NOT NULL DEFAULT '0',
  `protect_rate` float(6,3) DEFAULT NULL,
  `ordernum` smallint(4) DEFAULT '0',
  `has_cod` enum('0','1') NOT NULL DEFAULT '0',
  `minprice` float(10,2) NOT NULL DEFAULT '0.00',
  `disabled` enum('true','false') DEFAULT 'false',
  `corp_id` int(10) unsigned DEFAULT NULL,
  `dt_status` enum('0','1') DEFAULT '1',
  PRIMARY KEY (`dt_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_gift`
--

CREATE TABLE IF NOT EXISTS `sdb_gift` (
  `gift_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `gift_bn` varchar(255) DEFAULT '0',
  `giftcat_id` mediumint(8) unsigned DEFAULT NULL,
  `insert_time` int(10) unsigned NOT NULL DEFAULT '0',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `thumbnail_pic` varchar(255) DEFAULT NULL,
  `small_pic` varchar(255) DEFAULT NULL,
  `big_pic` varchar(255) DEFAULT NULL,
  `image_file` longtext,
  `intro` varchar(255) DEFAULT NULL,
  `gift_describe` longtext,
  `weight` int(11) NOT NULL DEFAULT '0',
  `storage` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `price` varchar(255) DEFAULT NULL,
  `orderlist` mediumint(8) unsigned DEFAULT '0',
  `shop_iffb` enum('0','1') NOT NULL DEFAULT '1',
  `limit_num` mediumint(8) unsigned DEFAULT '0',
  `limit_start_time` int(10) unsigned NOT NULL DEFAULT '0',
  `limit_end_time` int(10) unsigned NOT NULL DEFAULT '0',
  `limit_level` varchar(255) DEFAULT NULL,
  `ifrecommend` enum('0','1') NOT NULL DEFAULT '0',
  `point` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `freez` mediumint(8) unsigned DEFAULT '0',
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`gift_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_gift_cat`
--

CREATE TABLE IF NOT EXISTS `sdb_gift_cat` (
  `giftcat_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cat` varchar(255) DEFAULT NULL,
  `orderlist` mediumint(6) unsigned DEFAULT NULL,
  `shop_iffb` enum('0','1') DEFAULT '1',
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`giftcat_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_gift_items`
--

CREATE TABLE IF NOT EXISTS `sdb_gift_items` (
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `gift_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `name` varchar(200) DEFAULT NULL,
  `point` int(8) DEFAULT NULL,
  `nums` mediumint(8) unsigned DEFAULT NULL,
  `amount` int(10) unsigned DEFAULT NULL,
  `sendnum` mediumint(8) unsigned DEFAULT '0',
  `getmethod` enum('present','exchange') NOT NULL DEFAULT 'present',
  PRIMARY KEY (`order_id`,`gift_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_gimages`
--

CREATE TABLE IF NOT EXISTS `sdb_gimages` (
  `gimage_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `goods_id` mediumint(8) unsigned DEFAULT NULL,
  `is_remote` enum('true','false') NOT NULL DEFAULT 'false',
  `source` varchar(255) NOT NULL DEFAULT '',
  `orderby` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `src_size_width` int(10) unsigned NOT NULL DEFAULT '0',
  `src_size_height` int(10) unsigned NOT NULL DEFAULT '0',
  `small` varchar(255) DEFAULT NULL,
  `big` varchar(255) DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `up_time` int(10) unsigned NOT NULL DEFAULT '0',
  `supplier_id` int(10) unsigned DEFAULT NULL,
  `supplier_gimage_id` mediumint(8) unsigned DEFAULT NULL,
  `sync_time` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`gimage_id`),
  KEY `ind_up_time` (`up_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=450 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_gnotify`
--

CREATE TABLE IF NOT EXISTS `sdb_gnotify` (
  `gnotify_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `goods_id` mediumint(8) unsigned DEFAULT NULL,
  `member_id` mediumint(8) unsigned DEFAULT NULL,
  `product_id` mediumint(8) unsigned DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `status` enum('ready','send','progress') NOT NULL DEFAULT 'ready',
  `send_time` int(10) unsigned DEFAULT NULL,
  `creat_time` int(10) unsigned DEFAULT NULL,
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `remark` longtext,
  PRIMARY KEY (`gnotify_id`),
  KEY `ind_goods` (`goods_id`,`product_id`,`member_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods`
--

CREATE TABLE IF NOT EXISTS `sdb_goods` (
  `goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(10) NOT NULL DEFAULT '0',
  `type_id` int(10) DEFAULT NULL,
  `goods_type` enum('normal','bind') NOT NULL DEFAULT 'normal',
  `brand_id` mediumint(8) unsigned DEFAULT NULL,
  `brand` varchar(100) DEFAULT NULL,
  `supplier_id` int(10) unsigned DEFAULT NULL,
  `supplier_goods_id` mediumint(8) unsigned DEFAULT NULL,
  `wss_params` longtext,
  `image_default` longtext,
  `udfimg` enum('true','false') DEFAULT 'false',
  `thumbnail_pic` varchar(255) DEFAULT NULL,
  `small_pic` varchar(255) DEFAULT NULL,
  `big_pic` varchar(255) DEFAULT NULL,
  `image_file` longtext,
  `brief` varchar(255) DEFAULT NULL,
  `intro` longtext,
  `mktprice` decimal(20,3) DEFAULT NULL,
  `cost` decimal(20,3) NOT NULL DEFAULT '0.000',
  `price` decimal(20,3) NOT NULL DEFAULT '0.000',
  `bn` varchar(200) DEFAULT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `marketable` enum('true','false') NOT NULL DEFAULT 'true',
  `weight` decimal(20,3) DEFAULT NULL,
  `unit` varchar(20) DEFAULT NULL,
  `store` mediumint(8) unsigned DEFAULT NULL,
  `store_place` varchar(255) DEFAULT NULL,
  `score_setting` enum('percent','number') DEFAULT 'number',
  `score` mediumint(8) unsigned DEFAULT NULL,
  `spec` longtext,
  `pdt_desc` longtext,
  `spec_desc` longtext,
  `params` longtext,
  `uptime` int(10) unsigned DEFAULT NULL,
  `downtime` int(10) unsigned DEFAULT NULL,
  `last_modify` int(10) unsigned DEFAULT NULL,
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `notify_num` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rank` decimal(5,3) DEFAULT '5.000',
  `rank_count` int(10) unsigned DEFAULT '0',
  `comments_count` int(10) unsigned NOT NULL DEFAULT '0',
  `view_w_count` int(10) unsigned NOT NULL DEFAULT '0',
  `view_count` int(10) unsigned NOT NULL DEFAULT '0',
  `buy_count` int(10) unsigned NOT NULL DEFAULT '0',
  `buy_w_count` int(10) unsigned NOT NULL DEFAULT '0',
  `count_stat` longtext,
  `p_order` mediumint(8) unsigned NOT NULL DEFAULT '30',
  `d_order` mediumint(8) unsigned NOT NULL DEFAULT '30',
  `p_1` varchar(255) DEFAULT NULL,
  `p_2` varchar(255) DEFAULT NULL,
  `p_3` varchar(255) DEFAULT NULL,
  `p_4` varchar(255) DEFAULT NULL,
  `p_5` varchar(255) DEFAULT NULL,
  `p_6` varchar(255) DEFAULT NULL,
  `p_7` varchar(255) DEFAULT NULL,
  `p_8` varchar(255) DEFAULT NULL,
  `p_9` varchar(255) DEFAULT NULL,
  `p_10` varchar(255) DEFAULT NULL,
  `p_11` varchar(255) DEFAULT NULL,
  `p_12` varchar(255) DEFAULT NULL,
  `p_13` varchar(255) DEFAULT NULL,
  `p_14` varchar(255) DEFAULT NULL,
  `p_15` varchar(255) DEFAULT NULL,
  `p_16` varchar(255) DEFAULT NULL,
  `p_17` varchar(255) DEFAULT NULL,
  `p_18` varchar(255) DEFAULT NULL,
  `p_19` varchar(255) DEFAULT NULL,
  `p_20` varchar(255) DEFAULT NULL,
  `p_21` varchar(255) DEFAULT NULL,
  `p_22` varchar(255) DEFAULT NULL,
  `p_23` varchar(255) DEFAULT NULL,
  `p_24` varchar(255) DEFAULT NULL,
  `p_25` varchar(255) DEFAULT NULL,
  `p_26` varchar(255) DEFAULT NULL,
  `p_27` varchar(255) DEFAULT NULL,
  `p_28` varchar(255) DEFAULT NULL,
  `goods_info_update_status` enum('true','false') DEFAULT 'false',
  `stock_update_status` enum('true','false') DEFAULT 'false',
  `marketable_update_status` enum('true','false') DEFAULT 'false',
  `img_update_status` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`goods_id`),
  KEY `uni_bn` (`bn`),
  KEY `ind_p_1` (`p_1`),
  KEY `ind_p_2` (`p_2`),
  KEY `ind_p_3` (`p_3`),
  KEY `ind_p_4` (`p_4`),
  KEY `ind_p_23` (`p_23`),
  KEY `ind_p_22` (`p_22`),
  KEY `ind_p_21` (`p_21`),
  KEY `ind_frontend` (`disabled`,`goods_type`,`marketable`),
  KEY `supplier_goods` (`supplier_id`,`supplier_goods_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=82 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_cat`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_cat` (
  `cat_id` int(10) NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) DEFAULT NULL,
  `supplier_id` int(10) unsigned DEFAULT NULL,
  `supplier_cat_id` mediumint(8) unsigned DEFAULT NULL,
  `cat_path` varchar(100) DEFAULT ',',
  `is_leaf` enum('true','false') NOT NULL DEFAULT 'false',
  `type_id` int(10) DEFAULT NULL,
  `cat_name` varchar(100) NOT NULL DEFAULT '',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `p_order` mediumint(8) unsigned DEFAULT NULL,
  `goods_count` mediumint(8) unsigned DEFAULT NULL,
  `tabs` longtext,
  `finder` longtext,
  `addon` longtext,
  `child_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `ind_cat_path` (`cat_path`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_keywords`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_keywords` (
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `keyword` varchar(40) NOT NULL DEFAULT '',
  `refer` varchar(255) DEFAULT '',
  `res_type` enum('goods','article') NOT NULL DEFAULT 'goods',
  PRIMARY KEY (`goods_id`,`keyword`,`res_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_lv_price`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_lv_price` (
  `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `level_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `price` decimal(20,3) DEFAULT NULL,
  PRIMARY KEY (`product_id`,`level_id`,`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_memo`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_memo` (
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `p_key` varchar(20) NOT NULL DEFAULT '',
  `p_value` longtext,
  PRIMARY KEY (`goods_id`,`p_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_rate`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_rate` (
  `goods_1` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_2` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `manual` enum('left','both') DEFAULT NULL,
  `rate` mediumint(8) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`goods_1`,`goods_2`),
  KEY `ind_rate` (`goods_1`,`goods_2`,`manual`,`rate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_spec_index`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_spec_index` (
  `type_id` int(10) NOT NULL DEFAULT '0',
  `spec_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `spec_value_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `spec_value` varchar(100) NOT NULL DEFAULT '',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '生成的商品sku表id',
  PRIMARY KEY (`spec_value_id`,`spec_value`,`product_id`),
  KEY `type_specvalue_index` (`type_id`,`spec_value_id`,`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='sku和商品关联表，可知道哪些sku数据值被商品引用，限制后台删除sku值\r\n前端通过该表获取到所有sku数据集合，得到所有直积\r\n再与该表已有的数据值取差集\r\n';

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_type`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_type` (
  `type_id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `alias` longtext,
  `is_physical` enum('0','1') NOT NULL DEFAULT '1',
  `supplier_id` int(10) unsigned DEFAULT NULL,
  `supplier_type_id` mediumint(8) unsigned DEFAULT NULL,
  `schema_id` varchar(30) NOT NULL DEFAULT 'custom',
  `props` longtext,
  `spec` longtext,
  `setting` longtext,
  `minfo` longtext,
  `params` longtext,
  `dly_func` enum('0','1') NOT NULL DEFAULT '0',
  `ret_func` enum('0','1') NOT NULL DEFAULT '0',
  `reship` enum('disabled','func','normal','mixed') NOT NULL DEFAULT 'normal',
  `disabled` enum('true','false') DEFAULT 'false',
  `is_def` enum('true','false') NOT NULL DEFAULT 'false',
  `lastmodify` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`type_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_type_spec`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_type_spec` (
  `spec_id` mediumint(8) unsigned DEFAULT '0',
  `type_id` int(10) DEFAULT '0',
  `spec_style` enum('select','flat','disabled') NOT NULL DEFAULT 'flat'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_goods_virtual_cat`
--

CREATE TABLE IF NOT EXISTS `sdb_goods_virtual_cat` (
  `virtual_cat_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `virtual_cat_name` varchar(100) NOT NULL DEFAULT '',
  `filter` longtext,
  `addon` longtext,
  `type_id` int(10) DEFAULT NULL,
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `parent_id` mediumint(8) unsigned DEFAULT '0',
  `cat_id` int(10) DEFAULT NULL,
  `p_order` mediumint(8) unsigned DEFAULT NULL,
  `cat_path` varchar(100) DEFAULT ',',
  `child_count` mediumint(8) unsigned DEFAULT '0',
  PRIMARY KEY (`virtual_cat_id`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_p_order` (`p_order`),
  KEY `ind_cat_path` (`cat_path`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_gtask`
--

CREATE TABLE IF NOT EXISTS `sdb_gtask` (
  `goods_id` mediumint(8) unsigned DEFAULT NULL,
  `tasktime` int(10) unsigned NOT NULL DEFAULT '0',
  `action` enum('online','offline') NOT NULL DEFAULT 'online',
  KEY `tasktime` (`tasktime`),
  KEY `goods` (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_image_sync`
--

CREATE TABLE IF NOT EXISTS `sdb_image_sync` (
  `img_sync_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('gimage','spec_value','udfimg','brand_logo') NOT NULL DEFAULT 'gimage',
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `supplier_object_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `command_id` int(10) unsigned NOT NULL DEFAULT '0',
  `failed` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`img_sync_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_job_apilist`
--

CREATE TABLE IF NOT EXISTS `sdb_job_apilist` (
  `job_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `api_name` varchar(100) NOT NULL,
  `api_params` longtext,
  `api_version` varchar(10) NOT NULL,
  `api_action` varchar(100) NOT NULL,
  `page` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `limit` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`job_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_job_data_sync`
--

CREATE TABLE IF NOT EXISTS `sdb_job_data_sync` (
  `job_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `from_time` int(10) unsigned NOT NULL DEFAULT '0',
  `to_time` int(10) unsigned NOT NULL DEFAULT '0',
  `page` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `limit` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `supplier_pline` longtext,
  `auto_download` enum('true','false') NOT NULL DEFAULT 'false',
  `to_cat_id` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`job_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_job_goods_download`
--

CREATE TABLE IF NOT EXISTS `sdb_job_goods_download` (
  `job_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `supplier_goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `supplier_goods_count` int(10) unsigned NOT NULL DEFAULT '1',
  `command_id` int(10) unsigned NOT NULL DEFAULT '0',
  `failed` enum('true','false') NOT NULL DEFAULT 'false',
  `to_cat_id` mediumint(8) unsigned DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`job_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_link`
--

CREATE TABLE IF NOT EXISTS `sdb_link` (
  `link_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `link_name` varchar(128) NOT NULL,
  `href` varchar(255) NOT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `orderlist` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_lnk_acts`
--

CREATE TABLE IF NOT EXISTS `sdb_lnk_acts` (
  `role_id` int(10) unsigned NOT NULL DEFAULT '0',
  `action_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`role_id`,`action_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_lnk_roles`
--

CREATE TABLE IF NOT EXISTS `sdb_lnk_roles` (
  `op_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `role_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`op_id`,`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_magicvars`
--

CREATE TABLE IF NOT EXISTS `sdb_magicvars` (
  `var_name` varchar(20) NOT NULL,
  `var_title` varchar(100) DEFAULT NULL,
  `var_remark` varchar(100) NOT NULL,
  `var_value` text,
  `var_type` enum('system','custom') NOT NULL DEFAULT 'custom',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`var_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_members`
--

CREATE TABLE IF NOT EXISTS `sdb_members` (
  `member_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `member_lv_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uname` varchar(50) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `firstname` varchar(50) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `mobile` varchar(30) DEFAULT NULL,
  `tel` varchar(30) DEFAULT NULL,
  `email` varchar(200) NOT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `addr` varchar(255) DEFAULT NULL,
  `province` varchar(20) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `order_num` mediumint(8) unsigned DEFAULT '0',
  `refer_id` varchar(50) DEFAULT NULL,
  `refer_url` varchar(200) DEFAULT NULL,
  `refer_time` int(10) unsigned DEFAULT NULL,
  `c_refer_id` varchar(50) DEFAULT NULL,
  `c_refer_url` varchar(200) DEFAULT NULL,
  `c_refer_time` int(10) unsigned DEFAULT NULL,
  `b_year` smallint(5) unsigned DEFAULT NULL,
  `b_month` tinyint(3) unsigned DEFAULT NULL,
  `b_day` tinyint(3) unsigned DEFAULT NULL,
  `sex` enum('0','1') NOT NULL DEFAULT '1',
  `addon` longtext,
  `wedlock` enum('0','1') NOT NULL DEFAULT '0',
  `education` varchar(30) DEFAULT NULL,
  `vocation` varchar(50) DEFAULT NULL,
  `interest` longtext,
  `advance` decimal(20,3) NOT NULL DEFAULT '0.000',
  `advance_freeze` decimal(20,3) NOT NULL DEFAULT '0.000',
  `point_freeze` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `point_history` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `point` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `score_rate` decimal(5,3) DEFAULT NULL,
  `reg_ip` varchar(16) DEFAULT NULL,
  `regtime` int(10) unsigned DEFAULT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `pay_time` mediumint(8) unsigned DEFAULT NULL,
  `biz_money` decimal(20,3) NOT NULL DEFAULT '0.000',
  `pw_answer` varchar(250) DEFAULT NULL,
  `pw_question` varchar(250) DEFAULT NULL,
  `fav_tags` longtext,
  `custom` longtext,
  `cur` varchar(20) DEFAULT NULL,
  `lang` varchar(20) DEFAULT NULL,
  `unreadmsg` smallint(5) unsigned NOT NULL DEFAULT '0',
  `disabled` enum('true','false') DEFAULT 'false',
  `remark` text,
  `remark_type` varchar(2) NOT NULL DEFAULT 'b1',
  `login_count` int(11) NOT NULL DEFAULT '0',
  `experience` int(10) DEFAULT '0',
  `foreign_id` varchar(255) DEFAULT NULL,
  `member_refer` enum('local','mobile','qzone','alipayquick','taobao','sina','baidu','renren','tencent','netease163','windowslive','yahoo','sohu') DEFAULT 'local',
  PRIMARY KEY (`member_id`),
  KEY `ind_email` (`email`),
  KEY `uni_user` (`uname`),
  KEY `ind_regtime` (`regtime`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_member_addrs`
--

CREATE TABLE IF NOT EXISTS `sdb_member_addrs` (
  `addr_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `country` varchar(30) DEFAULT NULL,
  `province` varchar(30) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `addr` varchar(255) DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `tel` varchar(30) DEFAULT NULL,
  `mobile` varchar(30) DEFAULT NULL,
  `def_addr` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`addr_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_member_attr`
--

CREATE TABLE IF NOT EXISTS `sdb_member_attr` (
  `attr_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `attr_name` varchar(20) NOT NULL DEFAULT '',
  `attr_type` varchar(20) NOT NULL DEFAULT '',
  `attr_required` enum('true','false') NOT NULL DEFAULT 'false',
  `attr_search` enum('true','false') NOT NULL DEFAULT 'false',
  `attr_option` text,
  `attr_valtype` varchar(20) NOT NULL DEFAULT '',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `attr_tyname` varchar(20) NOT NULL DEFAULT '',
  `attr_group` varchar(20) NOT NULL DEFAULT '',
  `attr_show` enum('true','false') NOT NULL DEFAULT 'true',
  `attr_order` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`attr_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_member_coupon`
--

CREATE TABLE IF NOT EXISTS `sdb_member_coupon` (
  `memc_code` varchar(255) NOT NULL DEFAULT '',
  `cpns_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `memc_gen_orderid` varchar(15) DEFAULT NULL,
  `memc_source` enum('a','b','c') NOT NULL DEFAULT 'a',
  `memc_enabled` enum('true','false') NOT NULL DEFAULT 'true',
  `memc_used_times` mediumint(9) DEFAULT '0',
  `memc_gen_time` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`memc_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_member_lv`
--

CREATE TABLE IF NOT EXISTS `sdb_member_lv` (
  `member_lv_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `dis_count` decimal(5,2) NOT NULL DEFAULT '1.00',
  `pre_id` mediumint(9) DEFAULT NULL,
  `default_lv` enum('0','1') NOT NULL DEFAULT '0',
  `deposit_freeze_time` int(11) DEFAULT '0',
  `deposit` int(11) DEFAULT '0',
  `more_point` int(11) DEFAULT '1',
  `point` mediumint(8) NOT NULL DEFAULT '0',
  `lv_type` enum('retail','wholesale','dealer') NOT NULL DEFAULT 'retail',
  `disabled` enum('true','false') DEFAULT 'false',
  `show_other_price` enum('true','false') NOT NULL DEFAULT 'true',
  `order_limit` tinyint(1) NOT NULL DEFAULT '0',
  `order_limit_price` decimal(20,3) NOT NULL DEFAULT '0.000',
  `lv_remark` text,
  `experience` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`member_lv_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_member_mattrvalue`
--

CREATE TABLE IF NOT EXISTS `sdb_member_mattrvalue` (
  `attr_id` int(10) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `value` varchar(100) NOT NULL DEFAULT '',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_message`
--

CREATE TABLE IF NOT EXISTS `sdb_message` (
  `msg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `for_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `msg_from` varchar(30) NOT NULL DEFAULT '',
  `from_id` mediumint(8) unsigned DEFAULT '0',
  `from_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `to_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `to_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `unread` enum('0','1') NOT NULL DEFAULT '0',
  `folder` enum('inbox','outbox') NOT NULL DEFAULT 'inbox',
  `email` varchar(255) DEFAULT NULL,
  `tel` varchar(30) DEFAULT NULL,
  `subject` varchar(100) NOT NULL DEFAULT '',
  `message` longtext NOT NULL,
  `rel_order` bigint(20) unsigned DEFAULT '0',
  `date_line` int(10) unsigned NOT NULL DEFAULT '0',
  `is_sec` enum('true','false') NOT NULL DEFAULT 'true',
  `del_status` enum('0','1','2') DEFAULT '0',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `msg_ip` varchar(20) NOT NULL DEFAULT '',
  `msg_type` enum('default','payment') NOT NULL DEFAULT 'default',
  PRIMARY KEY (`msg_id`),
  KEY `ind_to_id` (`to_id`,`folder`,`from_type`,`unread`),
  KEY `ind_from_id` (`from_id`,`folder`,`to_type`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_msgqueue`
--

CREATE TABLE IF NOT EXISTS `sdb_msgqueue` (
  `queue_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `target` varchar(250) NOT NULL DEFAULT '',
  `event_name` varchar(50) DEFAULT NULL,
  `data` longtext,
  `tmpl_name` varchar(50) NOT NULL DEFAULT '',
  `level` tinyint(3) unsigned NOT NULL DEFAULT '5',
  `sender` varchar(50) NOT NULL DEFAULT '',
  `sender_order` tinyint(3) unsigned NOT NULL DEFAULT '5',
  `message` longtext,
  `status` enum('ready','succ','fail','locking') DEFAULT 'ready',
  `error_msg` varchar(255) DEFAULT NULL,
  `sendnum` smallint(6) DEFAULT NULL,
  `send_time` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`queue_id`),
  KEY `ind_level` (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_operators`
--

CREATE TABLE IF NOT EXISTS `sdb_operators` (
  `op_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '',
  `userpass` varchar(32) NOT NULL DEFAULT '',
  `name` varchar(30) DEFAULT NULL,
  `config` longtext,
  `favorite` longtext,
  `super` enum('0','1') NOT NULL DEFAULT '0',
  `lastip` varchar(20) DEFAULT NULL,
  `logincount` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `lastlogin` int(10) unsigned NOT NULL DEFAULT '0',
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `op_no` varchar(50) DEFAULT NULL,
  `department` varchar(50) DEFAULT NULL,
  `memo` text,
  PRIMARY KEY (`op_id`),
  KEY `uni_username` (`username`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_op_sessions`
--

CREATE TABLE IF NOT EXISTS `sdb_op_sessions` (
  `sess_id` varchar(32) NOT NULL DEFAULT '',
  `op_id` mediumint(6) unsigned DEFAULT NULL,
  `sess_type` enum('ADMIN','MEMBER') DEFAULT NULL,
  `login_time` int(10) unsigned DEFAULT NULL,
  `last_time` int(10) unsigned DEFAULT NULL,
  `api_id` mediumint(8) unsigned DEFAULT NULL,
  `sess_data` longtext,
  `status` tinyint(1) DEFAULT '0',
  `ip` varchar(17) DEFAULT NULL,
  PRIMARY KEY (`sess_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_orders`
--

CREATE TABLE IF NOT EXISTS `sdb_orders` (
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned DEFAULT NULL,
  `confirm` enum('Y','N') NOT NULL DEFAULT 'N',
  `status` enum('active','dead','finish') NOT NULL DEFAULT 'active',
  `pay_status` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  `ship_status` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
  `user_status` enum('null','payed','shipped') NOT NULL DEFAULT 'null',
  `is_delivery` enum('Y','N') NOT NULL DEFAULT 'Y',
  `shipping_id` smallint(4) unsigned DEFAULT NULL,
  `shipping` varchar(100) DEFAULT NULL,
  `shipping_area` varchar(50) DEFAULT NULL,
  `payment` mediumint(9) DEFAULT NULL,
  `weight` decimal(20,3) DEFAULT NULL,
  `tostr` longtext,
  `itemnum` mediumint(8) unsigned DEFAULT NULL,
  `acttime` int(10) unsigned DEFAULT NULL,
  `delivery_time` int(10) unsigned DEFAULT NULL,
  `delivery_delay_time` int(10) unsigned DEFAULT NULL,
  `createtime` int(10) unsigned DEFAULT NULL,
  `refer_id` varchar(50) DEFAULT NULL,
  `refer_url` text,
  `refer_time` int(10) unsigned DEFAULT NULL,
  `c_refer_id` varchar(50) DEFAULT NULL,
  `c_refer_url` text,
  `c_refer_time` int(10) unsigned DEFAULT NULL,
  `ip` varchar(15) DEFAULT NULL,
  `ship_name` varchar(50) DEFAULT NULL,
  `ship_area` varchar(255) DEFAULT NULL,
  `ship_addr` varchar(100) DEFAULT NULL,
  `ship_zip` varchar(20) DEFAULT NULL,
  `ship_tel` varchar(30) DEFAULT NULL,
  `ship_email` varchar(150) DEFAULT NULL,
  `ship_time` varchar(50) DEFAULT NULL,
  `ship_mobile` varchar(50) DEFAULT NULL,
  `cost_item` decimal(20,3) NOT NULL DEFAULT '0.000',
  `is_tax` enum('true','false') NOT NULL DEFAULT 'false',
  `cost_tax` decimal(20,3) NOT NULL DEFAULT '0.000',
  `tax_company` varchar(255) DEFAULT NULL,
  `cost_freight` decimal(20,3) NOT NULL DEFAULT '0.000',
  `is_protect` enum('true','false') NOT NULL DEFAULT 'false',
  `cost_protect` decimal(20,3) NOT NULL DEFAULT '0.000',
  `cost_payment` decimal(20,3) DEFAULT NULL,
  `currency` varchar(8) DEFAULT NULL,
  `cur_rate` decimal(10,4) DEFAULT '1.0000',
  `score_u` decimal(20,3) NOT NULL DEFAULT '0.000',
  `score_g` decimal(20,3) NOT NULL DEFAULT '0.000',
  `score_e` decimal(20,3) NOT NULL DEFAULT '0.000',
  `advance` decimal(20,3) DEFAULT '0.000',
  `discount` decimal(20,3) NOT NULL DEFAULT '0.000',
  `use_pmt` varchar(30) DEFAULT NULL,
  `total_amount` decimal(20,3) NOT NULL DEFAULT '0.000',
  `final_amount` decimal(20,3) NOT NULL DEFAULT '0.000',
  `pmt_amount` decimal(20,3) DEFAULT NULL,
  `payed` decimal(20,3) DEFAULT '0.000',
  `markstar` enum('Y','N') DEFAULT 'N',
  `memo` longtext,
  `print_status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mark_text` longtext,
  `disabled` enum('true','false') DEFAULT 'false',
  `last_change_time` int(11) NOT NULL DEFAULT '0',
  `use_registerinfo` enum('true','false') DEFAULT 'false',
  `mark_type` varchar(2) NOT NULL DEFAULT 'b1',
  `extend` varchar(255) DEFAULT 'false',
  `is_has_remote_pdts` enum('true','false') NOT NULL DEFAULT 'false',
  `order_refer` enum('local','taobao','paipai','mobile') NOT NULL DEFAULT 'local',
  `print_id` varchar(20) DEFAULT NULL,
  `cancel_time` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`order_id`),
  KEY `ind_ship_status` (`ship_status`),
  KEY `ind_pay_status` (`pay_status`),
  KEY `ind_status` (`status`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_print_id` (`print_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_order_items`
--

CREATE TABLE IF NOT EXISTS `sdb_order_items` (
  `item_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `dly_status` enum('storage','shipping','return','customer','returned') NOT NULL DEFAULT 'storage',
  `type_id` int(10) DEFAULT NULL,
  `bn` varchar(40) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `cost` decimal(20,3) DEFAULT NULL,
  `price` decimal(20,3) NOT NULL DEFAULT '0.000',
  `amount` decimal(20,3) DEFAULT NULL,
  `score` mediumint(8) unsigned DEFAULT NULL,
  `nums` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `minfo` longtext,
  `sendnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `addon` longtext,
  `is_type` enum('goods','pkg') NOT NULL DEFAULT 'goods',
  `point` mediumint(9) DEFAULT NULL,
  `supplier_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_order_log`
--

CREATE TABLE IF NOT EXISTS `sdb_order_log` (
  `log_id` int(10) NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `op_id` mediumint(8) DEFAULT NULL,
  `op_name` varchar(30) DEFAULT NULL,
  `log_text` longtext,
  `acttime` int(10) unsigned DEFAULT NULL,
  `behavior` varchar(20) DEFAULT '',
  `result` enum('success','failure') DEFAULT 'success',
  PRIMARY KEY (`log_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_order_pmt`
--

CREATE TABLE IF NOT EXISTS `sdb_order_pmt` (
  `pmt_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `pmt_amount` decimal(20,3) DEFAULT NULL,
  `pmt_memo` longtext,
  `pmt_describe` longtext,
  PRIMARY KEY (`pmt_id`,`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_package_product`
--

CREATE TABLE IF NOT EXISTS `sdb_package_product` (
  `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `discount` decimal(5,3) DEFAULT NULL,
  `pkgnum` mediumint(8) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`product_id`,`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_pages`
--

CREATE TABLE IF NOT EXISTS `sdb_pages` (
  `page_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `page_name` varchar(90) NOT NULL DEFAULT '',
  `page_title` varchar(90) NOT NULL DEFAULT '',
  `page_content` longtext,
  `page_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`page_id`),
  KEY `uni_pagename` (`page_name`),
  KEY `uni_pagetitle` (`page_title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_payments`
--

CREATE TABLE IF NOT EXISTS `sdb_payments` (
  `payment_id` varchar(20) NOT NULL DEFAULT '',
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `member_id` mediumint(8) unsigned DEFAULT NULL,
  `account` varchar(50) DEFAULT NULL,
  `bank` varchar(50) DEFAULT NULL,
  `pay_account` varchar(50) DEFAULT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `money` decimal(20,3) NOT NULL DEFAULT '0.000',
  `paycost` decimal(20,3) DEFAULT NULL,
  `cur_money` decimal(20,3) NOT NULL DEFAULT '0.000',
  `pay_type` enum('online','offline','deposit','recharge','joinfee') NOT NULL DEFAULT 'online',
  `payment` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `paymethod` varchar(100) DEFAULT NULL,
  `op_id` mediumint(8) unsigned DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `t_begin` int(10) unsigned DEFAULT NULL,
  `t_end` int(10) unsigned DEFAULT NULL,
  `status` enum('succ','failed','cancel','error','invalid','progress','timeout','ready') NOT NULL DEFAULT 'ready',
  `memo` longtext,
  `disabled` enum('true','false') DEFAULT 'false',
  `trade_no` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`payment_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_payment_cfg`
--

CREATE TABLE IF NOT EXISTS `sdb_payment_cfg` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `custom_name` varchar(100) DEFAULT NULL,
  `pay_type` varchar(30) NOT NULL DEFAULT '',
  `config` longtext,
  `fee` decimal(9,5) NOT NULL DEFAULT '0.00000',
  `des` longtext,
  `order_num` smallint(3) unsigned NOT NULL DEFAULT '0',
  `disabled` enum('true','false') DEFAULT 'false',
  `orderlist` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_plugins`
--

CREATE TABLE IF NOT EXISTS `sdb_plugins` (
  `plugin_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `plugin_ident` varchar(100) NOT NULL DEFAULT '',
  `plugin_name` varchar(100) NOT NULL DEFAULT '',
  `plugin_type` enum('io','schema','hook','pmt','local','messenger','pay','passport','admin','shop','action','app','mdl') NOT NULL DEFAULT 'io',
  `app_type` varchar(100) NOT NULL DEFAULT '',
  `plugin_base` enum('0','9') NOT NULL DEFAULT '0',
  `plugin_version` varchar(100) DEFAULT '1.0',
  `plugin_author` varchar(100) DEFAULT NULL,
  `plugin_package` varchar(100) DEFAULT NULL,
  `plugin_website` varchar(200) DEFAULT NULL,
  `plugin_updatechec` varchar(200) DEFAULT NULL,
  `plugin_desc` text,
  `plugin_hasopts` enum('true','false') NOT NULL DEFAULT 'false',
  `plugin_struct` text,
  `plugin_config` text,
  `plugin_path` varchar(255) NOT NULL DEFAULT '',
  `plugin_mode` enum('file','dir') NOT NULL DEFAULT 'file',
  `status` enum('unused','used','broken') NOT NULL DEFAULT 'unused',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `plugin_mtime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_pmt_gen_coupon`
--

CREATE TABLE IF NOT EXISTS `sdb_pmt_gen_coupon` (
  `pmt_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `cpns_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`pmt_id`,`cpns_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_pmt_goods`
--

CREATE TABLE IF NOT EXISTS `sdb_pmt_goods` (
  `pmt_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `count` mediumint(8) unsigned DEFAULT '0',
  PRIMARY KEY (`pmt_id`,`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_pmt_goods_cat`
--

CREATE TABLE IF NOT EXISTS `sdb_pmt_goods_cat` (
  `cat_id` int(10) NOT NULL DEFAULT '0',
  `brand_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `pmt_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`,`brand_id`,`pmt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_pmt_member_lv`
--

CREATE TABLE IF NOT EXISTS `sdb_pmt_member_lv` (
  `member_lv_id` mediumint(9) DEFAULT NULL,
  `pmt_id` mediumint(8) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_point_history`
--

CREATE TABLE IF NOT EXISTS `sdb_point_history` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `point` int(10) NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `reason` varchar(50) NOT NULL DEFAULT '',
  `related_id` bigint(20) unsigned DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `operator` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_print_tmpl`
--

CREATE TABLE IF NOT EXISTS `sdb_print_tmpl` (
  `prt_tmpl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `prt_tmpl_title` varchar(100) NOT NULL DEFAULT '',
  `shortcut` enum('true','false') DEFAULT 'false',
  `disabled` enum('true','false') DEFAULT 'false',
  `prt_tmpl_width` tinyint(3) unsigned NOT NULL DEFAULT '100',
  `prt_tmpl_height` tinyint(3) unsigned NOT NULL DEFAULT '100',
  `prt_tmpl_data` longtext,
  PRIMARY KEY (`prt_tmpl_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_products`
--

CREATE TABLE IF NOT EXISTS `sdb_products` (
  `product_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `barcode` varchar(128) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `bn` varchar(200) DEFAULT NULL,
  `price` decimal(20,3) NOT NULL DEFAULT '0.000',
  `cost` decimal(20,3) DEFAULT '0.000',
  `mktprice` decimal(20,3) DEFAULT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `weight` decimal(20,3) DEFAULT NULL,
  `unit` varchar(20) DEFAULT NULL,
  `store` mediumint(8) unsigned DEFAULT NULL,
  `store_place` varchar(255) DEFAULT NULL,
  `freez` mediumint(8) unsigned DEFAULT NULL,
  `pdt_desc` longtext,
  `props` longtext,
  `uptime` int(10) unsigned DEFAULT NULL,
  `last_modify` int(10) unsigned DEFAULT NULL,
  `disabled` enum('true','false') DEFAULT 'false',
  `marketable` enum('true','false') NOT NULL DEFAULT 'true',
  `is_local_stock` enum('true','false') NOT NULL DEFAULT 'true',
  PRIMARY KEY (`product_id`),
  KEY `ind_disabled` (`disabled`),
  KEY `ind_bn` (`bn`),
  KEY `ind_goods_id` (`goods_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=335 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_product_memo`
--

CREATE TABLE IF NOT EXISTS `sdb_product_memo` (
  `product_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `p_key` varchar(20) NOT NULL DEFAULT '',
  `p_value` longtext,
  PRIMARY KEY (`product_id`,`p_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_promotion`
--

CREATE TABLE IF NOT EXISTS `sdb_promotion` (
  `pmt_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `pmts_id` varchar(255) NOT NULL DEFAULT '',
  `pmta_id` mediumint(8) unsigned DEFAULT NULL,
  `pmt_time_begin` int(10) unsigned DEFAULT NULL,
  `pmt_time_end` int(10) unsigned DEFAULT NULL,
  `order_money_from` decimal(20,3) NOT NULL DEFAULT '0.000',
  `order_money_to` decimal(20,3) NOT NULL DEFAULT '9999999.000',
  `seq` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `pmt_type` enum('0','1','2') NOT NULL DEFAULT '0',
  `pmt_belong` enum('0','1') NOT NULL DEFAULT '0',
  `pmt_bond_type` enum('0','1','2') NOT NULL DEFAULT '0',
  `pmt_describe` longtext,
  `pmt_solution` longtext,
  `pmt_ifcoupon` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `pmt_update_time` int(10) unsigned DEFAULT '0',
  `pmt_basic_type` enum('goods','order') DEFAULT 'goods',
  `disabled` enum('true','false') DEFAULT 'false',
  `pmt_ifsale` enum('true','false') NOT NULL DEFAULT 'true',
  `pmt_distype` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`pmt_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_promotion_activity`
--

CREATE TABLE IF NOT EXISTS `sdb_promotion_activity` (
  `pmta_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `pmta_name` varchar(200) DEFAULT NULL,
  `pmta_enabled` enum('true','false') DEFAULT NULL,
  `pmta_time_begin` int(10) unsigned DEFAULT NULL,
  `pmta_time_end` int(10) unsigned DEFAULT NULL,
  `pmta_describe` longtext,
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`pmta_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_promotion_scheme`
--

CREATE TABLE IF NOT EXISTS `sdb_promotion_scheme` (
  `pmts_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `pmts_name` varchar(250) DEFAULT NULL,
  `pmts_memo` longtext,
  `pmts_solution` longtext,
  `pmts_type` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pmts_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_pub_files`
--

CREATE TABLE IF NOT EXISTS `sdb_pub_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(50) DEFAULT NULL,
  `file_ident` varchar(100) NOT NULL DEFAULT '',
  `cdate` int(10) unsigned NOT NULL DEFAULT '0',
  `memo` varchar(250) DEFAULT NULL,
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`file_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_refunds`
--

CREATE TABLE IF NOT EXISTS `sdb_refunds` (
  `refund_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `member_id` mediumint(8) unsigned DEFAULT NULL,
  `account` varchar(50) DEFAULT NULL,
  `bank` varchar(50) DEFAULT NULL,
  `pay_account` varchar(250) DEFAULT NULL,
  `currency` varchar(8) DEFAULT NULL,
  `money` decimal(20,3) NOT NULL DEFAULT '0.000',
  `pay_type` enum('online','offline','deposit','recharge') DEFAULT 'offline',
  `payment` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `paymethod` varchar(100) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `t_ready` int(10) unsigned NOT NULL DEFAULT '0',
  `t_sent` int(10) unsigned DEFAULT NULL,
  `t_received` int(10) unsigned DEFAULT NULL,
  `status` enum('ready','progress','sent','received','cancel') NOT NULL DEFAULT 'ready',
  `memo` longtext,
  `title` varchar(255) NOT NULL DEFAULT '',
  `send_op_id` mediumint(8) unsigned DEFAULT NULL,
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `trade_no` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`refund_id`),
  KEY `ind_disabled` (`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_regions`
--

CREATE TABLE IF NOT EXISTS `sdb_regions` (
  `region_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `package` varchar(20) NOT NULL DEFAULT '',
  `p_region_id` int(10) unsigned DEFAULT NULL,
  `region_path` varchar(255) DEFAULT NULL,
  `region_grade` mediumint(8) unsigned DEFAULT NULL,
  `local_name` varchar(50) NOT NULL DEFAULT '',
  `en_name` varchar(50) DEFAULT NULL,
  `p_1` varchar(50) DEFAULT NULL,
  `p_2` varchar(50) DEFAULT NULL,
  `ordernum` mediumint(8) unsigned DEFAULT NULL,
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`region_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3723 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_return_product`
--

CREATE TABLE IF NOT EXISTS `sdb_return_product` (
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `return_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL DEFAULT '',
  `content` longtext,
  `status` enum('1','2','3','4','5') NOT NULL DEFAULT '1',
  `image_file` varchar(255) NOT NULL DEFAULT '',
  `product_data` longtext,
  `comment` longtext,
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`return_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_sell_logs`
--

CREATE TABLE IF NOT EXISTS `sdb_sell_logs` (
  `log_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `member_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) DEFAULT '',
  `price` decimal(20,3) DEFAULT '0.000',
  `product_id` mediumint(8) NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `product_name` varchar(200) DEFAULT '',
  `pdt_desc` varchar(200) DEFAULT '',
  `number` mediumint(8) unsigned DEFAULT '0',
  `createtime` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`log_id`),
  KEY `idx_goods_id` (`member_id`,`product_id`,`goods_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_sendbox`
--

CREATE TABLE IF NOT EXISTS `sdb_sendbox` (
  `out_id` int(11) NOT NULL AUTO_INCREMENT,
  `tmpl_name` varchar(50) DEFAULT NULL,
  `sender` varchar(50) NOT NULL DEFAULT '',
  `creattime` int(10) unsigned NOT NULL DEFAULT '0',
  `target` longtext,
  `sendcount` mediumint(8) unsigned DEFAULT NULL,
  `content` varchar(200) DEFAULT NULL,
  `subject` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`out_id`),
  KEY `ind_sender` (`sender`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_seo`
--

CREATE TABLE IF NOT EXISTS `sdb_seo` (
  `seo_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `source_id` varchar(100) NOT NULL,
  `type` varchar(50) NOT NULL,
  `store_key` varchar(100) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`seo_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_settings`
--

CREATE TABLE IF NOT EXISTS `sdb_settings` (
  `s_name` varchar(16) NOT NULL DEFAULT '',
  `s_data` longtext,
  `s_time` int(10) unsigned NOT NULL DEFAULT '0',
  `disabled` enum('true','false') DEFAULT 'false',
  PRIMARY KEY (`s_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_sfiles`
--

CREATE TABLE IF NOT EXISTS `sdb_sfiles` (
  `file_id` varchar(32) NOT NULL DEFAULT '',
  `file_name` varchar(32) NOT NULL DEFAULT '',
  `usedby` varchar(32) DEFAULT NULL,
  `file_type` varchar(32) DEFAULT NULL,
  `file_size` int(9) NOT NULL DEFAULT '0',
  `cdate` int(10) unsigned NOT NULL DEFAULT '0',
  `misc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`file_id`),
  KEY `ind_usedby` (`usedby`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_sitemaps`
--

CREATE TABLE IF NOT EXISTS `sdb_sitemaps` (
  `node_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `p_node_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `node_type` varchar(30) NOT NULL DEFAULT '',
  `depth` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `path` varchar(200) DEFAULT NULL,
  `title` varchar(100) NOT NULL DEFAULT '',
  `action` varchar(255) NOT NULL DEFAULT '',
  `manual` enum('0','1') NOT NULL DEFAULT '1',
  `item_id` mediumint(8) unsigned DEFAULT NULL,
  `p_order` mediumint(8) unsigned DEFAULT NULL,
  `hidden` enum('true','false') NOT NULL DEFAULT 'false',
  `child_count` mediumint(4) DEFAULT NULL,
  PRIMARY KEY (`node_id`),
  KEY `ind_hidden` (`hidden`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=113 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_specification`
--

CREATE TABLE IF NOT EXISTS `sdb_specification` (
  `spec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `spec_name` varchar(50) NOT NULL DEFAULT '',
  `alias` varchar(255) DEFAULT '',
  `spec_show_type` enum('select','flat') NOT NULL DEFAULT 'flat',
  `spec_type` enum('text','image') NOT NULL DEFAULT 'text',
  `spec_memo` varchar(50) NOT NULL DEFAULT '',
  `p_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  `supplier_spec_id` mediumint(8) unsigned DEFAULT NULL,
  `supplier_id` int(10) unsigned DEFAULT NULL,
  `lastmodify` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`spec_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_spec_values`
--

CREATE TABLE IF NOT EXISTS `sdb_spec_values` (
  `spec_value_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `spec_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `spec_value` varchar(100) NOT NULL DEFAULT '',
  `alias` varchar(255) DEFAULT '',
  `spec_image` varchar(255) NOT NULL DEFAULT '',
  `p_order` mediumint(8) unsigned NOT NULL DEFAULT '50',
  `supplier_id` int(10) unsigned DEFAULT NULL,
  `supplier_spec_value_id` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`spec_value_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=92 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_status`
--

CREATE TABLE IF NOT EXISTS `sdb_status` (
  `status_key` varchar(20) NOT NULL DEFAULT '',
  `date_affect` date NOT NULL DEFAULT '0000-00-00',
  `status_value` varchar(100) NOT NULL DEFAULT '0',
  `last_update` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`status_key`,`date_affect`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_supplier`
--

CREATE TABLE IF NOT EXISTS `sdb_supplier` (
  `sp_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `supplier_brief_name` varchar(30) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `supplier_pline` longtext,
  `sync_time` int(10) unsigned NOT NULL DEFAULT '0',
  `domain` varchar(255) NOT NULL,
  `has_new` enum('true','false') NOT NULL DEFAULT 'true',
  `has_cost_new` enum('true','false') NOT NULL DEFAULT 'false',
  `sync_time_for_plat` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`sp_id`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_supplier_pdtbn`
--

CREATE TABLE IF NOT EXISTS `sdb_supplier_pdtbn` (
  `sp_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `local_bn` varchar(200) NOT NULL,
  `source_bn` varchar(200) NOT NULL,
  `default` enum('true','false') NOT NULL DEFAULT 'true',
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`sp_id`,`local_bn`),
  KEY `sp_srcbn` (`source_bn`,`supplier_id`),
  KEY `sp_source_bn` (`source_bn`),
  KEY `sp_local_bn` (`local_bn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_sync_tmp`
--

CREATE TABLE IF NOT EXISTS `sdb_sync_tmp` (
  `tmp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `s_type` enum('goods_type','spec','brand','goods_cat') NOT NULL DEFAULT 'goods_type',
  `ob_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `s_data` longtext,
  PRIMARY KEY (`tmp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_systmpl`
--

CREATE TABLE IF NOT EXISTS `sdb_systmpl` (
  `tmpl_name` varchar(50) NOT NULL DEFAULT '',
  `content` longtext,
  `edittime` int(10) unsigned NOT NULL DEFAULT '0',
  `active` enum('true','false') NOT NULL DEFAULT 'true',
  PRIMARY KEY (`tmpl_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_tags`
--

CREATE TABLE IF NOT EXISTS `sdb_tags` (
  `tag_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(20) NOT NULL DEFAULT '',
  `is_system` enum('true','false') NOT NULL DEFAULT 'false',
  `tag_type` varchar(20) NOT NULL DEFAULT '',
  `rel_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tag_id`),
  KEY `ind_type` (`tag_type`),
  KEY `ind_name` (`tag_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_tag_rel`
--

CREATE TABLE IF NOT EXISTS `sdb_tag_rel` (
  `tag_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rel_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tag_id`,`rel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_template_relation`
--

CREATE TABLE IF NOT EXISTS `sdb_template_relation` (
  `template_relation_id` int(11) NOT NULL AUTO_INCREMENT,
  `source_type` varchar(20) NOT NULL DEFAULT '',
  `source_id` int(11) NOT NULL DEFAULT '0',
  `template_name` varchar(100) NOT NULL DEFAULT '',
  `template_type` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`template_relation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_themes`
--

CREATE TABLE IF NOT EXISTS `sdb_themes` (
  `theme` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) DEFAULT NULL,
  `stime` int(10) unsigned DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `site` varchar(100) DEFAULT NULL,
  `version` varchar(50) DEFAULT NULL,
  `info` varchar(255) DEFAULT NULL,
  `config` longtext,
  `update_url` varchar(100) DEFAULT NULL,
  `template` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`theme`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_tpl_source`
--

CREATE TABLE IF NOT EXISTS `sdb_tpl_source` (
  `tpl_source_id` int(11) NOT NULL AUTO_INCREMENT,
  `tpl_type` varchar(50) NOT NULL DEFAULT '',
  `tpl_name` varchar(100) NOT NULL DEFAULT '',
  `tpl_file` varchar(100) NOT NULL DEFAULT '',
  `tpl_theme` varchar(100) NOT NULL,
  PRIMARY KEY (`tpl_source_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_triggers`
--

CREATE TABLE IF NOT EXISTS `sdb_triggers` (
  `trigger_id` int(11) NOT NULL AUTO_INCREMENT,
  `filter_str` varchar(255) NOT NULL DEFAULT '',
  `action_str` varchar(255) NOT NULL DEFAULT '',
  `trigger_event` varchar(100) NOT NULL DEFAULT '',
  `trigger_memo` varchar(100) DEFAULT NULL,
  `trigger_define` text NOT NULL,
  `trigger_order` tinyint(4) NOT NULL DEFAULT '5',
  `active` enum('true','false') DEFAULT 'false',
  `disabled` enum('true','false') NOT NULL DEFAULT 'false',
  PRIMARY KEY (`trigger_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_type_brand`
--

CREATE TABLE IF NOT EXISTS `sdb_type_brand` (
  `type_id` int(10) NOT NULL DEFAULT '0',
  `brand_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `brand_order` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`type_id`,`brand_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `sdb_widgets_set`
--

CREATE TABLE IF NOT EXISTS `sdb_widgets_set` (
  `widgets_id` int(11) NOT NULL AUTO_INCREMENT,
  `base_file` varchar(50) NOT NULL DEFAULT '',
  `base_slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `base_id` varchar(20) DEFAULT NULL,
  `widgets_type` varchar(20) NOT NULL DEFAULT '',
  `widgets_order` tinyint(3) unsigned NOT NULL DEFAULT '5',
  `title` varchar(100) DEFAULT NULL,
  `domid` varchar(100) DEFAULT NULL,
  `border` varchar(100) DEFAULT NULL,
  `classname` varchar(100) DEFAULT NULL,
  `tpl` varchar(100) DEFAULT NULL,
  `params` longtext,
  `modified` int(10) unsigned DEFAULT NULL,
  `vary` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`widgets_id`),
  KEY `ind_wgbase` (`base_file`,`base_id`,`widgets_order`),
  KEY `ind_wginfo` (`base_file`,`base_slot`,`widgets_order`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=46 ;












lumengabc
关注
专栏目录
shopex数据库表结构
10-26
shopex数据库表结构，Shopex重要的表字段
shopex 数据库结构
10-11
这个是一款shopex的数据库结构说明文档。此文档详细介绍了shopex各个字段的名称及含义，使查看者更进一步的了解shopex的数据库结构
shopex数据库结构表
07-18
shopex数据库结构表，包含详细的表和字段的属性设置等
shopex mysql索引_shopex数据库表结构说明文档.doc
weixin_36438989的博客
01-26 212
shopex数据库表结构说明文档shopEx数据库表结构说明文档目 录sdb_admin_roles3sdb_advance_logs3sdb_articles4sdb_autosync_rule4sdb_autosync_rule_relation5sdb_autosync_task5sdb_brand5sdb_cachemgr5sdb_comments6sdb_cost_syn...
shopex mysql 数据库服务器_shopex数据库优化实例
weixin_36278287的博客
01-30 192
shopex4.8.5是商派早年推出的一个基于php5.2平台的半开源电子商务建站软件，曾经一度有50多万用户使用。不过近年来更新比较少，加上有新的产品推出，官方对shopex的维护力度大不如前。很多用户在使用中，发现并发到一定量时，网站访问速度就明显下降。由于shopex是并开源产品，只有专业的开发人员(手头有源码的)可以通过修改程序来优化程序性能。以下是几个数据库优化例子，是清风君在给用户维护...
数据分析shopex
02-29
通常，这样的分析可以帮助我们了解各个表之间的关系，如订单表、商品表、用户表等，以及如何通过SQL查询或数据可视化工具来提取和呈现有价值的信息。 数据分析ShopEx的具体步骤可能包括以下环节： 1. 数据收集：...
ShopEx网上商店系统 4.8.5.82977
11-28
MySQL作为关系型数据库，能有效存储和管理大量商品信息和交易数据；而PHP则是一种强大且易于学习的脚本语言，便于开发人员快速构建动态网站。 ShopEx系统的核心功能包括商品管理、订单处理、库存控制、会员管理、...
PHP实例开发源码—ShopEX ECstore 源码完整版 免注册含数据词典.zip
11-23
数据词典是数据库设计的重要组成部分，它记录了数据库中各个表的字段含义、类型、长度等信息，有助于我们理解和操作数据库。在ShopEX ECstore的源码中，数据词典能帮助开发者快速定位和理解数据结构，方便进行数据库...
基于PHP的ShopEX ECstore v2.3.8源码完整版 免注册含数据词典.zip
最新发布
07-22
12. 数据字典：提供的数据词典可能是数据库表结构、字段说明等，帮助开发者理解数据库设计。 通过研究ECstore v2.3.8的源码，开发者可以深入理解一个成熟的电子商务平台是如何运作的，同时也可以学习到如何使用PHP...
shopex入门基础代码
02-27
学习如何定义模板、传递数据和渲染视图是理解ShopEx视图层的关键。 5. **会话和Cookie管理**：在电子商务系统中，会话管理和Cookie用于跟踪用户状态，如登录信息。理解PHP的session和cookie机制对于处理用户认证和...
ShopEX数据库设计.doc
09-02
shopex数据库设计分析文档，本人做shoepx一年二次开发经验整理，适合做二次开发的人参考。
亲测：ShopEX ECstore V2.3.8完整源码无需注册+数据字典
03-18
特点：无需修改下载即用、无广告、不用注册ShopexID、还有数据库字典。 资源分有点贵是因为本人找了一上午才稿定此版本大家下载后可直接使用，省时！省力！省心！ 安装步骤： 1、将新建一个空数据库，在安装时要选择建好的数据库。 2、直接开发网站开根据提示下一步下一步进行操作。到数据库配制页时，填写好数据库相关用户名、密码、数据名、表前缀等信息后，输入后台登录的用户名和密码。 注意：用户名和密码不能一样。 3、进行安装状态，系统功能多，大约需要5分钟左右。 4、安装完之后就可以直接进入后台登录页了。（注意：此时前台还不能访问，因为还没有设置模板） 5、输入账号和密码进入后台，设计网站的模板（操作方法：站点-->模板列表-->选择要使用的模板）。 6、后台设置了模板之后前台页面就可以访问了。 注意：代码供研究学习，商用请购买正版。
ecshop_v2.7.2数据库表结构2012完善版
03-25
ecshop_v2.7.2数据库表结构2012完善版.doc
ecshop2.7.3完全版数据字典
03-30
ecshop2.7.3完全版数据字典 ecshop数据调用、二次开发所用的参与材料。
ecshop2.7.3数据字典.pdf
07-11
ecshop2.7.3数据字典.pdf
shopex 深度探险 shopex 规格表 扩展属性表 商品表数据字典 对应关系图
ecshop数据采集发布接口，zencart，lightinthebox，shopex 采集，快客
12-07 2019
shopex mysql 数据库服务器_[日记] shopex转移以及MySql简单操作命令
weixin_36330704的博客
01-19 220
1:先在旧站shopex商城里的后台数据库备份里做个备份,做完全备份,其他都不要动了.2:在shopex商城的FTP里找到一个databack文件夹,进去后会看到一些sql文件,SQL_XXXXX.sql这样的,看前缀一样的下载下来,这些就是你第一步里备份的shopex商城的数据.3:在新空间里装一个shopex商城(版本要一样),管理员帐号设置和旧的shopex商城一样,不然还原数据库的时候会有...
ecshop 商品属性
ecshop数据采集发布接口，zencart，lightinthebox，shopex 采集，快客
11-27 1027
在B2C电子商务系统中，很可能在一个系统中，出售多种商品，而且不同的商品，却有不同的规格，不同的属性。在商品详情页会用到 商品属性,在ecshop中，通过三个字段来控制. １：ecshop商品类型 2：ecshop属性名称 ３：ecshop属性名称对应的属性值 首先，需要增加商品类型．增加商品类型的步骤为：后台->商品管理->商品类型->新建商品类型Ａ 选择商品类型Ａ
ShopEX的数据库配置文件是哪个？怎样修改数据库配置信息？
PHP错误汇总
10-03 272
ShopEX的数据库配置文件详细路径为：/public_html/config/config.php 如果在迁移shopex网店时，必须要修改config.php数据库配置信息。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值