/****** Object:  Table [dbo].[T_PentagramInfo]    Script Date: 03/10/2014 17:09:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_PentagramInfo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[T_PentagramInfo](
	[UserGuid] [int] NOT NULL,
	[AccountID] [varchar](10) NOT NULL,
	[Name] [varchar](10) NOT NULL,
	[JewelPos] [tinyint] NOT NULL,
	[JewelIndex] [smallint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_JewelIndex]  DEFAULT ((255)),
	[ItemType] [smallint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_ItemType]  DEFAULT ((255)),
	[ItemIndex] [smallint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_ItemIndex]  DEFAULT ((511)),
	[MainAttribute] [smallint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_MainAttribute]  DEFAULT ((255)),
	[JewelLevel] [smallint] NOT NULL,
	[Rank1] [tinyint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_Rank1]  DEFAULT ((255)),
	[Rank1Level] [tinyint] NULL,
	[Rank2] [tinyint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_Rank2]  DEFAULT ((255)),
	[Rank2Level] [tinyint] NULL,
	[Rank3] [tinyint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_Rank3]  DEFAULT ((255)),
	[Rank3Level] [tinyint] NULL,
	[Rank4] [tinyint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_Rank4]  DEFAULT ((255)),
	[Rank4Level] [tinyint] NULL,
	[Rank5] [tinyint] NOT NULL CONSTRAINT [DF_T_PentagramInfo_Rank5]  DEFAULT ((255)),
	[Rank5Level] [tinyint] NULL,
	[RegDate] [datetime] NULL CONSTRAINT [DF_T_PentagramInfo_RegDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_T_PentagramInfo] PRIMARY KEY CLUSTERED
(
	[AccountID] ASC,
	[Name] ASC,
	[JewelPos] ASC,
	[JewelIndex] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[T_Pentagram]    Script Date: 03/10/2014 17:09:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_Pentagram]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[T_Pentagram](
	[AccountID] [varchar](10) NOT NULL,
	[Name] [varchar](10) NOT NULL,
	[AddInventory] [varbinary](16) NULL,
	[MDate] [datetime] NULL,
	[LDate] [datetime] NULL CONSTRAINT [DF_T_Pentagram_MDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_T_Pentagram] PRIMARY KEY CLUSTERED
(
	[Name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO