USE [MuOnline]
GO
DROP PROCEDURE [dbo].[VERIFICAR_ITENS]
GO
DROP PROCEDURE [dbo].[chat_atualizar]
GO
DROP PROCEDURE [dbo].[WZ_GetMasterResetInfo]
GO
DROP PROCEDURE [dbo].[WZ_GetResetInfo]
GO
DROP PROCEDURE [dbo].[WZ_SetMasterResetInfo]
GO
DROP PROCEDURE [dbo].[WZ_SetResetInfo]
GO
DROP TABLE [dbo].[MK_Quest]
GO
DROP TABLE [dbo].[MK_MEDALHAS]
GO
DROP TABLE [dbo].[MK_Chat_online]
GO
DROP PROCEDURE [dbo].[EVENTO_ITENS]
GO
DROP PROCEDURE [dbo].[WZ_CS_ModifyTaxRate]
GO
DROP PROCEDURE [dbo].[WZ_GetAccountLevel]
GO
DROP TABLE [dbo].[MK_Chat_staff]
GO
DROP TABLE [dbo].[MK_DV]
GO
DROP TABLE [dbo].[MK_Reputacao]
GO
DROP TABLE [dbo].[MK_Server]
GO
DROP TABLE [dbo].[TOP_Diario]
GO
DROP TABLE [dbo].[TOP_Mensal]
GO
DROP TABLE [dbo].[TOP_Semanal]
GO
DROP TABLE [dbo].[MK_Mensagens]
GO
DROP TABLE [dbo].[MK_Mudar_Mail]
GO
DROP TABLE [dbo].[MK_Murkut_News]
GO
DROP TABLE [dbo].[MK_Online_today]
GO
DROP TABLE [dbo].[MK_Pagamentos]
GO
DROP TABLE [dbo].[LOG_ACESSO_N]
GO
DROP TABLE [dbo].[LOG_ADM]
GO
DROP TABLE [dbo].[LOG_AGRADECIMENTOS]
GO
DROP TABLE [dbo].[LOG_BAN]
GO
DROP TABLE [dbo].[LOG_BAU]
GO
DROP TABLE [dbo].[LOG_CADASTROS]
GO
DROP TABLE [dbo].[LOG_COMPRA_CREDITOS]
GO
DROP TABLE [dbo].[LOG_CREDITOS]
GO
DROP TABLE [dbo].[LOG_CUSTOM_ARENA]
GO
DROP TABLE [dbo].[LOG_DENUNCIAS]
GO
DROP TABLE [dbo].[LOG_DESBAN]
GO
DROP TABLE [dbo].[LOG_DUELO]
GO
DROP TABLE [dbo].[LOG_DUPE_EVENTO]
GO
DROP TABLE [dbo].[LOG_DV]
GO
DROP TABLE [dbo].[LOG_EVENTOS]
GO
DROP TABLE [dbo].[LOG_EVENTOS_ITENS]
GO
DROP TABLE [dbo].[LOG_GOLDS]
GO
DROP TABLE [dbo].[LOG_GUILDMEMBER]
GO
DROP TABLE [dbo].[LOG_MAIL]
GO
DROP TABLE [dbo].[LOG_NOME]
GO
DROP TABLE [dbo].[LOG_OBS]
GO
DROP TABLE [dbo].[LOG_ORDEM]
GO
DROP TABLE [dbo].[LOG_PAINEL]
GO
DROP TABLE [dbo].[LOG_RANK]
GO
DROP TABLE [dbo].[LOG_REI_MK]
GO
DROP TABLE [dbo].[LOG_SENHA_M]
GO
DROP TABLE [dbo].[LOG_SENHA_R]
GO
DROP TABLE [dbo].[LOG_STONES]
GO
DROP TABLE [dbo].[LOG_TRANSFERENCIA]
GO
DROP TABLE [dbo].[LOG_TRANSFERENCIA_CREDITOS]
GO
DROP TABLE [dbo].[LOG_USERONLINE]
GO
DROP TABLE [dbo].[LOG_VENDA_CONTA]
GO
DROP TABLE [dbo].[LOG_VIP]
GO
DROP TABLE [dbo].[LOG_VOTOS]
GO
DROP TABLE [dbo].[LOG_VOTOS2]
GO
DROP TABLE [dbo].[LOG_WAR]
GO
DROP TABLE [dbo].[LOG_XP_WAR]
GO
DROP TABLE [dbo].[MK_Character_GM]
GO
DROP TABLE [dbo].[MK_Chat]
GO
DROP TABLE [dbo].[MK_Chat_amigos]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Chat_amigos](
    [id_chat] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [login_amigo] [nvarchar](10) NOT NULL,
    [qtd_msgs] [INT] NOT NULL CONSTRAINT [DF_Chat_amigos_qtd_msgs]  DEFAULT ((0)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_Chat_amigos_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_Chat_amigos] PRIMARY KEY CLUSTERED
(
    [id_chat] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Chat](
    [id_chat] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [name] [nvarchar](10) NOT NULL,
    [msg] [nvarchar](140) NOT NULL,
    [DATA] [datetime] NOT NULL CONSTRAINT [DF_Chat_data]  DEFAULT (getdate()),
    [img] [nvarchar](15) NULL,
 CONSTRAINT [PK_Chat] PRIMARY KEY CLUSTERED
(
    [id_chat] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Character_GM](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [acc_gm] [nvarchar](10) NOT NULL,
    [acc_player] [nvarchar](10) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_Character_GM_data]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_XP_WAR](
    [id_xp] [INT] IDENTITY(1,1) NOT NULL,
    [guild] [nvarchar](10) NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_XP_WAR_data]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_WAR](
    [id_war] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [win] [nvarchar](10) NOT NULL,
    [lose] [nvarchar](10) NOT NULL,
    [ip] [CHAR](15) NULL,
    [DATA] [smalldatetime] NULL CONSTRAINT [DF_LOG_WAR_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_WAR] PRIMARY KEY CLUSTERED
(
    [id_war] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_VOTOS2](
    [id_voto] [INT] IDENTITY(1,1) NOT NULL,
    [login_fez] [nvarchar](10) NOT NULL,
    [login_recebeu] [nvarchar](10) NOT NULL,
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_VOTOS2_data]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_VOTOS](
    [id_voto] [INT] IDENTITY(1,1) NOT NULL,
    [login_fez] [nvarchar](10) NOT NULL,
    [login_recebeu] [nvarchar](10) NOT NULL,
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_VOTOS_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_VOTOS] PRIMARY KEY CLUSTERED
(
    [id_voto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_VIP](
    [id_vip] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [dias] [INT] NOT NULL,
    [tipo] [SMALLINT] NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_VIP_data]  DEFAULT (getdate()),
    [login_lan] [nvarchar](10) NULL,
 CONSTRAINT [PK_LOG_VIP] PRIMARY KEY CLUSTERED
(
    [id_vip] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_VENDA_CONTA](
    [id_venda] [INT] IDENTITY(1,1) NOT NULL,
    [conta] [nvarchar](10) NULL,
    [conta_comprou] [nvarchar](10) NULL,
    [conta_creditos] [nvarchar](10) NULL,
    [valor] [INT] NULL,
    [mail_antigo] [nvarchar](50) NULL,
    [mail_novo] [nvarchar](50) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_VENDA_CONTA_data]  DEFAULT (getdate()),
    [ip] [CHAR](15) NULL,
 CONSTRAINT [PK_LOG_VENDA_CONTA] PRIMARY KEY CLUSTERED
(
    [id_venda] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_USERONLINE](
    [TIMESTAMP] [INT] NOT NULL CONSTRAINT [DF_LOG_USERONLINE_timestamp]  DEFAULT ((0)),
    [ip] [nvarchar](15) NOT NULL,
    [file] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_TRANSFERENCIA_CREDITOS](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [login_destino] [nvarchar](10) NOT NULL,
    [valor] [INT] NOT NULL CONSTRAINT [DF_LOG_TRANSFERENCIA_CREDITOS_valor]  DEFAULT ((0)),
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_TRANSFERENCIA_CREDITOS_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_TRANSFERENCIA_CREDITOS] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_TRANSFERENCIA](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [CHAR] [nvarchar](10) NULL,
    [gameid] [nvarchar](10) NULL,
    [login_destino] [nvarchar](10) NOT NULL,
    [gameid_dest] [nvarchar](10) NULL,
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_TRANSFERENCIA_data]  DEFAULT (getdate()),
    [adm] [tinyint] NOT NULL CONSTRAINT [DF_LOG_TRANSFERENCIA_adm]  DEFAULT ((0)),
 CONSTRAINT [PK_LOG_TRANSFERENCIA] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_STONES](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [serial] [BINARY](4) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_STONES_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_STONES] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_SENHA_R](
    [id_senha] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [mail] [nvarchar](50) NULL,
    [ip] [CHAR](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_SENHA_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_SENHA] PRIMARY KEY CLUSTERED
(
    [id_senha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_SENHA_M](
    [id_mudar] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [antiga] [nvarchar](10) NULL,
    [ip] [CHAR](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_SENHA_M_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_SENHA_M] PRIMARY KEY CLUSTERED
(
    [id_mudar] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_REI_MK](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [name] [nvarchar](10) NOT NULL,
    [guild] [nvarchar](10) NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_REI_MK_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_Log_rei_mk] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_RANK](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [name] [nvarchar](10) NOT NULL,
    [tipo] [SMALLINT] NOT NULL,
    [posicao] [INT] NOT NULL,
 CONSTRAINT [PK_LOG_RANK] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_PAINEL](
    [id_painel] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [ip] [CHAR](15) NULL,
    [host] [nvarchar](50) NULL,
    [DATA] [smalldatetime] NULL CONSTRAINT [DF_LOG_PAINEL_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_PAINEL] PRIMARY KEY CLUSTERED
(
    [id_painel] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_ORDEM](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [posicao1] [nvarchar](10) NULL,
    [posicao2] [nvarchar](10) NULL,
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_ORDEM_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_ORDEM] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_OBS](
    [id_obs] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [obs] [nvarchar](150) NOT NULL,
    [mostrar] [tinyint] NOT NULL CONSTRAINT [DF_LOG_OBG_mostrar]  DEFAULT ((0)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_OBG_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_OBG] PRIMARY KEY CLUSTERED
(
    [id_obs] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_NOME](
    [login] [nvarchar](10) NOT NULL,
    [novo] [nvarchar](10) NOT NULL,
    [antigo] [nvarchar](10) NOT NULL,
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NULL CONSTRAINT [DF_LOG_NOME_data]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_MAIL](
    [id_mail] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [antigo] [nvarchar](50) NULL,
    [novo] [nvarchar](50) NULL,
    [ip] [CHAR](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_MAIL_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_MAIL] PRIMARY KEY CLUSTERED
(
    [id_mail] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_GUILDMEMBER](
    [id_historico] [INT] IDENTITY(1,1) NOT NULL,
    [name] [nvarchar](10) NOT NULL,
    [id_guild] [INT] NOT NULL CONSTRAINT [DF_LOG_GUILD_MEMBER_id_guild]  DEFAULT ((0)),
    [vitorias] [INT] NOT NULL CONSTRAINT [DF_LOG_GUILD_vitorias]  DEFAULT ((0)),
    [derrotas] [INT] NOT NULL CONSTRAINT [DF_LOG_GUILD_derrotas]  DEFAULT ((0)),
    [valor_compra] [INT] NOT NULL CONSTRAINT [DF_LOG_GUILD_valor_compra]  DEFAULT ((0)),
    [data_compra] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_GUILDMEMBER_data_compra]  DEFAULT (getdate()),
    [saiu] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_GUILDMEMBER_saiu]  DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_GOLDS](
    [login] [nvarchar](10) NOT NULL,
    [name] [nvarchar](10) NOT NULL,
    [name_destino] [nvarchar](10) NOT NULL,
    [valor] [INT] NOT NULL CONSTRAINT [DF_LOG_GOLDS_valor]  DEFAULT ((0)),
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_GOLDS_data]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_EVENTOS_ITENS](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [tipo] [SMALLINT] NOT NULL,
    [qtd] [INT] NOT NULL CONSTRAINT [DF_LOG_EVENTOS_ITENS_qtd]  DEFAULT ((0)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_EVENTOS_ITENS_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_EVENTOS_ITENS] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_EVENTOS](
    [id_gold] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [login_char] [nvarchar](10) NOT NULL,
    [personagem] [nvarchar](10) NOT NULL,
    [tipo] [INT] NOT NULL,
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_EVENTOS_data]  DEFAULT (getdate()),
    [valor] [INT] NOT NULL CONSTRAINT [DF_LOG_EVENTOS_valor]  DEFAULT ((0)),
 CONSTRAINT [PK_LOG_EVENTOS] PRIMARY KEY CLUSTERED
(
    [id_gold] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_DV](
    [id_dv] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [login_dv] [nvarchar](10) NOT NULL,
    [mail] [nvarchar](50) NOT NULL,
    [ativo] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_DV_ativo]  DEFAULT ((0)),
    [invalido] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_DV_invalido]  DEFAULT ((0)),
    [ip] [CHAR](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_DV_data]  DEFAULT (getdate()),
    [criou] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_DV_criou]  DEFAULT ((0)),
    [resetou] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_DV_resetou]  DEFAULT ((0)),
    [depositou] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_DV_depositou]  DEFAULT ((0)),
 CONSTRAINT [PK_LOG_DV] PRIMARY KEY CLUSTERED
