Ajuda aqui resolver esse erro !

[openzonespd]

 

[Peredelski]

Você Restaurou Certo As DB's??

Qual Versão Esta Usando?

 

[Aksz]

Tem alguma coisa errada com a tabela.

 

[openzonespd]

Versão 97d !

 

[preto157]

tenta usar esta query

------------------------------------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_CREDITS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_CREDITS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_DEPOSITS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_DEPOSITS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_HISTORY]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_HISTORY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_HISTORY2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_HISTORY2]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_ITEMS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_ITEMS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_ITEMS2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_ITEMS2]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_MAXOPT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_MAXOPT]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_PAYMENT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_PAYMENT]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DT_SHOP_SETTYPE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DT_SHOP_SETTYPE]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_ADMS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_ADMS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_AGRADECIMENTOS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_AGRADECIMENTOS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_ALTERAREMAIL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_ALTERAREMAIL]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_CADASTROS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_CADASTROS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_CHARS_BANIDOS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_CHARS_BANIDOS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_CHARS_IMAGES]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_CHARS_IMAGES]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_COMPRAS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_COMPRAS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_COMPRAS_ANSWERS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_COMPRAS_ANSWERS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_FAQ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_FAQ]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_FAQ_TYPES]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_FAQ_TYPES]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_GMS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_GMS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_GUILDS_CONVITES]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_GUILDS_CONVITES]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_LOG_ONLINE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_LOG_ONLINE]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_LOG_SERVICOS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_LOG_SERVICOS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_SERVICOS_TFRESETS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_SERVICOS_TFRESETS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_SERVICOS_UPLOADFOTO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_SERVICOS_UPLOADFOTO]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MWEB_TICKETS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MWEB_TICKETS]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WebShop_LOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[WebShop_LOG]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dt_web_admins]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[dt_web_admins]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dt_web_alerts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[dt_web_alerts]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dt_web_faqs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[dt_web_faqs]
GO

CREATE TABLE [DT_SHOP_CREDITS] (
    [login] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [credits] [int] NOT NULL CONSTRAINT [DF_DT_SHOP_CREDITS_credits] DEFAULT (0),
    [access] [int] NOT NULL CONSTRAINT [DF_DT_SHOP_CREDITS_access] DEFAULT (0),
    [unlimited] [int] NULL ,
    [credits2] [int] NOT NULL CONSTRAINT [DF_DT_SHOP_CREDITS_credits2] DEFAULT (0),
    [id] [int] IDENTITY (1, 1) NOT NULL ,
    [navegador] [varchar] (50) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DT_SHOP_DEPOSITS] (
    [id] [int] IDENTITY (1, 1) NOT NULL ,
    [user_login] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [deposit_conta] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [deposit_local] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [deposit_data] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [deposit_hora] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [deposit_ncontrole] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [deposit_valor] [float] NOT NULL ,
    [deposit_comentario] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [request_date] [datetime] NOT NULL ,
    [request_status] [int] NOT NULL ,
    [request_reason] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
    [deposit_value] [float] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DT_SHOP_HISTORY] (
    [login] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
    [item_key] [int] NOT NULL ,
    [item_serial] [int] NOT NULL ,
    [item_dump] [varbinary] (20) NOT NULL ,
    [buy_date] [datetime] NOT NULL ,
    [pay_price] [int] NOT NULL ,
    [id] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DT_SHOP_HISTORY2] (
    [login] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [item_key] [int] NOT NULL ,
    [item_serial] [int] NOT NULL ,
    [item_dump] [varbinary] (20) NOT NULL ,
    [buy_date] [datetime] NOT NULL ,
    [pay_price] [int] NOT NULL ,
    [id] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DT_SHOP_ITEMS] (
    [item_key] [int] NOT NULL ,
    [item_price] [int] NOT NULL ,
    [item_type] [int] NOT NULL ,
    [item_dyn_price] [int] NOT NULL ,
    [item_max_opt] [int] NOT NULL ,
    [item_options] [int] NOT NULL ,
    [item_exc_type] [int] NOT NULL ,
    [allow_for] [varbinary] (

NOT NULL ,
    [item_description] [varchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [buy_count] [int] NOT NULL ,
    [id] [int] IDENTITY (1, 1) NOT NULL ,
    [item_price2] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DT_SHOP_ITEMS2] (
    [item_key] [int] NOT NULL ,
    [item_price] [int] NOT NULL ,
    [item_type] [int] NOT NULL ,
    [item_dyn_price] [int] NOT NULL ,
    [item_max_opt] [int] NOT NULL ,
    [item_options] [int] NOT NULL ,
    [item_exc_type] [int] NOT NULL ,
    [allow_for] [varbinary] (

NOT NULL ,
    [item_description] [varchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [buy_count] [int] NOT NULL ,
    [id] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DT_SHOP_MAXOPT] (
    [max_level] [int] NOT NULL ,
    [max_option] [int] NOT NULL ,
    [max_excellent] [int] NOT NULL ,
    [allow_luck] [int] NOT NULL ,
    [allow_skill] [int] NOT NULL ,
    [allow_ancient] [int] NULL ,
    [description] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [id] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DT_SHOP_PAYMENT] (
    [pay_level] [int] NOT NULL ,
    [pay_option] [int] NOT NULL ,
    [pay_luck] [int] NOT NULL ,
    [pay_skill] [int] NOT NULL ,
    [pay_excellent] [int] NOT NULL ,
    [pay_ancient] [int] NOT NULL ,
    [pay_description] [varchar] (250) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [id] [int] IDENTITY (1, 1) NOT NULL ,
    [pay_moeda] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DT_SHOP_SETTYPE] (
    [id] [int] NOT NULL ,
    [item_level] [int] NOT NULL ,
    [item_option] [int] NOT NULL ,
    [item_skill] [int] NOT NULL ,
    [item_luck] [int] NOT NULL ,
    [item_excellent] [int] NOT NULL ,
    [item_ancient] [int] NOT NULL ,
    [item_description] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MWEB_ADMS] (
    [login] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [character] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MWEB_AGRADECIMENTOS] (
    [id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [gm] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [login] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [mensagem] [text] COLLATE Chinese_PRC_CI_AS NULL ,
    [data] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[MWEB_ALTERAREMAIL] (
    [cod] [int] NOT NULL ,
     [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_CADASTROS] (

    [login] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [confirmado] [int] NOT NULL ,

    [total] [int] NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_CHARS_BANIDOS] (

    [name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [dias] [int] NOT NULL ,

    [screenshot] [nvarchar] (75) COLLATE Chinese_PRC_CI_AS NULL ,

    [Quando] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [Character] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [Motivo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [Por] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [Vezes] [int] NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_CHARS_IMAGES] (

    [imagem] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

    [Character] [varchar] (75) COLLATE Chinese_PRC_CI_AS NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_COMPRAS] (

    [day] [int] NOT NULL ,

    [valor] [int] NOT NULL ,

    [status] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [data] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [pontos] [int] NOT NULL ,

    [login] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [banco] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [character] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_COMPRAS_ANSWERS] (

    [id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [banco] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_FAQ] (

    [Pergunta] [text] COLLATE Chinese_PRC_CI_AS NULL ,

    [faqid] [bigint] IDENTITY (1, 1) NOT NULL ,

    [Tipo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,

    [Resposta] [text] COLLATE Chinese_PRC_CI_AS NULL ,

    [id] [bigint] NOT NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_FAQ_TYPES] (

    [tipo] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_GMS] (

    [login] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [gm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_GUILDS_CONVITES] (

    [guild] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [character] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_LOG_ONLINE] (

    [data] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [quanto] [bigint] NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_LOG_SERVICOS] (

    [campo7] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [login] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [id] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [campo2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_SERVICOS_TFRESETS] (

    [character] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_SERVICOS_UPLOADFOTO] (

    [upload] [int] NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[MWEB_TICKETS] (

    [login] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [id] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [tipo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [assunto] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [character] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

    [data] [datetime] NULL ,

    [status] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[WebShop_LOG] (

    [id] [int] IDENTITY (1, 1) NOT NULL ,

    [accountid] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,

    [details] [text] COLLATE Modern_Spanish_CI_AS NOT NULL ,

    [dateline] [int] NOT NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO


CREATE TABLE [dbo].[dt_web_admins] (

    [id] [int] IDENTITY (1, 1) NOT NULL ,

    [login] [varchar] (10) COLLATE Chinese_PRC_CS_AS NOT NULL ,

    [admin] [int] NOT NULL

) ON [PRIMARY]

GO


CREATE TABLE [dbo].[dt_web_alerts] (

    [id] [int] IDENTITY (1, 1) NOT NULL ,

    [alert_postdate] [varchar] (30) COLLATE Chinese_PRC_CS_AS NULL ,

    [alert_postby] [varchar] (15) COLLATE Chinese_PRC_CS_AS NULL ,

    [alert_text] [text] COLLATE Chinese_PRC_CS_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO


CREATE TABLE [dbo].[dt_web_faqs] (

    [id] [int] IDENTITY (1, 1) NOT NULL ,

    [faq_title] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,

    [faq_text] [text] COLLATE Chinese_PRC_CI_AS NULL ,

    [faq_postby] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,

    [faq_postdate] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,

    [faq_category] [int] NOT NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO