guild fix

USE [PS_GameData]
GO
/****** Creation Guild Fixed by sandolkakos: Shaiya-UGO Server - www.universalgamesonline.com.br  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Guilds](
    [RowID] [INT] IDENTITY(1,1) NOT NULL,
    [GuildID] [INT] NOT NULL,
    [GuildName] [VARCHAR](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
    [MasterUserID] [VARCHAR](18) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
    [MasterCharID] [INT] NOT NULL,
    [MasterName] [VARCHAR](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
    [Country] [tinyint] NOT NULL,
    [TotalCount] [SMALLINT] NOT NULL,
    [GuildPoint] [INT] NOT NULL,
    [Del] [tinyint] NOT NULL CONSTRAINT [DF_Guilds_Del]  DEFAULT ((0)),
    [CreateDate] [datetime] NOT NULL,
    [DeleteDate] [datetime] NULL,
 CONSTRAINT [PK_Guilds] PRIMARY KEY CLUSTERED
(
    [GuildID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF