up0b2to1b1.sql

一个jsp写的bbs

CREATE TABLE `bbscs_boardtag` (
  `ID` varchar(40) NOT NULL,
  `BoardID` bigint(20) NOT NULL,
  `TagName` varchar(255) NOT NULL,
  `Orders` int(11) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_forumbuy` (
  `ID` varchar(40) NOT NULL,
  `PostID` varchar(40) NOT NULL,
  `BuyFromID` varchar(40) NOT NULL,
  `BuyFromName` varchar(20) NOT NULL,
  `BuyToID` varchar(40) NOT NULL,
  `BuyToName` varchar(20) NOT NULL,
  `BuyPrice` int(11) NOT NULL default '0',
  `BuyToUserIncome` int(11) NOT NULL default '0',
  `BuyTime` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_userlevel` (
  `ID` varchar(40) NOT NULL,
  `LevelName` varchar(60) NOT NULL,
  `LevelValue` int(11) NOT NULL default '0',
  `LevelType` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
######
ALTER TABLE `bbscs_forum` ADD `TagID` VARCHAR( 40 ) NOT NULL DEFAULT '0',
ADD `TagName` VARCHAR( 255 ) NOT NULL ,
ADD `IsGuest` TINYINT( 1 ) NOT NULL DEFAULT '0';
######
ALTER TABLE `bbscs_forum_history` ADD `TagID` VARCHAR( 40 ) NOT NULL DEFAULT '0',
ADD `TagName` VARCHAR( 255 ) NOT NULL ,
ADD `IsGuest` TINYINT( 1 ) NOT NULL DEFAULT '0';
######
UPDATE `bbscs_forum_history` SET TagID = '0',IsGuest =0;
######
UPDATE `bbscs_userinfo` SET Coin =100;
######
update bbscs_permission set Action = "re,requote,addqre,addre,addrequote,buy" where id = 421;
######
INSERT INTO `bbscs_config` (`ID`, `ConfContext`) VALUES ('UsePostPeriodOfTime', '0');
######
INSERT INTO `bbscs_config` (`ID`, `ConfContext`) VALUES ('PostPeriodOfTimeStart', '8');
######
INSERT INTO `bbscs_config` (`ID`, `ConfContext`) VALUES ('PostPeriodOfTimeEnd', '20');
######
INSERT INTO `bbscs_config` (`ID`, `ConfContext`) VALUES ('PostPeriodOfTimeDay', '1');
######
INSERT INTO `bbscs_permission` (`ID`, `PermissionName`, `PermissionResource`, `Action`, `TypeID`) VALUES
(133,'版区Tag设置权限','/adminBoardTag','*',0),
  (134,'用户等级设置权限','/adminUserLevel','*',0);
######
update bbscs_role set Permissions = '103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,134' where id = 5;
######
update bbscs_role set Permissions = '122,123,124,125,132,133' where id = 6;
######
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);