网狐棋牌数据库整理文件

CREATE USER [test] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RecordUserProp]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[RecordUserProp]( [RecordID] [int] IDENTITY(1,1) NOT NULL, [UserID] [int] NOT NULL CONSTRAINT [DF_RecordUserProp_UserID] DEFAULT ((0)), [KindID] [int] NOT NULL CONSTRAINT [DF_RecordUserProp_KindID] DEFAULT ((0)), [CateID] [int] NOT NULL CONSTRAINT [DF_RecordUserProp_CateID] DEFAULT ((0)), [PropCount] [bigint] NOT NULL CONSTRAINT [DF_RecordUserProp_PropCount] DEFAULT ((0)), [WriteDate] [datetime] NOT NULL CONSTRAINT [DF_RecordUserProp_WriteDate] DEFAULT (getdate()), [ClientIP] [nvarchar](15) NOT NULL CONSTRAINT [DF_RecordUserProp_ClientIP] DEFAULT (N'000.000.000.000'), CONSTRAINT [PK_RecordUserProp] PRIMARY KEY CLUSTERED ( [RecordID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录标识' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'RecordUserProp', @level2type=N'COLUMN', @level2name=N'RecordID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户标识' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'RecordUserProp', @level2type=N'COLUMN', @level2name=N'UserID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'游戏标识' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'RecordUserProp', @level2type=N'COLUMN', @level2name=N'KindID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'道具类别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'RecordUserProp', @level2type=N'COLUMN', @level2name=N'CateID' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'道具数目' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'RecordUserProp', @level2type=N'COLUMN', @level2name=N'PropCount' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'写入时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'RecordUserProp', @level2type=N'COLUMN', @level2name=N'WriteDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'写入地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'RecordUserProp', @level2type=N'COLUMN', @level2name=N'ClientIP' GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ConfineAddress]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[ConfineAddress]( [AddrString] [nvarchar](15) NOT NULL, [EnjoinLogon] [bit] NOT NULL CONSTRAINT [DF_AddrConfineRule_EnjoinLogon] DEFAULT ((0)), [EnjoinOverDate] [datetime] NOT NULL, [CollectDate] [datetime] NOT NULL CONSTRAINT [DF_AddrConfineRule_CollectDate] DEFAULT (getdate()), [CollectNote] [nvarchar](32) NOT NULL CONSTRAINT [DF_AddrConfineRule_CollectNote] DEFAULT (''), CONSTRAINT [PK_ConfineAddress_AddrString] PRIMARY KEY CLUSTERED ( [AddrString] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址字符' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ConfineAddress', @level2type=N'COLUMN', @level2name=N'AddrString' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'限制登陆' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ConfineAddress', @level2type=N'COLUMN', @level2name=N'EnjoinLogon' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'过期时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ConfineAddress', @level2type=N'COLUMN', @level2name=N'EnjoinOverDate' GO EXEC sys.sp_adde