20-04-2013, 01:08 AM
|
#10
|
|
|
• الانـتـسـاب » May 2012
|
|
• رقـم العـضـويـة » 100967
|
|
• المشـــاركـات » 613
|
|
• الـدولـة » AT MY HoMe
|
|
• الـهـوايـة » Web dsinger
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 10
|
|
|
|
.gif)
خد القيورى وادعيلى بعد ما تمسح القديم
|
|
|
USE [SRO_VT_SHARD]
GO
/****** Object: Table [dbo].[_SiegeFortress] Script Date: 04/20/2013 00:01:23 Byღ♥_iMoRy_♥ღ ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_SiegeFortress](
[FortressID] [int] NOT NULL,
[GuildID] [int] NOT NULL,
[TaxRatio] [smallint] NOT NULL,
[Tax] [bigint] NOT NULL,
[NPCHired] [tinyint] NOT NULL,
[TempGuildID] [int] NOT NULL,
[Introduction] [varchar](120) NULL,
[CreatedDungeonTime] [datetime] NULL,
[CreatedDungeonCount] [tinyint] NULL,
[IntroductionModificationPermission] [tinyint] NOT NULL,
CONSTRAINT [PK__SiegeFortress] PRIMARY KEY CLUSTERED
(
[FortressID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[_SiegeFortress] WITH NOCHECK ADD CONSTRAINT [FK__SiegeFortress__Guild] FOREIGN KEY([GuildID])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_SiegeFortress] CHECK CONSTRAINT [FK__SiegeFortress__Guild]
GO
ALTER TABLE [dbo].[_SiegeFortress] ADD DEFAULT (0) FOR [GuildID]
GO
ALTER TABLE [dbo].[_SiegeFortress] ADD DEFAULT (0) FOR [TaxRatio]
GO
ALTER TABLE [dbo].[_SiegeFortress] ADD DEFAULT (0) FOR [Tax]
GO
ALTER TABLE [dbo].[_SiegeFortress] ADD DEFAULT (0) FOR [NPCHired]
GO
ALTER TABLE [dbo].[_SiegeFortress] ADD DEFAULT (0) FOR [TempGuildID]
GO
ALTER TABLE [dbo].[_SiegeFortress] ADD DEFAULT (0) FOR [CreatedDungeonCount]
GO
ALTER TABLE [dbo].[_SiegeFortress] ADD DEFAULT (1) FOR [IntroductionModificationPermission]
GO
|
|
|
|
|