一个采用thinkphp3.2开发的商城系统.zip

-- phpMyAdmin SQL Dump -- version phpStudy 2014 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2016 年 10 月 28 日 22:32 -- 服务器版本: 5.5.40 -- PHP 版本: 5.4.33 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 */; -- -- 数据库: `yunniupin` -- -- -------------------------------------------------------- -- -- 表的结构 `ynp_activity` -- CREATE TABLE IF NOT EXISTS `ynp_activity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` char(30) NOT NULL DEFAULT '', `title` char(80) NOT NULL DEFAULT '', `picurl` varchar(255) DEFAULT NULL, `remark` char(140) NOT NULL DEFAULT '', `rule` text, `log` text, `type` tinyint(2) unsigned NOT NULL DEFAULT '1', `icon` char(50) NOT NULL DEFAULT '', `status` tinyint(2) NOT NULL DEFAULT '0', `end_time` int(11) unsigned NOT NULL DEFAULT '0', `display` tinyint(3) unsigned NOT NULL DEFAULT '1', `web_index_tpl` char(50) NOT NULL DEFAULT '', `wap_index_tpl` char(50) NOT NULL DEFAULT '', `web_list_tpl` char(50) NOT NULL DEFAULT '', `wap_list_tpl` char(50) NOT NULL DEFAULT '', `web_content_tpl` char(50) NOT NULL DEFAULT '', `wap_content_tpl` char(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=64 ; -- -- 转存表中的数据 `ynp_activity` -- INSERT INTO `ynp_activity` (`id`, `name`, `title`, `picurl`, `remark`, `rule`, `log`, `type`, `icon`, `status`, `end_time`, `display`, `web_index_tpl`, `wap_index_tpl`, `web_list_tpl`, `wap_list_tpl`, `web_content_tpl`, `wap_content_tpl`) VALUES (55, 'tz_jl', '购买欢乐送', './Picture/Activity/active-04.jpg', '一次性每购买100人次送5云币', 'table:user|field:black|condition:id={$self} and floor({$relf}/100)>=1|rule:black+floor({$relf}/100)*5|cycle:24|max:10', '用户[user|get_user_name]投注[record]奖励[record|activity_mod]云币[price=record|activity_mod]', 4, 'demo-icon icon-basket-1 a3 discount-icon', 1, 1483113600, 1, 'activity/activity-more4.html', 'explain-goumai.html', '', '', '', ''), (56, 'sd_jl', '晒单欢乐送', './Picture/Activity/active-03.jpg', '中奖后成功晒单即送1云币', 'table:user|field:black|condition:id={$self}|rule:black+1|cycle:24|max:10', '用户[user|get_user_name]晒单[record]奖励1云币[price=1]', 6, 'demo-icon icon-camera-1 a2 discount-icon', 1, 1483113600, 1, 'activity/activity-more3.html', 'explain-shared.html', '', '', '', ''), (57, 'userfx_jl', '分享欢乐送', './Picture/Activity/active-02.jpg', '分享你好友每关注5人即送1云币', 'table:user|field:spread|condition:id={$self}|rule:spread+1|cycle:24|max:100|ip:1;table:user|field:black|condition:id={$self} and spread%5=0|rule:black+1|cycle:24|max:100|ip:1', '您邀请的好友累计5人关注奖励1云币[price=1]', 7, 'demo-icon icon-picasa a4 discount-icon', 1, 1483113600, 1, 'activity/activity-more2.html', 'explain-share.html', '', '', 'activity/activity-share.html', 'activity-share.html'), (58, 'recharge_jl', '充值欢乐送', './Picture/Activity/active-01.jpg', '每充值满100 即刻送 5 云币', 'table:user|field:black|condition:id={$self} and floor({$relf}/100)>=1|rule:black+floor({$relf}/100)*5|cycle:24|max:10', '用户[user|get_user_name]充值[record]奖励[record|activity_mod]云币[price=record|activity_mod]', 5, 'demo-icon icon-money a5 discount-icon', 1, 1483113600, 1, 'activity/activity-more1.html', 'explain-pay.html', '', '', '', ''), (59, 'turntable_jl', '欢乐大转盘', './Picture/Activity/active-05.jpg', '转盘奖励', 'table:user|field:black|condition:id={$self}|rule:black+{$relf}|cycle:16|max:2', '用户[user|get_user_name]欢乐大转盘奖励[record]云币[price=record]', 9, 'demo-icon icon-gift a1 discount-icon', 1, 1483113600, 1, 'activity/turntable/index.html', 'turntable/index.html', '', '', '', ''), (60, 'share_turntable', '大转盘分享增加机会', '', '大转盘分享增加机会', 'table:user|field:turntable|condition:id={$self}|rule:turntable+1|cycle:16|max:1', '用户[user|get_user_name]分享增加一次欢乐大转盘机会', 9, '', 1, 1483113600, 0, '', '', '', '', '', ''), (61, 'login_turntable', '登录增加转盘机会', '', '登录增加转盘机会', 'table:user|field:turntable|condition:id={$self}|rule:turntable+1|cycle:16|max:1', '用户[user|get_user_name]登录增加一次欢乐大转盘机会', 2, '', 1, 1483113600, 0, '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- 表的结构 `ynp_activity_log` -- CREATE TABLE IF NOT EXISTS `ynp_activity_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(2) unsigned NOT NULL DEFAULT '1', `activity_id` int(10) unsigned NOT NULL DEFAULT '0', `user_id` int(10) unsigned NOT NULL DEFAULT '0', `activity_ip` bigint(20) DEFAULT NULL, `record_id` varchar(255) NOT NULL DEFAULT '0', `remark` varchar(255) NOT NULL DEFAULT '', `status` tinyint(2) NOT NULL DEFAULT '1', `create_time` int(10) unsigned NOT NULL DEFAULT '0', `price` int(11) NOT NULL DEFAULT '0', `wid` int(11) DEFAULT '0', PRIMARY KEY (`id`), KEY `user_id_ix` (`user_id`), KEY `activity_id_ix` (`activity_id`), KEY `activity_ip_ix` (`activity_ip`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的结构 `ynp_category` -- CREATE TABLE IF NOT EXISTS `ynp_category` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `pid` int(10) unsigned NOT NULL DEFAULT '0', `icon` char(50) DEFAULT NULL, `sort` int(10) unsigned NOT NULL DEFAULT '0', `display` tinyint(3) unsigned NOT NULL DEFAULT '0', `meta_title` varchar(50) NOT NULL DEFAULT '', `keywords` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `create_time` int(10) unsigned NOT NULL DEFAULT '0', `update_time` int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `pid` (`pid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=14 ; -- -- 转存表中的数据 `ynp_category` -- INSERT INTO `ynp_category` (`id`, `title`, `pid`, `icon`, `sort`, `display`, `meta_title`, `keywords`, `description`, `create_time`, `update_time`, `status`) VALUES (4, '手机平板', 0, 'icon icon-tablet', 1, 1, '', '', '', 1440469030, 1450770171, 1), (8, '电脑办公', 0, 'icon icon-desktop', 2, 1, '', '', '', 1450770206, 1450770206, 1), (9, '数码影音', 0, 'icon icon-camera-1', 3, 1, '', '', '', 1450770234, 1450770234, 1), (10, '女性时尚', 0, 'icon icon-women', 4, 1, '', '', '', 1450770259, 1450770259, 1), (11, '美食天地', 0, 'icon icon-food', 5, 1, '', '', '', 1450770274, 1450770274, 1), (12, '潮流新品', 0, 'icon icon-fashion', 6, 1, '', '', '', 1450770293, 1450770293, 1), (13, '其他商品', 0, 'icon icon-th', 7, 1, '', '', '', 1450770304, 1450770304, 1); -- -------------------------------------------------------- -- -- 表的结构 `ynp_config` -- CREATE TABLE IF NOT EXISTS `ynp_config` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `title` varchar(50) NOT NULL DEFAULT '', `group` tinyint(3) unsigned NOT NULL DEFAULT '0', `extra` varchar(255) NOT NULL DEFAULT '', `remark` varchar(100) NOT NULL, `create_time` int(10) unsigned NOT NULL DEFAULT '0', `update_time` int(10) unsigned NOT NULL DEFAULT '0', `value` text NOT NULL, `sort` smallint(3) unsigned NOT NULL DEFAULT '0', `display` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `uk_name` (`name`), KEY `type` (`type`), KEY `group` (`group`) ) ENGINE=MyISAM DE