表名:ZL_UserPromotions












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1pidint40  权限ID
2GroupIDint40    用户组ID
3lookint40    查看
4addToint40    添加
5Modifyint40    修改
6Columnsint40    仅当前节点
7Commentsint40    允许评论
8Deletedint40    删除
9NodeIDint40    节点ID
10ModelIDint40    模型ID
11quoteint40    引用权限
12downint40    下载权限

简要说明:

用户促销表

CREATE TABLE [dbo].[ZL_UserPromotions](
[pid] [int] IDENTITY(1,1) NOT NULL,
[GroupID] [int] NULL,
[look] [int] NULL,
[addTo] [int] NULL,
[Modify] [int] NULL,
[Columns] [int] NULL,
[Comments] [int] NULL,
[Deleted] [int] NULL,
[NodeID] [int] NULL,
[ModelID] [int] NULL,
[quote] [int] NULL,
[down][int] NULL,
CONSTRAINT [PK_ZL_UserPromotions] PRIMARY KEY CLUSTERED
([pid] ASC
) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'权限ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'pid'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'用户组ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'GroupID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'查看' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'look'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'addTo'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'修改' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'Modify'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'仅当前节点' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'Columns'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'允许评论' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'Comments'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'删除' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'Deleted'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'节点ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'NodeID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'模型ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserPromotions', @level2type=N'COLUMN',@level2name=N'ModelID'


SET IDENTITY_INSERT [ZL_UserPromotions] ON
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 1,1,1,1,1,1,1,1,1,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 2,1,1,1,1,1,1,1,2,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 3,1,1,1,1,1,1,1,3,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 4,1,1,1,1,1,1,1,8,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 5,1,1,1,1,1,1,1,9,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 6,1,1,1,1,1,1,1,10,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 7,1,1,1,1,1,1,1,11,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 8,1,1,1,1,1,1,1,12,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 9,1,1,1,1,1,1,1,13,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 10,1,1,1,1,1,1,1,15,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 11,1,1,1,1,1,1,1,16,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 12,1,1,1,1,1,1,1,17,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 13,1,1,1,1,1,1,1,18,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 14,1,1,1,1,1,1,1,19,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 15,1,1,1,1,1,1,1,20,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 16,1,1,1,1,1,1,1,21,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 17,1,1,1,1,1,1,1,22,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 18,1,1,1,1,1,1,1,23,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 19,1,1,1,1,1,1,1,24,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 20,1,1,1,1,1,1,1,25,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 21,1,1,1,1,1,1,1,26,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 22,1,1,1,1,1,1,1,27,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 23,1,1,1,1,1,1,1,28,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 24,1,1,1,1,1,1,1,29,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 25,1,1,1,1,1,1,1,30,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 26,1,1,1,1,1,1,1,31,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 27,1,1,1,1,1,1,1,32,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 28,1,1,1,1,1,1,1,33,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 29,1,1,1,1,1,1,1,34,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 30,1,1,1,1,1,1,1,35,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 31,1,1,1,1,1,1,1,36,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 32,1,1,1,1,1,1,1,37,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 33,1,1,1,1,1,1,1,38,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 34,1,1,1,1,1,1,1,39,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 35,1,1,1,1,1,1,1,40,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 36,1,1,1,1,1,1,1,41,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 37,1,1,1,1,1,1,1,42,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 38,1,1,1,1,1,1,1,43,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 39,1,1,1,1,1,1,1,44,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 40,1,1,1,1,1,1,1,45,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 41,1,1,1,1,1,1,1,46,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 42,1,1,1,1,1,1,1,47,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 43,1,1,1,1,1,1,1,48,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 44,1,1,1,1,1,1,1,49,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 45,1,1,1,1,1,1,1,50,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 46,1,1,1,1,1,1,1,51,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 47,1,1,1,1,1,1,1,52,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 48,1,1,1,1,1,1,1,53,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 49,1,1,1,1,1,1,1,54,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 50,1,1,1,1,1,1,1,55,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 51,1,1,1,1,1,1,1,56,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 52,1,1,1,1,1,1,1,57,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 53,1,1,1,1,1,1,1,58,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 54,1,1,1,1,1,1,1,59,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 55,1,1,1,1,1,1,1,60,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 56,1,1,1,1,1,1,1,61,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 57,1,1,1,1,1,1,1,62,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 58,1,1,1,1,1,1,1,63,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 59,1,1,1,1,1,1,1,64,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 60,1,1,1,1,1,1,1,65,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 61,1,1,1,1,1,1,1,66,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 62,1,1,1,1,1,1,1,67,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 63,1,1,1,1,1,1,1,68,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 64,1,1,1,1,1,1,1,69,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 65,1,1,1,1,1,1,1,70,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 66,1,1,1,1,1,1,1,71,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 67,1,1,1,1,1,1,1,72,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 68,1,1,1,1,1,1,1,73,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 69,1,1,1,1,1,1,1,74,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 70,1,1,1,1,1,1,1,75,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 71,1,1,1,1,1,1,1,76,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 72,1,1,1,1,1,1,1,77,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 73,1,1,1,1,1,1,1,78,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 74,1,1,1,1,1,1,1,79,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 75,1,1,1,1,1,1,1,80,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 76,1,1,1,1,1,1,1,81,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 77,1,1,1,1,1,1,1,82,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 78,1,1,1,1,1,1,1,83,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 79,1,1,1,1,1,1,1,84,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 80,1,1,1,1,1,1,1,85,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 81,1,1,1,1,1,1,1,86,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 82,1,1,1,1,1,1,1,87,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 83,1,1,1,1,1,1,1,88,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 84,1,1,1,1,1,1,1,89,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 85,1,1,1,1,1,1,1,90,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 86,1,1,1,1,1,1,1,91,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 87,1,1,1,1,1,1,1,92,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 88,1,1,1,1,1,1,1,93,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 89,1,1,1,1,1,1,1,94,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 90,1,1,1,1,1,1,1,95,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 91,1,1,1,1,1,1,1,96,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 92,1,1,1,1,1,1,1,97,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 93,1,1,1,1,1,1,1,98,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 94,1,1,1,1,1,1,1,99,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 95,1,1,1,1,1,1,1,100,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 96,1,1,1,1,1,1,1,101,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 97,1,1,1,1,1,1,1,102,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 98,1,1,1,1,1,1,1,103,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 99,1,1,1,1,1,1,1,104,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 100,1,1,1,1,1,1,1,105,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 101,1,1,1,1,1,1,1,106,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 102,1,1,1,1,1,1,1,107,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 103,1,1,1,1,1,1,1,108,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 104,1,1,1,1,1,1,1,109,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 105,1,1,1,1,1,1,1,110,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 106,1,1,1,1,1,1,1,111,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 107,1,1,1,1,1,1,1,112,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 108,1,1,1,1,1,1,1,113,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 109,1,1,1,1,1,1,1,114,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 110,1,1,1,1,1,1,1,115,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 111,1,1,1,1,1,1,1,116,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 112,1,1,1,1,1,1,1,117,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 113,1,1,1,1,1,1,1,118,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 114,1,1,1,1,1,1,1,119,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 115,1,1,1,1,1,1,1,120,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 116,1,1,1,1,1,1,1,121,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 117,1,1,1,1,1,1,1,122,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 118,1,1,1,1,1,1,1,123,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 119,1,1,1,1,1,1,1,124,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 120,1,1,1,1,1,1,1,125,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 121,1,1,1,1,1,1,1,126,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 122,1,1,1,1,1,1,1,127,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 123,1,1,1,1,1,1,1,128,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 124,1,1,1,1,1,1,1,129,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 125,1,1,1,1,1,1,1,130,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 126,1,1,1,1,1,1,1,131,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 127,1,1,1,1,1,1,1,132,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 128,1,1,1,1,1,1,1,133,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 129,1,1,1,1,1,1,1,134,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 130,1,1,1,1,1,1,1,135,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 131,1,1,1,1,1,1,1,136,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 132,1,1,1,1,1,1,1,137,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 133,1,1,1,1,1,1,1,138,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 134,1,1,1,1,1,1,1,139,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 135,1,1,1,1,1,1,1,201,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 136,1,1,1,1,1,1,1,203,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 137,1,1,1,1,1,1,1,206,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 138,2,1,1,1,1,1,1,1,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 139,2,1,1,1,1,1,1,2,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 140,2,1,1,1,1,1,1,3,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 141,2,1,1,1,1,1,1,8,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 142,2,1,1,1,1,1,1,9,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 143,2,1,1,1,1,1,1,10,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 144,2,1,1,1,1,1,1,11,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 145,2,1,1,1,1,1,1,12,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 146,2,1,1,1,1,1,1,13,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 147,2,1,1,1,1,1,1,15,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 148,2,1,1,1,1,1,1,16,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 149,2,1,1,1,1,1,1,17,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 150,2,1,1,1,1,1,1,18,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 151,2,1,1,1,1,1,1,19,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 152,2,1,1,1,1,1,1,20,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 153,2,1,1,1,1,1,1,21,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 154,2,1,1,1,1,1,1,22,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 155,2,1,1,1,1,1,1,23,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 156,2,1,1,1,1,1,1,24,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 157,2,1,1,1,1,1,1,25,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 158,2,1,1,1,1,1,1,26,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 159,2,1,1,1,1,1,1,27,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 160,2,1,1,1,1,1,1,28,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 161,2,1,1,1,1,1,1,29,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 162,2,1,1,1,1,1,1,30,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 163,2,1,1,1,1,1,1,31,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 164,2,1,1,1,1,1,1,32,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 165,2,1,1,1,1,1,1,33,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 166,2,1,1,1,1,1,1,34,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 167,2,1,1,1,1,1,1,35,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 168,2,1,1,1,1,1,1,36,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 169,2,1,1,1,1,1,1,37,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 170,2,1,1,1,1,1,1,38,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 171,2,1,1,1,1,1,1,39,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 172,2,1,1,1,1,1,1,40,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 173,2,1,1,1,1,1,1,41,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 174,2,1,1,1,1,1,1,42,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 175,2,1,1,1,1,1,1,43,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 176,2,1,1,1,1,1,1,44,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 177,2,1,1,1,1,1,1,45,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 178,2,1,1,1,1,1,1,46,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 179,2,1,1,1,1,1,1,47,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 180,2,1,1,1,1,1,1,48,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 181,2,1,1,1,1,1,1,49,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 182,2,1,1,1,1,1,1,50,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 183,2,1,1,1,1,1,1,51,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 184,2,1,1,1,1,1,1,52,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 185,2,1,1,1,1,1,1,53,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 186,2,1,1,1,1,1,1,54,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 187,2,1,1,1,1,1,1,55,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 188,2,1,1,1,1,1,1,56,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 189,2,1,1,1,1,1,1,57,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 190,2,1,1,1,1,1,1,58,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 191,2,1,1,1,1,1,1,59,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 192,2,1,1,1,1,1,1,60,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 193,2,1,1,1,1,1,1,61,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 194,2,1,1,1,1,1,1,62,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 195,2,1,1,1,1,1,1,63,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 196,2,1,1,1,1,1,1,64,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 197,2,1,1,1,1,1,1,65,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 198,2,1,1,1,1,1,1,66,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 199,2,1,1,1,1,1,1,67,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 200,2,1,1,1,1,1,1,68,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 201,2,1,1,1,1,1,1,69,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 202,2,1,1,1,1,1,1,70,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 203,2,1,1,1,1,1,1,71,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 204,2,1,1,1,1,1,1,72,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 205,2,1,1,1,1,1,1,73,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 206,2,1,1,1,1,1,1,74,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 207,2,1,1,1,1,1,1,75,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 208,2,1,1,1,1,1,1,76,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 209,2,1,1,1,1,1,1,77,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 210,2,1,1,1,1,1,1,78,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 211,2,1,1,1,1,1,1,79,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 212,2,1,1,1,1,1,1,80,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 213,2,1,1,1,1,1,1,81,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 214,2,1,1,1,1,1,1,82,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 215,2,1,1,1,1,1,1,83,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 216,2,1,1,1,1,1,1,84,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 217,2,1,1,1,1,1,1,85,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 218,2,1,1,1,1,1,1,86,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 219,2,1,1,1,1,1,1,87,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 220,2,1,1,1,1,1,1,88,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 221,2,1,1,1,1,1,1,89,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 222,2,1,1,1,1,1,1,90,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 223,2,1,1,1,1,1,1,91,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 224,2,1,1,1,1,1,1,92,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 225,2,1,1,1,1,1,1,93,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 226,2,1,1,1,1,1,1,94,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 227,2,1,1,1,1,1,1,95,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 228,2,1,1,1,1,1,1,96,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 229,2,1,1,1,1,1,1,97,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 230,2,1,1,1,1,1,1,98,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 231,2,1,1,1,1,1,1,99,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 232,2,1,1,1,1,1,1,100,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 233,2,1,1,1,1,1,1,101,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 234,2,1,1,1,1,1,1,102,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 235,2,1,1,1,1,1,1,103,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 236,2,1,1,1,1,1,1,104,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 237,2,1,1,1,1,1,1,105,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 238,2,1,1,1,1,1,1,106,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 239,2,1,1,1,1,1,1,107,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 240,2,1,1,1,1,1,1,108,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 241,2,1,1,1,1,1,1,109,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 242,2,1,1,1,1,1,1,110,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 243,2,1,1,1,1,1,1,111,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 244,2,1,1,1,1,1,1,112,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 245,2,1,1,1,1,1,1,113,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 246,2,1,1,1,1,1,1,114,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 247,2,1,1,1,1,1,1,115,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 248,2,1,1,1,1,1,1,116,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 249,2,1,1,1,1,1,1,117,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 250,2,1,1,1,1,1,1,118,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 251,2,1,1,1,1,1,1,119,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 252,2,1,1,1,1,1,1,120,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 253,2,1,1,1,1,1,1,121,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 254,2,1,1,1,1,1,1,122,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 255,2,1,1,1,1,1,1,123,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 256,2,1,1,1,1,1,1,124,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 257,2,1,1,1,1,1,1,125,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 258,2,1,1,1,1,1,1,126,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 259,2,1,1,1,1,1,1,127,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 260,2,1,1,1,1,1,1,128,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 261,2,1,1,1,1,1,1,129,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 262,2,1,1,1,1,1,1,130,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 263,2,1,1,1,1,1,1,131,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 264,2,1,1,1,1,1,1,132,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 265,2,1,1,1,1,1,1,133,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 266,2,1,1,1,1,1,1,134,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 267,2,1,1,1,1,1,1,135,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 268,2,1,1,1,1,1,1,136,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 269,2,1,1,1,1,1,1,137,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 270,2,1,1,1,1,1,1,138,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 271,2,1,1,1,1,1,1,139,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 272,2,1,1,1,1,1,1,201,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 273,2,1,1,1,1,1,1,203,1,1)
INSERT [ZL_UserPromotions] ([pid],[GroupID],[look],[addTo],[Modify],[Columns],[Comments],[Deleted],[NodeID],[quote],[down]) VALUES ( 274,2,1,1,1,1,1,1,206,1,1)
SET IDENTITY_INSERT [ZL_UserPromotions] OFF

 

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

detele from ZL_UserPromotions

--注意:将删除整个表

drop table ZL_UserPromotions

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

TRUNCATE table ZL_UserPromotions