表名:ZL_Search












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40   
2namenvarchar2550    快速链接名称
3typeint40    链接类型:1为后台链接,2为会员链接
4linkTypeint40    链接类型
5stateint40    状态:1为启用,2为关闭
6linkStateint40    0:后台,3:会员
7OpenTypeint40    链接打开方式 0为原窗口,1为新窗口,2为父窗口,3为全局
8AdminIDint40    管理员ID
9timedatetime83    创建时间
10fileUrlnvarchar2000    文件与路径
11iconvarchar2000    图标
12Sizeint40    块大小:1大,2中,3小
13Mobileint40    支持移动:1为支持,0为不支持
14UserGroupvarchar80000    用户组ids
15EliteLevelint40    是否推荐:0为不推荐   1为推荐
16OrderIDint40    排序
17BKColornvarchar1000    背景色

简要说明:

后台快速功能表

GO
CREATE TABLE [dbo].[ZL_Search](
[ID] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](255) NOT NULL,
[type] [int] NOT NULL,
[linkType] [int] NULL,
[state] [int] NULL,
[linkState] [int] NULL,
[OpenType] [int] NULL,
[AdminID] [int] NULL,
[time] [datetime] NULL,
[fileUrl] [nvarchar](200) NULL,
[ico] [nvarchar](200) NULL,
[Size] [int] NULL,
[Mobile] [int] NULL,
[UserGroup] [varchar](8000) NULL,
[EliteLevel] [int] NULL,
[OrderID] [int] NULL,
[BKColor] [nvarchar](100) NULL,
CONSTRAINT [PK_search] 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_Search] ON
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 1,N'系统配置',1,1,2,0,1,N'2015/8/25 9:47:38',N'/Manage/Config/SiteInfo.aspx',N'fa fa-cog',2,0,0,1,N'#852b99')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 2,N'内容管理',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/Content/ContentManage.aspx',N'fa fa-tree',3,1,0,2,N'#4B7F8C')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 3,N'模型管理',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/Content/Model/ModelManage.aspx?ModelType=1',N'fa fa-file',2,0,0,3,N'#1E86EA')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 4,N'标签管理',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/Template/LabelManage.aspx',N'fa fa-eyedropper',2,0,0,4,N'#ffb848')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 5,N'模板管理',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/Template/TemplateManage.aspx',N'fa fa-list-alt',2,0,0,5,N'#00CCFF')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 6,N'会员管理',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/User/UserManage.aspx',N'fa fa-user',2,1,0,6,N'#FE7906')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 7,N'邮件配置',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/Config/MailConfig.aspx',N'fa fa-envelope',2,0,0,7,N'#004B9B')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 8,N'安全设定',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/User/AdminManage.aspx',N'fa fa-fire',2,0,0,8,N'#74B512')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 9,N'留言管理',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/Guest/GuestManage.aspx',N'fa fa-comment',2,0,0,9,N'#A43AE3')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 10,N'订单列表',1,1,2,0,1,N'2012/1/1 0:00:00',N'/Manage/Shop/OrderList.aspx',N'fa fa-shopping-cart',2,1,0,10,N'#22AFC2')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 11,N'技术论坛',1,1,2,1,1,N'2012/1/1 0:00:00',N'http://bbs.z01.com',N'fa fa-question-circle',1,0,0,11,N'#808081')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[EliteLevel],[OrderID],[BKColor]) VALUES ( 12,N'视频教程',1,1,2,1,1,N'2012/1/1 0:00:00',N'http://www.z01.com/mtv/',N'fa fa-film',1,0,0,12,N'#F874A4')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 13,N'我的信息',2,1,2,0,1,N'2015/8/25 9:33:20',N'/user/Info/UserInfo',N'fa fa-user',3,1,N'1,2',1,13,N'#852b99')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 14,N'内容管理',2,1,2,0,1,N'2015/8/25 9:47:56',N'/user/Content/MyContent',N'fa fa-list-alt',3,1,N'1,2',1,14,N'#4B7F8C')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 15,N'商城订单',2,1,3,0,1,N'2015/8/24 14:55:32',N'/User/Order/OrderList',N'fa fa-shopping-cart',3,1,N'1,2',1,15,N'#1E86EA')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 16,N'我的店铺',2,1,2,0,1,N'2015/8/14 16:39:30',N'/user/UserShop/',N'fa fa-home',3,1,N'1,2',1,16,N'#ffb848')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 17,N'店铺订单',2,1,2,0,1,N'2015/8/14 16:39:49',N'/User/UserShop/OrderList',N'fa fa-shopping-cart',3,1,N'1,2',1,17,N'#00CCFF')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 18,N'黄页管理',2,1,2,0,1,N'2015/8/14 16:40:08',N'/user/Pages/Default',N'fa fa-copyright',3,1,N'1,2',1,18,N'#FE7906')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 19,N'OA办公系统',2,1,2,0,1,N'2015/8/14 16:40:25',N'/Office/',N'fa fa-align-left',3,1,N'1,2',1,19,N'#004B9B')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 20,N'排课系统',2,1,3,0,1,N'2015/8/21 17:43:29',N'/BU/Ke/ConfigList.aspx',N'fa fa-tasks',3,1,N'1,2',1,20,N'#74B512')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 21,N'短信通知',2,1,3,0,1,N'2015/8/24 14:54:59',N'/user/Message/Message',N'fa fa-comment',3,1,N'1,2',1,21,N'#A43AE3')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 22,N'智写',2,1,3,0,1,N'2015/8/21 17:44:25',N'/Plugins/Third/wordPanel.html',N'fa fa-font',3,1,N'1,2',1,22,N'#22AFC2')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 23,N'有问必答',2,1,3,0,1,N'2015/8/21 17:45:56',N'/user/iServer/FiServer',N'fa fa-comments',3,1,N'1,2',1,23,N'#808081')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 24,N'贴吧问答',2,1,3,0,1,N'2015/8/21 18:06:16',N'/Bar/Index',N'fa fa-bullhorn',3,1,N'1,2',1,24,N'#F874A4')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 25,N'日程安排',2,1,3,0,1,N'2015/8/24 16:41:49',N'/BU/ke/DailyPlan.aspx',N'fa fa-calendar',3,1,N'1,2',1,25,N'#852b99')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 26,N'订阅管理',2,1,3,0,1,N'2015/8/24 16:31:29',N'/User/UserZone/MySubscription',N'fa fa-rss',3,1,N'1,2',1,26,N'#4B7F8C')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 27,N'财务管理',2,1,3,0,1,N'2015/8/24 16:31:36',N'/User/Info/Listprofit',N'fa fa-usd',3,1,N'1,2',1,27,N'#1E86EA')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 28,N'申请OA',2,1,3,0,1,N'2015/8/24 16:36:11',N'/Plat/Common/Apply.aspx',N'fa fa-users',3,1,N'1,2',1,28,N'#ffb848')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 29,N'抵用券',2,1,3,0,1,N'2015/8/24 16:36:30',N'/User/CashCoupon/ArriveManage',N'fa fa-file-text',3,1,N'1,2',1,29,N'#00CCFF')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 30,N'VIP卡',2,1,3,0,1,N'2015/8/24 16:30:44',N'/User/Info/DredgeVip',N'fa fa-credit-card-alt',3,1,N'1,2',1,30,N'#FE7906')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 31,N'项目管理',2,1,3,0,1,N'2015/8/21 18:11:20',N'/Plat/Note/ProList.aspx',N'fa fa-th-large',3,1,N'1,2',0,31,N'#004B9B')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 32,N'问卷投票',2,1,3,0,1,N'2015/8/24 16:37:55',N'/User/Survey/SurveyAll',N'fa fa-list-alt',3,1,N'1,2',1,32,N'#74B512')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 33,N'H5创作',2,1,3,0,1,N'2015/8/24 16:31:10',N'/design/h5/',N'fa fa-pencil',3,1,N'1,2',1,33,N'#A43AE3')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 34,N'IDC',2,1,3,0,1,N'2015/8/24 14:53:12',N'/Plugins/Domain/Domname.aspx?Page=7',N'fa fa-globe',3,1,N'1,2',1,34,N'#22AFC2')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 35,N'授权证书生成',2,1,3,0,1,N'2015/8/21 18:13:35',N'/User/UserFunc/Watermark',N'fa fa-barcode',3,1,N'1,2',0,36,N'#808081')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 36,N'我的互动',2,1,3,0,1,N'2015/8/24 9:49:28',N'/User/Pub/ManagePub',N'fa fa-refresh',3,1,N'1,2',0,38,N'#F874A4')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 37,N'我的问答',2,1,3,0,1,N'2015/8/24 9:52:21',N'/User/Guest/MyAsk',N'fa fa-question',3,1,N'1,2',0,39,N'#852b99')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 38,N'我的百科',2,1,3,0,1,N'2015/8/24 16:42:01',N'/User/Guest/BaikeContribution',N'fa fa-font',3,1,N'1,2',1,40,N'#4B7F8C')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 39,N'推广赚钱',2,1,3,0,1,N'2015/8/24 9:55:59',N'/User/UserFunc/PromotUnion',N'fa fa-usd',3,1,N'1,2',0,42,N'#1E86EA')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 40,N'考试系统',2,1,3,0,1,N'2015/8/24 10:00:56',N'/User/Questions/MyCoruse',N'fa fa-list-alt',3,1,N'1,2',0,45,N'#ffb848')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 41,N'组卷系统',2,1,3,0,1,N'2015/8/24 16:42:13',N'/User/Exam/QuestionManage',N'fa fa-copy',3,1,N'1,2',1,46,N'#00CCFF')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 42,N'聊天系统',2,1,3,0,1,N'2015/8/24 10:03:18',N'/User/UserFunc/TalkLog',N'fa fa-wechat',3,1,N'1,2',0,47,N'#FE7906')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 43,N'收藏夹',2,1,3,0,1,N'2015/8/24 16:43:31',N'/User/Content/MyFavori?type=1',N'fa fa-heart-o',3,1,N'1,2',1,49,N'#004B9B')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 44,N'广告申请',2,1,3,0,1,N'2015/8/24 15:24:23',N'/User/UserFunc/AdPlanAdd',N'fa fa-plus',3,1,N'1,2',0,51,N'#74B512')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 45,N'每日签到',2,1,3,0,1,N'2015/8/24 15:44:06',N'/User/UserFunc/UserSignin',N'fa fa-clock-o',3,1,N'1,2',0,53,N'#A43AE3')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 46,N'优惠券',2,1,3,0,1,N'2015/8/24 16:02:29',N'/User/CashCoupon/ArriveManage',N'fa fa-bookmark-o',3,1,N'1,2',0,54,N'#22AFC2')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 47,N'地址簿',2,1,3,0,1,N'2015/8/24 16:03:38',N'/User/Info/UserRecei',N'fa fa-map-marker',3,1,N'1,2',0,56,N'#808081')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 48,N'节日提醒',2,1,3,0,1,N'2015/8/24 16:04:18',N'/User/UserFunc/UserDay',N'fa fa-birthday-cake',3,1,N'1,2',0,57,N'#F874A4')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 49,N'广告计划',2,1,3,0,1,N'2015/8/24 16:20:04',N'/User/UserFunc/AdPlan',N'fa fa-paper-plane-o',3,1,N'1,2',0,60,N'#852b99')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 50,N'二级密码',2,1,3,0,1,N'2015/8/24 16:22:27',N'/User/UserFunc/SetSecondPwd',N'fa fa-lock',3,1,N'1,2',0,61,N'#4B7F8C')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 51,N'修改邮箱',2,1,3,0,1,N'2015/8/24 16:23:03',N'/User/Change/Email',N'fa fa-envelope-o',3,1,N'1,2',0,62,N'#1E86EA')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 52,N'修改手机',2,1,3,0,1,N'2015/8/24 16:23:41',N'/User/Change/Mobile',N'fa fa-mobile',3,1,N'1,2',0,63,N'#ffb848')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 53,N'注册域名',2,1,3,0,1,N'2015/8/24 16:24:28',N'/Plugins/Domain/DomName.aspx',N'fa fa-edit',3,1,N'1,2',0,64,N'#00CCFF')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 54,N'评论管理',2,1,3,0,1,N'2015/8/24 16:25:22',N'/User/Pub/PubManage',N'fa fa-comments-o',3,1,N'1,2',0,65,N'#FE7906')
INSERT [ZL_Search] ([ID],[name],[type],[state],[linkState],[OpenType],[AdminID],[time],[fileUrl],[ico],[Size],[Mobile],[UserGroup],[EliteLevel],[OrderID],[BKColor]) VALUES ( 55,N'邀请码',2,1,3,0,1,N'2015/8/24 16:26:25',N'/User/UserFunc/InviteCode',N'fa fa-qrcode',3,1,N'1,2',0,66,N'#004B9B')
SET IDENTITY_INSERT [ZL_Search] OFF

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

detele from ZL_Search

--注意:将删除整个表

drop table ZL_Search

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

TRUNCATE table ZL_Search