x-MU.net форум

CREATE TABLE [EWDNews] (
[news_title] [varchar] (100) ,
[news_autor] [varchar] (100) ,
[news_category] [varchar] (100) ,
[news_context] [text] ,
[news_date] [varchar] (100) ,
[news_id] [smallint] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_EWDNews] PRIMARY KEY CLUSTERED
(
[news_id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [EWDServers] (
[name] [varchar] (100) NULL ,
[experience] [varchar] (100) NULL ,
[drops] [varchar] (100) NULL ,
[gsport] [varchar] (100) NULL ,
[ip] [varchar] (100) NULL ,
[display_order] [varchar] (100) NULL ,
[version] [varchar] (100) NULL ,
[type] [varchar] (50) NULL
) ON [PRIMARY]
GO

CREATE TABLE [EWDDownloads] (
[link_name] [varchar] (100) NULL ,
[link_address] [text] NULL ,
[link_description] [text] NULL ,
[link_id] [smallint] IDENTITY (1, 1) NOT NULL ,
[link_date] [varchar] (100) NULL ,
CONSTRAINT [PK_EWDDownloads] PRIMARY KEY CLUSTERED
(
[link_id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [EWDadmin] (
[username] [varchar] (100) NULL ,
[password] [varchar] (100) NULL ,
[securitycode] [varchar] (100) NULL
) ON [PRIMARY]
GO

alter table dbo.Character ADD GReset smallint not null default 0
alter table dbo.Character ADD Resets int not null default 0
alter table dbo.Character ADD votes int not null default 0
alter table dbo.MEMB_INFO ADD credits int not null default 0
alter table dbo.MEMB_INFO ADd SCFIsVip smallint not null default 0
alter table dbo.MEMB_INFO ADD votes int not null default 0
alter table dbo.MEMB_INFO ADd myref char( null
alter table dbo.MEMB_INFO ADD referer char( null
alter table dbo.MEMB_INFO ADD ip char(15) null

информативные скрины