📄 initdb.sql
字号:
(113,'用户禁止选项设置权限','/adminForbidSet','*',0),
(114,'发帖和编辑选项设置权限','/adminPostSet','*',0),
(115,'附件选项设置权限','/adminAttachSet','*',0),
(116,'投票选项设置权限','/adminVoteSet','*',0),
(117,'悄悄话选项设置权限','/aminPmSet','*',0),
(118,'主题列表显示选项设置权限','/adminForumViewSet','*',0),
(119,'主题内容显示选项设置权限','/adminPostViewSet','*',0),
(120,'隐藏帖选项设置权限','/adminPostHiddenSet','*',0),
(121,'在线时长设定权限','/adminUOTimeSet','*',0),
(122,'查看版区列表权限','/adminBoardList','*',0),
(123,'添加修改版区权限','/adminBoardSet','*',0),
(124,'查看版主列表权限','/adminBML','*',0),
(125,'添加修改版主权限','/adminBmSet','*',0),
(126,'查看权限列表权限','/adminPermission','*',0),
(127,'查看角色列表权限','/adminRoleList','*',0),
(128,'管理角色权限','/adminRoleSet','*',0),
(129,'查看用户组列表权限','/adminUgList','*',0),
(130,'用户组管理权限','/adminUgSet','*',0),
(131,'用户管理权限','/adminUserSearch','*',0),
(132,'版区权限设置权限','/adminBoardUg','*',0),
(133,'版区Tag设置权限','/adminBoardTag','*',0),
(134,'用户等级设置权限','/adminUserLevel','*',0),
(201,'查看社区主框架权限','/main','*',0),
(202,'查看社区左侧导航页权限','/nag','*',0),
(203,'修改签名权限','/signSet','*',0),
(204,'修改昵称权限','/nickNameSet','*',0),
(205,'个人参数设置权限','/userConfig','*',0),
(206,'朋友/黑名单设置权限','/friendSet','*',0),
(207,'悄悄话权限','/note','*',0),
(208,'书签管理权限','/bookMark','*',0),
(209,'头像设置权限','/userFace','index,uppage,up,delme',0),
(210,'查看用户头像权限','/userFace','showface',0),
(211,'修改个人详细资料权限','/userDetailSet','*',0),
(212,'进入社区首页权限','/in','*',0),
(213,'察看用户资料权限','/userInfo','*',0),
(214,'查看在线用户权限','/online','*',0),
(215,'全文搜索权限','/search','*',0),
(216,'修改密码权限','/cpasswd','*',0),
(217,'管理个人珍藏权限','/boardSaveManage','*',0),
(220,'社区首页管理','/inCoverManage','*',0),
(401,'查看讨论版权限','/forum','index',2),
(402,'查看热门帖权限','/forum','hot',2),
(403,'查看推荐帖权限','/forum','commend',2),
(404,'查看历史帖权限','/forum','history',2),
(405,'查看主题权限','/read','topic',2),
(406,'查看主题摘要权限','/read','summary',2),
(407,'查看用户IP权限','/read','showip',2),
(408,'显示帖子中附件权限','/read','showupfile',2),
(409,'显示帖子中投票权限','/read','showvote',2),
(410,'只看楼主权限','/read','own',2),
(411,'查看垃圾桶里帖子主题权限','/read','waste',2),
(412,'查看未审核帖子主题权限','/read','auditing',2),
(413,'查看未审核附件帖子主题权限','/read','auditingAttach',2),
(414,'查看精华区帖子主题权限','/read','elite',2),
(420,'发帖权限','/post','new,add',2),
(421,'回帖权限','/post','re,requote,addqre,addre,addrequote,buy',2),
(422,'上传附件权限','/post','upfile,upfileinput,upfiledo',2),
(423,'编辑帖子权限','/post','edit,editdo,showdelattachpage',2),
(424,'帖子赞成反对权限','/postOpt','votyes,votno',2),
(425,'订阅帖子权限','/postOpt','subs',2),
(426,'帖子打包权限','/postOpt','mailsend,mailsendtopic',2),
(427,'举报帖子权限','/postOpt','report',2),
(430,'发布修改投票帖权限','/votePost','new,add,edit,editdo',2),
(431,'投票帖投票权限','/oteOpt','*',2),
(432,'删除帖子附件权限','/delAttach','*',2),
(433,'收藏版区权限','/boardSave','*',2),
(434,'查看帖子订阅列表权限','/subs','*',2),
(435,'版内搜索权限','/forumSearch','*',2),
(440,'查看历史帖子主题权限','/readHistory','*',2),
(441,'给帖子投票权限','/voteOpt','*',2),
(450,'查看精华区权限','/refine','index,showelite,showflist',2),
(451,'管理精华区权限','/refine','manage,showelite,showflist,adddir,intodir,del,outdir,edit,editdo,deldir',2),
(460,'删除单个帖子权限','/postOpt','dela',2),
(462,'帖子置顶权限','/postOpt','top,untop',2),
(463,'M帖权限','/postOpt','cannotdel,candel',2),
(464,'推荐帖子权限','/postOpt','commend,uncommend',2),
(465,'锁定帖子权限','/postOpt','lock,unlock',2),
(466,'加入精华权限','/postOpt','elite',2),
(470,'版区管理权限','/forumManage','m,w,a,aa,dels,delw,delallw,resume,auditing,auditingAttach,delsnota,delsnotaa',2),
(471,'版区高级管理权限','/manageAdvance','index,forbiduser,bulletin,addauth,delauth',2),
(475,'版区封面管理权限','/coverManage','*',2),
(476,'查看社区统计权限','/sysNumStat','*',0),
(477,'查看用户列表权限','/userShow','*',0),
(601,'发帖时显示版区置顶选项权限','*','*',3),
(602,'可以使用彩色标题权限','*','*',3),
(603,'可直接查看隐藏帖内容权限','*','*',3),
(604,'不受发帖间隔时间限制','*','*',3),
(605,'高级-编辑所有帖子权限','*','*',3),
(606,'高级-删除所有帖子权限','*','*',3),
(607,'高级-删除附件权限','*','*',3),
(608,'不需要密码进入版区权限','*','*',3),
(609,'不需要授权进入版区权限','*','*',3),
(610,'可查看未审核附件权限','*','*',3),
(901,'可以查看隐藏版区权限','*','*',1);
######
INSERT INTO `bbscs_role` (`ID`, `RoleName`, `TypeID`, `Permissions`) VALUES
(1,'版主角色',1,'401,402,403,404,405,406,407,408,409,410,411,412,413,414,420,421,422,423,424,425,426,427,430,431,432,433,434,435,440,450,451,460,462,463,464,465,466,470,471,475,601,602,603,604,605,606,607,608,609,610'),
(2,'版副角色',1,'401,402,403,404,405,406,407,408,409,410,411,412,413,414,420,421,422,423,424,425,426,427,430,431,432,433,434,435,440,450,451,460,462,463,464,465,466,470,601,602,603,604,608,609,610'),
(3,'隐身版主角色',1,'401,402,403,405,406,407,408,409,410,411,412,413,414,420,421,422,423,424,425,426,427,430,431,432,433,434,435,440,450,451,460,462,463,464,465,466,470,601,602,603,604,608,609,610'),
(4,'后台可进行权限管理角色',0,'126,127,128,129,130'),
(5,'后台可管理常规选项角色',0,'103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,134'),
(6,'后台可管理版区角色',0,'122,123,124,125,132,133'),
(7,'可进入后台管理角色',0,'101,102'),
(8,'后台可管理用户角色',0,'131'),
(9,'前台可进入社区用户角色',0,'201,202,212,213,214,215'),
(10,'前台初级管理员角色',0,'901'),
(11,'前台中级管理员角色',0,'901'),
(12,'前台高级管理员角色',0,'220,476,477,901'),
(13,'前台可管理自己用户信息角色',0,'203,204,205,206,207,208,209,210,211,216,217');
######
INSERT INTO `bbscs_usergroup` (`ID`, `GroupName`, `GroupDesc`, `TypeID`) VALUES
(1,'游客/未注册用户','',0),
(2,'注册用户','',0),
(3,'待验证用户','',0),
(4,'超级版主','',0),
(5,'系统管理员','',0),
(6,'封禁用户','',0);
######
INSERT INTO `bbscs_userlevel` (`ID`, `LevelName`, `LevelValue`, `LevelType`) VALUES
('402881820ebb22b2010ebb2462550001','恶贯满盈',-500,0),
('402881820ebb335f010ebb344eee0001','犯事累累',-100,0),
('402881820ebb3806010ebb38d84f0001','不务正业',0,0),
('402881820ebb3806010ebb39143e0002','初出江湖',100,0),
('402881820ebb3806010ebb3961450003','新手上路',300,0),
('402881820ebb3806010ebb39f1120004','初级站友',800,0),
('402881820ebb3806010ebb3a29d50005','中级站友',1500,0),
('402881820ebb3806010ebb3a7a560006','高级站友',2500,0),
('402881820ebb3806010ebb3ab9730007','青铜长老',5000,0),
('402881820ebb3806010ebb3afd130008','白银长老',7000,0),
('402881820ebb3806010ebb3b71880009','黄金长老',10000,0),
('402881820ebb3806010ebb3bb0f2000a','白金长老',15000,0),
('402881820ebb3806010ebb3be996000b','钻石长老',22000,0),
('402881820ebb3806010ebb3c220b000c','资深元老',30000,0),
('402881820ebb3806010ebb3c55ae000d','社区支柱',40000,0),
('402881820ebb3806010ebb3d6171000f','骨灰级元老',2147483647,0);
######
INSERT INTO `bbscs_userinfo` (`ID`, `UserName`, `NickName`, `Passwd`, `RePasswd`, `Email`, `Question`, `Answer`, `RegTime`, `LoginTime`, `LoginIP`, `LoginTimes`, `LastLoginTime`, `LastLoginIP`, `ArticleNum`, `StayTime`, `ArticleEliteNum`, `LifeForce`, `UserTitle`, `Coin`, `Literary`, `Experience`, `UserKnow`, `SignName0`, `SignDetail0`, `SignName1`, `SignDetail1`, `SignName2`, `SignDetail2`, `HavePic`, `PicFileName`, `ForumPerNum`, `PostPerNum`, `UserFrom`, `TimeZone`, `BirthYear`, `BirthMonth`, `BirthDay`, `ReceiveNote`, `AcceptFriend`, `ForumViewMode`, `Validated`, `GroupID`, `HiddenLogin`, `EditType`, `UserLocale`, `ValidateCode`) VALUES
('4028818208ed006b0108ed020bd50001','webmaster','webmaster','12345','827CCB0EEA8A706C4C34A16891F84E7B','webmaster@laoer.com','who?','webmaster','2006-08-18','2006-08-18','127.0.0.1',0,'2006-08-18','127.0.0.1',0,0,0,0,0,0,0,0,0,'','孔子东游，遇二小儿辩斗，问其故。 \r\n一小儿曰：我以日本生自山东，故属东。 \r\n一小儿曰：夕阳西下，日本归山西也明矣，是以属西。 \r\n孔子不能决，后以问老子（就是我）。 \r\n老子笑曰：孰为汝多知乎？日本无根基，岂能算东西 ！！','','天乙软件工作室\r\nhttp://www.laoer.com\r\n天乙社区\r\nhttp://bbscs.laoer.com\r\n天乙博客\r\nhttp://blog.laoer.com','',':3:',0,'',20,10,'上海','GMT+08:00',1980,1,1,1,1,2,1,5,0,-1,'zh_CN',NULL);
######
INSERT INTO `bbscs_userdetail` (`ID`, `Height`, `Weight`, `Interest`, `Graduate`, `FavourPeople`, `DreamJob`, `FavourArt`, `FavourMusic`, `FavourPlace`, `FavourMovie`, `FavourChat`, `FavourBook`, `DreamLover`, `FavourTeam`, `HomePage`, `OicqNo`, `IcqNo`, `MSN`, `Yahoo`, `Sex`, `Brief`) VALUES
('4028818208ed006b0108ed020bd50001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL);⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -