存档

2015年6月 的存档

dnspod怎么可以添加多个a记录?

2015年6月26日 没有评论

dnspod怎么可以添加多个a记录?很奇怪,于是我问了官方客服,回答很满意。

技术支持 – bluze

2015-06-26 10:25:39
您好,是的,如果您开启了我们的D监控功能的话,我们的监控会自动帮您把有问题的IP切掉,用户访问到另外一个正常的IP上。
当故障IP恢复了,我们的监控再自动帮您切换回来。
D监控开启及使用方法请见:https://support.dnspod.cn/Kb/showarticle/tsid/16
如您还有疑问,请您在24小时内答复该工单;若该工单长时间无应答,系统将自动关闭该工单哦。
感谢您对DNSPod的支持和信赖~

先生

2015-06-26 10:16:12
那如果其中一个IP的服务器挂了,这个时候刚好随机到这个挂的IP服务器上,岂不是访问不了?

技术支持 – bluze

2015-06-26 10:14:14
您好,这个是负载均衡功能了,您可以一个域名同时指向到2个服务器ip,用户随机访问这2个服务器ip中的一个,这样可以让服务器分摊流量。
保证服务器运行的稳定性。
如您还有疑问,请您在24小时内答复该工单;若该工单长时间无应答,系统将自动关闭该工单哦。
感谢您对DNSPod的支持和信赖~

先生

2015-06-26 10:10:38
请问我在域名上添加了2个A记录www,线路都是默认,比如一个指定到8.8.8.8,还有一个指定到4.4.4.4,这个时候有什么区别?
分类: 张宏良张洪量 标签:

mysql快速导入超大sql文件的解决办法

2015年6月1日 没有评论

很简单,使用官方的mysql-workbench-community软件可以解决超大sql文件导入很慢的问题。

之前有一个大概1亿多条的数据,保存的是sql文件,这次用到的时候,用Navicat for MySQL或者mysql source命令导入都非常慢,到了5、6个小时,最后还挂掉了。

没办法,百度了很多帖子,最后尝试了一个方案,终于解决了,1亿多条的数据终于导入完毕,耗时45分钟。

如果你正在寻找mysql导入超大sql文件的快速方法,请使用mysql官方的数据库管理软件(mysql-workbench-community),类似:Navicat for MySQL

之前建立的一个mysql数据库设计

2015年6月1日 没有评论

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50532
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50532
File Encoding         : 65001

Date: 2015-06-01 14:03:54
*/

SET FOREIGN_KEY_CHECKS=0;

