joesuef |
08-04-2017 09:17 PM |
رد: محتاج شويه Query
اقتباس:
المشاركة الأصلية كتبت بواسطة MORJANA
(المشاركة 5312162)
الجيلد
كود:
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_Guild] DROP CONSTRAINT [FK__Guild__AlliedClans]
GO
/****** Object: Table [dbo].[_Guild] Script Date: 08/4/2017 8:08:37 PM ******/
DROP TABLE [dbo].[_Guild]
GO
/****** Object: Table [dbo].[_Guild] Script Date: 08/4/2017 8:08:37 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_Guild](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](64) NOT NULL,
[Lvl] [tinyint] NOT NULL,
[GatheredSP] [int] NOT NULL,
[FoundationDate] [smalldatetime] NOT NULL,
[Alliance] [int] NULL,
[MasterCommentTitle] [varchar](129) NULL,
[MasterComment] [varchar](2049) NULL,
[Booty] [int] NULL,
[Gold] [bigint] NOT NULL DEFAULT (0),
[LastCrestRev] [int] NOT NULL DEFAULT (0),
[CurCrestRev] [int] NOT NULL DEFAULT (0),
[MercenaryAttr] [tinyint] NOT NULL DEFAULT (0),
CONSTRAINT [PK__Guild] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [IX__Guild] UNIQUE NONCLUSTERED
(
[Name] 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].[_Guild] WITH CHECK ADD CONSTRAINT [FK__Guild__AlliedClans] FOREIGN KEY([Alliance])
REFERENCES [dbo].[_AlliedClans] ([ID])
GO
ALTER TABLE [dbo].[_Guild] CHECK CONSTRAINT [FK__Guild__AlliedClans]
GO
كود:
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildChest] DROP CONSTRAINT [FK__GuildChest_Guild]
GO
/****** Object: Table [dbo].[_GuildChest] Script Date: 08/4/2017 8:08:51 PM ******/
DROP TABLE [dbo].[_GuildChest]
GO
/****** Object: Table [dbo].[_GuildChest] Script Date: 08/4/2017 8:08:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_GuildChest](
[GuildID] [int] NOT NULL,
[Slot] [tinyint] NOT NULL,
[ItemID] [bigint] NULL,
CONSTRAINT [PK__GuildChest] PRIMARY KEY CLUSTERED
(
[GuildID] ASC,
[Slot] 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
ALTER TABLE [dbo].[_GuildChest] WITH NOCHECK ADD CONSTRAINT [FK__GuildChest_Guild] FOREIGN KEY([GuildID])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildChest] CHECK CONSTRAINT [FK__GuildChest_Guild]
GO
كود:
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [FK__GuildMember__Guild]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [DF___GuildMem__Siege__40C9606C]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [DF___GuildMem__RefOb__0C326F40]
GO
/****** Object: Table [dbo].[_GuildMember] Script Date: 08/4/2017 8:09:23 PM ******/
DROP TABLE [dbo].[_GuildMember]
GO
/****** Object: Table [dbo].[_GuildMember] Script Date: 08/4/2017 8:09:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_GuildMember](
[GuildID] [int] NOT NULL,
[CharID] [int] NOT NULL,
[CharName] [varchar](64) NOT NULL,
[MemberClass] [tinyint] NOT NULL,
[CharLevel] [tinyint] NOT NULL,
[GP_Donation] [int] NOT NULL,
[JoinDate] [smalldatetime] NOT NULL,
[Permission] [int] NULL,
[Contribution] [int] NULL,
[GuildWarKill] [int] NULL,
[GuildWarKilled] [int] NULL,
[Nickname] [varchar](64) NULL,
[RefObjID] [int] NULL,
[SiegeAuthority] [tinyint] NULL,
CONSTRAINT [PK__GuildMember] PRIMARY KEY CLUSTERED
(
[GuildID] ASC,
[CharID] 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].[_GuildMember] ADD DEFAULT (0) FOR [RefObjID]
GO
ALTER TABLE [dbo].[_GuildMember] ADD DEFAULT (0) FOR [SiegeAuthority]
GO
ALTER TABLE [dbo].[_GuildMember] WITH CHECK ADD CONSTRAINT [FK__GuildMember__Guild] FOREIGN KEY([GuildID])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildMember] CHECK CONSTRAINT [FK__GuildMember__Guild]
GO
كود:
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildWar] DROP CONSTRAINT [FK__GuildWar__Guild1]
GO
ALTER TABLE [dbo].[_GuildWar] DROP CONSTRAINT [FK__GuildWar__Guild]
GO
/****** Object: Table [dbo].[_GuildWar] Script Date: 08/4/2017 8:09:40 PM ******/
DROP TABLE [dbo].[_GuildWar]
GO
/****** Object: Table [dbo].[_GuildWar] Script Date: 08/4/2017 8:09:40 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_GuildWar](
[ID] [int] IDENTITY(1,1) NOT NULL,
[WarType] [tinyint] NOT NULL,
[VictoryPointIndex] [tinyint] NOT NULL,
[LodgedGold] [int] NOT NULL,
[WarEndTime] [smalldatetime] NULL,
[Guild1] [int] NOT NULL,
[Guild2] [int] NOT NULL,
[PointGain1] [int] NOT NULL,
[PointGain2] [int] NOT NULL,
[Data1] [int] NOT NULL,
[Data2] [int] NOT NULL,
CONSTRAINT [PK__GuildWar] PRIMARY KEY CLUSTERED
(
[ID] 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
ALTER TABLE [dbo].[_GuildWar] WITH CHECK ADD CONSTRAINT [FK__GuildWar__Guild] FOREIGN KEY([Guild1])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildWar] CHECK CONSTRAINT [FK__GuildWar__Guild]
GO
ALTER TABLE [dbo].[_GuildWar] WITH CHECK ADD CONSTRAINT [FK__GuildWar__Guild1] FOREIGN KEY([Guild2])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildWar] CHECK CONSTRAINT [FK__GuildWar__Guild1]
GO
FTW
كود:
/*** Simple query for Fortress Owner Declaration By Buddha ***/
USE [SRO_VT_SHARD]UPDATE _SiegeFortress
SET GuildID=0
|
كله شغال معاده واحده اول واحده بتجبلي
Msg 3726, Level 16, State 1, Line 8
Could not drop object 'dbo._Guild' because it is referenced by a FOREIGN KEY constraint.
Msg 2714, Level 16, State 6, Line 21
There is already an object named '_Guild' in the database.
|