表名：ZL_PointGrounp












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2PointValfloat80   是 积分数
3Remarknvarchar5000   是 备注
4AddTimedatetime83   是 添加时间
5GroupNamenvarchar500   是 等级名称
6ImgUrlnvarchar2550   是 图片路径

简要说明：

会员等级表


GO
CREATE TABLE [dbo].[ZL_PointGrounp](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PointVal] [float] NULL,
[Remark] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[AddTime] [datetime] NULL,
[GroupName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ImgUrl] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'积分数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_PointGrounp', @level2type=N'COLUMN',@level2name=N'PointVal'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_PointGrounp', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_PointGrounp', @level2type=N'COLUMN',@level2name=N'AddTime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'等级名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_PointGrounp', @level2type=N'COLUMN',@level2name=N'GroupName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'图片路径' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_PointGrounp', @level2type=N'COLUMN',@level2name=N'ImgUrl'
GO
SET IDENTITY_INSERT [ZL_PointGrounp] ON
INSERT [ZL_PointGrounp] ([ID],[PointVal],[AddTime],[GroupName],[ImgUrl]) VALUES ( 1,0,N'2015/9/7 17:23:06',N'新驴',N'fa fa-coffee')
INSERT [ZL_PointGrounp] ([ID],[PointVal],[AddTime],[GroupName],[ImgUrl]) VALUES ( 2,100,N'2015/7/31 16:07:22',N'小驴',N'fa fa-child')
INSERT [ZL_PointGrounp] ([ID],[PointVal],[AddTime],[GroupName],[ImgUrl]) VALUES ( 3,500,N'2015/7/31 16:07:40',N'户外驴',N'fa fa-car')
INSERT [ZL_PointGrounp] ([ID],[PointVal],[AddTime],[GroupName],[ImgUrl]) VALUES ( 4,1500,N'2015/7/31 16:07:54',N'老驴',N'fa fa-briefcase')
INSERT [ZL_PointGrounp] ([ID],[PointVal],[AddTime],[GroupName],[ImgUrl]) VALUES ( 5,3500,N'2015/7/31 16:08:11',N'老老驴',N'fa fa-chevron-up')
INSERT [ZL_PointGrounp] ([ID],[PointVal],[AddTime],[GroupName],[ImgUrl]) VALUES ( 6,5000,N'2015/7/31 16:08:44',N'专家驴',N'fa fa-user')
INSERT [ZL_PointGrounp] ([ID],[PointVal],[AddTime],[GroupName],[ImgUrl]) VALUES ( 7,10000,N'2015/9/12 9:09:45',N'骨灰级',N'fa fa-users')
SET IDENTITY_INSERT [ZL_PointGrounp] OFF

--注意：将清空全表数据

detele from ZL_PointGrounp

--注意：将删除整个表

drop table ZL_PointGrounp

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_PointGrounp