DELETE FROM [MEMB_INFO]
GO
DELETE FROM [AccountCharacter]
GO
DELETE FROM [Character]
GO
DELETE FROM [Guild]
GO
DELETE FROM [GuildMember]
GO
DELETE FROM [MEMB_STAT]
GO
DELETE FROM [OptionData]
GO
DELETE FROM [warehouse]
GO

create proc MY_CLEAR_NOCHARID
as

delete from memb_info  
  where memb___id in
  (select memb___id from memb_info
  left join character on (character.accountid=memb_info.memb___id)
  where character.accountid is null)

delete from vi_curr_info  
  where memb___id in
  (select memb___id from vi_curr_info
  left join character on (character.accountid=vi_curr_info.memb___id)
  where character.accountid is null )

delete from accountcharacter  
  where id in
  (select id from accountcharacter
  left join character on (character.accountid=accountcharacter.id)
  where character.accountid is null )

delete from warehouse  
  where accountid in
  (select warehouse.accountid from warehouse
  left join character on (character.accountid=warehouse.accountid)
  where character.accountid is null )

GO