initdb-oracle.sql

天乙虚拟社区8.05版本。只支持Mysql

INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UseFace','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UseForbid','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UseLinkToPages','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UsePass','0')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UsePm','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UsePostPeriodOfTime','0')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UseRegAuthCode','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UserOnlineTime','300')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UserPerPage','5,10,20,30,40')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UseSafeLogin','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UseScreen','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('UseSign','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('ViewAttachImg','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('VoteChange','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('VoteItemLength','150')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('VoteItemNum','10')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('VoteUpdatePost','1')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('WebmasterEmail','[e-mail]')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('WebName','天乙软件工作室')
######
INSERT INTO bbscs_config (ID, ConfContext) VALUES  ('WebUrl','http://www.laoer.com')
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES (1,9)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (2,9)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (2,13)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (3,9)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (3,13)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (4,1)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (4,9)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (4,13)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (5,4)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (5,5)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (5,6)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (5,7)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (5,8)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (5,9)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (5,12)
######
INSERT INTO bbscs_grouprole (GroupID, RoleID) VALUES  (5,13)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES (101,'后台主窗口权限','/adminMain','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (102,'查看后台导航权限','/adminLeft','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (103,'管理打开/关闭论坛权限','/adminOpenSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (104,'网站信息设置权限','/adminWebset','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (105,'基本设置权限','/adminBaseSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (106,'日期时间设置权限','/adminDateTimeFormatSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (107,'COOKIE和通行证设置权限','/adminCookiePassSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (108,'屏蔽选项设置权限','/adminScreenSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (109,'Email选项设置权限','/adminEmailSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (110,'用户注册选项设置权限','/adminUserRegSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (111,'用户资料选项设置权限','/adminUserProSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (112,'用户头像选项设置权限','/adminFaceSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (113,'用户禁止选项设置权限','/adminForbidSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (114,'发帖和编辑选项设置权限','/adminPostSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (115,'附件选项设置权限','/adminAttachSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (116,'投票选项设置权限','/adminVoteSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (117,'悄悄话选项设置权限','/adminPmSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (118,'主题列表显示选项设置权限','/adminForumViewSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (119,'主题内容显示选项设置权限','/adminPostViewSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (120,'隐藏帖选项设置权限','/adminPostHiddenSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (121,'在线时长设定权限','/adminUOTimeSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (122,'查看版区列表权限','/adminBoardList','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (123,'添加修改版区权限','/adminBoardSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (124,'查看版主列表权限','/adminBML','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (125,'添加修改版主权限','/adminBmSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (126,'查看权限列表权限','/adminPermission','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (127,'查看角色列表权限','/adminRoleList','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (128,'管理角色权限','/adminRoleSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (129,'查看用户组列表权限','/adminUgList','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (130,'用户组管理权限','/adminUgSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (131,'用户管理权限','/adminUserSearch','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (132,'版区权限设置权限','/adminBoardUg','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (133,'版区Tag设置权限','/adminBoardTag','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (134,'用户等级设置权限','/adminUserLevel','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (201,'查看社区主框架权限','/main','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (202,'查看社区左侧导航页权限','/nag','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (203,'修改签名权限','/signSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (204,'修改昵称权限','/nickNameSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (205,'个人参数设置权限','/userConfig','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (206,'朋友/黑名单设置权限','/friendSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (207,'悄悄话权限','/note','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (208,'书签管理权限','/bookMark','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (209,'头像设置权限','/userFace','index,uppage,up,delme',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (210,'查看用户头像权限','/userFace','showface',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (211,'修改个人详细资料权限','/userDetailSet','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (212,'进入社区首页权限','/in','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (213,'察看用户资料权限','/userInfo','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (214,'查看在线用户权限','/online','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (215,'全文搜索权限','/search','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (216,'修改密码权限','/cpasswd','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (217,'管理个人珍藏权限','/boardSaveManage','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (220,'社区首页管理','/inCoverManage','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (401,'查看讨论版权限','/forum','index',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (402,'查看热门帖权限','/forum','hot',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (403,'查看推荐帖权限','/forum','commend',2)
######