表名：ZL_RolePermissions












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1RoleIDint40   否 主键ID
2OperateCodenvarchar500   否 操作代码
3NodeIDint40   是 节点ID

简要说明：

角色权限表


GO
CREATE TABLE [dbo].[ZL_RolePermissions](
[RoleID] [int] NOT NULL,
[OperateCode] [nvarchar](50) NOT NULL,
[NodeID] [int] NULL
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作代码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RolePermissions', @level2type=N'COLUMN', @level2name=N'OperateCode'

INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ContentMange' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ContentEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ContentSpec' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ContentRecycle' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ComentManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'CreateHtmL' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ModelManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ModelEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ShopModelManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ShopModelEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'PageModelManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'AddPageModel' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'NodeManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'NodeEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'SpecCateManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'SpecManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'TemplateManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'TemplateEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'CssManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'CssEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'LabelManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'LabelEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'LabelImport' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'LabelExport' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'AdminManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'AdminEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'RoleMange' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'RoleEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'UserManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'UserGroup' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'UserModel' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'UserModelField' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'UserRoleMange' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'UserRoleEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'MessManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'EmailManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ProductManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'StockManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'AddStock' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'CartManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'OrderList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'BankRollList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'SaleList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'PayList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'InvoiceList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'TotalSale' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ProductSale' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'CategotySale' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'UserOrders' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'UserExpenditure' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'DeliverType' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'PageModel' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'PageManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'PageAudit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'PageContent' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'PageStyle' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'AddPageStyle' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ApplyStoreStyle' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ApplyStoreStyleAdd' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'StoreManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'StoreExamine' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'StoreStyleManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'StoreStyleAdd' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'StoreProductManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'StoreinfoManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneConfig' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneApply' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneStyleManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneProductManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneParking' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneMoney' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneGS' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ZoneInfo' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'ADManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'SurveyManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'FileManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'AuthorManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'DownServerManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'SourceManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 1 , 'DicManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 2 , 'ContentMange' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 2 , 'ContentEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 2 , 'ContentSpec' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 2 , 'ContentRecycle' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 2 , 'ComentManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 2 , 'CreateHtmL' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 3 , 'ApplyStoreStyle' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 3 , 'ApplyStoreStyleAdd' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 3 , 'StoreManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 3 , 'StoreExamine' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 3 , 'StoreStyleManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 3 , 'StoreStyleAdd' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 3 , 'StoreProductManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 3 , 'StoreinfoManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'ProductManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'StockManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'AddStock' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'CartManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'OrderList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'BankRollList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'SaleList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'PayList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'InvoiceList' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'TotalSale' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'ProductSale' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'CategotySale' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'UserOrders' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'UserExpenditure' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 4 , 'DeliverType' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'AdminManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'AdminEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'RoleMange' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'RoleEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'UserManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'UserGroup' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'UserModel' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'UserModelField' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'UserRoleMange' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'UserRoleEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'MessManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 5 , 'EmailManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 6 , 'TemplateManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 6 , 'TemplateEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 6 , 'CssManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 6 , 'CssEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 6 , 'LabelManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 6 , 'LabelEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 6 , 'LabelImport' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 6 , 'LabelExport' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 7 , 'PageModelManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 7 , 'PageModel' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 7 , 'PageManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 7 , 'PageAudit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 7 , 'PageContent' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 7 , 'PageStyle' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 7 , 'AddPageStyle' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'ModelManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'ModelEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'ShopModelManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'ShopModelEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'ADManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'AddPageModel' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'NodeManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'NodeEdit' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'SpecCateManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'SpecManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'SurveyManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'FileManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'AuthorManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'DownServerManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'SourceManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 8 , 'DicManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneConfig' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneApply' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneStyleManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneProductManage' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneParking' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneMoney' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneGS' )
INSERT [ZL_RolePermissions] ( [RoleID] , [OperateCode] ) VALUES ( 9 , 'ZoneInfo' )

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

detele from ZL_RolePermissions

--注意：将删除整个表

drop table ZL_RolePermissions

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

TRUNCATE table ZL_RolePermissions