forked from hooray/hoorayos
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathhoorayos.sql
More file actions
336 lines (312 loc) · 27.9 KB
/
hoorayos.sql
File metadata and controls
336 lines (312 loc) · 27.9 KB
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
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50711
Source Host : localhost:3306
Source Database : hoorayos
Target Server Type : MYSQL
Target Server Version : 50711
File Encoding : 65001
Date: 2016-07-05 01:38:39
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tb_app
-- ----------------------------
DROP TABLE IF EXISTS `tb_app`;
CREATE TABLE `tb_app` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标名称',
`icon` tinytext COLLATE utf8_unicode_ci COMMENT '图标图片',
`url` tinytext COLLATE utf8_unicode_ci COMMENT '图标链接',
`type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '应用类型，app（窗口应用）widget（挂件应用）',
`width` int(11) DEFAULT NULL COMMENT '窗口宽度',
`height` int(11) DEFAULT NULL COMMENT '窗口高度',
`isresize` tinyint(1) DEFAULT NULL COMMENT '是否能对窗口进行拉伸，1（是）0（否）',
`isopenmax` tinyint(1) DEFAULT NULL COMMENT '是否打开直接最大化，1（是）0（否）',
`isflash` tinyint(1) DEFAULT NULL COMMENT '是否为flash应用，1（是）0（否）',
`usecount` bigint(20) DEFAULT '0' COMMENT '使用人数',
`dt` datetime DEFAULT NULL COMMENT '添加时间',
`app_category_id` bigint(20) DEFAULT '0' COMMENT '应用类目id',
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_app
-- ----------------------------
INSERT INTO `tb_app` VALUES ('1', '应用管理', 'uploads/shortcut/20130505/13677343655235.png', 'sysapp/appmanage/index.php', 'window', '900', '650', '0', '0', '0', '1', '2012-02-26 22:51:53', '1');
INSERT INTO `tb_app` VALUES ('2', '网站设置', 'uploads/shortcut/20130505/1496650652100229.png', 'sysapp/websitesetting/index.php', 'window', '900', '550', '0', '0', '0', '1', '2012-02-26 22:52:40', '1');
INSERT INTO `tb_app` VALUES ('3', '会员管理', 'uploads/shortcut/20130505/1496650652100230.png', 'sysapp/member/index.php', 'window', '900', '550', '0', '0', '0', '1', '2012-07-19 10:57:28', '1');
INSERT INTO `tb_app` VALUES ('4', '权限管理', 'uploads/shortcut/20130505/1496650652100231.png', 'sysapp/permission/index.php', 'window', '900', '550', '0', '0', '0', '1', '2012-07-19 10:59:41', '1');
INSERT INTO `tb_app` VALUES ('5', '类目管理', 'uploads/shortcut/20130505/1496650652100231.png', 'sysapp/category/index.php', 'window', '900', '550', '0', '0', '0', '1', '2012-07-19 11:11:41', '1');
INSERT INTO `tb_app` VALUES ('6', '豆瓣FM', 'uploads/shortcut/20130505/13677359545258.png', 'http://douban.fm/partner/webqq?fromhoorayos', 'window', '420', '240', '0', '0', '0', '0', '2012-02-26 22:52:03', '3');
INSERT INTO `tb_app` VALUES ('7', '百度地图', 'uploads/shortcut/20130505/136773428052.png', 'http://map.baidu.com/', 'window', '1050', '550', '1', '0', '1', '0', '2012-02-26 22:52:55', '6');
INSERT INTO `tb_app` VALUES ('8', '美图秀秀', 'uploads/shortcut/20130505/13677342371591.png', 'http://xiuxiu.web.meitu.com/main.html', 'window', '900', '620', '1', '0', '1', '0', '2012-02-26 22:52:58', '6');
INSERT INTO `tb_app` VALUES ('9', 'AcFun弹幕视频网', 'uploads/shortcut/20130505/13677343281639.png', 'http://m.acfun.tv', 'window', '800', '480', '1', '0', '1', '0', '2012-02-26 22:52:24', '3');
INSERT INTO `tb_app` VALUES ('10', '搜狐视频', 'uploads/shortcut/20130505/13677343162518.png', 'http://tv.sohu.com/upload/sohuapp/index.html', 'window', '800', '646', '1', '0', '1', '0', '2012-02-26 22:52:26', '3');
INSERT INTO `tb_app` VALUES ('11', '哔哩哔哩弹幕视频网', 'uploads/shortcut/20130505/13677342975360.png', 'http://www.bilibili.com/mobile/index.html', 'window', '960', '650', '0', '0', '1', '0', '2012-02-26 22:52:29', '3');
INSERT INTO `tb_app` VALUES ('12', '时钟', 'uploads/shortcut/20130505/1496650652100232.png', 'extapp/clock/index.php', 'widget', '130', '160', '0', '0', '0', '0', '2012-08-05 23:01:51', '6');
INSERT INTO `tb_app` VALUES ('13', '天气预报', 'uploads/shortcut/20130505/13677369315643.png', 'extapp/weather/index.php', 'widget', '200', '330', '0', '0', '0', '0', '2012-08-05 23:02:28', '6');
INSERT INTO `tb_app` VALUES ('14', '日历', 'uploads/shortcut/20130505/13677342114330.png', 'sysapp/calendar/index.php', 'window', '800', '720', '1', '0', '0', '0', '2012-10-16 03:06:17', '6');
INSERT INTO `tb_app` VALUES ('15', '愤怒的小鸟', 'uploads/shortcut/20130505/13677340436355.png', 'http://www.3366.com/swf.html?gid=63298&type=0&needframe=0&open=1&FlashParam=&IFrameName=&basedirexp=base20130108095114&adid=3366_1_12413&apiflag=1&NeedOutLink=0', 'window', '800', '512', '1', '0', '1', '0', '2013-05-05 14:07:28', '2');
INSERT INTO `tb_app` VALUES ('16', '保卫萝卜', 'uploads/shortcut/20130505/13677346104517.png', 'http://www.3366.com/swf.html?gid=95658&type=0&needframe=0&open=0&FlashParam=&IFrameName=game53.htm&basedirexp=&adid=&apiflag=0&NeedOutLink=0', 'window', '800', '638', '1', '0', '1', '0', '2013-05-05 14:17:14', '2');
INSERT INTO `tb_app` VALUES ('17', '植物大战僵尸', 'uploads/shortcut/20130505/13677346716160.png', 'http://www.3366.com/swf.html?gid=27261&type=0&needframe=1&open=0&FlashParam=&IFrameName=&basedirexp=&adid=', 'window', '640', '542', '0', '0', '1', '0', '2013-05-05 14:18:09', '2');
INSERT INTO `tb_app` VALUES ('18', '小鳄鱼爱洗澡', 'uploads/shortcut/20130505/13677347227549.png', 'http://www.4399.com/360game/93551.htm', 'window', '800', '663', '0', '0', '1', '0', '2013-05-05 14:19:48', '2');
INSERT INTO `tb_app` VALUES ('19', '水果忍者', 'uploads/shortcut/20130505/13677349543577.png', 'http://www.3366.com/swf.html?gid=94690&type=0&needframe=0&open=1&FlashParam=wmode%3Ddirect&IFrameName=&basedirexp=base20130905193213&adid=3366_1_23255&apiflag=241&NeedOutLink=1', 'window', '640', '542', '0', '0', '1', '0', '2013-05-05 14:23:02', '2');
INSERT INTO `tb_app` VALUES ('20', '三国杀', 'uploads/shortcut/20130505/13677350213580.png', 'http://web.sanguosha.com/', 'window', '1200', '762', '1', '0', '1', '0', '2013-05-05 14:24:01', '2');
INSERT INTO `tb_app` VALUES ('21', '全民斗地主', 'uploads/shortcut/20130505/1367735129442.png', 'http://www.4399.com/360game/117945.htm', 'window', '800', '663', '1', '0', '1', '0', '2013-05-05 14:26:00', '2');
INSERT INTO `tb_app` VALUES ('22', '神庙逃亡2', 'uploads/shortcut/20130505/13677351957517.png', 'http://www.4399.com/360game/112909.htm', 'window', '800', '663', '0', '0', '1', '0', '2013-05-05 14:27:00', '2');
INSERT INTO `tb_app` VALUES ('23', '黑八传奇', 'uploads/shortcut/20130505/13677353369336.png', 'http://www.4399.com/360game/33239.htm', 'window', '800', '663', '0', '0', '1', '0', '2013-05-05 14:29:18', '2');
INSERT INTO `tb_app` VALUES ('24', '割绳子H5版', 'uploads/shortcut/20130505/13677353829381.png', 'http://www.4399.com/360game/142014.htm', 'window', '800', '663', '0', '0', '1', '0', '2013-05-05 14:30:07', '2');
INSERT INTO `tb_app` VALUES ('25', '优酷视频', 'uploads/shortcut/20130505/13677356058228.png', 'http://api.youku.com/widget/360box/index.html', 'window', '820', '680', '1', '0', '1', '0', '2013-05-05 14:33:48', '3');
INSERT INTO `tb_app` VALUES ('26', '虾米音乐', 'uploads/shortcut/20130505/13677356703430.png', 'http://m.xiami.com/', 'window', '400', '700', '0', '0', '1', '0', '2013-05-05 14:35:28', '3');
INSERT INTO `tb_app` VALUES ('27', '爱奇艺', 'uploads/shortcut/20130505/13677357888501.png', 'http://www.qiyi.com/mini/qplus.html', 'window', '1030', '720', '1', '0', '1', '0', '2013-05-05 14:37:16', '3');
INSERT INTO `tb_app` VALUES ('28', '土豆视频', 'uploads/shortcut/20130505/13677358555620.png', 'http://2010.tudou.com/360api/index.php', 'window', '1030', '800', '1', '0', '1', '0', '2013-05-05 14:38:25', '3');
INSERT INTO `tb_app` VALUES ('29', '音悦台', 'uploads/shortcut/20130505/13677359969968.png', 'http://www.yinyuetai.com/webqq', 'window', '830', '520', '1', '0', '1', '0', '2013-05-05 14:40:33', '3');
INSERT INTO `tb_app` VALUES ('30', '酷狗电台', 'uploads/shortcut/20130505/13677361014197.png', 'http://topic.kugou.com/radio/', 'window', '780', '580', '1', '0', '1', '0', '2013-05-05 14:42:19', '3');
INSERT INTO `tb_app` VALUES ('31', 'ONE · 一个', 'uploads/shortcut/20130505/13677362198177.png', 'http://www.wufazhuce.com', 'window', '700', '650', '1', '0', '0', '0', '2013-05-05 14:44:27', '4');
INSERT INTO `tb_app` VALUES ('32', '36氪', 'uploads/shortcut/20130505/1367736387213.png', 'http://36kr.com/', 'window', '1020', '650', '1', '0', '0', '0', '2013-05-05 14:46:48', '4');
INSERT INTO `tb_app` VALUES ('33', '新华字典', 'uploads/shortcut/20130505/13677364305280.png', 'http://xh.5156edu.com/', 'window', '840', '650', '1', '0', '0', '0', '2013-05-05 14:47:28', '4');
INSERT INTO `tb_app` VALUES ('34', '校花保镖', 'uploads/shortcut/20130505/13677364692734.png', 'http://book.hjsm.tom.com/106665/360catelog.html', 'window', '1000', '650', '1', '0', '0', '0', '2013-05-05 14:48:11', '4');
INSERT INTO `tb_app` VALUES ('35', '我的制服女友', 'uploads/shortcut/20130505/13677365159802.png', 'http://book.hjsm.tom.com/110407/360catelog.html', 'window', '1000', '650', '1', '0', '0', '0', '2013-05-05 14:48:53', '4');
INSERT INTO `tb_app` VALUES ('36', '被妞泡的日子', 'uploads/shortcut/20130505/1367736560985.png', 'http://book.hjsm.tom.com/108669/360catelog.html', 'window', '1000', '650', '1', '0', '0', '0', '2013-05-05 14:49:39', '4');
INSERT INTO `tb_app` VALUES ('37', '极品小员工', 'uploads/shortcut/20130505/13677366172043.png', 'http://book.hjsm.tom.com/109038/360catelog.html', 'window', '1000', '650', '1', '0', '0', '0', '2013-05-05 14:50:41', '4');
INSERT INTO `tb_app` VALUES ('38', '异世御龙', 'uploads/shortcut/20130505/13677366722127.png', 'http://book.hjsm.tom.com/105977/360catelog.html', 'window', '1000', '650', '1', '0', '0', '0', '2013-05-05 14:51:32', '4');
INSERT INTO `tb_app` VALUES ('39', '冷酷校草恋上我', 'uploads/shortcut/20130505/13677367421113.png', 'http://book.hjsm.tom.com/105522/360catelog.html', 'window', '1000', '650', '1', '0', '0', '0', '2013-05-05 14:52:43', '4');
INSERT INTO `tb_app` VALUES ('40', '赵子龙穿越到都市', 'uploads/shortcut/20130505/1367736867676.png', 'http://book.hjsm.tom.com/109405/360catelog.html', 'window', '1000', '650', '1', '0', '0', '0', '2013-05-05 14:54:49', '4');
INSERT INTO `tb_app` VALUES ('41', '天气预报', 'uploads/shortcut/20130505/13677369315643.png', 'http://shenghuo.360.cn/tq/yb?360src=360se', 'window', '420', '680', '1', '0', '0', '0', '2013-05-05 14:56:07', '5');
INSERT INTO `tb_app` VALUES ('42', '快递查询', 'uploads/shortcut/20130505/13677370021209.png', 'http://www.kuaidi100.com/frame/qq/webqq/?canvas_pos=2016', 'window', '560', '460', '1', '0', '0', '0', '2013-05-05 14:57:14', '5');
INSERT INTO `tb_app` VALUES ('43', '万年历', 'uploads/shortcut/20130505/1367737151617.png', 'http://www.saturdaysoft.com/prod/360apc/calendar.html', 'window', '540', '450', '0', '0', '0', '0', '2013-05-05 14:59:42', '5');
INSERT INTO `tb_app` VALUES ('44', '城市间路程油费路桥费查询', 'uploads/shortcut/20130505/13677372407307.png', 'http://www.pcwcn.com/city_search?type=alone&bd_user=0&bd_sig=bb7229df73013a1a18f947b4c929e2b7', 'window', '560', '400', '0', '0', '0', '0', '2013-05-05 15:01:22', '5');
INSERT INTO `tb_app` VALUES ('45', '手机充值', 'uploads/shortcut/20130505/13677373176723.png', 'http://shenghuo.360.cn/dapp', 'window', '540', '350', '0', '0', '0', '0', '2013-05-05 15:02:36', '5');
INSERT INTO `tb_app` VALUES ('46', '身份证查询', 'uploads/shortcut/20130505/13677373916735.png', 'http://360app.45451.com/sfz', 'window', '580', '380', '0', '0', '0', '0', '2013-05-05 15:03:56', '5');
INSERT INTO `tb_app` VALUES ('47', '酷讯火车票', 'uploads/shortcut/20130505/13677375795763.png', 'http://n.huoche.kuxun.cn/?fromid=Kapc360cn-S1205011-T1183881', 'window', '790', '630', '0', '0', '0', '0', '2013-05-05 15:07:01', '5');
INSERT INTO `tb_app` VALUES ('48', '减肥食谱', 'uploads/shortcut/20130505/1367737648336.png', 'http://www.pcbaby.com.cn/360/diet/', 'window', '820', '640', '0', '0', '0', '0', '2013-05-05 15:08:04', '5');
INSERT INTO `tb_app` VALUES ('49', '眼睛保健操', 'uploads/shortcut/20130505/13677377979610.png', 'http://apps.qiyigoo.com/yanbaojiancao/', 'window', '570', '600', '0', '0', '0', '0', '2013-05-05 15:10:24', '5');
INSERT INTO `tb_app` VALUES ('50', 'KTV大全', 'uploads/shortcut/20130505/13677378833444.png', 'http://www.51huoban.com/baidu/ktv/index.php', 'window', '560', '540', '0', '0', '0', '0', '2013-05-05 15:11:58', '5');
INSERT INTO `tb_app` VALUES ('51', '语音计算器', 'uploads/shortcut/20130505/13677380592462.png', 'http://app.qiqi.cc/apps/video_calc/', 'window', '560', '530', '0', '0', '1', '0', '2013-05-05 15:15:05', '6');
INSERT INTO `tb_app` VALUES ('52', '有道词典', 'uploads/shortcut/20130505/1367738149614.png', 'http://dict.youdao.com/app/360', 'window', '554', '552', '0', '0', '0', '0', '2013-05-05 15:16:30', '6');
INSERT INTO `tb_app` VALUES ('53', '交通标志', 'uploads/shortcut/20130505/13677384429066.png', 'http://cnzaobao.com/360se/jiaotongbiaozhi.html', 'window', '600', '700', '0', '0', '1', '0', '2013-05-05 15:21:17', '6');
INSERT INTO `tb_app` VALUES ('54', '秒表计时器', 'uploads/shortcut/20130505/13677387064869.png', 'http://5.app100672505.twsapp.com/bd_miaodao.php', 'window', '580', '440', '0', '0', '0', '0', '2013-05-05 15:25:53', '6');
INSERT INTO `tb_app` VALUES ('55', '阴历阳历转换', 'uploads/shortcut/20130505/13677388786.png', 'http://5.app100672505.twsapp.com/ada_yrzh/', 'window', '570', '470', '0', '0', '0', '0', '2013-05-05 15:28:30', '6');
-- ----------------------------
-- Table structure for tb_app_category
-- ----------------------------
DROP TABLE IF EXISTS `tb_app_category`;
CREATE TABLE `tb_app_category` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
`issystem` tinyint(1) DEFAULT '0' COMMENT '是否为系统类目，1（是）0（否）',
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_app_category
-- ----------------------------
INSERT INTO `tb_app_category` VALUES ('1', '系统', '1');
INSERT INTO `tb_app_category` VALUES ('2', '游戏', '0');
INSERT INTO `tb_app_category` VALUES ('3', '影音', '0');
INSERT INTO `tb_app_category` VALUES ('4', '图书', '0');
INSERT INTO `tb_app_category` VALUES ('5', '生活', '0');
INSERT INTO `tb_app_category` VALUES ('6', '工具', '0');
-- ----------------------------
-- Table structure for tb_calendar
-- ----------------------------
DROP TABLE IF EXISTS `tb_calendar`;
CREATE TABLE `tb_calendar` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '标题',
`content` longtext COLLATE utf8_unicode_ci COMMENT '详细内容',
`url` text COLLATE utf8_unicode_ci COMMENT '超链接',
`startdt` datetime DEFAULT NULL COMMENT '开始时间',
`enddt` datetime DEFAULT NULL COMMENT '结束时间',
`isallday` tinyint(1) DEFAULT '1' COMMENT '是否属于全天任务',
`member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_calendar
-- ----------------------------
-- ----------------------------
-- Table structure for tb_file
-- ----------------------------
DROP TABLE IF EXISTS `tb_file`;
CREATE TABLE `tb_file` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`icon` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标地址',
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '文件名',
`ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '扩展名',
`size` int(11) DEFAULT NULL COMMENT '文件大小',
`url` text COLLATE utf8_unicode_ci COMMENT '文件存放地址',
`member_id` bigint(20) DEFAULT NULL,
`dt` datetime DEFAULT NULL,
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_file
-- ----------------------------
-- ----------------------------
-- Table structure for tb_member
-- ----------------------------
DROP TABLE IF EXISTS `tb_member`;
CREATE TABLE `tb_member` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户名',
`password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密码',
`lockpassword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '锁屏密码',
`type` tinyint(1) DEFAULT '0' COMMENT '用户类型，0（普通用户）1（管理员）',
`permission_id` bigint(20) DEFAULT NULL COMMENT '权限id',
`dock` longtext COLLATE utf8_unicode_ci COMMENT '[应用码头]应用id，用","相连',
`desk1` longtext COLLATE utf8_unicode_ci COMMENT '[桌面1]应用id，用","相连',
`desk2` longtext COLLATE utf8_unicode_ci COMMENT '[桌面2]应用id，用","相连',
`desk3` longtext COLLATE utf8_unicode_ci COMMENT '[桌面3]应用id，用","相连',
`desk4` longtext COLLATE utf8_unicode_ci COMMENT '[桌面4]应用id，用","相连',
`desk5` longtext COLLATE utf8_unicode_ci COMMENT '[桌面5]应用id，用","相连',
`appxy` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'x' COMMENT '图标排列方式，x（横向排列）y（纵向排列）',
`desk` tinyint(1) DEFAULT '1' COMMENT '默认桌面',
`dockpos` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'top' COMMENT '应用码头位置，top（顶部）left（左侧）right（右侧）none（隐藏）',
`appsize` int(11) DEFAULT '48' COMMENT '图标尺寸',
`appverticalspacing` int(11) DEFAULT '50' COMMENT '图标垂直间距',
`apphorizontalspacing` int(11) DEFAULT '50' COMMENT '图标水平间距',
`wallpaper_id` int(11) DEFAULT '1' COMMENT '壁纸id',
`wallpaperwebsite` text COLLATE utf8_unicode_ci COMMENT '壁纸网址',
`wallpaperstate` tinyint(4) DEFAULT '1' COMMENT '1（系统壁纸）2（自定义壁纸）3（网络地址）',
`wallpapertype` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'juzhong' COMMENT '壁纸显示方式，tianchong（填充）shiying（适应）pingpu（平铺）lashen（拉伸）juzhong（居中）',
`skin` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'default' COMMENT '窗口皮肤',
`regdt` datetime DEFAULT NULL COMMENT '注册时间',
`lastlogindt` datetime DEFAULT NULL COMMENT '上次登录时间',
`lastloginip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '上次登录IP',
`thislogindt` datetime DEFAULT NULL COMMENT '本次登陆时间',
`thisloginip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '本次登录IP',
`openid_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`openname_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`openavatar_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`openurl_qq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`openid_weibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`openname_weibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`openavatar_weibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`openurl_weibo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_member
-- ----------------------------
INSERT INTO `tb_member` VALUES ('1', 'hoorayos', 'c5e9fe42f061fa6102857db920734c33ec7b0816', 'c5e9fe42f061fa6102857db920734c33ec7b0816', '1', '1', '', '1,2,3,4,5', '', '', '', '', 'x', '1', 'top', '64', '50', '50', '1', null, '1', 'lashen', 'default', '2012-02-29 00:00:00', '2012-02-29 00:00:00', '0.0.0.0', '2012-02-29 00:00:00', '0.0.0.0', null, null, null, null, null, null, null, null);
-- ----------------------------
-- Table structure for tb_member_app
-- ----------------------------
DROP TABLE IF EXISTS `tb_member_app`;
CREATE TABLE `tb_member_app` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`realid` bigint(20) DEFAULT '0' COMMENT '真实id',
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标名称',
`icon` tinytext COLLATE utf8_unicode_ci COMMENT '图标图片',
`url` tinytext COLLATE utf8_unicode_ci COMMENT '应用地址',
`type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '应用类型',
`width` int(11) DEFAULT NULL COMMENT '窗口宽度',
`height` int(11) DEFAULT NULL COMMENT '窗口高度',
`isresize` tinyint(11) DEFAULT NULL COMMENT '是否能对窗口进行拉伸',
`isopenmax` tinyint(4) DEFAULT NULL COMMENT '是否打开直接最大化',
`isflash` tinyint(4) DEFAULT NULL COMMENT '是否为flash应用',
`ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '扩展名',
`size` int(11) DEFAULT NULL COMMENT '文件大小',
`dt` datetime DEFAULT NULL COMMENT '创建时间',
`lastdt` datetime DEFAULT NULL COMMENT '最后修改时间',
`folder_id` bigint(20) DEFAULT '0' COMMENT '文件夹id',
`member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_member_app
-- ----------------------------
INSERT INTO `tb_member_app` VALUES ('1', '1', '应用管理', 'uploads/shortcut/20130505/13677343655235.png', null, 'window', '900', '650', '0', '0', '0', null, null, '2016-07-05 01:36:31', '2016-07-05 01:36:31', '0', '1');
INSERT INTO `tb_member_app` VALUES ('2', '2', '网站设置', 'uploads/shortcut/20130505/1496650652100229.png', null, 'window', '900', '550', '0', '0', '0', null, null, '2016-07-05 01:36:32', '2016-07-05 01:36:32', '0', '1');
INSERT INTO `tb_member_app` VALUES ('3', '3', '会员管理', 'uploads/shortcut/20130505/1496650652100230.png', null, 'window', '900', '550', '0', '0', '0', null, null, '2016-07-05 01:36:33', '2016-07-05 01:36:33', '0', '1');
INSERT INTO `tb_member_app` VALUES ('4', '4', '权限管理', 'uploads/shortcut/20130505/1496650652100231.png', null, 'window', '900', '550', '0', '0', '0', null, null, '2016-07-05 01:36:34', '2016-07-05 01:36:34', '0', '1');
INSERT INTO `tb_member_app` VALUES ('5', '5', '类目管理', 'uploads/shortcut/20130505/1496650652100231.png', null, 'window', '900', '550', '0', '0', '0', null, null, '2016-07-05 01:36:35', '2016-07-05 01:36:35', '0', '1');
-- ----------------------------
-- Table structure for tb_permission
-- ----------------------------
DROP TABLE IF EXISTS `tb_permission`;
CREATE TABLE `tb_permission` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限名称',
`apps_id` longtext COLLATE utf8_unicode_ci COMMENT '权限关联应用id，用","相连',
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_permission
-- ----------------------------
INSERT INTO `tb_permission` VALUES ('1', '平台管理员', '1,2,3,4,5');
INSERT INTO `tb_permission` VALUES ('2', '应用管理员', '1');
INSERT INTO `tb_permission` VALUES ('3', '会员管理员', '3');
INSERT INTO `tb_permission` VALUES ('4', '网站设置管理员', '2');
INSERT INTO `tb_permission` VALUES ('5', '类目管理员', '5');
-- ----------------------------
-- Table structure for tb_pwallpaper
-- ----------------------------
DROP TABLE IF EXISTS `tb_pwallpaper`;
CREATE TABLE `tb_pwallpaper` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`url` tinytext COLLATE utf8_unicode_ci COMMENT '壁纸地址',
`width` int(11) DEFAULT NULL COMMENT '壁纸宽度',
`height` int(11) DEFAULT NULL COMMENT '壁纸高度',
`member_id` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_pwallpaper
-- ----------------------------
-- ----------------------------
-- Table structure for tb_setting
-- ----------------------------
DROP TABLE IF EXISTS `tb_setting`;
CREATE TABLE `tb_setting` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`title` text COLLATE utf8_unicode_ci COMMENT '网站标题',
`description` text COLLATE utf8_unicode_ci COMMENT '网站描述',
`keywords` text COLLATE utf8_unicode_ci COMMENT '网站关键字',
`dock` longtext COLLATE utf8_unicode_ci COMMENT '[应用码头]应用id，用","相连',
`desk1` longtext COLLATE utf8_unicode_ci COMMENT '[桌面1]应用id，用","相连',
`desk2` longtext COLLATE utf8_unicode_ci COMMENT '[桌面2]应用id，用","相连',
`desk3` longtext COLLATE utf8_unicode_ci COMMENT '[桌面3]应用id，用","相连',
`desk4` longtext COLLATE utf8_unicode_ci COMMENT '[桌面4]应用id，用","相连',
`desk5` longtext COLLATE utf8_unicode_ci COMMENT '[桌面5]应用id，用","相连',
`desk` tinyint(1) DEFAULT '1' COMMENT '默认显示第几桌面',
`appxy` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'x' COMMENT '图标排列方式，x（横向排列）y（纵向排列）',
`appsize` int(11) DEFAULT '48' COMMENT '图标尺寸',
`appverticalspacing` int(11) DEFAULT '50' COMMENT '图标垂直间距',
`apphorizontalspacing` int(11) DEFAULT '50' COMMENT '图标水平间距',
`dockpos` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'top' COMMENT '应用码头位置，top（顶部）left（左侧）right（右侧）none（隐藏）',
`skin` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'default' COMMENT '窗口皮肤',
`wallpaper_id` int(11) DEFAULT '1',
`wallpapertype` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'juzhong' COMMENT '壁纸显示方式，tianchong（填充）shiying（适应）pingpu（平铺）lashen（拉伸）juzhong（居中）',
`isforcedlogin` tinyint(1) DEFAULT '1' COMMENT '是否开启强制登录，1开启0不开启',
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_setting
-- ----------------------------
INSERT INTO `tb_setting` VALUES ('1', 'HoorayOS桌面应用框架', 'HoorayOS是一套web桌面应用框架，你可以用它开发出类似于Q+web这类的桌面应用网站，也可以在它的基础上二次开发出适合项目的桌面式管理系统。', 'HoorayOS,web桌面,免费开源,桌面管理系统', '14', '55,54,53,52,51', '50,49,48,47,46', '45,44,43,41,42', '30,29,28,27,26', '20,19,18,17,16', '1', 'x', '64', '50', '50', 'top', 'default', '1', 'juzhong', '0');
-- ----------------------------
-- Table structure for tb_wallpaper
-- ----------------------------
DROP TABLE IF EXISTS `tb_wallpaper`;
CREATE TABLE `tb_wallpaper` (
`tbid` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '壁纸名称',
`url` tinytext COLLATE utf8_unicode_ci COMMENT '壁纸地址',
`width` int(11) DEFAULT NULL COMMENT '壁纸宽度',
`height` int(11) DEFAULT NULL COMMENT '壁纸高度',
PRIMARY KEY (`tbid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------
-- Records of tb_wallpaper
-- ----------------------------
INSERT INTO `tb_wallpaper` VALUES ('1', '壁纸1', 'static/img/wallpaper/wallpaper1.jpg', '1920', '1080');
INSERT INTO `tb_wallpaper` VALUES ('2', '壁纸2', 'static/img/wallpaper/wallpaper2.jpg', '1920', '1080');
INSERT INTO `tb_wallpaper` VALUES ('3', '壁纸3', 'static/img/wallpaper/wallpaper3.jpg', '1920', '1080');
INSERT INTO `tb_wallpaper` VALUES ('4', '壁纸4', 'static/img/wallpaper/wallpaper4.jpg', '1920', '1080');
INSERT INTO `tb_wallpaper` VALUES ('5', '壁纸5', 'static/img/wallpaper/wallpaper5.jpg', '1920', '1080');
INSERT INTO `tb_wallpaper` VALUES ('6', '壁纸6', 'static/img/wallpaper/wallpaper6.jpg', '1920', '1080');
INSERT INTO `tb_wallpaper` VALUES ('7', '壁纸7', 'static/img/wallpaper/wallpaper7.jpg', '1920', '1080');
INSERT INTO `tb_wallpaper` VALUES ('8', '壁纸8', 'static/img/wallpaper/wallpaper8.jpg', '1920', '1080');
INSERT INTO `tb_wallpaper` VALUES ('9', '壁纸9', 'static/img/wallpaper/wallpaper9.jpg', '1920', '1080');