Skip to content

Commit 9fa8fac

Browse files
yew1ebyew1eb
committed
add stack info
1 parent d1ec30a commit 9fa8fac

109 files changed

Lines changed: 4951 additions & 1 deletion

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎stack-info/.gitignore‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
.idea
2+
target
3+
*.iml
4+
.logs

‎stack-info/.travis.yml‎

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
language: java
2+
jdk:
3+
- oraclejdk8
4+
5+
service_name:
6+
- travis-pro
7+
8+
script:
9+
- mvn clean -U install
10+
11+
after_success:
12+
- mvn clean cobertura:cobertura coveralls:report -DrepoToken=Bss2ibmZGyQ2dPDEK21HALv67CMB8L5Bb

‎stack-info/README.md‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
# stack-info
2+
3+
[![Build Status](https://travis-ci.org/yew1eb/stack-info.svg)](https://travis-ci.org/yew1eb/stack-info)
4+
[![Coverage Status](https://coveralls.io/repos/github/yew1eb/stack-info/badge.svg?branch=master)](https://coveralls.io/github/yew1eb/stack-info?branch=master)
5+
6+
# 依赖框架
7+
Spring Boot
8+
Mybatis
9+
Freemarker
10+
MySQL

‎stack-info/docs/GenerateTestData.sql‎

Lines changed: 30 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,30 @@
1+
USE `stackinfo`;
2+
DROP PROCEDURE IF EXISTS go;
3+
DELIMITER ;;
4+
CREATE PROCEDURE go()
5+
BEGIN
6+
DECLARE i INT;
7+
DECLARE N INT;
8+
DECLARE name VARCHAR(128);
9+
DECLARE age INT;
10+
DECLARE passwd VARCHAR(128);
11+
DECLARE CurTime VARCHAR(128);
12+
DECLARE RandomNum INT;
13+
14+
SET N = 50;
15+
SET i = 1;
16+
WHILE i <= N DO
17+
SET i = i + 1;
18+
SELECT DATE_FORMAT(NOW(), 'HN%Y%m%d%H')
19+
INTO CurTime;
20+
SET name = concat(CurTime, i);
21+
SET age = floor(10 + 80 * rand());
22+
SET RandomNum = floor(1000 + 1000 * rand());
23+
SET passwd = concat(name, RandomNum);
24+
INSERT INTO user (id, name, age, password)
25+
VALUES (i, name, age, passwd);
26+
END WHILE;
27+
END
28+
;;
29+
DELIMITER ;
30+
CALL go();

‎stack-info/docs/stackinfo.sql‎

Lines changed: 273 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,273 @@
1+
-- MySQL dump 10.13 Distrib 5.7.9, for osx10.9 (x86_64)
2+
--
3+
-- Host: localhost Database: stackinfo
4+
-- ------------------------------------------------------
5+
-- Server version 5.5.48
6+
7+
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8+
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9+
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10+
/*!40101 SET NAMES utf8 */;
11+
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12+
/*!40103 SET TIME_ZONE='+00:00' */;
13+
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14+
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15+
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16+
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17+
18+
19+
--
20+
-- Table structure for table `t_activecode`
21+
--
22+
23+
DROP TABLE IF EXISTS `t_activecode`;
24+
/*!40101 SET @saved_cs_client = @@character_set_client */;
25+
/*!40101 SET character_set_client = utf8 */;
26+
CREATE TABLE `t_activecode` (
27+
`id` int(10) NOT NULL AUTO_INCREMENT,
28+
`uid` int(10) NOT NULL,
29+
`code` varchar(64) NOT NULL,
30+
`type` varchar(10) NOT NULL COMMENT 'signup:注册 reset:修改密码',
31+
`is_use` tinyint(2) NOT NULL DEFAULT '0',
32+
`c_time` int(10) NOT NULL COMMENT '创建时间',
33+
KEY `id` (`id`)
34+
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
35+
/*!40101 SET character_set_client = @saved_cs_client */;
36+
37+
--
38+
-- Table structure for table `t_comment`
39+
--
40+
41+
DROP TABLE IF EXISTS `t_comment`;
42+
/*!40101 SET @saved_cs_client = @@character_set_client */;
43+
/*!40101 SET character_set_client = utf8 */;
44+
CREATE TABLE `t_comment` (
45+
`cid` int(10) NOT NULL AUTO_INCREMENT,
46+
`uid` int(10) NOT NULL COMMENT '评论人uid',
47+
`to_uid` int(10) NOT NULL COMMENT '被评论人uid',
48+
`tid` int(10) NOT NULL COMMENT '帖子id',
49+
`content` text CHARACTER SET utf8mb4 NOT NULL COMMENT '评论内容',
50+
`device` varchar(255) DEFAULT 'pc' COMMENT '设备',
51+
`c_time` int(10) NOT NULL COMMENT '评论时间',
52+
PRIMARY KEY (`cid`)
53+
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;
54+
/*!40101 SET character_set_client = @saved_cs_client */;
55+
56+
--
57+
-- Table structure for table `t_favorite`
58+
--
59+
60+
DROP TABLE IF EXISTS `t_favorite`;
61+
/*!40101 SET @saved_cs_client = @@character_set_client */;
62+
/*!40101 SET character_set_client = utf8 */;
63+
CREATE TABLE `t_favorite` (
64+
`id` int(10) NOT NULL AUTO_INCREMENT,
65+
`type` varchar(10) NOT NULL COMMENT 'topic:帖子 node:节点',
66+
`uid` int(10) NOT NULL,
67+
`event_id` int(10) NOT NULL,
68+
`c_time` int(10) NOT NULL,
69+
PRIMARY KEY (`id`)
70+
) ENGINE=MyISAM AUTO_INCREMENT=97 DEFAULT CHARSET=utf8;
71+
/*!40101 SET character_set_client = @saved_cs_client */;
72+
73+
--
74+
-- Table structure for table `t_link`
75+
--
76+
77+
DROP TABLE IF EXISTS `t_link`;
78+
/*!40101 SET @saved_cs_client = @@character_set_client */;
79+
/*!40101 SET character_set_client = utf8 */;
80+
CREATE TABLE `t_link` (
81+
`id` int(10) NOT NULL AUTO_INCREMENT,
82+
`title` varchar(100) DEFAULT NULL,
83+
`url` varchar(100) NOT NULL,
84+
`c_time` int(10) NOT NULL,
85+
PRIMARY KEY (`id`)
86+
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
87+
/*!40101 SET character_set_client = @saved_cs_client */;
88+
89+
--
90+
-- Table structure for table `t_node`
91+
--
92+
93+
DROP TABLE IF EXISTS `t_node`;
94+
/*!40101 SET @saved_cs_client = @@character_set_client */;
95+
/*!40101 SET character_set_client = utf8 */;
96+
CREATE TABLE `t_node` (
97+
`nid` int(10) NOT NULL AUTO_INCREMENT,
98+
`pid` int(10) NOT NULL DEFAULT '0' COMMENT '父节点id',
99+
`title` varchar(30) DEFAULT NULL COMMENT '节点名称',
100+
`description` varchar(255) DEFAULT NULL COMMENT '节点描述',
101+
`slug` varchar(50) NOT NULL COMMENT '节点英文简写',
102+
`pic` varchar(100) DEFAULT NULL COMMENT '节点图片',
103+
`topics` int(10) DEFAULT '0' COMMENT '帖子数',
104+
`c_time` int(10) NOT NULL COMMENT '创建时间',
105+
`u_time` int(10) NOT NULL,
106+
`is_del` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否删除',
107+
PRIMARY KEY (`nid`)
108+
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
109+
/*!40101 SET character_set_client = @saved_cs_client */;
110+
111+
--
112+
-- Table structure for table `t_notice`
113+
--
114+
115+
DROP TABLE IF EXISTS `t_notice`;
116+
/*!40101 SET @saved_cs_client = @@character_set_client */;
117+
/*!40101 SET character_set_client = utf8 */;
118+
CREATE TABLE `t_notice` (
119+
`id` int(10) NOT NULL AUTO_INCREMENT,
120+
`type` varchar(10) NOT NULL,
121+
`uid` int(10) NOT NULL,
122+
`to_uid` int(10) NOT NULL,
123+
`event_id` int(10) NOT NULL,
124+
`is_read` tinyint(1) NOT NULL DEFAULT '0',
125+
`c_time` int(10) NOT NULL,
126+
PRIMARY KEY (`id`)
127+
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
128+
/*!40101 SET character_set_client = @saved_cs_client */;
129+
130+
--
131+
-- Table structure for table `t_openid`
132+
--
133+
134+
DROP TABLE IF EXISTS `t_openid`;
135+
/*!40101 SET @saved_cs_client = @@character_set_client */;
136+
/*!40101 SET character_set_client = utf8 */;
137+
CREATE TABLE `t_openid` (
138+
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
139+
`type` varchar(50) DEFAULT NULL,
140+
`open_id` int(11) DEFAULT NULL,
141+
`uid` int(11) DEFAULT NULL,
142+
`create_time` int(11) DEFAULT NULL,
143+
PRIMARY KEY (`id`),
144+
UNIQUE KEY `u_openid` (`open_id`,`type`,`uid`)
145+
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
146+
/*!40101 SET character_set_client = @saved_cs_client */;
147+
148+
--
149+
-- Table structure for table `t_settings`
150+
--
151+
152+
DROP TABLE IF EXISTS `t_settings`;
153+
/*!40101 SET @saved_cs_client = @@character_set_client */;
154+
/*!40101 SET character_set_client = utf8 */;
155+
CREATE TABLE `t_settings` (
156+
`skey` varchar(50) NOT NULL,
157+
`svalue` text,
158+
PRIMARY KEY (`skey`)
159+
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
160+
/*!40101 SET character_set_client = @saved_cs_client */;
161+
162+
--
163+
-- Table structure for table `t_topic`
164+
--
165+
166+
DROP TABLE IF EXISTS `t_topic`;
167+
/*!40101 SET @saved_cs_client = @@character_set_client */;
168+
/*!40101 SET character_set_client = utf8 */;
169+
CREATE TABLE `t_topic` (
170+
`tid` int(10) NOT NULL AUTO_INCREMENT,
171+
`uid` int(10) NOT NULL COMMENT '发布人',
172+
`nid` int(10) NOT NULL COMMENT '所属节点',
173+
`title` varchar(50) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '帖子标题',
174+
`content` text CHARACTER SET utf8mb4 COMMENT '帖子内容',
175+
`is_top` tinyint(2) DEFAULT '0' COMMENT '是否置顶',
176+
`is_essence` tinyint(2) DEFAULT '0' COMMENT '是否精华帖',
177+
`weight` double(10,2) DEFAULT '0.00' COMMENT '帖子权重',
178+
`c_time` int(10) NOT NULL COMMENT '帖子创建时间',
179+
`u_time` int(10) NOT NULL COMMENT '最后更新时间',
180+
`status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1:正常 2:删除',
181+
PRIMARY KEY (`tid`)
182+
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
183+
/*!40101 SET character_set_client = @saved_cs_client */;
184+
185+
--
186+
-- Table structure for table `t_topiccount`
187+
--
188+
189+
DROP TABLE IF EXISTS `t_topiccount`;
190+
/*!40101 SET @saved_cs_client = @@character_set_client */;
191+
/*!40101 SET character_set_client = utf8 */;
192+
CREATE TABLE `t_topiccount` (
193+
`tid` int(10) NOT NULL,
194+
`views` int(10) DEFAULT '0',
195+
`loves` int(10) DEFAULT '0',
196+
`favorites` int(10) DEFAULT '0',
197+
`comments` int(10) DEFAULT '0',
198+
`sinks` int(10) DEFAULT '0',
199+
`c_time` int(10) DEFAULT NULL,
200+
PRIMARY KEY (`tid`)
201+
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
202+
/*!40101 SET character_set_client = @saved_cs_client */;
203+
204+
--
205+
-- Table structure for table `t_user`
206+
--
207+
208+
DROP TABLE IF EXISTS `t_user`;
209+
/*!40101 SET @saved_cs_client = @@character_set_client */;
210+
/*!40101 SET character_set_client = utf8 */;
211+
CREATE TABLE `t_user` (
212+
`uid` int(10) NOT NULL AUTO_INCREMENT,
213+
`login` varchar(50) NOT NULL,
214+
`password` varchar(100) DEFAULT NULL,
215+
`avatar` varchar(100) DEFAULT NULL COMMENT '头像',
216+
`email` varchar(100) NOT NULL COMMENT '电子邮箱',
217+
`c_time` int(10) NOT NULL COMMENT '创建时间',
218+
`u_time` int(10) NOT NULL COMMENT '最后一次操作时间',
219+
`role_id` tinyint(2) DEFAULT '5' COMMENT '5:普通用户 2:管理员 1:系统管理员',
220+
`status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0:待激活 1:正常 2：删除',
221+
PRIMARY KEY (`uid`)
222+
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
223+
/*!40101 SET character_set_client = @saved_cs_client */;
224+
225+
--
226+
-- Table structure for table `t_userinfo`
227+
--
228+
229+
DROP TABLE IF EXISTS `t_userinfo`;
230+
/*!40101 SET @saved_cs_client = @@character_set_client */;
231+
/*!40101 SET character_set_client = utf8 */;
232+
CREATE TABLE `t_userinfo` (
233+
`uid` int(10) NOT NULL,
234+
`nick_name` varchar(50) DEFAULT NULL,
235+
`jobs` varchar(100) DEFAULT NULL,
236+
`web_site` varchar(255) DEFAULT NULL,
237+
`github` varchar(20) DEFAULT NULL,
238+
`weibo` varchar(50) DEFAULT NULL,
239+
`location` varchar(100) DEFAULT NULL,
240+
`signature` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
241+
`instructions` text CHARACTER SET utf8mb4,
242+
PRIMARY KEY (`uid`)
243+
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
244+
/*!40101 SET character_set_client = @saved_cs_client */;
245+
246+
--
247+
-- Table structure for table `t_userlog`
248+
--
249+
250+
DROP TABLE IF EXISTS `t_userlog`;
251+
/*!40101 SET @saved_cs_client = @@character_set_client */;
252+
/*!40101 SET character_set_client = utf8 */;
253+
CREATE TABLE `t_userlog` (
254+
`id` int(10) NOT NULL AUTO_INCREMENT,
255+
`uid` int(10) NOT NULL,
256+
`action` varchar(100) NOT NULL,
257+
`content` text,
258+
`ip` varchar(50) DEFAULT NULL,
259+
`c_time` int(10) NOT NULL,
260+
PRIMARY KEY (`id`)
261+
) ENGINE=MyISAM AUTO_INCREMENT=232 DEFAULT CHARSET=utf8;
262+
/*!40101 SET character_set_client = @saved_cs_client */;
263+
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
264+
265+
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
266+
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
267+
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
268+
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
269+
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
270+
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
271+
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
272+
273+
-- Dump completed on 2016-05-30 19:30:31

‎stack-info/docs/web-ui.md‎

Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,14 @@
1+
http://spring-abc.xyz/
2+
3+
https://www.expper.com/
4+
5+
http://discuss.flarum.org.cn/
6+
7+
https://ruby-china.org/
8+
9+
http://moeclub.net/
10+
11+
12+
https://java-china.org
13+
14+
http://bladejava.com/

0 commit comments

Comments
 (0)