(
    [id_dv] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_DUPE_EVENTO](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [serial] [BINARY](4) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_DUPE_EVENTO_data]  DEFAULT (getdate()),
    [evento] [NCHAR](20) NULL,
 CONSTRAINT [PK_LOG_DUPE_EVENTO] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_DUELO](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [vencedor] [nvarchar](10) NULL,
    [perdedor] [nvarchar](10) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_DUELO_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_DUELO] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_DESBAN](
    [id_desban] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [desbanido] [nvarchar](10) NOT NULL,
    [ip] [nvarchar](15) NULL,
    [DATA] [smalldatetime] NULL CONSTRAINT [DF_LOG_DESBAN_data]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_DENUNCIAS](
    [id_acc] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [mostrar] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_DENUNCIAS_mostrar]  DEFAULT ((0)),
    [qtd] [INT] NOT NULL CONSTRAINT [DF_LOG_DENUNCIAS_qtd]  DEFAULT ((0)),
 CONSTRAINT [PK_LOG_DENUNCIAS] PRIMARY KEY CLUSTERED
(
    [id_acc] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_CUSTOM_ARENA](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](10) NOT NULL,
    [Valor] [INT] NOT NULL CONSTRAINT [DF_LOG_CUSTOM_ARENA_Valor]  DEFAULT ((0)),
    [arena] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_CUSTOM_ARENA_arena]  DEFAULT ((0)),
    [rank] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_CUSTOM_ARENA_rank]  DEFAULT ((1)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_Table_1_data]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_CREDITOS](
    [id_creditos] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [valor] [INT] NOT NULL CONSTRAINT [DF_LOG_CREDITOS_valor]  DEFAULT ((0)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_CREDITOS_data]  DEFAULT (getdate()),
    [ip] [CHAR](15) NULL,
    [tipo] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_CREDITOS_tipo]  DEFAULT ((0)),
 CONSTRAINT [PK_LOG_CREDITOS] PRIMARY KEY CLUSTERED
(
    [id_creditos] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_COMPRA_CREDITOS](
    [id_c] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [nome] [nvarchar](10) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_COMPRA_CREDITOS_data]  DEFAULT (getdate())
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_CADASTROS](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [ip] [CHAR](15) NULL,
    [host] [nvarchar](50) NULL,
    [navegador] [nvarchar](110) NULL,
    [cookie1] [nvarchar](20) NULL,
    [cookie2] [nvarchar](20) NULL,
    [DATA] [smalldatetime] NULL CONSTRAINT [DF_LOG_CADASTROS_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_CADASTROS] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_BAU](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_BAU_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_BAU] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_BAN](
    [id_ban] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [name] [nvarchar](10) NULL,
    [reason] [nvarchar](200) NULL,
    [gm] [nvarchar](10) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_BAN_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_BAN] PRIMARY KEY CLUSTERED
(
    [id_ban] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LOG_AGRADECIMENTOS](
    [id_agr] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [login_r] [nvarchar](10) NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_LOG_AGRADECIMENTOS_data]  DEFAULT (getdate()),
    [ip] [nvarchar](15) NULL,
 CONSTRAINT [PK_LOG_AGRADECIMENTOS] PRIMARY KEY CLUSTERED
(
    [id_agr] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_ADM](
    [id_adm] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [ip] [CHAR](15) NULL,
    [valor] [nvarchar](50) NULL,
    [valor2] [nvarchar](50) NULL,
    [tipo] [SMALLINT] NULL,
    [DATA] [smalldatetime] NULL CONSTRAINT [DF_LOG_ADM_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_ADM] PRIMARY KEY CLUSTERED
(
    [id_adm] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MK_Despesas](
    [id_desp] [INT] IDENTITY(1,1) NOT NULL,
    [despesa] [nvarchar](30) NOT NULL,
    [valor_despesa] [INT] NOT NULL,
    [data_pg] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_Despesas] PRIMARY KEY CLUSTERED
(
    [id_desp] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[MK_Despesas] ADD  DEFAULT ((0)) FOR [valor_despesa]
GO

ALTER TABLE [dbo].[MK_Despesas] ADD  DEFAULT (getdate()) FOR [data_pg]
GO

CREATE TABLE [dbo].[LOG_ACESSO_N](
    [id_acesso] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NULL,
    [senha] [nvarchar](10) NULL,
    [tipo] [SMALLINT] NOT NULL CONSTRAINT [DF_LOG_ACESSO_N_tipo]  DEFAULT ((1)),
    [ip] [CHAR](15) NULL,
    [DATA] [smalldatetime] NULL CONSTRAINT [DF_LOG_ACESSO_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_LOG_ACESSO] PRIMARY KEY CLUSTERED
(
    [id_acesso] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MK_Pagamentos](
    [id_pg] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [DATA] [CHAR](10) NOT NULL,
    [hora] [CHAR](10) NOT NULL,
    [terminal] [CHAR](20) NOT NULL,
    [conta] [CHAR](30) NOT NULL,
    [valor] [CHAR](10) NOT NULL,
    [dados] [text] NOT NULL,
    [valor_depositado] [INT] NOT NULL CONSTRAINT [DF_Pagamentos_valor_depositado]  DEFAULT ((0)),
    [valor_confirmado] [INT] NOT NULL CONSTRAINT [DF_Pagamentos_valor_confirmado]  DEFAULT ((0)),
    [ip] [CHAR](15) NULL,
    [data_pg] [smalldatetime] NOT NULL CONSTRAINT [DF_Pagamentos_data_pg]  DEFAULT (getdate()),
    [confirmado] [SMALLINT] NOT NULL CONSTRAINT [DF_Pagamentos_confirmado]  DEFAULT ((0)),
    [respondido] [SMALLINT] NOT NULL CONSTRAINT [DF_Pagamentos_respondido]  DEFAULT ((0)),
 CONSTRAINT [PK_Pagamentos] PRIMARY KEY CLUSTERED
(
    [id_pg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Online_today](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [quant] [INT] NOT NULL CONSTRAINT [DF_Online_today_quant]  DEFAULT ((0)),
    [quant2] [INT] NOT NULL CONSTRAINT [DF_Online_today_quant2]  DEFAULT ((0)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_Online_today_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_Online_today] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Murkut_News](
    [id_news] [INT] IDENTITY(1,1) NOT NULL,
    [nome] [nvarchar](10) NULL,
    [valor] [nvarchar](20) NULL,
    [valor2] [nvarchar](25) NULL,
    [tipo] [INT] NOT NULL,
    [DATA] [datetime] NOT NULL CONSTRAINT [DF_Murkut_News_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_Murkut_News] PRIMARY KEY CLUSTERED
(
    [id_news] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MK_Mudar_Mail](
    [login] [nvarchar](10) NOT NULL,
    [antigo] [nvarchar](50) NOT NULL,
    [novo] [nvarchar](50) NOT NULL,
    [dias] [INT] NOT NULL CONSTRAINT [DF_Mudar_Mail_dias]  DEFAULT ((0)),
    [ip] [CHAR](15) NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_Mudar_Mail_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_Mudar_Mail] PRIMARY KEY CLUSTERED
(
    [login] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MK_Mensagens](
    [id_msg] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [login_r] [nvarchar](10) NOT NULL,
    [msg] [text] NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_Mensagens_data]  DEFAULT (getdate()),
    [respondido] [SMALLINT] NOT NULL CONSTRAINT [DF_Mensagens_respondido]  DEFAULT ((0)),
    [suporte] [tinyint] NOT NULL CONSTRAINT [DF_MK_Mensagens_suporte]  DEFAULT ((0)),
    [viu] [SMALLINT] NOT NULL CONSTRAINT [DF_Mensagens_viu]  DEFAULT ((0)),
    [removeu1] [VARCHAR](10) NULL,
    [removeu2] [VARCHAR](10) NULL,
 CONSTRAINT [PK_Mensagens] PRIMARY KEY CLUSTERED
(
    [id_msg] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TOP_Semanal](
    [id_top] [INT] IDENTITY(1,1) NOT NULL,
    [nome] [VARCHAR](10) NOT NULL,
    [dado] [INT] NOT NULL,
    [tipo] [SMALLINT] NOT NULL,
    [rank] [SMALLINT] NOT NULL CONSTRAINT [DF_TOP_Semanal_rank]  DEFAULT ((1)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_TOP_Semanal_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_TOP_Semanal] PRIMARY KEY CLUSTERED
(
    [id_top] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TOP_Mensal](
    [id_top] [INT] IDENTITY(1,1) NOT NULL,
    [nome] [VARCHAR](10) NOT NULL,
    [dado] [INT] NOT NULL,
    [tipo] [SMALLINT] NOT NULL,
    [rank] [SMALLINT] NOT NULL CONSTRAINT [DF_TOP_Mensal_rank]  DEFAULT ((1)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_TOP_Mensal_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_TOP_Mensal] PRIMARY KEY CLUSTERED
(
    [id_top] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TOP_Diario](
    [id_topd] [INT] IDENTITY(1,1) NOT NULL,
    [nome] [nvarchar](10) NOT NULL,
    [dado] [INT] NOT NULL,
    [tipo] [SMALLINT] NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_TOP_Diario_data]  DEFAULT (getdate()),
 CONSTRAINT [PK_TOP_Diario] PRIMARY KEY CLUSTERED
(
    [id_topd] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Server](
    [rei_do_mk] [SMALLINT] NOT NULL CONSTRAINT [DF_Server_rei_do_mk]  DEFAULT ((0)),
    [recorde_on] [INT] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MK_Reputacao](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [login_r] [nvarchar](10) NOT NULL,
    [reputacao] [CHAR](1) NOT NULL CONSTRAINT [DF_Reputacao_reputacao]  DEFAULT ('P'),
    [comentario] [nvarchar](200) NULL,
 CONSTRAINT [PK_Reputacao] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MK_DV](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [VARCHAR](10) NOT NULL,
    [link] [nvarchar](250) NOT NULL,
    [valor] [tinyint] NOT NULL CONSTRAINT [DF_MK_DV_valor]  DEFAULT ((0)),
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_MK_DV_data]  DEFAULT (getdate()),
    [invalida] [tinyint] NOT NULL CONSTRAINT [DF_MK_DV_invalida]  DEFAULT ((0)),
 CONSTRAINT [PK_MK_DV] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Chat_staff](
    [id_chat] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](20) NOT NULL,
    [name] [nvarchar](20) NOT NULL,
    [msg] [nvarchar](70) NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_Chat_staff_data]  DEFAULT (getdate()),
    [server] [SMALLINT] NOT NULL CONSTRAINT [DF_Chat_staff_server]  DEFAULT ((0)),
 CONSTRAINT [PK_Chat_staff] PRIMARY KEY CLUSTERED
(
    [id_chat] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WZ_GetAccountLevel]
@Account VARCHAR(10)
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON


DECLARE @CurrentAccountLevel INT
DECLARE @CurrentAccountExpireDate smalldatetime

SELECT @CurrentAccountLevel = AccountLevel, @CurrentAccountExpireDate = AccountExpireDate FROM MEMB_INFO WHERE memb___id = @account

IF (@CurrentAccountLevel <> 0 AND GETDATE() > @CurrentAccountExpireDate)
BEGIN
    SET @CurrentAccountLevel = 0
    UPDATE MEMB_INFO SET AccountLevel = @CurrentAccountLevel WHERE memb___id = @account
END

SELECT @CurrentAccountLevel AS AccountLevel, @CurrentAccountExpireDate AS AccountExpireDate


SET NOCOUNT OFF
SET XACT_ABORT OFF

END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--
-- Definition for stored procedure WZ_CS_ModifyTaxRate :
--

--//************************************************************************
--// << ? ??? - ?? ???? >>
--//
--// ?? : ?? ? (????) ? ??? ????.
--// ?? : ???? 1?
--// ???    : 2004.11.09
--// ???    : ???
--//
--//************************************************************************

CREATE PROCEDURE    [dbo].[WZ_CS_ModifyTaxRate]
    @iMapSvrGroup       SMALLINT,   -- ??? ??
    @iTaxKind       INT,        -- ??? ?? (1:????? / 2:??)
    @iTaxRate       INT     -- ??? ??
AS
BEGIN
    BEGIN TRANSACTION

    SET NOCOUNT ON

    IF (@iTaxKind = 1)          -- ??? ?? ????
    BEGIN
        IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_DATA  WITH (READUNCOMMITTED)
                    WHERE MAP_SVR_GROUP = @iMapSvrGroup)
        BEGIN
            UPDATE MuCastle_DATA
            SET TAX_RATE_CHAOS = 0
            WHERE MAP_SVR_GROUP = @iMapSvrGroup

            SELECT @iTaxKind AS TaxKind, 1 AS QueryResult, TAX_RATE_CHAOS AS TaxRate    -- ????? ??? ???? ????? ????.
            FROM MuCastle_DATA
            WHERE MAP_SVR_GROUP = @iMapSvrGroup
        END
        ELSE
        BEGIN
            SELECT @iTaxKind AS TaxKind, 0 AS QueryResult, 0 AS TaxRate             -- ????? ??? ???? ???? ????? ????.
        END
    END
    ELSE IF (@iTaxKind = 2)         -- ?? ?? ??
    BEGIN
        IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_DATA  WITH (READUNCOMMITTED)
                    WHERE MAP_SVR_GROUP = @iMapSvrGroup)
        BEGIN
            UPDATE MuCastle_DATA
            SET TAX_RATE_STORE = 0 -- @iTaxRate
            WHERE MAP_SVR_GROUP = @iMapSvrGroup

            SELECT @iTaxKind AS TaxKind, 1 AS QueryResult, TAX_RATE_STORE AS TaxRate    -- ????? ??? ???? ????? ????.
            FROM MuCastle_DATA
            WHERE MAP_SVR_GROUP = @iMapSvrGroup
        END
        ELSE
        BEGIN
            SELECT @iTaxKind AS TaxKind, 0 AS QueryResult, 0 AS TaxRate             -- ????? ??? ???? ???? ????? ????.
        END
    END
    ELSE IF (@iTaxKind = 3)         -- ??? ??? ?? ??
    BEGIN
        IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_DATA  WITH (READUNCOMMITTED)
                    WHERE MAP_SVR_GROUP = @iMapSvrGroup)
        BEGIN
            UPDATE MuCastle_DATA
            SET TAX_HUNT_ZONE = 0 --@iTaxRate
            WHERE MAP_SVR_GROUP = @iMapSvrGroup

            SELECT @iTaxKind AS TaxKind, 1 AS QueryResult, TAX_HUNT_ZONE AS TaxRate -- ????? ??? ???? ????? ????.
            FROM MuCastle_DATA
            WHERE MAP_SVR_GROUP = @iMapSvrGroup
        END
        ELSE
        BEGIN
            SELECT @iTaxKind AS TaxKind, 0 AS QueryResult, 0 AS TaxRate             -- ????? ??? ???? ???? ????? ????.
        END
    END
    ELSE
    BEGIN
        SELECT @iTaxKind AS TaxKind, 0 AS QueryResult, 0 AS TaxRate                 -- ????? ???? ???.
    END


    IF(@@Error <> 0 )
        ROLLBACK TRANSACTION
    ELSE
        COMMIT TRANSACTION

    SET NOCOUNT OFF
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[EVENTO_ITENS]
@uid VARCHAR(20),
@tip INT
AS

BEGIN

SET NoCOUNT ON
DECLARE
@wh_acid VARCHAR(10),
@wh_data BINARY(1920),
@wh_type BINARY(2),
@wh_full BINARY(1),
@wh_serial BINARY(4),
@wj_serial BINARY(4),
@wh_13 BINARY(1),
@k INT,
@j INT,
@qtd INT,
@find INT,
@conn INT

SELECT @conn = (SELECT top 1 connectstat FROM memb_stat WHERE memb___id=@uid)

SET @k=0
SET @qtd=0

IF @conn = 0
BEGIN
--Verifica Baú
SELECT @wh_data=items FROM warehouse WHERE accountid = @uid


WHILE @k<120 AND @wh_data IS NOT NULL
BEGIN
SET @wh_type=SUBSTRING(@wh_data,@k*16+1,2)
SET @wh_serial=SUBSTRING(@wh_data,@k*16+4,4)
SET @wh_13=SUBSTRING(@wh_data,@k*16+8,1)
SET @k=@k+1

IF
@wh_type = 0xCB60
BEGIN
SET @find=0
SET @j=0

    WHILE @j < (@k-1)
        BEGIN
            SET @wj_serial=SUBSTRING(@wh_data,@j*16+4,4)
            SET @j=@j+1

                IF @wj_serial = @wh_serial
                    BEGIN
                        SET @find=1
                        INSERT INTO LOG_DUPE_EVENTO (login,serial,evento) VALUES (@uid, @wj_serial,'K5')
                    END
        END

IF @wh_serial = 0x00000000
BEGIN
SET @wh_data = SUBSTRING(@wh_data ,1,16*@j)+0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF+SUBSTRING(@wh_data,16*@j+11,len(@wh_data))
UPDATE [warehouse] SET [items]=@wh_data WHERE [AccountId]=@uid
END

IF @find=0 AND @wh_serial<>0x00000000
    BEGIN
        SET @qtd = @qtd+1
    END

END
END
END

SELECT @qtd AS qtd

END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Chat_online](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [DATA] [smalldatetime] NOT NULL CONSTRAINT [DF_Chat_online_data]  DEFAULT (getdate()),
    [img] [nvarchar](25) NULL,
 CONSTRAINT [PK_Chat_online] PRIMARY KEY CLUSTERED
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_MEDALHAS](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [login] [nvarchar](10) NOT NULL,
    [Name] [nvarchar](10) NOT NULL,
    [medal_evento] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_evento]  DEFAULT ((0)),
    [medal_resets] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_resets]  DEFAULT ((0)),
    [medal_mresets] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_mresets]  DEFAULT ((0)),
    [medal_tempo] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_tempo]  DEFAULT ((0)),
    [medal_sresets] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_sresets]  DEFAULT ((0)),
    [medal_smresets] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_smresets]  DEFAULT ((0)),
    [medal_pk] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_pk]  DEFAULT ((0)),
    [medal_exp] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_exp]  DEFAULT ((0)),
    [medal_gm] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_gm]  DEFAULT ((0)),
    [medal_reputacao] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_reputacao]  DEFAULT ((0)),
    [medal_evento_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_evento_m]  DEFAULT ((0)),
    [medal_resets_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_resets_m]  DEFAULT ((0)),
    [medal_mresets_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_mresets_m]  DEFAULT ((0)),
    [medal_tempo_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_tempo_m]  DEFAULT ((0)),
    [medal_pk_m] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_pk_m]  DEFAULT ((0)),
    [medal_ds] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_ds]  DEFAULT ((0)),
    [medal_ds_s] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_ds_s]  DEFAULT ((0)),
    [medal_rei] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_rei]  DEFAULT ((0)),
    [medal_duel_semanal] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_5]  DEFAULT ((0)),
    [medal_duel] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel]  DEFAULT ((0)),
    [medal_missao] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1]  DEFAULT ((0)),
    [medal_bc] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_1]  DEFAULT ((0)),
    [medal_vip] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_2]  DEFAULT ((0)),
    [medal_contribuinte] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_3]  DEFAULT ((0)),
    [medal_rei_conquistas] [tinyint] NOT NULL CONSTRAINT [DF_Character_medal_duel1_4]  DEFAULT ((0)),
    [medal_bc_s] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_bc_s]  DEFAULT ((0)),
    [medal_hr] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_hr]  DEFAULT ((0)),
    [medal_hr_m] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_hr_m]  DEFAULT ((0)),
    [medal_cc_s] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_cc_s]  DEFAULT ((0)),
    [medal_joias] [tinyint] NOT NULL CONSTRAINT [DF_MK_MEDALHAS_medal_joias]  DEFAULT ((0)),
 CONSTRAINT [PK_LOginName] PRIMARY KEY CLUSTERED
(
    [login] ASC,
    [Name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MK_Quest](
    [Name] [nvarchar](10) NOT NULL,
    [quest1] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest1]  DEFAULT ((0)),
    [quest2] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest2]  DEFAULT ((0)),
    [quest3] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest3]  DEFAULT ((0)),
    [quest4] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest4]  DEFAULT ((0)),
    [quest5] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest5]  DEFAULT ((0)),
    [quest6] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest6]  DEFAULT ((0)),
    [quest7] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest7]  DEFAULT ((0)),
    [quest8] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest8]  DEFAULT ((0)),
    [quest9] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest9]  DEFAULT ((0)),
    [quest10] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest10]  DEFAULT ((0)),
    [quest11] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest11]  DEFAULT ((0)),
    [quest12] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest12]  DEFAULT ((0)),
    [quest13] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest13]  DEFAULT ((0)),
    [quest14] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest14]  DEFAULT ((0)),
    [quest15] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest15]  DEFAULT ((0)),
    [quest16] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest16]  DEFAULT ((0)),
    [quest17] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest17]  DEFAULT ((0)),
    [quest18] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest18]  DEFAULT ((0)),
    [quest19] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest19]  DEFAULT ((0)),
    [quest20] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest20]  DEFAULT ((0)),
    [nivel] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_nivel]  DEFAULT ((0)),
    [quest21] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest21]  DEFAULT ((0)),
    [quest22] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest22]  DEFAULT ((0)),
    [quest23] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest23]  DEFAULT ((0)),
    [quest24] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest24]  DEFAULT ((0)),
    [quest25] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest25]  DEFAULT ((0)),
    [quest26] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest26]  DEFAULT ((0)),
    [quest27] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest27]  DEFAULT ((0)),
    [quest28] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest28]  DEFAULT ((0)),
    [quest29] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest29]  DEFAULT ((0)),
    [quest30] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest30]  DEFAULT ((0)),
    [quest31] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest31]  DEFAULT ((0)),
    [quest32] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest32]  DEFAULT ((0)),
    [quest33] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest33]  DEFAULT ((0)),
    [quest34] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest34]  DEFAULT ((0)),
    [quest35] [SMALLINT] NOT NULL CONSTRAINT [DF_Quest_quest35]  DEFAULT ((0)),
 CONSTRAINT [PK_Quest] PRIMARY KEY CLUSTERED
(
    [Name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WZ_SetResetInfo]
@Account VARCHAR(10),
@Name VARCHAR(10),
@Reset INT,
@ResetDay INT,
@ResetWek INT,
@ResetMon INT
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

SET @Reset = 1

UPDATE CHARACTER SET ResetCount=ResetCount+@Reset, reset_diario = reset_diario +@Reset, reset_semanal = reset_semanal +@Reset, reset_mensal = reset_mensal+@Reset
 WHERE AccountID=@Account AND Name=@Name

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WZ_SetMasterResetInfo]
@Account VARCHAR(10),
@Name VARCHAR(10),
@Reset INT,
@MasterReset INT,
@MasterResetDay INT,
@MasterResetWek INT,
@MasterResetMon INT
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

SET @Reset = 1

UPDATE CHARACTER SET MasterResetCount=MasterResetCount+@Reset,mresets_diario=mresets_diario+@Reset, mresets_semanal = mresets_semanal +@Reset, mreset_mensal = mreset_mensal+@Reset, exp_war = exp_war +30
 WHERE AccountID=@Account AND Name=@Name

UPDATE CashShopData SET WCoinP = WCoinP + 10, GoblinPoint = GoblinPoint+30 WHERE AccountID=@Account

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WZ_GetResetInfo]
@Account VARCHAR(10),
@Name VARCHAR(10)
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @Reset INT
DECLARE @ResetDay INT
DECLARE @ResetWek INT
DECLARE @ResetMon INT

SELECT @Reset=ResetCount,@ResetDay=0,@ResetWek=0,@ResetMon=0 FROM CHARACTER WHERE AccountID=@Account AND Name=@Name

SELECT @Reset AS Reset,@ResetDay AS ResetDay,@ResetWek AS ResetWek,@ResetMon AS ResetMon

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WZ_GetMasterResetInfo]
@Account VARCHAR(10),
@Name VARCHAR(10)
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @MasterReset INT
DECLARE @MasterResetDay INT
DECLARE @MasterResetWek INT
DECLARE @MasterResetMon INT

SELECT @MasterReset=MasterResetCount,@MasterResetDay=0,@MasterResetWek=0,@MasterResetMon=0 FROM CHARACTER WHERE AccountID=@Account AND Name=@Name

SELECT @MasterReset AS MasterReset,@MasterResetDay AS MasterResetDay,@MasterResetWek AS MasterResetWek,@MasterResetMon AS MasterResetMon

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[chat_atualizar]
@acc VARCHAR(10)
AS
BEGIN

IF NOT EXISTS (SELECT login FROM MK_chat_online WHERE login = @acc)
    INSERT INTO MK_Chat_online (login) VALUES (@acc)
ELSE
    UPDATE MK_Chat_online SET DATA = (getdate()) WHERE login = @acc

END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[VERIFICAR_ITENS]
@uid VARCHAR(20),
@TYPE BINARY(2)
AS

BEGIN

SET NoCOUNT ON
DECLARE
@wh_acid VARCHAR(10),
@wh_data BINARY(3840),
@wh_type BINARY(2),
@wh_full BINARY(1),
@wh_serial BINARY(4),
@wj_serial BINARY(4),
@wh_13 BINARY(1),
@k INT,
@j INT,
@qtd INT,
@find INT,
@conn INT

SELECT @conn = (SELECT top 1 connectstat FROM memb_stat WHERE memb___id=@uid)

SET @k=0
SET @qtd=0
SET @find=0

IF @conn = 0
BEGIN
--Verifica Baú
SELECT @wh_data=items FROM warehouse WHERE accountid = @uid

WHILE @k<120 AND @wh_data IS NOT NULL
BEGIN
SET @wh_type=SUBSTRING(@wh_data,@k*16+1,2)
SET @k=@k+1

    IF
    @wh_type <> @TYPE
    AND @wh_type <> 0xFFFF
    BEGIN
        SET @find = 1
    END
END

SET @k=0

--Verifica Baú
IF @find = 0
BEGIN

WHILE @k<120 AND @wh_data IS NOT NULL
BEGIN
SET @wh_type=SUBSTRING(@wh_data,@k*16+1,2)
SET @wh_serial=SUBSTRING(@wh_data,@k*16+4,4)
SET @wh_13=SUBSTRING(@wh_data,@k*16+8,1)
SET @k=@k+1

IF
@wh_type = @TYPE
BEGIN
SET @find=0
SET @j=0

    WHILE @j < (@k-1)
        BEGIN
            SET @wj_serial=SUBSTRING(@wh_data,@j*16+4,4)
            SET @j=@j+1

                IF @wj_serial = @wh_serial
                    BEGIN
                        SET @find=1
                        INSERT INTO LOG_DUPE_EVENTO (login,serial,evento) VALUES (@uid, @wj_serial,'K5')
                    END
        END

SET @wh_data = SUBSTRING(@wh_data ,1,16*@j)+0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF+SUBSTRING(@wh_data,16*@j+17,len(@wh_data))

IF @find=0 AND @wh_serial<>0x00000000
    BEGIN
        SET @qtd = @qtd+1
    END

END
END
END
    IF @qtd >= 120
        BEGIN
            UPDATE [warehouse] SET [items]=@wh_data WHERE [AccountId]=@uid

            IF @TYPE = 0x0E00
            BEGIN
                DECLARE @nome VARCHAR(10)
                SELECT @nome = dbo.fn_char_forte(@uid)
                IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @uid AND name = @nome)
                    UPDATE MK_MEDALHAS SET medal_joias=1 WHERE name = @nome
                ELSE
                    INSERT INTO MK_MEDALHAS (login,name,medal_joias) VALUES (@uid,@nome,1)
            END
        END
END

SELECT @qtd AS qtd, @find AS find

END
GO
ALTER TABLE [dbo].[MK_MEDALHAS]  WITH CHECK ADD  CONSTRAINT [FK_MK_MEDALHAS_Character] FOREIGN KEY([Name])
REFERENCES [dbo].[CHARACTER] ([Name])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[MK_MEDALHAS] CHECK CONSTRAINT [FK_MK_MEDALHAS_Character]
GO
ALTER TABLE [dbo].[MK_Quest]  WITH CHECK ADD  CONSTRAINT [fk_name_char] FOREIGN KEY([Name])
REFERENCES [dbo].[CHARACTER] ([Name])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[MK_Quest] CHECK CONSTRAINT [fk_name_char]
GO


CREATE PROCEDURE [dbo].[PREMIAR_TOPS]
@Account VARCHAR(10),
@Name VARCHAR(10),
@WC INT,
@WP INT,
@GP INT,
@XP INT,
@VIP1 INT,
@VIP2 INT,
@VIP3 INT,
@EVENTOS INT
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF @WC > 0 OR @WP > 0 OR @GP > 0
BEGIN
UPDATE CashShopData
    SET WCoinC = WCoinC + @WC, WCoinP = WCoinP + @WP, GoblinPoint = GoblinPoint + @GP WHERE AccountID = @Account
END

IF @WC > 0
BEGIN
    INSERT INTO log_creditos ( login, valor, ip, tipo ) VALUES (@Account,@WC,'1','6')
END

IF @EVENTOS > 0 OR @XP > 0
BEGIN
UPDATE CHARACTER
    SET exp_war = exp_war + @XP, eventos = eventos + @EVENTOS WHERE Name = @Name AND AccountID = @Account
END

IF @VIP1 > 0
BEGIN
    -- ADD VIP NA CONTA VIP_AL1
    UPDATE memb_info SET AccountExpireDate = AccountExpireDate+@VIP1 WHERE memb___id = @Account AND accountlevel = 1
    -- ADD VIP NA CONTA VIP_AL0
    UPDATE memb_info SET accountlevel = 1, AccountExpireDate = (getdate())+@VIP1 WHERE memb___id = @Account AND accountlevel = 0

    IF (SELECT COUNT(*) FROM MEMB_INFO WHERE memb___id = @Account AND AccountLevel = 1) > 0
    INSERT INTO log_vip (login,dias,tipo) VALUES (@Account,@VIP1,'6' )
END

IF @VIP2 > 0
BEGIN
    -- ADD VIP NA CONTA VIP_AL2
    UPDATE memb_info SET AccountExpireDate = AccountExpireDate+@VIP2 WHERE memb___id = @Account AND accountlevel = 2

    IF (SELECT COUNT(*) FROM MEMB_INFO WHERE memb___id = @Account AND AccountLevel = 2) > 0
    INSERT INTO log_vip (login,dias,tipo) VALUES (@Account,@VIP2,'7' )
END

IF @VIP3 > 0
BEGIN
    -- ADD VIP NA CONTA VIP_AL3
    UPDATE memb_info SET AccountExpireDate = AccountExpireDate+@VIP3 WHERE memb___id = @Account AND accountlevel = 3

    IF (SELECT COUNT(*) FROM MEMB_INFO WHERE memb___id = @Account AND AccountLevel = 3) > 0
    INSERT INTO log_vip (login,dias,tipo) VALUES (@Account,@VIP3,'8' )
END


CREATE PROCEDURE [dbo].[PREMIAR_TOPS_MEDALHAS]
@Account    VARCHAR(10),
@Name       VARCHAR(10),
@MEDALHA    INT
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF @MEDALHA = 1
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_sresets=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_sresets) VALUES (@Account,@name,1)
END

IF @MEDALHA = 2
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_smresets=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_smresets) VALUES (@Account,@name,1)
END

IF @MEDALHA = 3
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_tempo=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_tempo) VALUES (@Account,@name,1)
END

IF @MEDALHA = 4
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_evento=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_evento) VALUES (@Account,@name,1)
END

IF @MEDALHA = 5
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_pk=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_pk) VALUES (@Account,@name,1)
END

IF @MEDALHA = 6
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_hr=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_hr) VALUES (@Account,@name,1)
END

IF @MEDALHA = 7
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_ds_s=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_ds_s) VALUES (@Account,@name,1)
END

IF @MEDALHA = 8
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_bc_s=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_bc_s) VALUES (@Account,@name,1)
END

IF @MEDALHA = 9
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_cc_s=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_cc_s) VALUES (@Account,@name,1)
END

IF @MEDALHA = 10
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_duel_semanal=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_duel_semanal) VALUES (@Account,@name,1)
END

IF @MEDALHA = 11
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_resets_m=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_resets_m) VALUES (@Account,@name,1)
END

IF @MEDALHA = 12
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_mresets_m=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_mresets_m) VALUES (@Account,@name,1)
END


IF @MEDALHA = 13
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_tempo_m=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_tempo_m) VALUES (@Account,@name,1)
END

IF @MEDALHA = 14
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_evento_m=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_evento_m) VALUES (@Account,@name,1)
END

IF @MEDALHA = 15
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_pk_m=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_pk_m) VALUES (@Account,@name,1)
END

IF @MEDALHA = 16
BEGIN
    IF EXISTS (SELECT login FROM mk_medalhas WHERE login = @Account AND name = @name)
        UPDATE MK_MEDALHAS SET medal_hr_m=1 WHERE name = @name
    ELSE
        INSERT INTO MK_MEDALHAS (login,name,medal_hr_m) VALUES (@Account,@name,1)
END




INSERT INTO MK_SERVER (REI_DO_MK,recorde_on) VALUES (0,0)
GO