SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webBanneds](
[name] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[datebegin] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,
[dateend] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,
[type] [smallint] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[webCash] Script Date: 02/16/2094 17:14:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webCash](
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[amount] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[webComplaints] Script Date: 02/16/2009 17:14:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webComplaints](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[image] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[date] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[ip] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[status] [smallint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[webLogBuyCash] Script Date: 02/16/2009 17:15:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webLogBuyCash](
[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[username] [varchar](12) COLLATE Chinese_PRC_CI_AS NOT NULL,
[cash] [int] NULL,
[banco] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[nterminal] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ntransferencia] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[agencia_acolhedora] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[nsequencia] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ctr] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[caixa_eletronico] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[nenvelope] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ndocumento] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ncontrole] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[noperador] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[data] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[hora] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[pago_em] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[anexo] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[comentario] [text] COLLATE Chinese_PRC_CI_AS NULL,
[valor] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[status] [int] NOT NULL CONSTRAINT [DF_webLogBuyCash_status] DEFAULT ((0)),
[comentario_adm] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[webLogBuyVips] Script Date: 02/16/2009 17:15:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webLogBuyVips](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[type] [smallint] NOT NULL,
[cashAmount] [int] NOT NULL,
[days] [smallint] NOT NULL,
[date] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[webNotices] Script Date: 02/16/2009 17:15:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webNotices](
[id] [smallint] IDENTITY(1,1) NOT NULL,
[subject] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[content] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[date] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[webPrevilegy] Script Date: 02/16/2009 17:15:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webPrevilegy](
[id] [smallint] IDENTITY(1,1) NOT NULL,
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[previlegy] [smallint] NOT NULL CONSTRAINT [DF_webPrevilegy_previlegy] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[webPwdHashWrite]
@login VARCHAR(10),
@senha VARCHAR(10)
AS
BEGIN
DECLARE @Hash BINARY(16);
EXEC master..XP_MD5_EncodeKeyVal @senha, @login, @Hash OUT;
UPDATE MuOnline.dbo.MEMB_INFO SET memb__pwd = @senha WHERE memb___id = @login;
END
/****** Object: Table [dbo].[webRecord] Script Date: 02/16/2009 17:15:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webRecord](
[record] [smallint] NOT NULL CONSTRAINT [DF_webRecord_record] DEFAULT ((0)),
[date] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[webTickets] Script Date: 02/16/2009 17:16:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webTickets](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[character] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[sector] [varchar](20) COLLATE Latin1_General_CI_AS NOT NULL,
[subject] [varchar](30) COLLATE Latin1_General_CI_AS NOT NULL,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[date] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,
[ip] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
[status] [smallint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[webTicketsAnswers] Script Date: 02/16/2009 17:16:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webTicketsAnswers](
[id] [int] NOT NULL,
[description] [text] COLLATE Latin1_General_CI_AS NOT NULL,
[answerBy] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[date] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[webVerifyLogin]
@login VARCHAR(10),
@senha VARCHAR(10),
@md5 int
AS
BEGIN
DECLARE @Valid int;
SET @Valid = 0;
IF @md5 = 1
BEGIN
DECLARE @Hash BINARY(16);
EXEC master..XP_MD5_EncodeKeyVal @senha, @login, @Hash OUT;
SELECT @Valid = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Hash;
END
IF @md5 = 0
BEGIN
SELECT @Valid = 1 FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = @login AND memb__pwd = @Senha;
END
SELECT @Valid;
END
/****** Object: Table [dbo].[webVips] Script Date: 02/16/2009 17:16:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[webVips](
[username] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL,
[type] [smallint] NOT NULL,
[datebegin] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,
[dateend] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[MEMB_INFO] Script Date: 02/16/2094 17:11:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MEMB_INFO](
[data] [smalldatetime] NULL,
[aniversario] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
