initdb.sql

一个jsp写的bbs

INSERT INTO `bbscs_config` (`ID`, `ConfContext`) VALUES
  ('AttachFileSize','3072'),
  ('AttachFileType','jpg,jpeg,gif,bmp,png,txt,rar,zip,doc,exe'),
  ('AttachImgRow','3'),
  ('AttachImgType','jpg,jpeg,gif,bmp,png'),
  ('AttachmentNum','10'),
  ('BestrowScreen','**'),
  ('BirthDateTimeFormat','yyyy-MM-dd'),
  ('CanDelAttachmentClosedPost','1'),
  ('CanDelAttachmentOverTime','1'),
  ('CanNotRegUserName','guest,webmaster,admin,administrator,fuck,shit,super'),
  ('CanNotUseNickName','[法].{0,3}[轮];[江].{0,3}[泽].{0,3}[民];[Ff].{0,2}[Uu].{0,2}[Cc].{0,2}[Kk];[Ss].{0,2}[Hh].{0,2}[Ii].{0,2}[Tt];[六].{0,3}[四];[李].{0,3}[宏].{0,3}[志];[李].{0,3}[洪].{0,3}[志];[大].{0,3}[法];[真].{0,3}[善].{0,3}[忍];[共].{0,3}[产].{0,3}[党];[中].{0,3}[共];[明].{0,3}[慧];[动].{0,3}[乱];[爆].{0,3}[乱];[版].{0,3}[主];[斑].{0,3}[竹];[管].{0,3}[理].{0,3}[员];[坛].{0,3}[主]'),
  ('CanSeePageNum','10'),
  ('CheckNewPm','0'),
  ('CheckRegUser','0'),
  ('CheckRegUserEmail','0'),
  ('CloseReson','Sorry，社区维护中，请稍候再访问...'),
  ('CookieDomain',''),
  ('CookieKey','nhNhwZ6X7xzgXnnZBxWFQLwCGQtJojL3'),
  ('CookiePath','/'),
  ('CopyRightMsg','www.laoer.com'),
  ('DateShowType','1'),
  ('DefaultTimeZone','26'),
  ('EditInterface','0'),
  ('EditPostLimit','0'),
  ('EditPostTitleLimit','14400'),
  ('FaceHigh','120'),
  ('FaceSize','50'),
  ('FaceWidth','120'),
  ('ForbidEmail','[e-mail]'),
  ('ForbidIP','61.129.89.99,61.129.89.98'),
  ('ForumDateTimeFormat','MM-dd HH:mm'),
  ('ForumHotRes','15'),
  ('ForumHotViews','100'),
  ('ForumName','天乙社区'),
  ('ForumPrePage','20'),
  ('ForumUrl','http://bbscs.laoer.com'),
  ('IsOpen','1'),
  ('LogIP','0'),
  ('LogoutUrl','/login'),
  ('MaxMultiPage','3'),
  ('MetaDescription','java开源社区'),
  ('MetaKeywords','laoer.com,天乙社区,开源,java,struts,hibernate,spring'),
  ('OpenUserReg','1'),
  ('OtherDateTimeFormat','yyyy-MM-dd HH:mm:ss'),
  ('PassChangeUrl','http://www.laoer.com/changPasswd.jsp'),
  ('PassRegUrl','http://www.laoer.com/reg.do'),
  ('PassUrl','http://www.laoer.com/login.do'),
  ('PmAllowFace','0'),
  ('PmAllowHTML','0'),
  ('PmAllowSmilies','1'),
  ('PmAllowUBB','0'),
  ('PmFloodTime','30'),
  ('PmMaxLength','3000'),
  ('PmPerPage','10'),
  ('PostCheckTime','0'),
  ('PostDateTimeFormat','yyyy-MM-dd HH:mm:ss'),
  ('PostDefFaceImg','images/icon1.gif'),
  ('PostHiddenTypeArtNum','1'),
  ('PostHiddenTypeMoney','1'),
  ('PostHiddenTypeRe','1'),
  ('PostMaxSize','150000'),
  ('PostMinSize','1'),
  ('PostPeriodOfTimeDay','0'),
  ('PostPeriodOfTimeEnd','20'),
  ('PostPeriodOfTimeStart','9'),
  ('PostPerPage','10'),
  ('PostPriceList','2,4,8,10,20,30'),
  ('PostPriceTax','0.5'),
  ('PostShowUserImg','1'),
  ('PostViewLength','300'),
  ('PostVoteRec','1'),
  ('PrivacyUrl',''),
  ('QuoteMaxSize','300'),
  ('ReduceAttachImg','1'),
  ('ReduceAttachImgSize','500'),
  ('RegDateTimeFormat','yyyy-MM-dd'),
  ('ScreenWord','[法].{0,3}[轮];[江].{0,3}[泽].{0,3}[民];[Ff].{0,2}[Uu].{0,2}[Cc].{0,2}[Kk];[Ss].{0,2}[Hh].{0,2}[Ii].{0,2}[Tt];[六].{0,3}[四];[李].{0,3}[宏].{0,3}[志];[李].{0,3}[洪].{0,3}[志];[大].{0,3}[法];[真].{0,3}[善].{0,3}[忍];[共].{0,3}[产].{0,3}[党];[中].{0,3}[共];[明].{0,3}[慧];[动].{0,3}[乱];[爆].{0,3}[乱]'),
  ('SenderEmail','[e-mail]'),
  ('SignMaxLen','500'),
  ('SignUseHtml','1'),
  ('SignUseSmile','1'),
  ('SignUseUBB','0'),
  ('SmtpAuth','1'),
  ('SmtpPasswd','a'),
  ('SmtpPort','25'),
  ('SmtpServer','smtp.163.com'),
  ('SmtpUser','laoer.'),
  ('TimeFormat','HH:mm'),
  ('UseEmail','1'),
  ('UseFace','1'),
  ('UseForbid','1'),
  ('UseLinkToPages','1'),
  ('UsePass','0'),
  ('UsePm','1'),
  ('UsePostPeriodOfTime','0'),
  ('UserOnlineTime','300'),
  ('UserPerPage','5,10,20,30,40'),
  ('UseSafeLogin','1'),
  ('UseScreen','1'),
  ('UseSign','1'),
  ('ViewAttachImg','1'),
  ('VoteChange','1'),
  ('VoteItemLength','150'),
  ('VoteItemNum','10'),
  ('VoteUpdatePost','1'),
  ('WebmasterEmail','[e-mail]'),
  ('WebName','天乙软件工作室'),
  ('WebUrl','http://www.laoer.com');
