initdb.sql

交易撮合系统是一套买卖信息沟通的平台

(113, '用户禁止选项设置权限', '/adminForbidSet', '*', 0),
(114, '发帖和编辑选项设置权限', '/adminPostSet', '*', 0),
(115, '附件选项设置权限', '/adminAttachSet', '*', 0),
(116, '投票选项设置权限', '/adminVoteSet', '*', 0),
(117, '悄悄话选项设置权限', '/adminPmSet', '*', 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,showiphistory', 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),
(415, '查看所有原始附件权限', '/read', 'attach', 2),
(416, '转移帖子权限', '/moveForum', '*', 2),
(420, '发帖权限', '/post', 'add,addsave', 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', 'addsave,add,edit,editdo', 2),
(431, '投票帖投票权限', '/oteOpt', '*', 2),
(432, '删除帖子附件权限', '/delAttach', '*', 2),
(433, '收藏版区权限', '/boardSave', '*', 2),
(434, '查看帖子订阅列表权限', '/subs', '*', 2),
(435, '版内搜索权限', '/forumSearch', '*', 2),
(440, '查看历史帖子主题权限', '/read', 'history,summaryhistory', 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),
(611, '发帖不用审核权限', '*', '*', 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','[e-mail]','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);