DB_51aspx/2014年/2014年7月分/世界杯竞猜612.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

GO
CREATE TABLE [dbo].[wx_sjb_bisai](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[bsPic] [varchar](800) COLLATE Chinese_PRC_CI_AS NULL,
	[bsRemark] [varchar](2000) COLLATE Chinese_PRC_CI_AS NULL,
	[rcId] [int] NULL,
	[qd1Id] [int] NULL,
	[qd2Id] [int] NULL,
	[beginDate] [datetime] NULL,
	[endDate] [datetime] NULL,
	[jcBeginDate] [datetime] NULL,
	[jcEndDate] [datetime] NULL,
	[resultType] [int] NULL,
	[rType1Times] [int] NULL,
	[rType2Times] [int] NULL,
	[rType3Times] [int] NULL,
	[createDate] [datetime] NULL,
 CONSTRAINT [PK_wx_sjb_bisai_id] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @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'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'bsPic'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'比赛详情' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'bsRemark'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日程id' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'rcId'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'球队1' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'qd1Id'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'球队2' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'qd2Id'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开始时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'beginDate'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'endDate'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'竞猜开始时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'jcBeginDate'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'竞猜结束时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'jcEndDate'

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结果：1：球队1胜利，2：球队2胜利，3平局' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'wx_sjb_bisai', @level2type=N'COLUMN', @level2name=N'resultType'

GO