SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LeadBBS_SellList](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[PID] [bigint] NOT NULL,
[UserName] [varchar](20) NOT NULL,
[PayPoints] [int] NOT NULL,
[GetPoints] [int] NOT NULL,
[SellTime] [bigint] NOT NULL,
[PayFlag] [tinyint] NOT NULL,
[UserID] [bigint] NOT NULL,
[PID_TMP] [bigint] NOT NULL,
[PAY_STAT] [varchar](50) NOT NULL,
[PAY_MEMO] [varchar](255) NOT NULL,
CONSTRAINT [PK_LeadBBS_SellList] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_PAY_STAT] ON [dbo].[LeadBBS_SellList]
(
[PAY_STAT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_PayFlag] ON [dbo].[LeadBBS_SellList]
(
[PayFlag] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_PID] ON [dbo].[LeadBBS_SellList]
(
[PID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_PID_TMP] ON [dbo].[LeadBBS_SellList]
(
[PID_TMP] ASC,
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_SellTime] ON [dbo].[LeadBBS_SellList]
(
[SellTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_UserID] ON [dbo].[LeadBBS_SellList]
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_UserNamePayFlag] ON [dbo].[LeadBBS_SellList]
(
[UserID] ASC,
[PayFlag] ASC,
[ID] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LeadBBS_SellList_UserSellTime] ON [dbo].[LeadBBS_SellList]
(
[UserID] ASC,
[PayFlag] ASC,
[SellTime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'ID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'PID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'购买用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'付款金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'PayPoints'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'兑换财富点数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'GetPoints'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'SellTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0,未支付 1,完成支付' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LeadBBS_SellList', @level2type=N'COLUMN',@level2name=N'PayFlag'
GO
/****** Object: Default [DF_LeadBBS_SellList_PID] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_PID] DEFAULT (0) FOR [PID]
GO
/****** Object: Default [DF_LeadBBS_SellList_UserName] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_UserName] DEFAULT ('') FOR [UserName]
GO
/****** Object: Default [DF_LeadBBS_SellList_PayPoints] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_PayPoints] DEFAULT (0) FOR [PayPoints]
GO
/****** Object: Default [DF_LeadBBS_SellList_GetPoints] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_GetPoints] DEFAULT (0) FOR [GetPoints]
GO
/****** Object: Default [DF_LeadBBS_SellList_SellTime] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_SellTime] DEFAULT (0) FOR [SellTime]
GO
/****** Object: Default [DF_LeadBBS_SellList_PayFlag] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_PayFlag] DEFAULT (0) FOR [PayFlag]
GO
/****** Object: Default [DF_LeadBBS_SellList_UserID] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_UserID] DEFAULT ((0)) FOR [UserID]
GO
/****** Object: Default [DF_LeadBBS_SellList_PID_TMP] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_PID_TMP] DEFAULT ((0)) FOR [PID_TMP]
GO
/****** Object: Default [DF_LeadBBS_SellList_PAY_STAT] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_PAY_STAT] DEFAULT ('') FOR [PAY_STAT]
GO
/****** Object: Default [DF_LeadBBS_SellList_PAY_MEMO] Script Date: 07/20/2015 15:19:24 ******/
ALTER TABLE [dbo].[LeadBBS_SellList] ADD CONSTRAINT [DF_LeadBBS_SellList_PAY_MEMO] DEFAULT ('') FOR [PAY_MEMO]
GO
