Código:
Tabela "pagamentos_res"
CREATE TABLE [pagamentos_res] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[msg] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mensagem] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Tabela "pagamentos"
CREATE TABLE [pagamentos] (
[valor] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mensagem] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[hora] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [int] NOT NULL CONSTRAINT [DF_pagamentos_status] DEFAULT (0),
[login] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[diasvip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[dateenv] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[pontos] [int] NOT NULL CONSTRAINT [DF_pagamentos_pontos] DEFAULT (0),
[banco] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
Tabela "agradecer_gm"
CREATE TABLE [agradecer_gm] (
[chargm] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[msg] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[login] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Tabela "faq"
CREATE TABLE [faq] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[titulo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[conteudo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[faq] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_faq_votos] DEFAULT (N'(0'),
[por] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
Tabela "avisos"
CREATE TABLE [avisos] (
[msg] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[por] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[titulo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[id] [bigint] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Tabela "tickets"
CREATE TABLE [tickets] (
[titulo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[assunto] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[msg] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[login] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Tabela "not?cias"
CREATE TABLE [Noticias] (
[Titulo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[Por] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[Tipo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Noticia] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Tabela "ticket_res"
CREATE TABLE [ticket_res] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[msg] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[titulo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Tabela "hall_da_fama"
CREATE TABLE [hall_da_fama] (
[participando] [int] NOT NULL CONSTRAINT [DF_hall_da_fama_participando] DEFAULT (0),
[login] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[votos] [int] NOT NULL CONSTRAINT [DF_hall_da_fama_votos] DEFAULT (0)
) ON [PRIMARY]
GO
Tabela "Pro_Team_Comentarios"
CREATE TABLE [Pro_Team_Comentarios] (
[Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[msg] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[idnoticia] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[site_aviso] (
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[nome] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[msg] [text] COLLATE Korean_Wansung_CI_AS NULL ,
[data] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
assunto] [varchar] (255) COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[site_contato] (
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[nome] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[assunto] [varchar] (250) COLLATE Korean_Wansung_CI_AS NULL ,
[email] [varchar] (200) COLLATE Korean_Wansung_CI_AS NULL ,
[msg] [text] COLLATE Korean_Wansung_CI_AS NULL ,
[data] [varchar] (250) COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[site_ticket] (
[titulo] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[assunto] [varchar] (255) COLLATE Korean_Wansung_CI_AS NULL ,
[msg] [text] COLLATE Korean_Wansung_CI_AS NULL ,
[data] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[status] [int] NOT NULL ,
[name] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[login] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[site_ticket_res] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[msg] [text] COLLATE Korean_Wansung_CI_AS NULL ,
[data] [varchar] (30) COLLATE Korean_Wansung_CI_AS NULL ,
[name] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[titulo] [varchar] (20) COLLATE Korean_Wansung_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[site_confirma] (
[valor] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mensagem] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[data] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[hora] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [int] NOT NULL ,
[login] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[diasvip] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[id] [bigint] IDENTITY (1, 1) NOT NULL ,
[dateenv] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[pontos] [int] NOT NULL ,
[banco] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
Character:
resets | int | 4 | Desmarcado | Default value: 0
resetao | int | 4 | Desmarcado | Default value: 0
foto | nvarchar | Desmarcado | Default value: sem_imagem.gif
bloc_reason | nvarchar | 50 | Marcado
bloc_by | nvarchar | 50 | Marcado
screen | nvarchar | 100 | Marcado
diasban | int | 4 | Desmarcado | Default value: 0
MEMB_INFO
vip | int | 4 | Desmarcado | Default value: 0
creditos | int | 4 | Desmarcado | Default value: 0
adm | int | 4 | Desmarcado | Default value: 0
ban_by | nvarchar | 50 | Marcado
ban_reason | nvarchar | 50 | Marcado
accdias | int | 4 | Desmarcado | Default value: 0
gold | int | 4 | Desmarcado | Default value: 0
indicacoes | int | 4 | Desmarcado | Default value: 0
indicado | nvarchar | Marcado
Guild:
G_Banner | nvarchar | 75 | Desmarcado | Default value: guild_sem_banner.gif
//////////////////////////////////////////////////////////////////////////
******
CREATE TABLE [faq] (
[Id] [bigint] IDENTITY (1, 1) NOT NULL ,
[titulo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[conteudo] [text] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[faq] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_faq_votos] DEFAULT (N'(0'),
[por] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO