[SQL]Отчистка баз данных MSSQL

[Go-piratia]

---------------------------------------------------
-- Work accountserver
---------------------------------------------------
USE accountserver
TRUNCATE TABLE account_charge;
TRUNCATE TABLE account_login;
TRUNCATE TABLE account_pending;
TRUNCATE TABLE act_album;
TRUNCATE TABLE GameDBServerList;
TRUNCATE TABLE LogRandomAccount;
TRUNCATE TABLE safety;
TRUNCATE TABLE TradeRecord;
TRUNCATE TABLE user_log;
TRUNCATE TABLE UserAccountLogin;
--INSERT INTO account_login (name, password, originalPassword, email) VALUES ('Admin10','783C82F9D792A703364FF0D7B99EF8D8', 'zRraUghTaX', '[email protected]')
--INSERT INTO account_login (name, password, originalPassword, email) VALUES ('Admin11','783C82F9D792A703364FF0D7B99EF8D8', 'zRraUghTaX', '[email protected]') 
--INSERT INTO account_login (name, password, originalPassword, email) VALUES ('Admin12','783C82F9D792A703364FF0D7B99EF8D8', 'zRraUghTaX', '[email protected]') 
---------------------------------------------------
-- Work gamedb
---------------------------------------------------
USE gamedb
DELETE FROM account;
TRUNCATE TABLE AmphitheaterSetting;
TRUNCATE TABLE AmphitheaterTeam;
TRUNCATE TABLE birth_tab;
TRUNCATE TABLE boat;
TRUNCATE TABLE ChaGD;
DELETE FROM character;
TRUNCATE TABLE character_log;
TRUNCATE TABLE dtproperties;
TRUNCATE TABLE friends;
TRUNCATE TABLE IPAddress;
TRUNCATE TABLE item;
TRUNCATE TABLE Kop_MonthReport;
TRUNCATE TABLE LotterySetting;
TRUNCATE TABLE map_mask;
TRUNCATE TABLE master;
TRUNCATE TABLE param;
TRUNCATE TABLE personavatar;
TRUNCATE TABLE personinfo;
TRUNCATE TABLE property;
TRUNCATE TABLE Resource;
TRUNCATE TABLE stat_log;
TRUNCATE TABLE stat_log_hh;
TRUNCATE TABLE StatDegree;
TRUNCATE TABLE StatGender;
TRUNCATE TABLE StatJob;
TRUNCATE TABLE StatLogin;
TRUNCATE TABLE StatMap;
TRUNCATE TABLE Ticket;
TRUNCATE TABLE Trade_Log;
TRUNCATE TABLE weekreport;
TRUNCATE TABLE WinTicket;
DBCC CHECKIDENT ( character, RESEED, 0 );
INSERT INTO account (act_id, act_name, gm) VALUES ('1','Admin10', '99');
INSERT INTO account (act_id, act_name, gm) VALUES ('2','Admin11', '99');
INSERT INTO account (act_id, act_name, gm) VALUES ('3','Admin12', '99');
INSERT INTO character(cha_name, act_id, delflag) VALUES ('TestCharacter','1', '1') 

update character set guild_id = 0,guild_stat = 0,guild_permission = 0
delete guild
insert into guild (guild_id,guild_name,type) values(0,'NavyHQ',0)
insert into guild (guild_id,guild_name,type) values(1,'Navy Division 1',0)
insert into guild (guild_id,guild_name,type) values(2,'Navy Division 2',0)
insert into guild (guild_id,guild_name,type) values(3,'Navy Division 3',0)
insert into guild (guild_id,guild_name,type) values(4,'Navy Division 4',0)
insert into guild (guild_id,guild_name,type) values(5,'Navy Division 5',0)
insert into guild (guild_id,guild_name,type) values(6,'Navy Division 6',0)
insert into guild (guild_id,guild_name,type) values(7,'Navy Division 7',0)
insert into guild (guild_id,guild_name,type) values(8,'Navy Division 8 ',0)
insert into guild (guild_id,guild_name,type) values(9,'Navy Division 9',0)
insert into guild (guild_id,guild_name,type) values(10,'Navy Division 10',0)
 
declare @id int
select @id = 11
while @id < 100
begin
    insert into guild (guild_id,guild_name,type) values(@id,'Navy Division '+convert(varchar(2),@id),0)
    select @id = @id +1
end
 
insert into guild (guild_id,guild_name,type) values(101,'Pirate Guild 1',1)
insert into guild (guild_id,guild_name,type) values(102,'Pirate Guild 2',1)
insert into guild (guild_id,guild_name,type) values(103,'Pirate Guild 3',1)
insert into guild (guild_id,guild_name,type) values(104,'Pirate Guild 4',1)
insert into guild (guild_id,guild_name,type) values(105,'Pirate Guild 5',1)
insert into guild (guild_id,guild_name,type) values(106,'Pirate Guild 6',1)
insert into guild (guild_id,guild_name,type) values(107,'Pirate Guild 7',1)
insert into guild (guild_id,guild_name,type) values(108,'Pirate Guild 8',1)
insert into guild (guild_id,guild_name,type) values(109,'Pirate Guild 9',1)
insert into guild (guild_id,guild_name,type) values(110,'Pirate Guild 10',1)
 
select @id = 111
while @id < 200
begin
    insert into guild (guild_id,guild_name,type) values(@id,'Pirate Guild '+convert(varchar(2),@id-100),1)
    select @id =@id +1
end