存档

文章标签 ‘设计’

网页/移动端交互设计师,招聘需求内容

2016年1月21日 没有评论

网页/移动端交互设计师

能力要求:
1,熟练使用Photoshop,简单了解HTML/CSS/Javascript;
2,三年以上网页产品设计工作经验,并有成功案例;
3,喜爱设计,对设计品质有执着追求,关注细节,善于创新,对设计交付精益求精、苛求完美;
4,主动性高,有持续的热情和责任心,富有创造力和激情,并有动手实践的良好习惯;
5,有大局观,可以在复杂的约束条件下找到平衡或创新的方法;
6,具备良好的审美能力、对视觉设计、色彩有敏锐的分析能力,有较强的平面设计和网页设计能力;
7,对互联网产品有深刻理解,喜欢体验各类互联网产品,具有良好的逻辑思维及表达沟通能力;
8,熟悉WEB网页设计知识,如:交互界面结构、用户操作流程功能分析、界面设计、易用性等;
(具备移动app构建的相关知识,熟悉iOS和Android平台设计规范、有手机移动端设计经验者优先考虑)

岗位职责:
1,分析用户的使用习惯和体验需求,提出设计需求及用户体验目标,给出有效的交互解决方案;
2,负责公司WEB网页、移动app整体风格的定位和视觉设计(包括界面、图标风格与统一规范等);
3,善于学习并掌握当下和未来主流设计趋势,对现有页面进行交互体验评估、规划构思, 提出设计改进方案, 持续优化;
4,主导设计团队对产品整体界面视觉风格、交互设计把控和创意规划,共同完成WEB网页、移动app的设计工作;

还不错的抽奖页面设计

2016年1月7日 没有评论

发现一个还不错的抽奖页面设计,参考参考。下次也许用得着。

还不错的抽奖页面

之前建立的一个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优化 标签: ,

根据要求设计mysql数据库,特简单,但是考验的东西不少。

2015年5月13日 没有评论

设计表:(该表约有2万5千条记录)

id,自动增长,唯一标记
name,记录名称,约存入100个汉字
phone,手机号,存入国内手机号
headimg,头像图片,存入固定长度为42个英文字符
ptype,父类别id,父类别不超过255个
stype,子类别id,子类别不超过255个
ip,注册IP
isclosed,标记是否已屏蔽,存入1或者0

————————–

注意:
前台会经常需要根据id、phone查找信息,包括根据注册IP查找

分类: mysql优化 标签: ,

发2个还不错是设计

2015年5月4日 没有评论

 

坤鼎

新澳美游学

说明:本人转载,版权归设计者。

分类: 张宏良张洪量 标签:
css.php