x-MU.net форум

USE [MuOnline]
GO
DROP TABLE [dbo].[T_PeriodItem_Info];
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_PeriodItem_Info](
[PeriodIndex] [int] NULL,
[UserGuid] [int] NOT NULL,
[CharacterName] [char](10) NOT NULL,
[ItemCode] [int] NOT NULL,
[EffectType1] [tinyint] NOT NULL,
[EffectType2] [tinyint] NULL,
[UsedTime] [int] NULL,
[LeftTime] [int] NOT NULL,
[BuyDate] [datetime] NOT NULL,
[ExpireDate] [datetime2](7) NOT NULL,
[UsedInfo] [tinyint] NOT NULL,
[OptionType] [tinyint] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO