GO
CREATE TABLE [dbo].[ZL_ARoleAuth](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Rid] [int] NULL,
[model] [varchar](3000) NULL,
[content] [varchar](3000) NULL,
[crm] [varchar](3000) NULL,
[label] [varchar](3000) NULL,
[shop] [varchar](3000) NULL,
[store] [varchar](3000) NULL,
[page] [varchar](3000) NULL,
[user] [varchar](3000) NULL,
[other] [varchar](3000) NULL,
[edu] [varchar](3000) NULL,
[extend] [varchar](3000) NULL,
[system] [varchar](3000) NULL,
[oa] [varchar](3000) NULL,
[mobile] [varchar](3000) NULL,
[bar] [varchar](3000) NULL,
[site] [varchar](3000) NULL
) ON [PRIMARY]
SET ANSI_PADDING ON
ALTER TABLE [dbo].[ZL_ARoleAuth] ADD [pub] [varchar](3000) NULL
SET ANSI_PADDING OFF

SET IDENTITY_INSERT [ZL_ARoleAuth] ON
INSERT [ZL_ARoleAuth] ([ID],[Rid],[model],[content],[shop]) VALUES ( 1,2,N'ModelManage,ModelEdit,ShopModelManage,ShopModelEdit,PageModelManage,AddPageModel,NodeManage,NodeEdit,SpecManage',N'ContentMange,ContentSpec,ContentRecycle,ComentManage,CreateHtmL,OnlyMe,VideoManage,BarManage,AskManage,BaikeManage,GuestManage',N'ProductManage,StockManage,AddStock,CartManage,OrderList,BankRollList,SaleList,PayList,InvoiceList,TotalSale,ProductSale,CategotySale,UserOrders,UserExpenditure,DeliverType')
INSERT [ZL_ARoleAuth] ([ID],[Rid],[shop],[store],[user]) VALUES ( 2,3,N'ProductManage,StockManage,AddStock,CartManage,OrderList,BankRollList,SaleList,PayList,InvoiceList,TotalSale,ProductSale,CategotySale,UserOrders,UserExpenditure,DeliverType',N'ApplyStoreStyle,ApplyStoreStyleAdd,StoreManage,StoreExamine,StoreStyleManage,StoreStyleAdd,StoreProductManage,StoreinfoManage',N'AdminManage,AdminEdit,RoleMange,RoleEdit,UserManage,UserGroup,UserModel,UserModelField,UserRoleMange,UserRoleEdit,MessManage,EmailManage')
INSERT [ZL_ARoleAuth] ([ID],[Rid],[shop],[store]) VALUES ( 3,4,N'ProductManage,StockManage,AddStock,CartManage,OrderList,BankRollList,SaleList,PayList,InvoiceList,TotalSale,ProductSale,CategotySale,UserOrders,UserExpenditure,DeliverType',N'ApplyStoreStyle,ApplyStoreStyleAdd,StoreManage,StoreExamine,StoreStyleManage,StoreStyleAdd,StoreProductManage,StoreinfoManage')
INSERT [ZL_ARoleAuth] ([ID],[Rid],[user]) VALUES ( 4,5,N'AdminManage,AdminEdit,RoleMange,RoleEdit,UserManage,UserGroup,UserModel,UserModelField,UserRoleMange,UserRoleEdit,MessManage,EmailManage')
INSERT [ZL_ARoleAuth] ([ID],[Rid],[model],[label]) VALUES ( 5,6,N'ModelManage,ModelEdit,ShopModelManage,ShopModelEdit,PageModelManage,AddPageModel,NodeManage,NodeEdit,SpecManage',N'TemplateManage,TemplateEdit,CssManage,CssEdit,LabelManage,LabelEdit,LabelImport,LabelExport')
INSERT [ZL_ARoleAuth] ([ID],[Rid],[crm],[other]) VALUES ( 6,8,N'AllowOption,AllowOptionValue,AllowExcel,AllowAddClient,AllCustomer,AssignFPMan',N'PayManage,ADManage,StatInfoListReport,CorrectManage,LogManage,SourceManage,SurveyManage,GuestCateMana,DownServerManage,DictionaryManage,CustomerService,GameManage,DevCenter')
INSERT [ZL_ARoleAuth] ([ID],[Rid],[page]) VALUES ( 7,7,N'PageModelManage,PageModel,PageManage,PageAudit,PageContent,PageStyle,AddPageStyle')
SET IDENTITY_INSERT [ZL_ARoleAuth] OFF