USAR ESTA QUERY
USE GameDB
update character set guild_id = 0,guild_stat = 0,guild_permission = 0
delete guild
insert into guild (guild_id,guild_name,type) values(0,'Navy HQ3',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