棋牌游戏数据库清理脚本

自助开通VIP,整站资源任意下载

--------------------------------------------------------------------

-- 数据库清理脚本

-- 作者:小刘

-- 编写日期:20120-01-09

--------------------------------------------------------------------

--------------------------------------------------------------------

--------------------------------------------------------------------

-- 清空锁定的用户

TRUNCATE TABLE [QPTreasureDB].[dbo].[GameScoreLocker]

GO

--TRUNCATE TABLE [QPWeiQiDB].[dbo].[GameScoreLocker]

--GO

--清空所有用户的金币

TRUNCATE TABLE [QPTreasureDB].[dbo].[GameScoreInfo]

GO

--清除一些记录信息

TRUNCATE TABLE [QPTreasureDB].[dbo].[SystemStreamInfo]

GO

TRUNCATE TABLE [QPRecordDB].[dbo].[RecordConvertUserMedal]

GO

TRUNCATE TABLE[QPRecordDB].[dbo].[RecordGrantTreasure]

GO

TRUNCATE TABLE [QPRecordDB].[dbo].[RecordSendPresent]

GO

TRUNCATE TABLE [QPRecordDB].[dbo].[RecordSendProperty]

GO

TRUNCATE TABLE [QPPlatformManagerDB].[dbo].[SystemSecurity]

GO

TRUNCATE TABLE [QPPlatformDB].[dbo].[OnLineStreamInfo]

GO

TRUNCATE TABLE [QPNativeWebDB].[dbo].[News]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[AndroidManager]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[GameScoreInfo]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[GameScoreLocker]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[MatchInfo]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[SystemStreamInfo]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[StreamMatchHistory]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[StreamMatchFeeInfo]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[RecordUserInout]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[RecordDrawScore]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[RecordDrawInfo]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[RecordUserInout]

GO

TRUNCATE TABLE [QPGameMatchDB].[dbo].[SystemStreamInfo]

GO

TRUNCATE TABLE [QPAccountsDB].[dbo].[AccountsInfo]

GO

TRUNCATE TABLE [QPAccountsDB].[dbo].[IndividualDatum]

GO

TRUNCATE TABLE [QPAccountsDB].[dbo].[SystemGrantCount]

GO

TRUNCATE TABLE [QPAccountsDB].[dbo].[SystemStreamInfo]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[RecordInsure]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[RecordSpreadInfo]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[RecordDrawScore]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[RecordDrawInfo]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[AndroidManager]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[RecordUserInout]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[RecordUserInout]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[GlobalSpreadInfo]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[LivcardAssociator]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[LivcardBuildStream]

GO

TRUNCATE TABLE [QPTreasureDB].[dbo].[OnLineOrder]

GO

--------------------------------------------------------------------

棋牌游戏数据库清理脚本-第1张

----------------------------------------------------------------------

--初始化基本数据

USE [QPAccountsDB]

GO

--银行存取条件,存取金币数必须大于此数才可操作

UPDATE SystemStatusInfo SET StatusValue=50000 WHERE StatusName='BankPrerequisite'

GO

--更新注册送金币数量

UPDATE SystemStatusInfo SET StatusValue=25000 WHERE StatusName='GrantScoreCount'

GO

--银行转账条件,转账金币数必须大于此数才可转账

UPDATE SystemStatusInfo SET StatusValue=3600000 WHERE StatusName='TransferPrerequisite'

GO

--会员间转账是否收取手续费

UPDATE SystemStatusInfo SET StatusValue=1 WHERE StatusName='TransferNullity'

GO

--清理用户表中LIKE 'admin' 的记录

DELETE FROM [QPAccountsDB].dbo.AccountsInfo WHERE Accounts LIKE '%admin%'

GO

--清理用户表中LIKE '金商' 的记录

DELETE FROM [QPAccountsDB].dbo.AccountsInfo WHERE Accounts LIKE '%金商%' OR NickName LIKE '%金商%'

GO

--清理用户表中LIKE '机器人' 的记录

DELETE FROM [QPAccountsDB].dbo.AccountsInfo WHERE Accounts LIKE '%机器人%' OR NickName LIKE '%机器人%'

GO

---------------------------------------------------------------------

-- 会员卡类型

USE [QPTreasureDB]

GO

TRUNCATE TABLE GlobalLivcard

GO

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('水晶月卡',10,100000,1,30,512,0);

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('黄金半年卡',60,600000,2,180,512,0);

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('白金年卡',120,1200000,3,360,512,0);

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('金币充值',10,180000,0,0,0,0);

INSERT INTO GlobalLivcard(CardName,CardPrice,CardGold,MemberOrder,MemberDays,UserRight,ServiceRight) VALUES('金币充值',1,18000,0,0,0,0);

GO

-- 充值服务

TRUNCATE TABLE GlobalShareInfo

GO

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(1,'实卡充值','SK','实卡充值服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(2,'快钱充值','KQ','充值服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(3,'易宝充值','YB','易宝充值服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(4,'神州行充值','SZX','神州行服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(5,'联通卡充值','LT','联通卡服务');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(6,'电信卡充值','DX','电信卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(7,'盛大卡充值','SD','盛大卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(8,'征途卡充值','ZT','征途卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(9,'网易卡充值','WY','网易卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(10,'搜狐卡充值','SH','搜狐卡充值');

棋牌游戏数据库清理脚本-第2张

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(11,'完美卡充值','WM','完美卡充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(12,'声讯充值','SX','声讯充值');

INSERT INTO GlobalShareInfo(ShareID,ShareName,ShareAlias,ShareNote) VALUES(13,'骏网卡充值','SX','骏网卡充值');

GO


本站源码仅做学术研究,自娱自乐使用,不得用于赌博性质的非法商业用途!转载请说明出处!
棋牌资源网 » 棋牌游戏数据库清理脚本

发表评论

欢迎 访客 发表评论

这里有你所需要的,找专业的人做专业的事!

游戏演示 联系客服