TPshop表结构
TPshop数据表结构介绍
CREATE TABLE `tp_account_log` (
`log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`user_id` mediumint(8) unsigned NOT NULL,
`user_money` decimal(10,2) NOT NULL,
`frozen_money` decimal(10,2) NOT NULL COMMENT '冻结金额',
`rank_points` mediumint(9) NOT NULL,
`pay_points` mediumint(9) NOT NULL COMMENT '支付积分',
`change_time` int(10) unsigned NOT NULL,
`change_desc` varchar(255) NOT NULL,
`change_type` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`log_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_ad` */
CREATE TABLE `tp_ad` (
`ad_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告id',
`pid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '广告位置ID',
`media_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '广告类型',
`ad_name` varchar(60) NOT NULL DEFAULT '' COMMENT '广告名称',
`ad_link` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
`ad_code` text NOT NULL COMMENT '图片地址',
`start_time` int(11) NOT NULL DEFAULT '0' COMMENT '投放时间',
`end_time` int(11) NOT NULL DEFAULT '0' COMMENT '结束时间',
`link_man` varchar(60) NOT NULL DEFAULT '' COMMENT '添加人',
`link_email` varchar(60) NOT NULL DEFAULT '' COMMENT '添加人邮箱',
`link_phone` varchar(60) NOT NULL DEFAULT '' COMMENT '添加人联系电话',
`click_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
`enabled` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`ad_id`),
KEY `enabled` (`enabled`),
KEY `position_id` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_ad_position` */
CREATE TABLE `tp_ad_position` (
`position_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`position_name` varchar(60) NOT NULL DEFAULT '' COMMENT '广告位置名称',
`ad_width` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '广告位宽度',
`ad_height` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '广告位高度',
`position_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '广告描述',
`position_style` text NOT NULL COMMENT '模板',
`is_open` tinyint(1) DEFAULT '0' COMMENT '0关闭1开启',
PRIMARY KEY (`position_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_admin` */
CREATE TABLE `tp_admin` (
`admin_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户id',
`user_name` varchar(60) NOT NULL DEFAULT '' COMMENT '用户名',
`email` varchar(60) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`ec_salt` varchar(10) DEFAULT NULL COMMENT '秘钥',
`add_time` int(11) NOT NULL DEFAULT '0',
`last_login` int(11) NOT NULL DEFAULT '0',
`last_ip` varchar(15) NOT NULL DEFAULT '',
`action_list` text NOT NULL COMMENT '允许操作行为',
`nav_list` text NOT NULL,
`lang_type` varchar(50) NOT NULL DEFAULT '',
`agency_id` smallint(5) unsigned NOT NULL,
`suppliers_id` smallint(5) unsigned DEFAULT '0',
`todolist` longtext,
`role_id` smallint(5) DEFAULT NULL COMMENT '角色id',
PRIMARY KEY (`admin_id`),
KEY `user_name` (`user_name`) USING BTREE,
KEY `agency_id` (`agency_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_admin_role` */
CREATE TABLE `tp_admin_role` (
`role_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色ID',
`role_name` varchar(30) DEFAULT NULL COMMENT '角色名称',
`act_list` text COMMENT '权限列表',
`role_desc` varchar(255) DEFAULT NULL COMMENT '角色描述',
PRIMARY KEY (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_area_region` */
CREATE TABLE `tp_area_region` (
`shipping_area_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`region_id` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`shipping_area_id`,`region_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_article` */
CREATE TABLE `tp_article` (
`article_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`cat_id` smallint(5) NOT NULL DEFAULT '0' COMMENT '类别ID',
`title` varchar(150) NOT NULL DEFAULT '' COMMENT '文章标题',
`content` longtext NOT NULL,
`author` varchar(30) NOT NULL DEFAULT '' COMMENT '文章作者',
`author_email` varchar(60) NOT NULL DEFAULT '' COMMENT '作者邮箱',
`keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字',
`article_type` tinyint(1) unsigned NOT NULL DEFAULT '2',
`is_open` tinyint(1) unsigned NOT NULL DEFAULT '1',
`add_time` int(10) unsigned NOT NULL DEFAULT '0',
`file_url` varchar(255) NOT NULL DEFAULT '' COMMENT '附件地址',
`open_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`link` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
`description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`article_id`),
KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*Table structure for table `tp_article_cat` */
CREATE TABLE `tp_article_cat` (
`cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cat_name` varchar(20) DEFAULT NULL COMMENT '类别名称',
`cat_type` smallint(6) DEFAULT NULL,
`parent_id` smallint(6) DEFAULT NULL COMMENT '夫级ID',
`show_in_nav` tinyint(1) DEFAULT NULL,
`sort_order` smallint(6) DEFAULT NULL,
`cat_desc` varchar(255) DEFAULT NULL,
`keywords` varchar(30) DEFAULT NULL,
`cat_alias` varchar(20) DEFAULT NULL COMMENT '别名标示',
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_back_goods` */
CREATE TABLE `tp_back_goods` (
`rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`back_id` mediumint(8) unsigned DEFAULT '0' COMMENT '退货单ID',
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '商品id',
`goods_name` varchar(120) DEFAULT NULL,
`goods_sn` varchar(60) DEFAULT NULL,
`send_number` smallint(5) unsigned DEFAULT '0' COMMENT '发货数量',
`goods_attr` text COMMENT '商品属性',
PRIMARY KEY (`rec_id`),
KEY `back_id` (`back_id`),
KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_back_order` */
CREATE TABLE `tp_back_order` (
`back_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`delivery_sn` varchar(20) NOT NULL COMMENT '发货流水单号',
`order_sn` varchar(20) NOT NULL COMMENT '订单编号',
`order_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '订单iD',
`invoice_no` varchar(50) DEFAULT NULL COMMENT '发货单号',
`add_time` int(10) unsigned DEFAULT '0',
`shipping_id` tinyint(3) unsigned DEFAULT '0' COMMENT '物流id',
`shipping_name` varchar(120) DEFAULT NULL COMMENT '物流名字',
`user_id` mediumint(8) unsigned DEFAULT '0' COMMENT '用户id',
`action_user` varchar(30) DEFAULT NULL COMMENT '操作人',
`consignee` varchar(60) DEFAULT NULL,
`address` varchar(250) DEFAULT NULL,
`country` smallint(5) unsigned DEFAULT '0',
`province` smallint(5) unsigned DEFAULT '0',
`city` smallint(5) unsigned DEFAULT '0',
`district` smallint(5) unsigned DEFAULT '0',
`sign_building` varchar(120) DEFAULT NULL,
`email` varchar(60) DEFAULT NULL,
`zipcode` varchar(60) DEFAULT NULL,
`tel` varchar(60) DEFAULT NULL,
`mobile` varchar(60) DEFAULT NULL,
`best_time` varchar(120) DEFAULT NULL,
`update_time` int(10) unsigned DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`return_time` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`back_id`),
KEY `user_id` (`user_id`),
KEY `order_id` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_brand` */
CREATE TABLE `tp_brand` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '品牌表',
`name` varchar(60) NOT NULL DEFAULT '' COMMENT '品牌名称',
`logo` varchar(80) NOT NULL DEFAULT '' COMMENT '品牌logo',
`desc` text NOT NULL COMMENT '品牌描述',
`url` varchar(255) NOT NULL DEFAULT '' COMMENT '品牌地址',
`order` tinyint(3) unsigned NOT NULL DEFAULT '50' COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_cart` */
CREATE TABLE `tp_cart` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '购物车表',
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`session_id` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'session',
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '商品id',
`goods_sn` varchar(60) NOT NULL DEFAULT '' COMMENT '商品货号',
`goods_name` varchar(120) NOT NULL DEFAULT '' COMMENT '商品名称',
`market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '市场价',
`goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '本店价',
`goods_num` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '购买数量',
`spec_key` varchar(64) NOT NULL DEFAULT '' COMMENT '商品规格key 对应tp_spec_goods_price 表',
`spec_key_name` varchar(64) DEFAULT '' COMMENT '商品规格组合名称',
`bar_code` varchar(64) DEFAULT '' COMMENT '商品条码',
`selected` tinyint(1) DEFAULT '1' COMMENT '购物车选中状态',
PRIMARY KEY (`id`),
KEY `session_id` (`session_id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_comment` */
CREATE TABLE `tp_comment` (
`comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '商品id',
`email` varchar(60) NOT NULL DEFAULT '',
`username` varchar(60) NOT NULL DEFAULT '',
`content` text NOT NULL,
`rank` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '评论等级',
`add_time` int(10) unsigned NOT NULL DEFAULT '0',
`ip_address` varchar(15) NOT NULL DEFAULT '',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否显示',
`parent_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`comment_id`),
KEY `parent_id` (`parent_id`),
KEY `id_value` (`goods_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_config` */
CREATE TABLE `tp_config` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`value` varchar(30) DEFAULT NULL,
`inc_type` varchar(20) DEFAULT NULL,
`desc` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_coupon` */
CREATE TABLE `tp_coupon` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL COMMENT '优惠券名字',
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发放类型 1 按订单发放 2 注册 3 邀请 4 按用户发放',
`money` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '优惠券金额',
`condition` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '使用条件',
`send_start_time` int(11) DEFAULT NULL COMMENT '发放开始时间',
`send_end_time` int(11) DEFAULT NULL COMMENT '发放结束时间',
`use_start_time` int(11) DEFAULT NULL COMMENT '使用开始时间',
`use_end_time` int(11) DEFAULT NULL COMMENT '使用结束时间',
`use_num` int(6) DEFAULT '0' COMMENT '已使用数量',
`add_time` int(11) DEFAULT NULL COMMENT '添加时间',
`send_num` int(6) DEFAULT '0' COMMENT '发放数量(按用户发放类型)',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_coupon_list` */
CREATE TABLE `tp_coupon_list` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`cid` int(8) NOT NULL DEFAULT '0' COMMENT '优惠券 对应coupon表id',
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发放类型 1 按订单发放 2 注册 3 邀请 4 按用户发放',
`uid` int(8) NOT NULL DEFAULT '0' COMMENT '用户id',
`order_id` int(8) DEFAULT '0' COMMENT '订单id',
`use_time` int(11) DEFAULT NULL COMMENT '使用时间',
`code` varchar(10) DEFAULT NULL COMMENT '优惠券兑换码',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_delivery_goods` */
CREATE TABLE `tp_delivery_goods` (
`rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`delivery_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`product_id` mediumint(8) unsigned DEFAULT '0',
`product_sn` varchar(60) DEFAULT NULL,
`goods_name` varchar(120) DEFAULT NULL,
`brand_name` varchar(60) DEFAULT NULL,
`goods_sn` varchar(60) DEFAULT NULL,
`is_real` tinyint(1) unsigned DEFAULT '0',
`extension_code` varchar(30) DEFAULT NULL,
`parent_id` mediumint(8) unsigned DEFAULT '0',
`send_number` smallint(5) unsigned DEFAULT '0',
`goods_attr` text,
PRIMARY KEY (`rec_id`),
KEY `delivery_id` (`delivery_id`,`goods_id`),
KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_delivery_order` */
CREATE TABLE `tp_delivery_order` (
`delivery_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`delivery_sn` varchar(20) NOT NULL,
`order_sn` varchar(20) NOT NULL,
`order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`invoice_no` varchar(50) DEFAULT NULL,
`add_time` int(10) unsigned DEFAULT '0',
`shipping_id` tinyint(3) unsigned DEFAULT '0',
`shipping_name` varchar(120) DEFAULT NULL,
`user_id` mediumint(8) unsigned DEFAULT '0',
`action_user` varchar(30) DEFAULT NULL,
`consignee` varchar(60) DEFAULT NULL,
`address` varchar(250) DEFAULT NULL,
`country` smallint(5) unsigned DEFAULT '0',
`province` smallint(5) unsigned DEFAULT '0',
`city` smallint(5) unsigned DEFAULT '0',
`district` smallint(5) unsigned DEFAULT '0',
`sign_building` varchar(120) DEFAULT NULL,
`email` varchar(60) DEFAULT NULL,
`zipcode` varchar(60) DEFAULT NULL,
`tel` varchar(60) DEFAULT NULL,
`mobile` varchar(60) DEFAULT NULL,
`best_time` varchar(120) DEFAULT NULL,
`postscript` varchar(255) DEFAULT NULL,
`how_oos` varchar(120) DEFAULT NULL,
`insure_fee` decimal(10,2) unsigned DEFAULT '0.00',
`shipping_fee` decimal(10,2) unsigned DEFAULT '0.00',
`update_time` int(10) unsigned DEFAULT '0',
`suppliers_id` smallint(5) DEFAULT '0',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`agency_id` smallint(5) unsigned DEFAULT '0',
PRIMARY KEY (`delivery_id`),
KEY `user_id` (`user_id`),
KEY `order_id` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_goods` */
CREATE TABLE `tp_goods` (
`goods_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品id',
`cat_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
`goods_sn` varchar(60) NOT NULL DEFAULT '' COMMENT '商品编号',
`goods_name` varchar(120) NOT NULL DEFAULT '' COMMENT '商品名称',
`click_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击数',
`brand_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '品牌id',
`kc_count` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '库存数量',
`pl_count` smallint(5) DEFAULT '0' COMMENT '商品评论数',
`weight` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品重量克为单位',
`market_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '市场价',
`shop_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '本店价',
`member_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '默认会员价',
`keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '商品关键词',
`goods_remark` varchar(255) NOT NULL DEFAULT '' COMMENT '商品简单描述',
`goods_content` text CHARACTER SET utf16 COMMENT '商品详细描述',
`original_img` varchar(255) NOT NULL DEFAULT '' COMMENT '商品上传原始图',
`is_real` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否为实物',
`is_on_sale` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否上架',
`is_baoyou` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否包邮0否1是',
`on_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品上架时间',
`order` smallint(4) unsigned NOT NULL DEFAULT '50' COMMENT '商品排序',
`is_tuijian` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否推荐',
`is_new` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否新品',
`is_hot` tinyint(1) DEFAULT '0' COMMENT '是否热卖',
`last_update` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后更新时间',
`goods_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '商品所属类型id，取值表goods_type的cat_id',
`spec_type` smallint(5) DEFAULT '0' COMMENT '商品规格类型，取值表goods_type的cat_id',
PRIMARY KEY (`goods_id`),
KEY `goods_sn` (`goods_sn`),
KEY `cat_id` (`cat_id`),
KEY `last_update` (`last_update`),
KEY `brand_id` (`brand_id`),
KEY `goods_number` (`kc_count`),
KEY `goods_weight` (`weight`),
KEY `sort_order` (`order`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_goods_attr` */
CREATE TABLE `tp_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 AUTO_INCREMENT=403 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_goods_attribute` */
CREATE TABLE `tp_goods_attribute` (
`attr_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '属性id',
`attr_name` varchar(60) NOT NULL DEFAULT '' COMMENT '属性名称',
`type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '属性分类id',
`attr_index` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不需要检索 1关键字检索 2范围检索',
`attr_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0唯一属性 1单选属性 2复选属性',
`attr_input_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT ' 0 手工录入 1从列表中选择 2多行文本框',
`attr_values` text NOT NULL COMMENT '可选值列表',
`order` tinyint(3) unsigned NOT NULL DEFAULT '50' COMMENT '属性排序',
PRIMARY KEY (`attr_id`),
KEY `cat_id` (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=223 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_goods_category` */
CREATE TABLE `tp_goods_category` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品分类id',
`name` varchar(90) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '商品分类名称',
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
`parent_id_path` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '家族图谱',
`level` tinyint(1) DEFAULT '0' COMMENT '等级',
`sort_order` tinyint(1) unsigned NOT NULL DEFAULT '50' COMMENT '顺序排序',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
`goods_type` int(11) DEFAULT '0' COMMENT '商品分类对应的商品类型',
`filter_spec` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '帅选规格',
`filter_attr` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '帅选属性',
`image` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '分类图片',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=844 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_goods_category4` */
CREATE TABLE `tp_goods_category4` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '商品分类id',
`name` varchar(90) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '商品分类名称',
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父id',
`parent_id_path` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '家族图谱',
`level` tinyint(1) DEFAULT '0' COMMENT '等级',
`sort_order` tinyint(1) unsigned NOT NULL DEFAULT '50' COMMENT '顺序排序',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
`filter_attr` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '帅选属性',
`image` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '分类图片',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=508 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_goods_images` */
CREATE TABLE `tp_goods_images` (
`img_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`imgage_url` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`img_id`),
KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_goods_type` */
CREATE TABLE `tp_goods_type` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_navigation` */
CREATE TABLE `tp_navigation` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '前台导航表',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '导航名称',
`is_show` tinyint(1) DEFAULT '1' COMMENT '是否显示',
`is_new` tinyint(1) DEFAULT '1' COMMENT '是否新窗口',
`order` int(11) DEFAULT '50' COMMENT '排序',
`url` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '链接地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*Table structure for table `tp_order` */
CREATE TABLE `tp_order` (
`order_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单id',
`order_sn` varchar(20) NOT NULL DEFAULT '' COMMENT '订单编号',
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
`order_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '订单状态',
`shipping_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '发货状态',
`pay_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态',
`consignee` varchar(60) NOT NULL DEFAULT '' COMMENT '收货人',
`country` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '国家',
`province` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '省份',
`city` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '城市',
`district` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '县区',
`address` varchar(255) NOT NULL DEFAULT '' COMMENT '地址',
`zipcode` varchar(60) NOT NULL DEFAULT '' COMMENT '邮政编码',
`mobile` varchar(60) NOT NULL DEFAULT '' COMMENT '手机',
`email` varchar(60) NOT NULL DEFAULT '' COMMENT '邮件',
`shipping_code` varchar(32) NOT NULL DEFAULT '0' COMMENT '物流code',
`shipping_name` varchar(120) NOT NULL DEFAULT '' COMMENT '物流名称',
`pay_code` varchar(32) NOT NULL DEFAULT '0' COMMENT '支付code',
`pay_name` varchar(120) NOT NULL DEFAULT '' COMMENT '支付方式名称',
`invoice_title` varchar(256) DEFAULT '' COMMENT '发票抬头',
`goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品总价',
`shipping_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '邮费',
`user_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '使用余额',
`coupon_price` decimal(10,2) DEFAULT '0.00' COMMENT '使用优惠券抵多少钱',
`integral` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '使用积分',
`integral_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '使用积分抵多少钱',
`order_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '应付款金额',
`add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '下单时间',
`confirm_time` int(10) DEFAULT '0' COMMENT '收货确认时间',
`pay_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
`shipping_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发货时间',
`invoice_no` varchar(255) NOT NULL DEFAULT '' COMMENT '发货单号',
`pay_note` varchar(255) NOT NULL DEFAULT '' COMMENT '支付备注',
`discount` decimal(10,2) NOT NULL COMMENT '打折金额',
`is_cod` tinyint(1) DEFAULT '0' COMMENT '是否货到付款',
PRIMARY KEY (`order_id`),
UNIQUE KEY `order_sn` (`order_sn`),
KEY `user_id` (`user_id`),
KEY `order_status` (`order_status`),
KEY `shipping_status` (`shipping_status`),
KEY `pay_status` (`pay_status`),
KEY `shipping_id` (`shipping_code`),
KEY `pay_id` (`pay_code`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_order_action` */
CREATE TABLE `tp_order_action` (
`action_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`order_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
`action_user` varchar(30) NOT NULL DEFAULT '' COMMENT '操作人',
`order_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`shipping_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`pay_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`action_place` tinyint(1) unsigned NOT NULL DEFAULT '0',
`action_note` varchar(255) NOT NULL DEFAULT '' COMMENT '操作备注',
`log_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
PRIMARY KEY (`action_id`),
KEY `order_id` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_order_goods` */
CREATE TABLE `tp_order_goods` (
`rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '表id自增',
`order_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '订单id',
`goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '商品id',
`goods_name` varchar(120) NOT NULL DEFAULT '' COMMENT '视频名称',
`goods_sn` varchar(60) NOT NULL DEFAULT '' COMMENT '商品货号',
`goods_num` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '购买数量',
`market_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '市场价',
`goods_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '本店价',
`spec_key` varchar(128) NOT NULL DEFAULT '' COMMENT '商品规格key',
`spec_key_name` varchar(128) NOT NULL DEFAULT '' COMMENT '规格对应的中文名字',
`bar_code` varchar(64) NOT NULL DEFAULT '' COMMENT '条码',
PRIMARY KEY (`rec_id`),
KEY `order_id` (`order_id`),
KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_payment` */
CREATE TABLE `tp_payment` (
`pay_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`pay_code` varchar(20) NOT NULL DEFAULT '',
`pay_name` varchar(120) NOT NULL DEFAULT '' COMMENT '支付方式名称',
`pay_fee` varchar(10) NOT NULL DEFAULT '0' COMMENT '手续费',
`pay_desc` text NOT NULL COMMENT '描述',
`pay_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
`pay_config` text NOT NULL COMMENT '配置',
`enabled` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '开启',
`is_cod` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否货到付款',
`is_online` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否在线支付',
PRIMARY KEY (`pay_id`),
UNIQUE KEY `pay_code` (`pay_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_plugin` */
CREATE TABLE `tp_plugin` (
`code` varchar(13) DEFAULT NULL COMMENT '插件编码',
`name` varchar(55) DEFAULT NULL COMMENT '中文名字',
`version` varchar(13) DEFAULT NULL,
`author` varchar(30) DEFAULT NULL,
`config` text COMMENT '配置信息',
`config_value` text COMMENT '配置值信息',
`desc` varchar(255) DEFAULT NULL,
`status` tinyint(1) DEFAULT '0' COMMENT '是否启用',
`type` varchar(50) DEFAULT NULL COMMENT '插件类型 payment支付 login 登陆 shipping物流',
`icon` varchar(255) DEFAULT NULL COMMENT '图标'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_region` */
CREATE TABLE `tp_region` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`parent_id` int(11) DEFAULT NULL,
`level` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3524 DEFAULT CHARSET=gbk;
/*Table structure for table `tp_shipping_area` */
CREATE TABLE `tp_shipping_area` (
`shipping_area_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`shipping_area_name` varchar(150) NOT NULL DEFAULT '',
`shipping_code` varchar(50) NOT NULL DEFAULT '0',
`config` text NOT NULL,
`update_time` int(11) DEFAULT NULL,
`is_default` tinyint(1) DEFAULT '0' COMMENT '是否默认',
PRIMARY KEY (`shipping_area_id`),
KEY `shipping_id` (`shipping_code`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_shop_config` */
CREATE TABLE `tp_shop_config` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`code` varchar(30) NOT NULL DEFAULT '',
`type` varchar(10) NOT NULL DEFAULT '',
`store_range` varchar(255) NOT NULL DEFAULT '' COMMENT '存储范围',
`store_path` varchar(255) NOT NULL DEFAULT '' COMMENT '存储路径',
`value` text NOT NULL,
`sort` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '排序',
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_spec` */
CREATE TABLE `tp_spec` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '规格表',
`type_id` int(11) DEFAULT '0' COMMENT '规格类型',
`name` varchar(55) DEFAULT NULL COMMENT '规格名称',
`order` int(11) DEFAULT '50' COMMENT '排序',
`search_index` tinyint(1) DEFAULT '0' COMMENT '是否需要检索',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_spec_goods_price` */
CREATE TABLE `tp_spec_goods_price` (
`goods_id` int(11) DEFAULT '0',
`key` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`key_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`price` decimal(10,2) DEFAULT NULL,
`kc_count` int(11) DEFAULT '10' COMMENT '库存数量',
`bar_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '商品 条形码'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_spec_image` */
CREATE TABLE `tp_spec_image` (
`goods_id` int(11) DEFAULT '0' COMMENT '商品规格图片表id',
`spec_image_id` int(11) DEFAULT '0' COMMENT '规格项id',
`src` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '' COMMENT '商品规格图片路径'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `tp_spec_item` */
CREATE TABLE `tp_spec_item` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`spec_id` int(11) DEFAULT NULL,
`item` varchar(54) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_system_module` */
CREATE TABLE `tp_system_module` (
`mod_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`module` enum('top','menu','module') DEFAULT 'module',
`level` tinyint(1) DEFAULT '3',
`ctl` varchar(20) DEFAULT '',
`act` varchar(20) DEFAULT '',
`title` varchar(20) DEFAULT '',
`visible` tinyint(1) DEFAULT '1',
`parent_id` smallint(6) DEFAULT '0',
`orderby` smallint(6) DEFAULT '50',
`dateline` int(10) DEFAULT '0',
PRIMARY KEY (`mod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_user_address` */
CREATE TABLE `tp_user_address` (
`address_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`consignee` varchar(60) NOT NULL DEFAULT '' COMMENT '收货人',
`email` varchar(60) NOT NULL DEFAULT '' COMMENT '邮箱地址',
`country` smallint(5) NOT NULL DEFAULT '0',
`province` smallint(5) NOT NULL DEFAULT '0' COMMENT '省份',
`city` smallint(5) NOT NULL DEFAULT '0' COMMENT '城市',
`district` smallint(5) NOT NULL DEFAULT '0' COMMENT '地区',
`address` varchar(120) NOT NULL DEFAULT '' COMMENT '地址',
`zipcode` varchar(60) NOT NULL DEFAULT '' COMMENT '邮政编码',
`mobile` varchar(60) NOT NULL DEFAULT '' COMMENT '手机',
`is_default` tinyint(1) DEFAULT '0' COMMENT '默认收货地址',
PRIMARY KEY (`address_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_users` */
CREATE TABLE `tp_users` (
`user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(60) NOT NULL DEFAULT '',
`username` varchar(60) NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(32) NOT NULL DEFAULT '',
`sex` tinyint(1) unsigned NOT NULL DEFAULT '0',
`birthday` date NOT NULL DEFAULT '0000-00-00',
`user_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '用户金额',
`frozen_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '冻结金额',
`pay_points` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '消费积分',
`rank_points` int(10) unsigned NOT NULL DEFAULT '0',
`address_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '默认收货地址',
`reg_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
`last_login` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
`last_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
`user_rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
`parent_id` mediumint(9) NOT NULL DEFAULT '0' COMMENT '推荐人',
`qq` varchar(20) NOT NULL,
`mobile` varchar(20) NOT NULL,
`is_validated` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`username`),
KEY `email` (`email`),
KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*Table structure for table `tp_wx_img` */
CREATE TABLE `tp_wx_img` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`keyword` char(255) NOT NULL,
`desc` text NOT NULL COMMENT '简介',
`pic` char(255) NOT NULL COMMENT '封面图片',
`url` char(255) NOT NULL COMMENT '图文外链地址',
`createtime` varchar(13) NOT NULL,
`uptatetime` varchar(13) NOT NULL,
`token` char(30) NOT NULL,
`title` varchar(60) NOT NULL,
`goods_id` int(11) NOT NULL DEFAULT '0',
`goods_name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信图文';
/*Table structure for table `tp_wx_keyword` */
CREATE TABLE `tp_wx_keyword` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`keyword` char(255) NOT NULL,
`pid` int(11) NOT NULL,
`token` varchar(60) NOT NULL,
`module` varchar(15) NOT NULL,
`precision` tinyint(1) NOT NULL DEFAULT '0',
`precisions` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 包含匹配 1 完全匹配',
PRIMARY KEY (`id`),
KEY `pid` (`pid`),
KEY `token` (`token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_wx_menu` */
CREATE TABLE `tp_wx_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`level` tinyint(1) DEFAULT '1' COMMENT '菜单级别',
`name` varchar(50) NOT NULL,
`sort` int(5) DEFAULT '0' COMMENT '排序',
`type` tinyint(1) DEFAULT '0' COMMENT '0 view 1 click',
`value` varchar(255) DEFAULT NULL,
`token` varchar(50) NOT NULL,
`pid` int(11) DEFAULT '0' COMMENT '上级菜单',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Table structure for table `tp_wx_news` */
CREATE TABLE `tp_wx_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`keyword` char(255) NOT NULL,
`createtime` varchar(13) NOT NULL,
`uptatetime` varchar(13) NOT NULL,
`token` char(30) NOT NULL,
`img_id` varchar(50) DEFAULT NULL COMMENT '图文组合id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信图文';
/*Table structure for table `tp_wx_text` */
CREATE TABLE `tp_wx_text` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`uname` varchar(90) NOT NULL,
`keyword` char(255) NOT NULL,
`precisions` tinyint(1) NOT NULL DEFAULT '0',
`text` text NOT NULL,
`createtime` varchar(13) NOT NULL,
`updatetime` varchar(13) NOT NULL,
`click` int(11) NOT NULL,
`token` char(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文本回复表';
/*Table structure for table `tp_wx_user` */
CREATE TABLE `tp_wx_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`wxname` varchar(60) NOT NULL COMMENT '公众号名称',
`aeskey` varchar(45) NOT NULL DEFAULT '',
`encode` tinyint(1) NOT NULL DEFAULT '0',
`appid` varchar(50) NOT NULL DEFAULT '',
`appsecret` varchar(50) NOT NULL DEFAULT '',
`wxid` varchar(20) NOT NULL COMMENT '公众号原始ID',
`weixin` char(20) NOT NULL COMMENT '微信号',
`headerpic` char(255) NOT NULL COMMENT '头像地址',
`token` char(255) NOT NULL,
`w_token` varchar(150) NOT NULL DEFAULT '' COMMENT '微信对接token',
`create_time` varchar(13) NOT NULL,
`updatetime` varchar(13) NOT NULL,
`tplcontentid` varchar(2) NOT NULL COMMENT '内容模版ID',
`share_ticket` varchar(150) NOT NULL COMMENT '分享ticket',
`share_dated` char(15) NOT NULL,
`authorizer_access_token` varchar(200) NOT NULL,
`authorizer_refresh_token` varchar(200) NOT NULL,
`authorizer_expires` char(10) NOT NULL,
`type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型',
`web_access_token` varchar(200) NOT NULL COMMENT ' 网页授权token',
`web_refresh_token` varchar(200) NOT NULL,
`web_expires` char(10) NOT NULL COMMENT '过期时间',
`qr` varchar(200) NOT NULL,
`menu_config` text COMMENT '菜单',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `uid_2` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信公共帐号';