代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50540
Source Host : localhost:3306
Source Database : cyzx
Target Server Type : MYSQL
Target Server Version : 50540
File Encoding : 65001
Date: 2017-12-26 17:07:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `clam_auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `clam_auth_group`;
CREATE TABLE `clam_auth_group` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` char(100) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '1',
`rules` text COMMENT '规则id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='用户组表';
-- ----------------------------
-- Records of clam_auth_group
-- ----------------------------
INSERT INTO `clam_auth_group` VALUES ('1', '超级管理员', '1', '6,96,20,1,3,4,5,21,7,8,9,10,11,12,13,14,15,16,2009,2010,19,1999,2096,2097,2102,2116,2143,2000,2098,2101,2103,2104,2105,2117,2118,2106,2108,2114,2109,2110,2115,2150,2151,2152,2111,2144,2145,2146,2147,2148,2149,2112');
-- ----------------------------
-- Table structure for `clam_auth_group_access`
-- ----------------------------
DROP TABLE IF EXISTS `clam_auth_group_access`;
CREATE TABLE `clam_auth_group_access` (
`uid` int(11) unsigned NOT NULL COMMENT '用户id',
`group_id` int(11) unsigned NOT NULL COMMENT '用户组id',
UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
KEY `uid` (`uid`),
KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户组明细表';
-- ----------------------------
-- Records of clam_auth_group_access
-- ----------------------------
INSERT INTO `clam_auth_group_access` VALUES ('1', '1');
INSERT INTO `clam_auth_group_access` VALUES ('2', '1');
INSERT INTO `clam_auth_group_access` VALUES ('3', '1');
INSERT INTO `clam_auth_group_access` VALUES ('4', '1');
-- ----------------------------
-- Table structure for `clam_auth_rule`
-- ----------------------------
DROP TABLE IF EXISTS `clam_auth_rule`;
CREATE TABLE `clam_auth_rule` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
`name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一标识',
`title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文名称',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：为1正常，为0禁用',
`type` tinyint(1) unsigned NOT NULL DEFAULT '1',
`condition` char(100) NOT NULL DEFAULT '' COMMENT '规则表达式，为空表示存在就验证，不为空表示按照条件验证',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2153 DEFAULT CHARSET=utf8 COMMENT='规则表';
-- ----------------------------
-- Records of clam_auth_rule
-- ----------------------------
INSERT INTO `clam_auth_rule` VALUES ('1', '20', 'Nav/index', '菜单管理', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('3', '1', 'Nav/add', '添加菜单', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('4', '1', 'Nav/edit', '修改菜单', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('5', '1', 'Nav/delete', '删除菜单', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('21', '0', 'RULE', '权限控制', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('7', '21', 'Rule/index', '权限管理', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('8', '7', 'Rule/add', '添加权限', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('9', '7', 'Rule/edit', '修改权限', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('10', '7', 'Rule/delete', '删除权限', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('11', '21', 'Rule/group', '用户组管理', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('12', '11', 'Rule/add_group', '添加用户组', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('13', '11', 'Rule/edit_group', '修改用户组', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('14', '11', 'Rule/delete_group', '删除用户组', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('15', '11', 'Rule/rule_group', '分配权限', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('16', '11', 'Rule/add_admin', '添加管理员', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('19', '21', 'Rule/admin_user_list', '管理员列表', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('20', '0', 'SYSTEM', '系统设置', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('6', '0', 'Index/index', '后台首页', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('96', '6', 'Index/welcome', '欢迎界面', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2009', '11', 'Rule/edit_admin', '修改用户权限', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2010', '11', 'Rule/check_user', '添加用户组成员', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('1999', '0', 'USER', '用户管理', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2096', '1999', 'User/showlist', '用户列表', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2097', '1999', 'User/update', '用户信息查看', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2098', '2000', 'UserMoney/moneyInfo', '查看用户资金', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2000', '0', 'USERMONEY', '用户资金管理', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2101', '2098', 'UserMoney/changeMoneyFormSub', '用户资金修改', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2102', '2097', 'User/updateFormSub', '用户信息修改', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2103', '0', 'FINANCE', '日志管理', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2104', '2103', 'finance/financeLog', '详细日志', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2105', '2103', 'finance/bonusLog', '统计日志', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2106', '0', 'CONFIG', '网站配置', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2109', '2106', 'Leavel/showlist', '级别配置列表', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2108', '2106', 'Currency/showlist', '奖金币种分配比例', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2110', '2109', 'Leavel/update', '级别配置详情', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2111', '0', 'SERVICE', '系统服务', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2112', '0', 'Service/userMessage', '留言列表', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2144', '2111', 'Service/backUserMessage', '留言给用户', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2114', '2108', 'Currency/update', '调整动态币种分配比例', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2115', '2109', 'Leavel/updateFormSub', '级别配置修改', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2116', '2097', 'finance/rechargeLog', '管理员资金操作', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2117', '2103', 'finance/sendLog', '会员转账列表', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2118', '2103', 'finance/changeLog', '资金转换列表', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2152', '2106', 'Config/qrcode', '收款信息', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2143', '1999', 'User/goToHome', '后台登录前台', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2145', '2111', 'Service/backUserMessageFormSub', '留言给用户提交', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2146', '2111', 'Service/uploadLog', '上传文件列表', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2147', '2146', 'Service/addUpload', '添加上传文件', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2148', '2146', 'Service/addUploadSub', '添加上传文件操作', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2149', '2146', 'Service/delUpload', '删除上传文件', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2150', '2106', 'Config/configlog', '配置参数', '1', '1', '');
INSERT INTO `clam_auth_rule` VALUES ('2151', '2150', 'Config/updateConfig', '修改配置参数', '1', '1', '');
-- ----------------------------
-- Table structure for `clam_bank_type`
-- ----------------------------
DROP TABLE IF EXISTS `clam_bank_type`;
CREATE TABLE `clam_bank_type` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_bank_type
-- ----------------------------
INSERT INTO `clam_bank_type` VALUES ('1', '中国工商银行');
INSERT INTO `clam_bank_type` VALUES ('2', '中国建设银行');
INSERT INTO `clam_bank_type` VALUES ('3', '中国银行');
INSERT INTO `clam_bank_type` VALUES ('4', '中国农业银行');
INSERT INTO `clam_bank_type` VALUES ('5', '交通银行');
INSERT INTO `clam_bank_type` VALUES ('6', '招商银行');
INSERT INTO `clam_bank_type` VALUES ('7', '平安银行');
-- ----------------------------
-- Table structure for `clam_bonus_log`
-- ----------------------------
DROP TABLE IF EXISTS `clam_bonus_log`;
CREATE TABLE `clam_bonus_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`add_time` int(10) NOT NULL,
`bonus1` decimal(32,2) NOT NULL DEFAULT '0.00',
`bonus2` decimal(32,2) DEFAULT '0.00',
`bonus3` decimal(32,2) DEFAULT '0.00',
`bonus4` decimal(32,2) DEFAULT '0.00',
`bonus5` decimal(32,2) DEFAULT '0.00',
`bonus6` decimal(32,2) DEFAULT '0.00',
`bonus7` decimal(32,2) DEFAULT '0.00',
`bonus8` decimal(32,2) DEFAULT '0.00',
`bonus9` decimal(32,2) DEFAULT '0.00',
`bonus10` decimal(32,2) DEFAULT '0.00',
`bonus11` decimal(32,2) DEFAULT '0.00',
`user_id` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_bonus_log
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_bonus_type`
-- ----------------------------
DROP TABLE IF EXISTS `clam_bonus_type`;
CREATE TABLE `clam_bonus_type` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`remark` varchar(32) NOT NULL,
`status` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_bonus_type
-- ----------------------------
INSERT INTO `clam_bonus_type` VALUES ('1', '推荐奖', '推荐奖', '1');
INSERT INTO `clam_bonus_type` VALUES ('3', '对碰奖', '对碰奖', '1');
INSERT INTO `clam_bonus_type` VALUES ('5', '注册与升级', '', '1');
INSERT INTO `clam_bonus_type` VALUES ('6', '动态总额', '', '1');
INSERT INTO `clam_bonus_type` VALUES ('7', '大区推荐奖', '', '0');
INSERT INTO `clam_bonus_type` VALUES ('9', '现金钱包', '', '1');
INSERT INTO `clam_bonus_type` VALUES ('8', '小区推荐奖', '', '0');
INSERT INTO `clam_bonus_type` VALUES ('2', '静态产生', '', '1');
-- ----------------------------
-- Table structure for `clam_change_log`
-- ----------------------------
DROP TABLE IF EXISTS `clam_change_log`;
CREATE TABLE `clam_change_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sys_id` int(10) NOT NULL,
`num` decimal(32,2) NOT NULL,
`add_time` int(10) NOT NULL,
`remark` text NOT NULL,
`user_id` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_change_log
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_change_sys`
-- ----------------------------
DROP TABLE IF EXISTS `clam_change_sys`;
CREATE TABLE `clam_change_sys` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`currency_id` int(10) NOT NULL,
`to_currency_id` int(10) NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_change_sys
-- ----------------------------
INSERT INTO `clam_change_sys` VALUES ('1', '5', '6', '1');
-- ----------------------------
-- Table structure for `clam_config`
-- ----------------------------
DROP TABLE IF EXISTS `clam_config`;
CREATE TABLE `clam_config` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(32) NOT NULL,
`value` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_config
-- ----------------------------
INSERT INTO `clam_config` VALUES ('1', 'reward_fee', '0.1');
INSERT INTO `clam_config` VALUES ('13', 'reward_jiandian_num1', '12');
INSERT INTO `clam_config` VALUES ('4', 'TRADE_RATIO_DAY', '0.2');
INSERT INTO `clam_config` VALUES ('5', 'TRADE_SELL_DAY', '1');
INSERT INTO `clam_config` VALUES ('6', 'BASIC_PRICE', '2');
INSERT INTO `clam_config` VALUES ('7', 'REG_MIN_PRICE', '4.8');
INSERT INTO `clam_config` VALUES ('8', 'CAN_REG', '1');
INSERT INTO `clam_config` VALUES ('9', 'CAN_BUY', '1');
INSERT INTO `clam_config` VALUES ('10', 'CAN_SELL', '1');
INSERT INTO `clam_config` VALUES ('11', 'MAX_SELL_DAY', '100000');
INSERT INTO `clam_config` VALUES ('12', 'CHANGE_FEE', '0.05');
INSERT INTO `clam_config` VALUES ('14', 'QRCODE', '/Uploads/2017-12-26/QRCODE_1514277859_558789.jpg');
-- ----------------------------
-- Table structure for `clam_country`
-- ----------------------------
DROP TABLE IF EXISTS `clam_country`;
CREATE TABLE `clam_country` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_country
-- ----------------------------
INSERT INTO `clam_country` VALUES ('1', 'China 中国');
INSERT INTO `clam_country` VALUES ('2', 'Malaysia 马来西亚');
INSERT INTO `clam_country` VALUES ('3', 'Singapore 新加坡');
INSERT INTO `clam_country` VALUES ('4', 'UnitedStates 美国');
INSERT INTO `clam_country` VALUES ('5', 'Australia 澳大利亚');
INSERT INTO `clam_country` VALUES ('6', 'HongKong 香港');
INSERT INTO `clam_country` VALUES ('7', 'Macao 澳门');
INSERT INTO `clam_country` VALUES ('8', 'Taiwan 台湾');
INSERT INTO `clam_country` VALUES ('9', 'Brunei 汶莱');
INSERT INTO `clam_country` VALUES ('10', 'Japan 日本');
INSERT INTO `clam_country` VALUES ('11', 'Korea 韩国');
INSERT INTO `clam_country` VALUES ('12', 'Philippines 菲律宾');
INSERT INTO `clam_country` VALUES ('13', 'Thailand 泰国');
INSERT INTO `clam_country` VALUES ('14', 'Vietnam 越南');
INSERT INTO `clam_country` VALUES ('15', 'Indonesia 印尼');
INSERT INTO `clam_country` VALUES ('16', 'Cambodia 柬埔寨');
INSERT INTO `clam_country` VALUES ('17', 'India 印度');
-- ----------------------------
-- Table structure for `clam_currency`
-- ----------------------------
DROP TABLE IF EXISTS `clam_currency`;
CREATE TABLE `clam_currency` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`reward_ratio` decimal(10,4) NOT NULL,
`sell` tinyint(4) DEFAULT '0',
`send` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_currency
-- ----------------------------
INSERT INTO `clam_currency` VALUES ('1', '账户余额', '0.8000', '0', '1');
INSERT INTO `clam_currency` VALUES ('2', '重复消费积分', '0.1500', '0', '0');
INSERT INTO `clam_currency` VALUES ('3', '动态总额', '1.0000', '0', '0');
INSERT INTO `clam_currency` VALUES ('4', '静态总额', '0.0000', '0', '0');
INSERT INTO `clam_currency` VALUES ('6', '奖励税金', '0.0500', '0', '0');
INSERT INTO `clam_currency` VALUES ('5', '静态收益剩余额度', '0.0000', '0', '0');
-- ----------------------------
-- Table structure for `clam_finance_log`
-- ----------------------------
DROP TABLE IF EXISTS `clam_finance_log`;
CREATE TABLE `clam_finance_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` tinyint(4) NOT NULL,
`num` decimal(32,2) NOT NULL,
`user_id` int(10) NOT NULL,
`from_id` int(10) NOT NULL,
`add_time` int(10) NOT NULL,
`status` tinyint(4) NOT NULL,
`bonus_id` int(10) NOT NULL,
`currency_id` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1621 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_finance_log
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_finance_type`
-- ----------------------------
DROP TABLE IF EXISTS `clam_finance_type`;
CREATE TABLE `clam_finance_type` (
`id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=104 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_finance_type
-- ----------------------------
INSERT INTO `clam_finance_type` VALUES ('100', '用户激活花费');
INSERT INTO `clam_finance_type` VALUES ('1', '推荐奖');
INSERT INTO `clam_finance_type` VALUES ('2', '静态奖励');
INSERT INTO `clam_finance_type` VALUES ('101', '管理员充值');
INSERT INTO `clam_finance_type` VALUES ('102', '管理员扣款');
INSERT INTO `clam_finance_type` VALUES ('103', '用户升级花费');
INSERT INTO `clam_finance_type` VALUES ('3', '对碰奖 ');
INSERT INTO `clam_finance_type` VALUES ('4', '安置奖');
-- ----------------------------
-- Table structure for `clam_leavel`
-- ----------------------------
DROP TABLE IF EXISTS `clam_leavel`;
CREATE TABLE `clam_leavel` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`money` int(10) NOT NULL DEFAULT '0',
`status` tinyint(4) NOT NULL DEFAULT '0',
`start_money1` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money2` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money3` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money4` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money5` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money6` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money7` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money8` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money9` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money10` decimal(32,2) NOT NULL DEFAULT '0.00',
`start_money11` decimal(32,2) NOT NULL DEFAULT '0.00',
`day_max_reward` decimal(32,2) NOT NULL DEFAULT '0.00',
`max_split` decimal(32,2) NOT NULL DEFAULT '0.00',
`only_name` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_leavel
-- ----------------------------
INSERT INTO `clam_leavel` VALUES ('1', '980', '980', '1', '0.00', '0.00', '0.00', '0.00', '980.00', '0.00', '0.00', '100.00', '3500.00', '0.00', '0.00', '784.00', '30.00', '一星会员');
INSERT INTO `clam_leavel` VALUES ('2', '4900', '4900', '1', '0.00', '0.00', '0.00', '0.00', '4900.00', '0.00', '0.00', '600.00', '12600.00', '0.00', '0.00', '3920.00', '210.00', '二星会员');
INSERT INTO `clam_leavel` VALUES ('3', '9800', '9800', '1', '0.00', '0.00', '0.00', '0.00', '9800.00', '0.00', '0.00', '1800.00', '24500.00', '0.00', '0.00', '7480.00', '720.00', '三星会员');
INSERT INTO `clam_leavel` VALUES ('4', 'VP4 8600', '8600', '0', '1000.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '6000.00', '56000.00', '0.00', '0.00', '784.00', '2700.00', '四星会员');
INSERT INTO `clam_leavel` VALUES ('5', 'VP5 25800', '25800', '0', '3000.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '10000.00', '189000.00', '0.00', '0.00', '784.00', '5000.00', '五星会员');
INSERT INTO `clam_leavel` VALUES ('6', 'VP6 43000', '43000', '0', '5000.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '30000.00', '350000.00', '0.00', '0.00', '784.00', '16500.00', '六星会员');
INSERT INTO `clam_leavel` VALUES ('7', '七星会员50000美金', '50000', '0', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '50000.00', '300000.00', '150000.00', '25000.00', '784.00', '30000.00', '七星会员');
-- ----------------------------
-- Table structure for `clam_leavel_ratio`
-- ----------------------------
DROP TABLE IF EXISTS `clam_leavel_ratio`;
CREATE TABLE `clam_leavel_ratio` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`leavel_id` int(10) NOT NULL,
`reward_type` int(10) NOT NULL,
`ratio` decimal(32,4) NOT NULL,
`num` decimal(32,2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_leavel_ratio
-- ----------------------------
INSERT INTO `clam_leavel_ratio` VALUES ('1', '1', '1', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('2', '1', '2', '0.0050', '20.00');
INSERT INTO `clam_leavel_ratio` VALUES ('3', '1', '3', '0.0200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('4', '1', '4', '3.0000', '3.00');
INSERT INTO `clam_leavel_ratio` VALUES ('5', '1', '5', '0.0750', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('6', '1', '6', '0.0200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('7', '1', '7', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('8', '1', '8', '0.1600', '30.00');
INSERT INTO `clam_leavel_ratio` VALUES ('9', '2', '1', '0.1400', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('10', '2', '2', '0.0050', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('11', '2', '3', '0.0400', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('12', '2', '4', '5.0000', '5.00');
INSERT INTO `clam_leavel_ratio` VALUES ('13', '2', '5', '7.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('14', '2', '6', '0.0400', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('15', '2', '7', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('16', '2', '8', '0.1600', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('17', '3', '1', '0.1600', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('18', '3', '2', '0.0050', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('19', '3', '3', '0.0600', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('20', '3', '4', '7.0000', '7.00');
INSERT INTO `clam_leavel_ratio` VALUES ('21', '3', '5', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('22', '3', '6', '0.0600', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('23', '3', '7', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('24', '3', '8', '0.1600', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('25', '4', '1', '0.0800', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('26', '4', '2', '0.0050', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('27', '4', '3', '0.0800', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('28', '4', '4', '9.0000', '9.00');
INSERT INTO `clam_leavel_ratio` VALUES ('29', '4', '5', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('30', '4', '6', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('31', '4', '7', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('32', '4', '8', '0.1600', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('33', '5', '1', '0.0900', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('34', '5', '2', '0.0050', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('35', '5', '3', '0.0900', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('36', '5', '4', '11.0000', '11.00');
INSERT INTO `clam_leavel_ratio` VALUES ('37', '5', '5', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('38', '5', '6', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('39', '5', '7', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('40', '5', '8', '0.1600', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('41', '6', '1', '0.1000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('42', '6', '2', '0.0050', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('43', '6', '3', '0.1000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('44', '6', '4', '13.0000', '13.00');
INSERT INTO `clam_leavel_ratio` VALUES ('45', '6', '5', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('46', '6', '6', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('47', '6', '7', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('48', '6', '8', '0.1600', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('49', '7', '1', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('50', '7', '2', '0.0050', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('51', '7', '3', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('52', '7', '4', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('53', '7', '5', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('54', '7', '6', '0.0000', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('55', '7', '7', '0.1200', '0.00');
INSERT INTO `clam_leavel_ratio` VALUES ('56', '7', '8', '0.1600', '0.00');
-- ----------------------------
-- Table structure for `clam_notice`
-- ----------------------------
DROP TABLE IF EXISTS `clam_notice`;
CREATE TABLE `clam_notice` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`add_time` varchar(32) NOT NULL,
`back_time` varchar(32) NOT NULL,
`add_name` varchar(32) NOT NULL,
`content` text NOT NULL,
`title` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_notice
-- ----------------------------
INSERT INTO `clam_notice` VALUES ('1', '2016-11-11 09:59 ', '2016-09-25 22:33', '不做大哥好多年', '啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊', '精灵家园新微商模式');
-- ----------------------------
-- Table structure for `clam_price`
-- ----------------------------
DROP TABLE IF EXISTS `clam_price`;
CREATE TABLE `clam_price` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`price` decimal(32,2) NOT NULL,
`num` decimal(32,2) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
`all_num` decimal(32,2) NOT NULL DEFAULT '0.00',
`sell_num` decimal(32,2) NOT NULL DEFAULT '0.00',
`buy_num` decimal(32,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=302 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_price
-- ----------------------------
INSERT INTO `clam_price` VALUES ('1', '2.00', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('2', '2.01', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('3', '2.02', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('4', '2.03', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('5', '2.04', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('6', '2.05', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('7', '2.06', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('8', '2.07', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('9', '2.08', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('10', '2.09', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('11', '2.10', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('12', '2.11', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('13', '2.12', '5000.00', '0', '5000.00', '0.00', '5000.00');
INSERT INTO `clam_price` VALUES ('14', '2.13', '5000.00', '0', '5000.00', '0.00', '1204.00');
INSERT INTO `clam_price` VALUES ('15', '2.14', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('16', '2.15', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('17', '2.16', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('18', '2.17', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('19', '2.18', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('20', '2.19', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('21', '2.20', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('22', '2.21', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('23', '2.22', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('24', '2.23', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('25', '2.24', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('26', '2.25', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('27', '2.26', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('28', '2.27', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('29', '2.28', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('30', '2.29', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('31', '2.30', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('32', '2.31', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('33', '2.32', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('34', '2.33', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('35', '2.34', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('36', '2.35', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('37', '2.36', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('38', '2.37', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('39', '2.38', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('40', '2.39', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('41', '2.40', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('42', '2.41', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('43', '2.42', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('44', '2.43', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('45', '2.44', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('46', '2.45', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('47', '2.46', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('48', '2.47', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('49', '2.48', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('50', '2.49', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('51', '2.50', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('52', '2.51', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('53', '2.52', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('54', '2.53', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('55', '2.54', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('56', '2.55', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('57', '2.56', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('58', '2.57', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('59', '2.58', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('60', '2.59', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('61', '2.60', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('62', '2.61', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('63', '2.62', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('64', '2.63', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('65', '2.64', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('66', '2.65', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('67', '2.66', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('68', '2.67', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('69', '2.68', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('70', '2.69', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('71', '2.70', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('72', '2.71', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('73', '2.72', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('74', '2.73', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('75', '2.74', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('76', '2.75', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('77', '2.76', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('78', '2.77', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('79', '2.78', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('80', '2.79', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('81', '2.80', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('82', '2.81', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('83', '2.82', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('84', '2.83', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('85', '2.84', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('86', '2.85', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('87', '2.86', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('88', '2.87', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('89', '2.88', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('90', '2.89', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('91', '2.90', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('92', '2.91', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('93', '2.92', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('94', '2.93', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('95', '2.94', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('96', '2.95', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('97', '2.96', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('98', '2.97', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('99', '2.98', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('100', '2.99', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('101', '3.00', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('102', '3.01', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('103', '3.02', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('104', '3.03', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('105', '3.04', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('106', '3.05', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('107', '3.06', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('108', '3.07', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('109', '3.08', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('110', '3.09', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('111', '3.10', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('112', '3.11', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('113', '3.12', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('114', '3.13', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('115', '3.14', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('116', '3.15', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('117', '3.16', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('118', '3.17', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('119', '3.18', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('120', '3.19', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('121', '3.20', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('122', '3.21', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('123', '3.22', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('124', '3.23', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('125', '3.24', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('126', '3.25', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('127', '3.26', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('128', '3.27', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('129', '3.28', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('130', '3.29', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('131', '3.30', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('132', '3.31', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('133', '3.32', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('134', '3.33', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('135', '3.34', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('136', '3.35', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('137', '3.36', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('138', '3.37', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('139', '3.38', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('140', '3.39', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('141', '3.40', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('142', '3.41', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('143', '3.42', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('144', '3.43', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('145', '3.44', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('146', '3.45', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('147', '3.46', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('148', '3.47', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('149', '3.48', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('150', '3.49', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('151', '3.50', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('152', '3.51', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('153', '3.52', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('154', '3.53', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('155', '3.54', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('156', '3.55', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('157', '3.56', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('158', '3.57', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('159', '3.58', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('160', '3.59', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('161', '3.60', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('162', '3.61', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('163', '3.62', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('164', '3.63', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('165', '3.64', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('166', '3.65', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('167', '3.66', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('168', '3.67', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('169', '3.68', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('170', '3.69', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('171', '3.70', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('172', '3.71', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('173', '3.72', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('174', '3.73', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('175', '3.74', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('176', '3.75', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('177', '3.76', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('178', '3.77', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('179', '3.78', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('180', '3.79', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('181', '3.80', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('182', '3.81', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('183', '3.82', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('184', '3.83', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('185', '3.84', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('186', '3.85', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('187', '3.86', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('188', '3.87', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('189', '3.88', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('190', '3.89', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('191', '3.90', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('192', '3.91', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('193', '3.92', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('194', '3.93', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('195', '3.94', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('196', '3.95', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('197', '3.96', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('198', '3.97', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('199', '3.98', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('200', '3.99', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('201', '4.00', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('202', '4.01', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('203', '4.02', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('204', '4.03', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('205', '4.04', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('206', '4.05', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('207', '4.06', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('208', '4.07', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('209', '4.08', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('210', '4.09', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('211', '4.10', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('212', '4.11', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('213', '4.12', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('214', '4.13', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('215', '4.14', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('216', '4.15', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('217', '4.16', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('218', '4.17', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('219', '4.18', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('220', '4.19', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('221', '4.20', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('222', '4.21', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('223', '4.22', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('224', '4.23', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('225', '4.24', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('226', '4.25', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('227', '4.26', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('228', '4.27', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('229', '4.28', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('230', '4.29', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('231', '4.30', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('232', '4.31', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('233', '4.32', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('234', '4.33', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('235', '4.34', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('236', '4.35', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('237', '4.36', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('238', '4.37', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('239', '4.38', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('240', '4.39', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('241', '4.40', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('242', '4.41', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('243', '4.42', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('244', '4.43', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('245', '4.44', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('246', '4.45', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('247', '4.46', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('248', '4.47', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('249', '4.48', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('250', '4.49', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('251', '4.50', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('252', '4.51', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('253', '4.52', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('254', '4.53', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('255', '4.54', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('256', '4.55', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('257', '4.56', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('258', '4.57', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('259', '4.58', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('260', '4.59', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('261', '4.60', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('262', '4.61', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('263', '4.62', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('264', '4.63', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('265', '4.64', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('266', '4.65', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('267', '4.66', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('268', '4.67', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('269', '4.68', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('270', '4.69', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('271', '4.70', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('272', '4.71', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('273', '4.72', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('274', '4.73', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('275', '4.74', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('276', '4.75', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('277', '4.76', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('278', '4.77', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('279', '4.78', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('280', '4.79', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('281', '4.80', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('282', '4.81', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('283', '4.82', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('284', '4.83', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('285', '4.84', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('286', '4.85', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('287', '4.86', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('288', '4.87', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('289', '4.88', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('290', '4.89', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('291', '4.90', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('292', '4.91', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('293', '4.92', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('294', '4.93', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('295', '4.94', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('296', '4.95', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('297', '4.96', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('298', '4.97', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('299', '4.98', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('300', '4.99', '5000.00', '0', '5000.00', '0.00', '0.00');
INSERT INTO `clam_price` VALUES ('301', '5.00', '5000.00', '0', '5000.00', '0.00', '0.00');
-- ----------------------------
-- Table structure for `clam_recharge_log`
-- ----------------------------
DROP TABLE IF EXISTS `clam_recharge_log`;
CREATE TABLE `clam_recharge_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`admin_id` int(10) NOT NULL,
`num` decimal(32,2) NOT NULL,
`currency_id` int(10) NOT NULL,
`type` varchar(16) NOT NULL,
`add_time` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_recharge_log
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_reg_log`
-- ----------------------------
DROP TABLE IF EXISTS `clam_reg_log`;
CREATE TABLE `clam_reg_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL COMMENT '注册人',
`reg_type` tinyint(10) NOT NULL,
`num` decimal(32,2) NOT NULL,
`reg_id` int(10) NOT NULL COMMENT '被注册用户',
`leavel` tinyint(10) NOT NULL,
`add_time` int(10) NOT NULL,
`type` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_reg_log
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_reward_type`
-- ----------------------------
DROP TABLE IF EXISTS `clam_reward_type`;
CREATE TABLE `clam_reward_type` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(10) NOT NULL,
`type` varchar(10) NOT NULL,
`bonus_type` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_reward_type
-- ----------------------------
INSERT INTO `clam_reward_type` VALUES ('1', '推荐奖', 'ratio', '1');
INSERT INTO `clam_reward_type` VALUES ('3', 'PK奖（对碰奖）', 'ratio', '3');
INSERT INTO `clam_reward_type` VALUES ('2', '静态奖', 'ratio', '2');
-- ----------------------------
-- Table structure for `clam_sell`
-- ----------------------------
DROP TABLE IF EXISTS `clam_sell`;
CREATE TABLE `clam_sell` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sell_id` int(10) NOT NULL,
`buy_id` int(10) NOT NULL,
`num` decimal(32,2) NOT NULL DEFAULT '0.00',
`add_time` int(10) NOT NULL,
`status` tinyint(4) NOT NULL,
`bank_id` int(10) NOT NULL,
`pay_time` int(10) NOT NULL,
`success_time` int(10) NOT NULL,
`currency_id` int(10) NOT NULL,
`buy_time` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_sell
-- ----------------------------
INSERT INTO `clam_sell` VALUES ('17', '209', '0', '250.00', '1513839310', '0', '140', '0', '0', '5', '0');
-- ----------------------------
-- Table structure for `clam_send_log`
-- ----------------------------
DROP TABLE IF EXISTS `clam_send_log`;
CREATE TABLE `clam_send_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`receive_id` int(10) NOT NULL,
`num` decimal(32,2) NOT NULL DEFAULT '0.00',
`add_time` int(10) NOT NULL,
`remark` text NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
`currency_id` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_send_log
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_shop`
-- ----------------------------
DROP TABLE IF EXISTS `clam_shop`;
CREATE TABLE `clam_shop` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`money` decimal(32,2) NOT NULL,
`image` varchar(64) NOT NULL,
`add_time` int(10) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_shop
-- ----------------------------
INSERT INTO `clam_shop` VALUES ('1', '好东西好东西好东西好东西好东西好东西好东西', '110.00', 'sfsf', '0', '-1');
INSERT INTO `clam_shop` VALUES ('2', '001', '200.00', '', '0', '-1');
INSERT INTO `clam_shop` VALUES ('3', '001', '200.00', '/Uploads/2017-10-09/image_1507540899_241668.png', '0', '0');
INSERT INTO `clam_shop` VALUES ('4', '001', '200.00', '/Uploads/2017-10-09/image_1507540934_475045.png', '0', '0');
-- ----------------------------
-- Table structure for `clam_shop_buy`
-- ----------------------------
DROP TABLE IF EXISTS `clam_shop_buy`;
CREATE TABLE `clam_shop_buy` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`num` int(10) NOT NULL,
`price` decimal(32,2) NOT NULL,
`all_price` decimal(32,2) NOT NULL,
`shop_id` int(10) NOT NULL,
`add_time` int(10) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_shop_buy
-- ----------------------------
INSERT INTO `clam_shop_buy` VALUES ('4', '171', '1', '200.00', '200.00', '3', '1507878929', '0');
-- ----------------------------
-- Table structure for `clam_split`
-- ----------------------------
DROP TABLE IF EXISTS `clam_split`;
CREATE TABLE `clam_split` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`num` decimal(32,2) NOT NULL,
`user_id` int(10) NOT NULL,
`currency_id` int(10) NOT NULL,
`add_time` int(10) NOT NULL,
`type` tinyint(4) NOT NULL,
`new_num` decimal(32,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=113 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_split
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_split_log`
-- ----------------------------
DROP TABLE IF EXISTS `clam_split_log`;
CREATE TABLE `clam_split_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`price` decimal(32,2) NOT NULL,
`add_time` int(10) NOT NULL,
`now_price` decimal(32,2) NOT NULL,
`admin_id` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_split_log
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `clam_sys_menu`;
CREATE TABLE `clam_sys_menu` (
`menuID` int(11) NOT NULL AUTO_INCREMENT,
`menuName` varchar(45) NOT NULL COMMENT '菜单名称',
`state` varchar(10) NOT NULL,
`fid` int(11) NOT NULL COMMENT '父级ID',
`url` varchar(100) NOT NULL,
`remark` varchar(45) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`menuID`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 COMMENT='系统菜单';
-- ----------------------------
-- Records of clam_sys_menu
-- ----------------------------
INSERT INTO `clam_sys_menu` VALUES ('5', '系统设置', 'ON', '0', 'SYSTEM', '');
INSERT INTO `clam_sys_menu` VALUES ('6', '权限控制', 'ON', '0', 'RULE', null);
INSERT INTO `clam_sys_menu` VALUES ('36', '菜单管理', 'ON', '5', 'Nav/index', '');
INSERT INTO `clam_sys_menu` VALUES ('41', '权限管理', 'ON', '6', 'Rule/index', null);
INSERT INTO `clam_sys_menu` VALUES ('42', '用户组管理', 'ON', '6', 'Rule/group', null);
INSERT INTO `clam_sys_menu` VALUES ('43', '管理员列表', 'ON', '6', 'Rule/admin_user_list', null);
INSERT INTO `clam_sys_menu` VALUES ('44', '用户管理', 'ON', '0', 'USER', null);
INSERT INTO `clam_sys_menu` VALUES ('45', '用户列表', 'ON', '44', 'User/showlist', null);
INSERT INTO `clam_sys_menu` VALUES ('47', '日志管理', 'ON', '0', 'FINANCE', null);
INSERT INTO `clam_sys_menu` VALUES ('48', '详细日志', 'ON', '47', 'finance/financeLog', null);
INSERT INTO `clam_sys_menu` VALUES ('49', '统计日志', 'ON', '47', 'finance/bonusLog', null);
INSERT INTO `clam_sys_menu` VALUES ('50', '网站配置', 'ON', '0', 'CONFIG', null);
INSERT INTO `clam_sys_menu` VALUES ('52', '奖金币种分配比例', 'ON', '50', 'Currency/showlist', null);
INSERT INTO `clam_sys_menu` VALUES ('53', '级别配置列表', 'ON', '50', 'Leavel/showlist', null);
INSERT INTO `clam_sys_menu` VALUES ('54', '系统服务', 'ON', '0', 'SERVICE', null);
INSERT INTO `clam_sys_menu` VALUES ('55', '留言列表', 'ON', '54', 'Service/userMessage', null);
INSERT INTO `clam_sys_menu` VALUES ('57', '管理员资金操作', 'ON', '47', 'finance/rechargeLog', null);
INSERT INTO `clam_sys_menu` VALUES ('58', '会员转账列表', 'ON', '47', 'finance/sendLog', null);
INSERT INTO `clam_sys_menu` VALUES ('59', '资金转换列表', 'ON', '47', 'finance/changeLog', null);
INSERT INTO `clam_sys_menu` VALUES ('60', '基本交易管理', 'ON', '0', 'SELL', null);
INSERT INTO `clam_sys_menu` VALUES ('61', '交易列表', 'OFF', '60', 'Sell/sellLog', null);
INSERT INTO `clam_sys_menu` VALUES ('66', '交易盘控制', 'ON', '0', 'TRADE', null);
INSERT INTO `clam_sys_menu` VALUES ('67', '买单列表', 'ON', '66', 'Trade/tradeBuyLog', null);
INSERT INTO `clam_sys_menu` VALUES ('68', '卖单列表', 'ON', '66', 'Trade/tradeSellLog', null);
INSERT INTO `clam_sys_menu` VALUES ('69', '迪卡蒂股管理', 'ON', '0', 'PRICE', null);
INSERT INTO `clam_sys_menu` VALUES ('70', '迪卡蒂股价格', 'ON', '69', 'Price/priceLog', null);
INSERT INTO `clam_sys_menu` VALUES ('71', '拆分管理', 'ON', '69', 'Price/splitLog', null);
INSERT INTO `clam_sys_menu` VALUES ('72', '拆分日志', 'ON', '69', 'Price/splitLoglist', null);
INSERT INTO `clam_sys_menu` VALUES ('73', '用户拆分日志', 'ON', '69', 'Price/userSplitLog', null);
INSERT INTO `clam_sys_menu` VALUES ('74', '商城管理', 'ON', '0', 'SHOP', null);
INSERT INTO `clam_sys_menu` VALUES ('75', '商城商品管理', 'ON', '74', 'Shop/shoplist', null);
INSERT INTO `clam_sys_menu` VALUES ('76', '用户购买记录', 'ON', '74', 'Shop/shopBuyLog', null);
INSERT INTO `clam_sys_menu` VALUES ('77', '上传文件列表', 'ON', '54', 'Service/uploadLog', null);
INSERT INTO `clam_sys_menu` VALUES ('79', '配置参数', 'OFF', '50', 'Config/configlog', null);
INSERT INTO `clam_sys_menu` VALUES ('80', '配置参数', 'ON', '50', 'Config/configlog', '');
-- ----------------------------
-- Table structure for `clam_sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `clam_sys_user`;
CREATE TABLE `clam_sys_user` (
`userID` int(11) NOT NULL AUTO_INCREMENT,
`createTime` datetime NOT NULL,
`state` varchar(10) NOT NULL,
`userName` varchar(45) NOT NULL COMMENT '用户名',
`pwd` varchar(45) NOT NULL COMMENT '密码',
`groupID` int(10) unsigned NOT NULL COMMENT '权限组ID',
`name` varchar(45) DEFAULT NULL COMMENT '真是姓名',
PRIMARY KEY (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='系统后台用户表';
-- ----------------------------
-- Records of clam_sys_user
-- ----------------------------
INSERT INTO `clam_sys_user` VALUES ('1', '0000-00-00 00:00:00', 'ON', 'admin', 'fdb811c4d49ce70c8393d012fd58a710', '0', '123');
INSERT INTO `clam_sys_user` VALUES ('2', '0000-00-00 00:00:00', 'ON', '124', '39bb31e3ce8f03351576d9dc49b9bf7e', '0', '123');
INSERT INTO `clam_sys_user` VALUES ('3', '0000-00-00 00:00:00', '', '123', '429caa60d5c0ea0c02edd9d62377b63d', '0', '213');
INSERT INTO `clam_sys_user` VALUES ('4', '0000-00-00 00:00:00', '', '15', '429caa60d5c0ea0c02edd9d62377b63d', '0', '213');
-- ----------------------------
-- Table structure for `clam_trade_buy`
-- ----------------------------
DROP TABLE IF EXISTS `clam_trade_buy`;
CREATE TABLE `clam_trade_buy` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`price` decimal(32,2) NOT NULL,
`user_id` int(10) NOT NULL,
`num` decimal(32,2) NOT NULL,
`add_time` int(10) NOT NULL,
`status` tinyint(4) NOT NULL,
`surplus_num` decimal(32,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=162 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_trade_buy
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_trade_deal`
-- ----------------------------
DROP TABLE IF EXISTS `clam_trade_deal`;
CREATE TABLE `clam_trade_deal` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sell_id` int(11) NOT NULL,
`buy_id` int(11) NOT NULL,
`num` decimal(32,2) NOT NULL DEFAULT '0.00',
`add_time` int(10) NOT NULL,
`price` decimal(32,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_trade_deal
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_trade_sell`
-- ----------------------------
DROP TABLE IF EXISTS `clam_trade_sell`;
CREATE TABLE `clam_trade_sell` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`num` decimal(32,2) NOT NULL,
`add_time` int(10) NOT NULL,
`price` decimal(32,2) NOT NULL,
`status` tinyint(4) NOT NULL,
`surplus_num` decimal(32,2) NOT NULL DEFAULT '0.00' COMMENT '剩余金额',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_trade_sell
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_upload`
-- ----------------------------
DROP TABLE IF EXISTS `clam_upload`;
CREATE TABLE `clam_upload` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(32) NOT NULL,
`url` varchar(64) NOT NULL,
`add_time` int(10) NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_upload
-- ----------------------------
INSERT INTO `clam_upload` VALUES ('2', '万网', '/Uploads/2017-10-11/upload15910.docx', '1507709894', '0');
-- ----------------------------
-- Table structure for `clam_user`
-- ----------------------------
DROP TABLE IF EXISTS `clam_user`;
CREATE TABLE `clam_user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(32) NOT NULL,
`password` varchar(64) NOT NULL,
`twopassword` varchar(64) NOT NULL,
`realname` varchar(32) NOT NULL,
`phone` varchar(18) NOT NULL,
`email` varchar(32) NOT NULL,
`idcard` varchar(22) NOT NULL,
`address` varchar(128) NOT NULL,
`wechat` varchar(32) NOT NULL,
`qq` varchar(13) NOT NULL,
`sex` tinyint(4) NOT NULL DEFAULT '1',
`tel` varchar(18) NOT NULL,
`tui_id` int(11) NOT NULL,
`jie_id` int(11) NOT NULL,
`center_id` int(11) NOT NULL,
`quyu` tinyint(4) NOT NULL,
`leavel` tinyint(4) NOT NULL DEFAULT '0',
`all_yeji1` decimal(32,0) NOT NULL DEFAULT '0',
`all_yeji2` decimal(32,0) NOT NULL DEFAULT '0',
`all_yeji3` decimal(32,0) NOT NULL DEFAULT '0',
`yeji1` decimal(32,0) NOT NULL DEFAULT '0',
`yeji2` decimal(32,0) NOT NULL DEFAULT '0',
`yeji3` decimal(32,0) NOT NULL DEFAULT '0',
`reg_time` int(11) NOT NULL,
`ip` varchar(18) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
`honor_leavel` tinyint(4) NOT NULL DEFAULT '0',
`lock` tinyint(4) NOT NULL DEFAULT '0',
`country` tinyint(4) NOT NULL DEFAULT '0' COMMENT '城市',
`city` varchar(32) NOT NULL DEFAULT '' COMMENT '市',
`state` varchar(32) NOT NULL DEFAULT '' COMMENT '省',
`btc_url` varchar(64) DEFAULT NULL,
`ltc_url` varchar(64) DEFAULT NULL,
`zhifubao` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=218 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_user
-- ----------------------------
INSERT INTO `clam_user` VALUES ('1', 'admin', '8467d5577169a7a0fe8d31a1d4c8c783', '724738d141b31c4d3b61ff81b28b8edf', '系统管理', '22', '55', '11', '666', '33', '44', '1', '', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '127.0.0.1', '2', '2', '0', '1', '777', '888', null, null, '123');
-- ----------------------------
-- Table structure for `clam_user_bank`
-- ----------------------------
DROP TABLE IF EXISTS `clam_user_bank`;
CREATE TABLE `clam_user_bank` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`type` tinyint(4) NOT NULL,
`card` varchar(32) NOT NULL,
`realname` varchar(32) NOT NULL,
`address` varchar(128) NOT NULL,
`remark` varchar(128) NOT NULL,
`add_time` int(10) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=149 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_user_bank
-- ----------------------------
INSERT INTO `clam_user_bank` VALUES ('1', '1', '3', 'asdasd', '宝塔镇河妖', '', 'asdasd', '1505903000', '0');
-- ----------------------------
-- Table structure for `clam_user_message`
-- ----------------------------
DROP TABLE IF EXISTS `clam_user_message`;
CREATE TABLE `clam_user_message` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL,
`sendee_id` int(10) DEFAULT NULL COMMENT '接收人id',
`title` varchar(64) NOT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0',
`add_time` int(11) NOT NULL,
`status` tinyint(4) NOT NULL,
`content` text NOT NULL,
`fid` int(10) NOT NULL DEFAULT '0',
`read_status` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_user_message
-- ----------------------------
-- ----------------------------
-- Table structure for `clam_user_money`
-- ----------------------------
DROP TABLE IF EXISTS `clam_user_money`;
CREATE TABLE `clam_user_money` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`currency_id` int(10) NOT NULL,
`user_id` int(10) NOT NULL,
`num` decimal(32,2) NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1574 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of clam_user_money
-- ----------------------------
INSERT INTO `clam_user_money` VALUES ('1', '1', '1', '90827.20', '0');
INSERT INTO `clam_user_money` VALUES ('2', '2', '1', '117.60', '0');
INSERT INTO `clam_user_money` VALUES ('3', '3', '1', '0.00', '0');
INSERT INTO `clam_user_money` VALUES ('4', '4', '1', '0.00', '0');
INSERT INTO `clam_user_money` VALUES ('5', '5', '1', '0.00', '0');
INSERT INTO `clam_user_money` VALUES ('6', '6', '1', '39.20', '0');
INSERT INTO `clam_user_money` VALUES ('7', '7', '1', '0.00', '0');
INSERT INTO `clam_user_money` VALUES ('8', '8', '1', '0.00', '0');
INSERT INTO `clam_user_money` VALUES ('9', '9', '1', '0.00', '0');
INSERT INTO `clam_user_money` VALUES ('10', '10', '1', '0.00', '0');
INSERT INTO `clam_user_money` VALUES ('11', '11', '1', '0.00', '0');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手