initdb-oracle.sql

一个jsp写的bbs

INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (403,'查看推荐帖权限','/forum','commend',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (404,'查看历史帖权限','/forum','history',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (405,'查看主题权限','/read','topic',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (406,'查看主题摘要权限','/read','summary',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (407,'查看用户IP权限','/read','showip',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (408,'显示帖子中附件权限','/read','showupfile',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (409,'显示帖子中投票权限','/read','showvote',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (410,'只看楼主权限','/read','own',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (411,'查看垃圾桶里帖子主题权限','/read','waste',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (412,'查看未审核帖子主题权限','/read','auditing',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (413,'查看未审核附件帖子主题权限','/read','auditingAttach',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (414,'查看精华区帖子主题权限','/read','elite',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (420,'发帖权限','/post','new,add',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (421,'回帖权限','/post','re,requote,addqre,addre,addrequote,buy',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (422,'上传附件权限','/post','upfile,upfileinput,upfiledo',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (423,'编辑帖子权限','/post','edit,editdo,showdelattachpage',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (424,'帖子赞成反对权限','/postOpt','votyes,votno',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (425,'订阅帖子权限','/postOpt','subs',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (426,'帖子打包权限','/postOpt','mailsend,mailsendtopic',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (427,'举报帖子权限','/postOpt','report',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (430,'发布修改投票帖权限','/votePost','new,add,edit,editdo',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (431,'投票帖投票权限','/oteOpt','*',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (432,'删除帖子附件权限','/delAttach','*',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (433,'收藏版区权限','/boardSave','*',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (434,'查看帖子订阅列表权限','/subs','*',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (435,'版内搜索权限','/forumSearch','*',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (440,'查看历史帖子主题权限','/readHistory','*',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (441,'给帖子投票权限','/voteOpt','*',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (450,'查看精华区权限','/refine','index,showelite,showflist',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (451,'管理精华区权限','/refine','manage,showelite,showflist,adddir,intodir,del,outdir,edit,editdo,deldir',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (460,'删除单个帖子权限','/postOpt','dela',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (462,'帖子置顶权限','/postOpt','top,untop',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (463,'M帖权限','/postOpt','cannotdel,candel',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (464,'推荐帖子权限','/postOpt','commend,uncommend',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (465,'锁定帖子权限','/postOpt','lock,unlock',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (466,'加入精华权限','/postOpt','elite',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (470,'版区管理权限','/forumManage','m,w,a,aa,dels,delw,delallw,resume,auditing,auditingAttach,delsnota,delsnotaa',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (471,'版区高级管理权限','/manageAdvance','index,forbiduser,bulletin,addauth,delauth',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (475,'版区封面管理权限','/coverManage','*',2)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (476,'查看社区统计权限','/sysNumStat','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (477,'查看用户列表权限','/userShow','*',0)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (601,'发帖时显示版区置顶选项权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (602,'可以使用彩色标题权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (603,'可直接查看隐藏帖内容权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (604,'不受发帖间隔时间限制','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (605,'高级-编辑所有帖子权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (606,'高级-删除所有帖子权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (607,'高级-删除附件权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (608,'不需要密码进入版区权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (609,'不需要授权进入版区权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (610,'可查看未审核附件权限','*','*',3)
######
INSERT INTO bbscs_permission (ID, PermissionName, PermissionResource, Action, TypeID) VALUES  (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')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (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')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (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')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (4,'后台可进行权限管理角色',0,'126,127,128,129,130')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (5,'后台可管理常规选项角色',0,'103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,134')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (6,'后台可管理版区角色',0,'122,123,124,125,132,133')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (7,'可进入后台管理角色',0,'101,102')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (8,'后台可管理用户角色',0,'131')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (9,'前台可进入社区用户角色',0,'201,202,212,213,214,215')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (10,'前台初级管理员角色',0,'901')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (11,'前台中级管理员角色',0,'901')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (12,'前台高级管理员角色',0,'220,476,477,901')
######
INSERT INTO bbscs_role (ID, RoleName, TypeID, Permissions) VALUES  (13,'前台可管理自己用户信息角色',0,'203,204,205,206,207,208,209,210,211,216,217')
######
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','[e-mail]','who?','webmaster',to_date('2006-08-18','yyyy-mm-dd'),to_date('2006-08-18','yyyy-mm-dd'),'127.0.0.1',0,to_date('2006-08-18','yyyy-mm-dd'),'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','')
######
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','','','','','','','','','','','','','','','','','','','',1,'')
######
INSERT INTO bbscs_usergroup (ID, GroupName, GroupDesc, TypeID) VALUES (1,'游客/未注册用户','',0)
######
INSERT INTO bbscs_usergroup (ID, GroupName, GroupDesc, TypeID) VALUES (2,'注册用户','',0)
######
INSERT INTO bbscs_usergroup (ID, GroupName, GroupDesc, TypeID) VALUES (3,'待验证用户','',0)
######
INSERT INTO bbscs_usergroup (ID, GroupName, GroupDesc, TypeID) VALUES (4,'超级版主','',0)
######
INSERT INTO bbscs_usergroup (ID, GroupName, GroupDesc, TypeID) VALUES (5,'系统管理员','',0)
######
INSERT INTO bbscs_usergroup (ID, GroupName, GroupDesc, TypeID) VALUES (6,'封禁用户','',0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES ('402881820ebb22b2010ebb2462550001','恶贯满盈',-500,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb335f010ebb344eee0001','犯事累累',-100,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb38d84f0001','不务正业',0,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb39143e0002','初出江湖',100,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES ('402881820ebb3806010ebb3961450003','新手上路',300,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb39f1120004','初级站友',800,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3a29d50005','中级站友',1500,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3a7a560006','高级站友',2500,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3ab9730007','青铜长老',5000,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3afd130008','白银长老',7000,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3b71880009','黄金长老',10000,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3bb0f2000a','白金长老',15000,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3be996000b','钻石长老',22000,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3c220b000c','资深元老',30000,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3c55ae000d','社区支柱',40000,0)
######
INSERT INTO bbscs_userlevel (ID, LevelName, LevelValue, LevelType) VALUES  ('402881820ebb3806010ebb3d6171000f','骨灰级元老',2147483647,0)