SET IDENTITY_INSERT [FP_WMS_UserInfo] ON
INSERT [FP_WMS_UserInfo] ([id], [roleid], [departid], [gradeid], [type], [username], [password], [password2], [email], [isemail], [mobile], [ismobile], [realname], [isreal], [nickname], [avatar], [sex], [exp], [credits], [regip], [joindatetime], [onlinestate], [lastip], [lastvisit], [secques], [authstr], [authtime], [authflag], [vipdate], [bday], [bloodtype], [height], [weight], [married], [education], [school], [job], [position], [politics], [company], [nation], [phone], [qq], [blog], [province], [city], [address], [zipcode], [note], [idcard], [isidcard], [idcardface], [idcardback], [idcardper], [idcarvalidity], [content]) VALUES (1, 1, 0, 0, NULL, N'admin', N'e10adc3949ba59abbe56e057f20f883e', N'', N'12677206@qq.com', 1, N'13481092810', 1, N'方配', 0, N'方配', N'', -1, 0, 0, N'', CAST(0x0000A31900000000 AS DateTime), 1, N'0.0.0.0', CAST(0x0000A56100A372F8 AS DateTime), N'', N'', CAST(0x0000A31900000000 AS DateTime), 0, N'', N',,', N'', N'', N'', 0, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', 0, N'', N'', N'', CAST(0x0000A3E1012F3C84 AS DateTime), N'')
SET IDENTITY_INSERT [FP_WMS_UserInfo] OFF
GO
SET IDENTITY_INSERT [FP_WMS_RoleInfo] ON
INSERT [FP_WMS_RoleInfo] ([id], [name], [description], [desktopurl], [sorts], [menus], [desktop], [permission], [isadmin], [isupload], [isdownload]) VALUES (1, N'系统管理员', N'', N'', N'1,2', N'29', N'1,2,3,4,5', N'', 0, 0, 0)
INSERT [FP_WMS_RoleInfo] ([id], [name], [description], [desktopurl], [sorts], [menus], [desktop], [permission], [isadmin], [isupload], [isdownload]) VALUES (2, N'游客', N'', NULL, NULL, NULL, NULL, N'', 0, NULL, NULL)
INSERT [FP_WMS_RoleInfo] ([id], [name], [description], [desktopurl], [sorts], [menus], [desktop], [permission], [isadmin], [isupload], [isdownload]) VALUES (3, N'等待验证', N'', NULL, NULL, NULL, NULL, N'', 0, NULL, NULL)
INSERT [FP_WMS_RoleInfo] ([id], [name], [description], [desktopurl], [sorts], [menus], [desktop], [permission], [isadmin], [isupload], [isdownload]) VALUES (4, N'禁止访问', N'', N'', N'', N'', N'', N'', 0, 0, 0)
INSERT [FP_WMS_RoleInfo] ([id], [name], [description], [desktopurl], [sorts], [menus], [desktop], [permission], [isadmin], [isupload], [isdownload]) VALUES (5, N'注册用户', N'', N'', N'', N'', N'', N'', 0, 1, 1)
SET IDENTITY_INSERT [FP_WMS_RoleInfo] OFF
GO
SET IDENTITY_INSERT [FP_WMS_MenuInfo] ON
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (1, 0, N'系统管理', N'', N'', 1, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (2, 1, N'系统常规设置', N'', N'', 1, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (3, 2, N'系统基础配置', N'', N'global/sysconfigmanage.aspx', 1, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (5, 2, N'系统文件管理', N'', N'global/sysfilesmanage.aspx', 5, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (6, 2, N'系统缓存管理', N'', N'global/cachemanage.aspx', 6, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (7, 2, N'系统操作日志', N'', N'global/syslogmanage.aspx', 10, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (8, 2, N'邮箱短信配置', N'', N'global/emailconfigmanage.aspx', 11, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (9, 2, N'系统菜单管理', N'', N'global/sysmenumanage.aspx', 7, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (10, 40, N'上传图片配置', N'', N'global/watermarkset.aspx', 10, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (11, 40, N'上传附件类型', N'', N'global/attachtypemanage.aspx', 11, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (12, 40, N'上传附件管理', N'', N'global/attachmanage.aspx', 12, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (13, 1, N'系统用户设置', N'', N'', 3, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (14, 13, N'系统角色管理', N'', N'user/rolemanage.aspx', 1, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (15, 13, N'操作权限管理', N'', N'user/permissionmanage.aspx', 2, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (16, 13, N'用户部门管理', N'', N'user/departmentmanage.aspx', 3, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (17, 13, N'用户级别管理', N'', N'user/usergrademanage.aspx', 4, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (18, 13, N'用户注册配置', N'', N'user/regconfigmanage.aspx', 5, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (19, 13, N'等待验证用户', N'', N'user/userauditing.aspx', 8, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (20, 13, N'系统用户管理', N'', N'user/usermanage.aspx', 9, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (21, 1, N'系统栏目设置', N'', N'', 2, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (22, 2, N'系统站点管理', N'', N'global/sitemanage.aspx', 2, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (23, 21, N'系统栏目管理', N'', N'sort/sortmanage.aspx', 3, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (25, 1, N'系统数据库设置', N'', N'', 5, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (26, 25, N'在线运行SQL命令', N'', N'dbset/runsql.aspx', 1, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (27, 25, N'数据库备份还原', N'', N'dbset/dbbackup.aspx', 2, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (28, 25, N'数据库收缩优化', N'', N'dbset/dbshrink.aspx', 3, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (30, 2, N'系统桌面管理', N'', N'global/desktopmanage.aspx', 8, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (31, 21, N'栏目功能管理', N'', N'sort/sortappmanage.aspx', 2, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (32, 21, N'系统分类管理', N'', N'sort/typemanage.aspx', 4, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (34, 21, N'栏目频道管理', N'', N'sort/channelmanage.aspx', 1, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (36, 2, N'系统插件管理', N'', N'global/pluginmanage.aspx', 4, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (39, 25, N'重置清空数据库', N'', N'dbset/dbreset.aspx', 4, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (40, 1, N'上传附件设置', N'', N'', 4, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (41, 2, N'系统应用管理', N'', N'global/appmanage.aspx', 3, 1)
INSERT [FP_WMS_MenuInfo] ([id], [parentid], [name], [lefturl], [righturl], [display], [system]) VALUES (42, 2, N'系统计划任务', N'', N'global/taskmanage.aspx', 9, 1)
SET IDENTITY_INSERT [FP_WMS_MenuInfo] OFF
GO
SET IDENTITY_INSERT [FP_WMS_DesktopInfo] ON
INSERT [FP_WMS_DesktopInfo] ([id], [uid], [name], [icon], [lefturl], [righturl], [description], [hidden], [system]) VALUES (1, 0, N'系统设置', N'/admin/images/icon32/sys.gif', N'', N'global/sysconfigmanage.aspx', N'', 0, 1)
INSERT [FP_WMS_DesktopInfo] ([id], [uid], [name], [icon], [lefturl], [righturl], [description], [hidden], [system]) VALUES (2, 0, N'站点管理', N'/admin/images/icon32/sites.gif', N'', N'global/sitemanage.aspx', N'', 0, 1)
INSERT [FP_WMS_DesktopInfo] ([id], [uid], [name], [icon], [lefturl], [righturl], [description], [hidden], [system]) VALUES (3, 0, N'角色管理', N'/admin/images/icon32/role.gif', N'', N'user/rolemanage.aspx', N'', 0, 1)
INSERT [FP_WMS_DesktopInfo] ([id], [uid], [name], [icon], [lefturl], [righturl], [description], [hidden], [system]) VALUES (4, 0, N'用户管理', N'/admin/images/icon32/users.gif', N'', N'user/usermanage.aspx', N'', 0, 1)
INSERT [FP_WMS_DesktopInfo] ([id], [uid], [name], [icon], [lefturl], [righturl], [description], [hidden], [system]) VALUES (5, 0, N'栏目管理', N'/admin/images/icon32/sort.gif', N'', N'sort/sortmanage.aspx', N'', 0, 1)
SET IDENTITY_INSERT [FP_WMS_DesktopInfo] OFF
GO
SET IDENTITY_INSERT [FP_WMS_AttachType] ON
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (1, N'jpg', 4096, N'图片文件(JPG)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (3, N'gif', 4096, N'图片文件(GIF)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (4, N'zip', 4096, N'压缩文件(ZIP)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (6, N'png', 4096, N'图片文件(PNG)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (7, N'rar', 4096, N'压缩文件(RAR)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (8, N'doc', 4096, N'文档文件(DOC)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (9, N'xls', 4096, N'表格文件(XLS)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (10, N'flv', 10240, N'视频文件(FLV)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (11, N'ppt', 4096, N'幻灯文件(PPT)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (12, N'swf', 4096, N'Flash文件')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (13, N'docx', 4096, N'文档文件(DOCX)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (14, N'xlsx', 4096, N'文档文件(XLSX)')
INSERT [FP_WMS_AttachType] ([id], [extension], [maxsize], [type]) VALUES (15, N'pdf', 4096, N'PDF文件')
SET IDENTITY_INSERT [FP_WMS_AttachType] OFF
