DB_51aspx/2.mssql default data.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

TRUNCATE TABLE [Adm_Dept]
GO
SET IDENTITY_INSERT [Adm_Dept] ON
Insert Into [Adm_Dept] ([DeptID],[DeptName],[DeptParentID],[StatusFlag],[CreateTime],[CreateUser],[DeleteFlag],[DeleteTime],[UpdateUser],[UpdateTime],[Remark]) Values('1','后台系统','0','4','2013-07-18 14:36:34','1',0,'1900-01-01 00:00:00','0','1900-01-01 00:00:00','')
Insert Into [Adm_Dept] ([DeptID],[DeptName],[DeptParentID],[StatusFlag],[CreateTime],[CreateUser],[DeleteFlag],[DeleteTime],[UpdateUser],[UpdateTime],[Remark]) Values('2','技术部','1','4','2013-07-18 15:00:35','1',0,'1900-01-01 00:00:00','0','1900-01-01 00:00:00','')
Insert Into [Adm_Dept] ([DeptID],[DeptName],[DeptParentID],[StatusFlag],[CreateTime],[CreateUser],[DeleteFlag],[DeleteTime],[UpdateUser],[UpdateTime],[Remark]) Values('3','运营部','1','4','2013-07-18 15:01:45','1',0,'1900-01-01 00:00:00','0','1900-01-01 00:00:00','')
SET IDENTITY_INSERT [Adm_Dept] OFF
GO

TRUNCATE TABLE [Adm_Group]
GO
SET IDENTITY_INSERT [Adm_Group] ON
Insert Into [Adm_Group] ([GroupID],[GroupName],[StatusFlag],[GroupParentID],[CreateTime],[CreateUser],[DeleteFlag],[DeleteTime],[UpdateUser],[UpdateTime],[Remark]) Values('1','公司名称','4','0','2013-07-18 15:41:50','1',0,'1900-01-01 00:00:00','0','1900-01-01 00:00:00','')
Insert Into [Adm_Group] ([GroupID],[GroupName],[StatusFlag],[GroupParentID],[CreateTime],[CreateUser],[DeleteFlag],[DeleteTime],[UpdateUser],[UpdateTime],[Remark]) Values('2','系统管理员','4','1','2013-07-18 15:42:02','1',0,'1900-01-01 00:00:00','0','1900-01-01 00:00:00','')
SET IDENTITY_INSERT [Adm_Group] OFF
GO

TRUNCATE TABLE [Adm_GroupUser]
GO
SET IDENTITY_INSERT [Adm_GroupUser] ON
Insert Into [Adm_GroupUser] ([GroupUserID],[GroupID],[UserID]) Values('1','2','1')
SET IDENTITY_INSERT [Adm_GroupUser] OFF
GO

TRUNCATE TABLE [Adm_GroupUserRight]
GO
SET IDENTITY_INSERT [Adm_GroupUserRight] ON
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('1','2','26','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('2','2','6','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('3','2','5','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('4','2','7','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('5','2','8','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('6','2','9','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('7','2','23','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('8','2','24','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('9','2','25','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('10','2','10','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('11','2','15','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('12','2','16','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('13','2','17','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('14','2','18','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('15','2','19','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('16','2','11','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('17','2','20','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('18','2','21','2')
Insert Into [Adm_GroupUserRight] ([GroupRightID],[UserGroupID],[RightID],[UserGroupType]) Values('19','2','22','2')
SET IDENTITY_INSERT [Adm_GroupUserRight] OFF
GO

TRUNCATE TABLE [Adm_Rights]
GO
SET IDENTITY_INSERT [Adm_Rights] ON
Insert Into [Adm_Rights] ([RightsID],[RightsName],[RightsParentID],[DisplayName],[MenuType],[MenuPath],[MenuID],[URLName],[URLAddr],[StatusFalg],[OrderFlag],[MenuFlag],[RightMemo]) Values('1','SysManager','0','系统中心','1','1','0','','','4','1',0,'1111')
Insert Into [Adm_Rights] ([RightsID],[RightsName],[RightsParentID],[DisplayName],[MenuType],[MenuPath],[MenuID],[URLName],[URLAddr],[StatusFalg],[OrderFlag],[MenuFlag],[RightMemo]) Values('2','Sys002','1','用户权限','1','1^2','0','','','4','2',0,'')
Insert Into [Adm_Rights] ([RightsID],[RightsName],[RightsParentID],[DisplayName],[MenuType],[MenuPath],[MenuID],[URLName],[URLAddr],[StatusFalg],[OrderFlag],[MenuFlag],[RightMemo]) Values('3','Sys001','1','系统维护','1','1^3','0','','','4','1',0,'')
Insert Into [Adm_Rights] ([RightsID],[RightsName],[RightsParentID],[DisplayName],[MenuType],[MenuPath],[MenuID],[URLName],[URLAddr],[StatusFalg],[OrderFlag],[MenuFlag],[RightMemo]) Values('4','MenuRightsList','2','菜单模块管理','2','1^2^4','6','RightsList.aspx','/SysBase/RightsList.aspx','4','1',0,'')
Insert Into [Adm_Rights] ([RightsID],[RightsName],[RightsParentID],[DisplayName],[MenuType],[MenuPath],[MenuID],[URLName],[URLAddr],[StatusFalg],[OrderFlag],[MenuFlag],[RightMemo]) Values('5','RightsListEdit','2','菜单模块编辑','3','1^2^15','0','','','4','2',0,'')
Insert Into [Adm_Rights] ([RightsID],[RightsName],[RightsParentID],[DisplayName],[MenuType],[MenuPath],[MenuID],[URLName],[URLAddr],[StatusFalg],[OrderFlag],[MenuFlag],[RightMemo]) Values('6','RightsList','2','菜单模块管理','3','1^2^6','0','','','4','1',1,'')
Insert Into [Adm_Rights] ([RightsID],[RightsName],[RightsParentID],[DisplayName],[MenuType],[MenuPath],[MenuID],[URLName],[URLAddr],[StatusFalg],[OrderFlag],[MenuFlag],[RightMemo]) Values('7','RightsListAdd','2','菜单模块添加','3','1^2^20','0','','','4','3',0,'')
Insert Into [Adm_Rights] ([RightsID],[RightsName],[RightsParentID],[DisplayName],[MenuType],[MenuPath],[MenuID],[URLName],[URLAddr],[StatusFalg],[OrderFlag],[MenuFlag],[RightMemo]) Values('8','RightsListDel','2','菜单模块删除','3','1^2^21','0','','','4','4',0,'')