— —————————-
— Table structure for a_admin
— —————————-
DROP TABLE IF EXISTS `a_admin`;
CREATE TABLE `a_admin` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`username` char(20) NOT NULL,
`userpwd` char(32) NOT NULL,
`isclosed` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`truename` varchar(10) NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for a_app_version
— —————————-
DROP TABLE IF EXISTS `a_app_version`;
CREATE TABLE `a_app_version` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`version` char(30) NOT NULL,
`content` varchar(4000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for a_hd_adsmake
— —————————-
DROP TABLE IF EXISTS `a_hd_adsmake`;
CREATE TABLE `a_hd_adsmake` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`isclosed` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`makeprice` decimal(5,2) unsigned NOT NULL DEFAULT ‘0.00’ COMMENT ‘广告制作活动价格’,
`descurl` varchar(255) NOT NULL COMMENT ‘活动说明链接’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for a_news_all
— —————————-
DROP TABLE IF EXISTS `a_news_all`;
CREATE TABLE `a_news_all` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`description` varchar(200) NOT NULL,
`content` text NOT NULL,
`posttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`isclosed` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`website_view` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`website_hot` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`shangjia_view` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`shangjia_hot` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`app_view` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`app_notify` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘是否主动通知用户’,
`listshow` tinyint(1) unsigned NOT NULL DEFAULT ‘1’ COMMENT ‘是否列表显示’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_ads_make
— —————————-
DROP TABLE IF EXISTS `s_ads_make`;
CREATE TABLE `s_ads_make` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`ournumber` bigint(18) unsigned NOT NULL DEFAULT ‘0’,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘商家id’,
`posttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘制作时间’,
`price` decimal(5,2) unsigned NOT NULL DEFAULT ‘0.00’ COMMENT ‘广告制作价格’,
`attached` char(42) NOT NULL DEFAULT ” COMMENT ‘商家上传附件’,
`attachedsize` mediumint(7) unsigned NOT NULL DEFAULT ‘0’,
`attached_ext` varchar(4) NOT NULL DEFAULT ” COMMENT ‘附件拓展名’,
`yaoqiu` varchar(4000) NOT NULL DEFAULT ” COMMENT ‘商家制作要求’,
`huodongid` smallint(5) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘参加活动_news_all_id’,
`status` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘0确认中,1制作中,2完毕’,
`finishtime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`pic` char(42) NOT NULL DEFAULT ” COMMENT ‘完成的图片路径’,
PRIMARY KEY (`id`),
UNIQUE KEY `ournumber` (`ournumber`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_ads_one
— —————————-
DROP TABLE IF EXISTS `s_ads_one`;
CREATE TABLE `s_ads_one` (
`id` int(9) unsigned NOT NULL,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`question` varchar(255) NOT NULL COMMENT ‘问题’,
`answer` varchar(800) NOT NULL COMMENT ‘回答选项连接后字符串’,
`rightanswer` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘正确答案’,
`pic` char(42) NOT NULL COMMENT ‘图片’,
`yue` decimal(8,3) unsigned NOT NULL DEFAULT ‘0.000’ COMMENT ‘余额’,
`provinceid` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘发布区域-省’,
`cityid` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘发布区域-城市’,
`status` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘0默认,1通过,2未通过,3暂停,4终止,5已删除,6管理员强制终止’,
`unitprice` decimal(5,3) unsigned NOT NULL DEFAULT ‘0.000’ COMMENT ‘广告访问单次价格’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘发布时间’,
`lastvisittime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`xingbie` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘0不限,1男,2女’,
`hunfou` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘0不限,1已婚,2未婚’,
`age_start` tinyint(2) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘年龄起始’,
`age_end` tinyint(2) unsigned NOT NULL DEFAULT ‘100’,
`zhiye` tinyint(2) unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`id`),
KEY `provinceid_cityid` (`provinceid`,`cityid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_ads_two
— —————————-
DROP TABLE IF EXISTS `s_ads_two`;
CREATE TABLE `s_ads_two` (
`id` int(9) unsigned NOT NULL,
`picsize` mediumint(6) unsigned NOT NULL DEFAULT ‘0’,
`yusuan` mediumint(6) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘预算’,
`passtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘通过审核时间’,
`stoptime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`notpassreason` varchar(255) NOT NULL DEFAULT ”,
`stophaveback` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘已经退款’,
`stopbackmoney` decimal(9,3) unsigned NOT NULL DEFAULT ‘0.000’ COMMENT ‘终止返还金额’,
`youhuima` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘是否使用优惠码’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_ads_visit
— —————————-
DROP TABLE IF EXISTS `s_ads_visit`;
CREATE TABLE `s_ads_visit` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘用户uid’,
`ymd` mediumint(6) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘请求年月日:131212’,
`suid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘商家uid’,
`adsid` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘广告id’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘请求时间’,
`phone` bigint(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘用户手机号码’,
`androiduid` char(16) NOT NULL DEFAULT ” COMMENT ‘android识别号’,
`provinceid` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘省份id’,
`cityid` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘城市id’,
`status` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘0未答,1已答,2未答已退’,
`unitprice` decimal(4,3) unsigned NOT NULL DEFAULT ‘0.000’ COMMENT ‘商家扣除单价,和s_ads_one同步’,
`u_addprice` decimal(3,2) unsigned NOT NULL DEFAULT ‘0.00’ COMMENT ‘用户访问实际单价’,
`sequence` char(15) NOT NULL DEFAULT ” COMMENT ‘用户回答顺序’,
`xinghao` varchar(80) NOT NULL DEFAULT ” COMMENT ‘手机型号’,
`ip` int(11) unsigned NOT NULL DEFAULT ‘0’,
`needrightn` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘需要回答正确的选项n’,
`answertime` int(11) unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`id`),
KEY `adsid` (`adsid`),
KEY `uid_ymd` (`uid`,`ymd`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_ads_youhuima
— —————————-
DROP TABLE IF EXISTS `s_ads_youhuima`;
CREATE TABLE `s_ads_youhuima` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘绑定的商家uid’,
`money` smallint(5) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘优惠码价值’,
`code` char(16) NOT NULL COMMENT ‘优惠码’,
`expiredtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘过期时间’,
`usedtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘使用时间’,
`relation_adsid` int(9) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘相关adsid’,
PRIMARY KEY (`id`),
UNIQUE KEY `uid_code` (`uid`,`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_loginlog
— —————————-
DROP TABLE IF EXISTS `s_loginlog`;
CREATE TABLE `s_loginlog` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`ip` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘登录ip’,
`posttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘登录时间’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_member
— —————————-
DROP TABLE IF EXISTS `s_member`;
CREATE TABLE `s_member` (
`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`email` char(35) NOT NULL COMMENT ‘商家邮箱’,
`name` varchar(255) NOT NULL COMMENT ‘商家名称’,
`userpwd` char(32) NOT NULL COMMENT ‘商家pwd’,
`money` decimal(9,2) unsigned NOT NULL DEFAULT ‘0.00’ COMMENT ‘商家资金’,
`isclosed` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`zhekou` tinyint(1) unsigned NOT NULL DEFAULT ‘100’ COMMENT ‘终身折扣等级,如85,默认为100’,
`regip` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘注册ip’,
`regtime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`threepwdtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘三次错误密码锁定时间’,
`editname` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘是否已修改过商家名称(只能修改一次)’,
`profile_verify` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘资料验证’,
`tuser` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘是哪个商家推荐的’,
PRIMARY KEY (`uid`),
UNIQUE KEY `email` (`email`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_money_all
— —————————-
DROP TABLE IF EXISTS `s_money_all`;
CREATE TABLE `s_money_all` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL COMMENT ‘商家uid’,
`money` decimal(9,3) unsigned NOT NULL DEFAULT ‘0.000’ COMMENT ‘金额’,
`posttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘操作时间’,
`mark` varchar(150) NOT NULL COMMENT ‘备注’,
`act` char(3) NOT NULL COMMENT ‘类型,add为增加,cut为消耗’,
`sact` varchar(15) NOT NULL DEFAULT ” COMMENT ‘pay,makeads,postads,stopads,addmoneyads,deleteads,tixian,admin’,
`relationid` int(11) unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_pay
— —————————-
DROP TABLE IF EXISTS `s_pay`;
CREATE TABLE `s_pay` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL COMMENT ‘充值商家id’,
`ournumber` bigint(18) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘本站订单号’,
`othernumber` char(30) NOT NULL DEFAULT ” COMMENT ‘支付宝,财付通,银行(订单号)’,
`money` mediumint(6) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘充值金额’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘充值请求时间’,
`bankname` varchar(10) NOT NULL DEFAULT ” COMMENT ‘银行名称,支付宝,财付通(全英文)’,
`finishtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘充值完成时间’,
PRIMARY KEY (`id`),
UNIQUE KEY `ournumber` (`ournumber`),
KEY `uid` (`uid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_pwdemail
— —————————-
DROP TABLE IF EXISTS `s_pwdemail`;
CREATE TABLE `s_pwdemail` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`hash` bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘密钥’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘请求时间’,
`usedtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘使用时间’,
UNIQUE KEY `uid_hash` (`uid`,`hash`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_tixian
— —————————-
DROP TABLE IF EXISTS `s_tixian`;
CREATE TABLE `s_tixian` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL COMMENT ‘商家uid’,
`money` decimal(9,2) unsigned NOT NULL DEFAULT ‘0.00’ COMMENT ‘商家提现金额’,
`goodmoney` decimal(9,2) unsigned NOT NULL COMMENT ‘实际应付金额’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘请求时间’,
`bankname` varchar(15) NOT NULL COMMENT ‘银行名称、支付宝、财付通’,
`cardnumber` varchar(30) NOT NULL COMMENT ‘银行卡号,支付宝,财付通账号’,
`truename` varchar(15) NOT NULL COMMENT ‘开户名称’,
`finishtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘完成提现时间’,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for s_verify
— —————————-
DROP TABLE IF EXISTS `s_verify`;
CREATE TABLE `s_verify` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`posttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘请求时间’,
`notpass_time` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘使用时间’,
`status` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘0是待审核,1已通过,2未通过,3回收站’,
`notpass_reason` varchar(255) NOT NULL DEFAULT ”,
`notpass_n` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘未通过次数’,
`verify_type` tinyint(1) unsigned NOT NULL DEFAULT ‘1’ COMMENT ‘1为企业,2为普通商家’,
`content` varchar(4000) NOT NULL DEFAULT ”,
`yyzz` char(42) NOT NULL DEFAULT ”,
`sfz` char(42) NOT NULL DEFAULT ”,
`sname` varchar(255) NOT NULL DEFAULT ” COMMENT ‘商家名称’,
`lianxi` char(13) NOT NULL DEFAULT ”,
`address` varchar(255) NOT NULL DEFAULT ”,
PRIMARY KEY (`id`),
UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_choujiang_for
— —————————-
DROP TABLE IF EXISTS `u_choujiang_for`;
CREATE TABLE `u_choujiang_for` (
`id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`microtime` bigint(20) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘time’,
`money` decimal(4,2) unsigned NOT NULL DEFAULT ‘0.00’,
`isused` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`nums` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘共被抽次数’,
PRIMARY KEY (`id`),
UNIQUE KEY `microtime` (`microtime`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_choujiang_log
— —————————-
DROP TABLE IF EXISTS `u_choujiang_log`;
CREATE TABLE `u_choujiang_log` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘用户uid’,
`ymd` mediumint(6) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘请求年月日:131212’,
`posttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`money` decimal(4,2) unsigned NOT NULL DEFAULT ‘0.00’,
KEY `uid_ymd` (`uid`,`ymd`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_choujiang_ymd
— —————————-
DROP TABLE IF EXISTS `u_choujiang_ymd`;
CREATE TABLE `u_choujiang_ymd` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘用户uid’,
`ymd` mediumint(6) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘请求年月日:131212’,
`nums` tinyint(2) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘抽奖次数’,
KEY `uid` (`uid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_login_log
— —————————-
DROP TABLE IF EXISTS `u_login_log`;
CREATE TABLE `u_login_log` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘登录时间’,
`androiduid` char(16) NOT NULL DEFAULT ” COMMENT ‘android识别号’,
`ip` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘ip’,
`xinghao` char(80) NOT NULL DEFAULT ”,
KEY `androiduid` (`androiduid`) USING BTREE,
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_member
— —————————-
DROP TABLE IF EXISTS `u_member`;
CREATE TABLE `u_member` (
`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`phone` bigint(11) unsigned NOT NULL DEFAULT ‘0’,
`userpwd` char(32) NOT NULL,
`addmoney` decimal(7,2) unsigned NOT NULL DEFAULT ‘0.00’,
`cutmoney` decimal(7,2) unsigned NOT NULL DEFAULT ‘0.00’,
`isclosed` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`provinceid` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`cityid` smallint(1) NOT NULL DEFAULT ‘0’,
`inviteuid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘邀请人ID’,
`registtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘注册时间’,
`first_tixian` tinyint(1) unsigned NOT NULL DEFAULT ‘1’ COMMENT ‘是否是第一次提现’,
`yaoqingma` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘uid的邀请码’,
`closedwhy` varchar(150) NOT NULL DEFAULT ”,
`sms_pass` tinyint(1) unsigned NOT NULL DEFAULT ‘0’,
`shibiema` char(32) NOT NULL DEFAULT ”,
`androiduid` char(16) NOT NULL DEFAULT ”,
`profile_perfect` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘是否完善资料’,
PRIMARY KEY (`uid`),
UNIQUE KEY `phone` (`phone`) USING BTREE,
UNIQUE KEY `androiduid` (`androiduid`),
KEY `inviteuid` (`inviteuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_money_friend
— —————————-
DROP TABLE IF EXISTS `u_money_friend`;
CREATE TABLE `u_money_friend` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘所属用户uid’,
`phone` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘uid邀请的phone(省略中间4位)’,
`phone_uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘手机号码的uid(uid推荐phone_uid)’,
`money` decimal(4,2) unsigned NOT NULL DEFAULT ‘0.00’ COMMENT ‘共为uid赚的钱(不超过5元)’,
PRIMARY KEY (`id`),
KEY `uid_phone_uid` (`uid`,`phone_uid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_money_ymd
— —————————-
DROP TABLE IF EXISTS `u_money_ymd`;
CREATE TABLE `u_money_ymd` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`ymd` mediumint(6) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘用户当天赚钱日期:131212’,
`tumoney` decimal(4,2) unsigned NOT NULL DEFAULT ‘0.00’ COMMENT ‘当天看图总赚钱’,
`tu_nums` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`friend_nums` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘好看看图的数量(单价在php中)’,
`friend_update` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘是否已更新好友’,
PRIMARY KEY (`id`),
UNIQUE KEY `uid_ymd` (`uid`,`ymd`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_profile
— —————————-
DROP TABLE IF EXISTS `u_profile`;
CREATE TABLE `u_profile` (
`uid` mediumint(8) unsigned NOT NULL,
`xingbie` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘0未填,1男,2女’,
`year` smallint(4) unsigned NOT NULL DEFAULT ‘0’,
`month` tinyint(2) unsigned NOT NULL DEFAULT ‘0’,
`hunfou` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘婚否’,
`zhiye` tinyint(2) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘职业’,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_pwd_sms
— —————————-
DROP TABLE IF EXISTS `u_pwd_sms`;
CREATE TABLE `u_pwd_sms` (
`phone` bigint(11) unsigned NOT NULL DEFAULT ‘0’,
`androiduid` char(16) NOT NULL DEFAULT ” COMMENT ‘发送手机识别码’,
`hash` mediumint(6) unsigned NOT NULL DEFAULT ‘0’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`usedtime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`ip` int(11) unsigned NOT NULL DEFAULT ‘0’,
KEY `androiduid` (`androiduid`) USING BTREE,
KEY `phone` (`phone`),
KEY `hash` (`hash`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_regist_log
— —————————-
DROP TABLE IF EXISTS `u_regist_log`;
CREATE TABLE `u_regist_log` (
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘登录时间’,
`androiduid` char(16) NOT NULL DEFAULT ” COMMENT ‘android识别号’,
`ip` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘ip’,
`xinghao` varchar(80) NOT NULL DEFAULT ”,
KEY `androiduid` (`androiduid`) USING BTREE,
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_regist_sms
— —————————-
DROP TABLE IF EXISTS `u_regist_sms`;
CREATE TABLE `u_regist_sms` (
`phone` bigint(11) unsigned NOT NULL DEFAULT ‘0’,
`androiduid` char(16) NOT NULL DEFAULT ” COMMENT ‘发送手机识别码’,
`hash` mediumint(6) unsigned NOT NULL DEFAULT ‘0’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`usedtime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`ip` int(11) unsigned NOT NULL DEFAULT ‘0’,
KEY `ip` (`ip`) USING BTREE,
KEY `hash` (`hash`),
KEY `androiduid` (`androiduid`) USING BTREE,
KEY `phone` (`phone`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_shoucang
— —————————-
DROP TABLE IF EXISTS `u_shoucang`;
CREATE TABLE `u_shoucang` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL,
`adsid` int(9) unsigned NOT NULL COMMENT ‘商家uid’,
`adspic` char(42) NOT NULL COMMENT ‘收藏的图片pic’,
`ads_posttime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘广告发布时间(用于adsid配合调取商家信息)’,
PRIMARY KEY (`id`),
UNIQUE KEY `uid` (`uid`,`adsid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_sms
— —————————-
DROP TABLE IF EXISTS `u_sms`;
CREATE TABLE `u_sms` (
`phone` bigint(11) unsigned NOT NULL DEFAULT ‘0’,
`posttime` int(11) unsigned NOT NULL DEFAULT ‘0’,
`type` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘1为注册,2为找回密码’,
`isused` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘是否已经使用’,
KEY `phone` (`phone`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_tixian
— —————————-
DROP TABLE IF EXISTS `u_tixian`;
CREATE TABLE `u_tixian` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘用户uid’,
`phone` bigint(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘用户phone’,
`bankname` varchar(15) NOT NULL COMMENT ‘手机话费,Q币,银行名称,支付宝,财付通’,
`cardnumber` varchar(35) NOT NULL COMMENT ‘手机号码,QQ号码,卡号,支付宝号,财付通号’,
`truename` varchar(20) NOT NULL COMMENT ‘真实姓名’,
`posttime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`finishtime` int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘处理时间’,
`shidaomoney` mediumint(6) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘实际到账金额’,
`money` mediumint(6) unsigned NOT NULL DEFAULT ‘0’,
`failreason` varchar(150) NOT NULL DEFAULT ” COMMENT ‘失败原因’,
`fail_back` tinyint(1) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘失败已退还至用户账户’,
`posttime_int` int(11) unsigned NOT NULL DEFAULT ‘0’,
`dengdai_n` mediumint(8) unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`id`),
KEY `phone` (`phone`) USING BTREE,
KEY `dengdai_n` (`dengdai_n`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

— —————————-
— Table structure for u_tixian_badcard
— —————————-
DROP TABLE IF EXISTS `u_tixian_badcard`;
CREATE TABLE `u_tixian_badcard` (
`cardnumber` varchar(35) NOT NULL COMMENT ‘手机号码,QQ号码,卡号,支付宝号,财付通号’,
UNIQUE KEY `cardnumber` (`cardnumber`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

分类: mysql优化 标签: ,
css.php