######
  INSERT INTO `bbscs_grouprole` (`GroupID`, `RoleID`) VALUES
  (1,9),
  (2,9),
  (2,13),
  (3,9),
  (3,13),
  (4,1),
  (4,9),
  (4,13),
  (5,4),
  (5,5),
  (5,6),
  (5,7),
  (5,8),
  (5,9),
  (5,12),
  (5,13);
######
INSERT INTO `bbscs_permission` (`ID`, `PermissionName`, `PermissionResource`, `Action`, `TypeID`) VALUES
  (101,'后台主窗口权限','/adminMain','*',0),
  (102,'查看后台导航权限','/adminLeft','*',0),
  (103,'管理打开/关闭论坛权限','/adminOpenSet','*',0),
  (104,'网站信息设置权限','/adminWebset','*',0),
  (105,'基本设置权限','/adminBaseSet','*',0),
  (106,'日期时间设置权限','/adminDateTimeFormatSet','*',0),
  (107,'COOKIE和通行证设置权限','/adminCookiePassSet','*',0),
  (108,'屏蔽选项设置权限','/adminScreenSet','*',0),
  (109,'Email选项设置权限','/adminEmailSet','*',0),
  (110,'用户注册选项设置权限','/adminUserRegSet','*',0),
  (111,'用户资料选项设置权限','/adminUserProSet','*',0),
  (112,'用户头像选项设置权限','/adminFaceSet','*',0),