-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.sql
132 lines (101 loc) · 5.84 KB
/
db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: 127.0.0.1 (MySQL 5.6.19-1~exp1ubuntu2)
# Database: api
# Generation Time: 2015-07-31 03:51:41 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table api
# ------------------------------------------------------------
DROP TABLE IF EXISTS `api`;
CREATE TABLE `api` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '接口编号',
`aid` int(11) DEFAULT '0' COMMENT '接口分类id',
`num` varchar(100) DEFAULT NULL COMMENT '接口编号',
`url` varchar(240) DEFAULT NULL COMMENT '请求地址',
`name` varchar(100) DEFAULT NULL COMMENT '接口名',
`des` varchar(300) DEFAULT NULL COMMENT '接口描述',
`parameter` text COMMENT '请求参数{所有的主求参数,以json格式在此存放}',
`memo` text COMMENT '备注',
`re` text COMMENT '返回值',
`lasttime` int(11) unsigned DEFAULT NULL COMMENT '提后操作时间',
`lastuid` int(11) unsigned DEFAULT NULL COMMENT '最后修改uid',
`isdel` tinyint(4) unsigned DEFAULT '0' COMMENT '{0:正常,1:删除}',
`type` char(11) DEFAULT NULL COMMENT '请求方式',
`ord` int(11) DEFAULT '0' COMMENT '排序(值越大,越靠前)',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='接口明细表';
LOCK TABLES `api` WRITE;
/*!40000 ALTER TABLE `api` DISABLE KEYS */;
INSERT INTO `api` (`id`, `aid`, `num`, `url`, `name`, `des`, `parameter`, `memo`, `re`, `lasttime`, `lastuid`, `isdel`, `type`, `ord`)
VALUES
(1,2,'000','http://api.xxx.com','会员注册','会员注册调用此接口','a:4:{s:4:\"name\";a:3:{i:0;s:10:\"login_name\";i:1;s:8:\"password\";i:2;s:5:\"email\";}s:4:\"type\";a:3:{i:0;s:1:\"Y\";i:1;s:1:\"Y\";i:2;s:1:\"N\";}s:7:\"default\";a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:0:\"\";}s:3:\"des\";a:3:{i:0;s:9:\"登录名\";i:1;s:6:\"密码\";i:2;s:12:\"用户邮箱\";}}','','{\r\n "status": 1, \r\n "info": "注册成功", \r\n "data": {\r\n "uid": "20"\r\n }\r\n}',1435588983,1,0,'POST',0),
(2,2,'001','http://api.xxx.com','会员登录','会员登录调用此接口','a:4:{s:4:\"name\";a:3:{i:0;s:10:\"login_name\";i:1;s:5:\"email\";i:2;s:8:\"password\";}s:4:\"type\";a:3:{i:0;s:1:\"Y\";i:1;s:1:\"Y\";i:2;s:1:\"Y\";}s:7:\"default\";a:3:{i:0;s:0:\"\";i:1;s:0:\"\";i:2;s:0:\"\";}s:3:\"des\";a:3:{i:0;s:30:\"登录名与邮箱二选其一\";i:1;s:30:\"邮箱与登录名二选其一\";i:2;s:6:\"密码\";}}','login_name 与 email 二选其一','{\r\n "status": 1, \r\n "info": "登录成功", \r\n "data": [ ]\r\n}',1435576729,2,0,'POST',0);
/*!40000 ALTER TABLE `api` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table auth
# ------------------------------------------------------------
DROP TABLE IF EXISTS `auth`;
CREATE TABLE `auth` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL COMMENT '用户',
`aid` int(11) DEFAULT NULL COMMENT '接口分类权限',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='权限表 - 若用户为普通管理员时，读此表获取权限';
# Dump of table cate
# ------------------------------------------------------------
DROP TABLE IF EXISTS `cate`;
CREATE TABLE `cate` (
`aid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类id',
`cname` varchar(200) NOT NULL DEFAULT '' COMMENT '分类名称',
`cdesc` varchar(200) NOT NULL DEFAULT '' COMMENT '分类描述',
`isdel` int(11) DEFAULT '0' COMMENT '是否删除{0:正常,1删除}',
`addtime` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='接口分类表';
LOCK TABLES `cate` WRITE;
/*!40000 ALTER TABLE `cate` DISABLE KEYS */;
INSERT INTO `cate` (`aid`, `cname`, `cdesc`, `isdel`, `addtime`)
VALUES
(1,'分类一','第一个测试分类',0,1435575162),
(2,'分类二','第二个测试分类',0,1435575185);
/*!40000 ALTER TABLE `cate` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table user
# ------------------------------------------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`nice_name` char(20) DEFAULT NULL COMMENT '昵称',
`login_name` char(20) DEFAULT NULL COMMENT '登录名',
`last_time` int(11) DEFAULT '0' COMMENT '最近登录时间',
`login_pwd` varchar(32) DEFAULT NULL COMMENT '登录密码',
`isdel` int(11) DEFAULT '0' COMMENT '{0正常,1:删除}',
`issuper` int(11) DEFAULT '0' COMMENT '{0:普通管理员,1超级管理员}',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户表';
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`, `nice_name`, `login_name`, `last_time`, `login_pwd`, `isdel`, `issuper`)
VALUES
(1,'admin','admin',1438314444,'c33367701511b4f6020ec61ded352059',0,1),
(2,'root','root',1435575693,'e10adc3949ba59abbe56e057f20f883e',0,1);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;