x-MU.net форум

Цитата: pravednik от 2018 Сен. 17, 14:34  Пробовал ?

Спойлер

CREATE TABLE [dbo].[WEB_Ban] (
[memb___id] [nvarchar] (50) NOT NULL,
[block_time] [nvarchar] (50) NOT NULL,
[unblock_time] [nvarchar] (50) NOT NULL,
[block_reason] [nvarchar] (50) NOT NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[MEMB_VOTES](
[vote_id] [int] NOT NULL,
[vote_time] [nvarchar](50) NOT NULL,
[vote_ip] [nvarchar](50) NOT NULL,
[vote_acc] [nvarchar](50) NOT NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[Web_Shop](
[memb___id] [nvarchar] (50) NOT NULL,
[item] [varchar] (32) NULL ,
[time] [nvarchar](50) NOT NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[MEMB_CREDITS] ([memb___id] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,[credits] [int] NOT NULL) ON [PRIMARY];
ALTER TABLE [dbo].[MEMB_CREDITS] WITH NOCHECK ADD CONSTRAINT [DF_MEMB_CREDITS_credits] DEFAULT (0) FOR [credits];
ALTER TABLE [dbo].[MEMB_CREDITS] WITH NOCHECK ADD CONSTRAINT [PK_MEMB_CREDITS] PRIMARY KEY CLUSTERED ([memb___id]) ON [PRIMARY];

alter table dbo.memb_info add unblock_time nvarchar(50) not null default 0
alter table dbo.memb_info add block_reason nvarchar(50) not null default 0
alter table dbo.memb_info add referral varchar(100) NULL
alter table dbo.memb_info add reward_ref int not null default 0
alter table dbo.Character add Hide int not null default 0
alter table dbo.Character add HideTime int not null default 0
alter table dbo.warehouse add extMoney int not null default 0
alter table dbo.Character add Resets int not null default 0
alter table dbo.Character add GR int not null default 0

[свернуть]

Спойлер

CREATE TABLE [dbo].[WEB_Market] (
[cat_id] [int] NULL,
[item_id] [int] NULL,
[item] [varchar] (32) NULL,
[item_serial] [varchar] ( NULL,
[item_excellent] [smallint] NOT NULL DEFAULT 0,
[item_ancient] [smallint] NOT NULL DEFAULT 0,
[item_pvp] [smallint] NOT NULL DEFAULT 0,
[item_harmony] [smallint] NOT NULL DEFAULT 0,
[item_skill] [smallint] NOT NULL DEFAULT 0,
[item_luck] [smallint] NOT NULL DEFAULT 0,
[item_life] [int] NOT NULL DEFAULT 0,
[item_level] [int] NOT NULL DEFAULT 0,
[item_price] [varchar] (50) NULL,
[currency] [varchar] (50) NULL,
[seller] [varchar] (50) NULL,
[start_date] [varchar] (50) NULL,
[end_date] [varchar] (50) NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[WEB_MarketHistory] (
[cat_id] [int] NULL ,
[item] [varchar] (32) NULL,
[item_serial] [varchar] (50) NULL,
[item_price] [varchar] (50) NULL,
[currency] [varchar] (50) NULL,
[seller] [varchar] (50) NULL,
[start_date] [varchar] (50) NULL,
[end_date] [varchar] (50) NULL,
[sold_date] [varchar] (50) NULL,
[status] [smallint] NOT NULL DEFAULT 0,
[purchased_by] [varchar] (50) NULL
) ON [PRIMARY]

[свернуть]

Цитата: pravednik от 2018 Сен. 18, 09:12  попробуй это должно заработать

Спойлер

alter table dbo.MEMB_CREDITS add items bigint not null default 0

[свернуть]