表名：ZL_Design_RES












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2ztypevarchar500   是 资源类型 music|img
3useagenvarchar1000   是 用途 bk_pc|bk_h5
4namenvarchar5000   是 资源名称
5previewimgnvarchar10000   是 缩略图
6vpathnvarchar10000   是 虚拟路径
7cdatedatetime83   是 创建时间
8zstatusint40   是 状态
9useridint40   是 添加用户ID
10usenvarchar40000   是 用途(前端筛选)
11funnvarchar40000   是 功能
12stylenvarchar40000   是 风格

简要说明：

动力资源表

GO
CREATE TABLE [dbo].[ZL_Design_RES](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ztype] [varchar](50) NULL,
[useage] [nvarchar](100) NULL,
[name] [nvarchar](500) NULL,
[previewimg] [nvarchar](1000) NULL,
[vpath] [nvarchar](1000) NULL,
[cdate] [datetime] NULL,
[zstatus] [int] NULL,
[userid] [int] NULL,
[use] [nvarchar](4000) NULL,
[fun] [nvarchar](4000) NULL,
[style] [nvarchar](4000) NULL,
CONSTRAINT [PK_ZL_Design_RES] 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]

SET IDENTITY_INSERT [ZL_Design_RES] ON
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 1,N'img',N'bk_pc',N'xixixi',N'/UploadFiles/design/res/image/bk_pc/20160628153047yZAZ.thumb.jpg',N'/UploadFiles/design/res/image/bk_pc/20160628153047yZAZ.jpg',N'2016/6/28 15:30:47',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 2,N'img',N'bk_pc',N'xixixi',N'/UploadFiles/design/res/image/bk_pc/20160628153107pDqO.thumb.jpg',N'/UploadFiles/design/res/image/bk_pc/20160628153107pDqO.jpg',N'2016/6/28 15:31:07',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 3,N'img',N'bk_pc',N'xixixi',N'/UploadFiles/design/res/image/bk_pc/20160628153121LTPj.thumb.jpg',N'/UploadFiles/design/res/image/bk_pc/20160628153121LTPj.jpg',N'2016/6/28 15:31:21',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 4,N'img',N'bk_pc',N'xixixi',N'/UploadFiles/design/res/image/bk_pc/20160628153141Mt37.thumb.jpg',N'/UploadFiles/design/res/image/bk_pc/20160628153141Mt37.jpg',N'2016/6/28 15:31:41',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 5,N'img',N'bk_pc',N'xixixi',N'/UploadFiles/design/res/image/bk_pc/20160628153338GjN5.thumb.jpg',N'/UploadFiles/design/res/image/bk_pc/20160628153338GjN5.jpg',N'2016/6/28 15:33:38',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 6,N'img',N'bk_pc',N'xixixi',N'/UploadFiles/design/res/image/bk_pc/20160628153508Z9r1.thumb.jpg',N'/UploadFiles/design/res/image/bk_pc/20160628153508Z9r1.jpg',N'2016/6/28 15:35:09',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 7,N'img',N'bk_h5',N'xixixi',N'/UploadFiles/design/res/image/bk_h5/20160628153539q7Kl.thumb.png',N'/UploadFiles/design/res/image/bk_h5/20160628153539q7Kl.png',N'2016/6/28 15:35:40',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 8,N'img',N'bk_h5',N'xixixi',N'/UploadFiles/design/res/image/bk_h5/20160628153552cr81.thumb.jpg',N'/UploadFiles/design/res/image/bk_h5/20160628153552cr81.jpg',N'2016/6/28 15:35:52',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 9,N'img',N'bk_h5',N'xixixi',N'/UploadFiles/design/res/image/bk_h5/20160628153604m6lG.thumb.jpg',N'/UploadFiles/design/res/image/bk_h5/20160628153604m6lG.jpg',N'2016/6/28 15:36:05',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 10,N'img',N'bk_h5',N'xixixi',N'/UploadFiles/design/res/image/bk_h5/20160628153620AQsJ.thumb.jpg',N'/UploadFiles/design/res/image/bk_h5/20160628153620AQsJ.jpg',N'2016/6/28 15:36:20',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 11,N'img',N'bk_h5',N'xixixi',N'/UploadFiles/design/res/image/bk_h5/201606281536341KMq.thumb.jpg',N'/UploadFiles/design/res/image/bk_h5/201606281536341KMq.jpg',N'2016/6/28 15:36:34',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 12,N'img',N'bk_h5',N'xixixi',N'/UploadFiles/design/res/image/bk_h5/20160628153658yqZd.thumb.png',N'/UploadFiles/design/res/image/bk_h5/20160628153658yqZd.png',N'2016/6/28 15:36:59',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[previewimg],[vpath],[cdate],[zstatus],[userid]) VALUES ( 13,N'img',N'bk_h5',N'xixixi',N'/UploadFiles/design/res/image/bk_h5/20160628153721Gkpl.thumb.jpg',N'/UploadFiles/design/res/image/bk_h5/20160628153721Gkpl.jpg',N'2016/6/28 15:37:21',0,1)
INSERT [ZL_Design_RES] ([ID],[ztype],[useage],[name],[vpath],[cdate],[zstatus],[userid]) VALUES ( 14,N'music',N'bk_h5',N'xixixi',N'/UploadFiles/design/res/music/bk_h5/201606281557382xXc.mp3',N'2016/6/28 15:57:38',0,1)
SET IDENTITY_INSERT [ZL_Design_RES] OFF

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

detele from ZL_Design_RES

--注意：将删除整个表

drop table ZL_Design_RES

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

TRUNCATE table ZL_Design_RES