USE [MuOnline]
GO

ALTER TABLE CHARACTER ADD nivel_gm tinyint NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD exp_war int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD patente smallint NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD fenix int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD eventos int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD reset_diario int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD reset_semanal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD reset_mensal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD mresets_diario int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD mresets_semanal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD mreset_mensal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD tempo int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD tempo_mensal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD Z_RankHR int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD Z_RankHR_semanal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD Z_RankHR_mensal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD Z_RankPK int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD Z_RankPK_semanal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD Z_RankPK_mensal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD bloc_reason nvarchar(200)
GO
ALTER TABLE CHARACTER ADD bloc_by nvarchar(10)
GO
ALTER TABLE CHARACTER ADD dia_bloc int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD evento int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD evento_dia int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD eventos_semanal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD eventos_mensal int NOT NULL DEFAULT (0)
GO
ALTER TABLE CHARACTER ADD tempo_exp int NOT NULL DEFAULT (0)
GO

ALTER TABLE GUILD ADD data smalldatetime NOT NULL DEFAULT (getdate())
GO

ALTER TABLE MEMB_INFO ALTER COLUMN memb_name varchar(30) NOT NULL
GO
ALTER TABLE MEMB_INFO ADD missoes int NOT NULL DEFAULT (1)
GO
ALTER TABLE MEMB_INFO ADD msg_num smallint NOT NULL DEFAULT (1)
GO
ALTER TABLE MEMB_INFO ADD msg_viu tinyint NOT NULL DEFAULT (0)
GO
ALTER TABLE MEMB_INFO ADD chat_desativar_img tinyint NOT NULL DEFAULT (0)
GO
ALTER TABLE MEMB_INFO ADD chat_desativar_news tinyint NOT NULL DEFAULT (0)
GO
ALTER TABLE MEMB_INFO ADD tempo_chat smallint NOT NULL DEFAULT (0)
GO
ALTER TABLE MEMB_INFO ADD whatsapp nvarchar(15)
GO
ALTER TABLE MEMB_INFO ADD img nvarchar(25)
GO
ALTER TABLE MEMB_INFO ADD code smallint NOT NULL DEFAULT (0)
GO
ALTER TABLE MEMB_INFO ADD ip_cadastro nvarchar(15)
GO
ALTER TABLE MEMB_INFO ADD bandeira nvarchar(10)
GO
ALTER TABLE TOP_DIARIO ADD rank smallint NOT NULL DEFAULT (1)
GO

ALTER TABLE MEMB_STAT ADD tempo int NOT NULL DEFAULT (0)
GO
ALTER TABLE MEMB_STAT ADD tempo_vip int NOT NULL DEFAULT (0)
GO

ALTER TABLE RankingBloodCastle ADD Score_semanal int NOT NULL DEFAULT (0)
GO
ALTER TABLE RankingChaosCastle ADD Score_semanal int NOT NULL DEFAULT (0)
GO
ALTER TABLE RankingDevilSquare ADD Score_semanal int NOT NULL DEFAULT (0)
GO
ALTER TABLE RankingDuel ADD winScore_semanal int NOT NULL DEFAULT (0)
GO

ALTER TABLE MEMB_INFO ADD DEFAULT 1 FOR sno__numb
GO



