ExtJs Web开发框架ExtApp v1.0.0

/* Navicat SQL Server Data Transfer Source Server : SQL Server Source Server Version : 130000 Source Host : .\SQLEXPRESS:1433 Source Database : ExtApp Source Schema : dbo Target Server Type : SQL Server Target Server Version : 130000 File Encoding : 65001 Date: 2017-04-16 11:06:10 */ -- ---------------------------- -- Table structure for AppConfig -- ---------------------------- DROP TABLE [dbo].[AppConfig] GO CREATE TABLE [dbo].[AppConfig] ( [ID] int NOT NULL IDENTITY(1,1) , [Name] nvarchar(255) NULL , [ConfigKey] nvarchar(255) NULL , [ConfigValue] nvarchar(255) NULL , [Status] int NULL , [SectionID] int NULL , [Sort] int NULL , [Comment] nvarchar(255) NULL ) GO DBCC CHECKIDENT(N'[dbo].[AppConfig]', RESEED, 2) GO -- ---------------------------- -- Records of AppConfig -- ---------------------------- SET IDENTITY_INSERT [dbo].[AppConfig] ON GO INSERT INTO [dbo].[AppConfig] ([ID], [Name], [ConfigKey], [ConfigValue], [Status], [SectionID], [Sort], [Comment]) VALUES (N'1', N'用户初始密码', N'UserInitPwd', N'123', N'1', N'2', N'1', N'用户管理重置用户密码。') GO GO INSERT INTO [dbo].[AppConfig] ([ID], [Name], [ConfigKey], [ConfigValue], [Status], [SectionID], [Sort], [Comment]) VALUES (N'2', N'数据库名称', N'DatabaseName', N'ExtApp', N'1', N'1003', N'1', N'连接数据库的名称，数据库备份还原使用。') GO GO SET IDENTITY_INSERT [dbo].[AppConfig] OFF GO -- ---------------------------- -- Table structure for AppConfigSection -- ---------------------------- DROP TABLE [dbo].[AppConfigSection] GO CREATE TABLE [dbo].[AppConfigSection] ( [ID] int NOT NULL IDENTITY(1,1) , [Name] nvarchar(255) NULL , [Status] int NULL , [SectionID] int NULL , [Sort] int NULL , [Comment] nvarchar(255) NULL ) GO DBCC CHECKIDENT(N'[dbo].[AppConfigSection]', RESEED, 1003) GO -- ---------------------------- -- Records of AppConfigSection -- ---------------------------- SET IDENTITY_INSERT [dbo].[AppConfigSection] ON GO INSERT INTO [dbo].[AppConfigSection] ([ID], [Name], [Status], [SectionID], [Sort], [Comment]) VALUES (N'2', N'用户配置', N'1', null, N'1', null) GO GO INSERT INTO [dbo].[AppConfigSection] ([ID], [Name], [Status], [SectionID], [Sort], [Comment]) VALUES (N'1003', N'数据库配置', N'1', null, N'2', null) GO GO SET IDENTITY_INSERT [dbo].[AppConfigSection] OFF GO -- ---------------------------- -- Table structure for AppDatabaseBackup -- ---------------------------- DROP TABLE [dbo].[AppDatabaseBackup] GO CREATE TABLE [dbo].[AppDatabaseBackup] ( [ID] int NOT NULL IDENTITY(1,1) , [Name] nvarchar(255) NULL , [FileName] nvarchar(255) NULL , [AddTime] datetime NULL , [IsCurrent] bit NULL , [AddUserID] int NULL , [Comment] nvarchar(255) NULL ) GO DBCC CHECKIDENT(N'[dbo].[AppDatabaseBackup]', RESEED, 2) GO -- ---------------------------- -- Records of AppDatabaseBackup -- ---------------------------- SET IDENTITY_INSERT [dbo].[AppDatabaseBackup] ON GO INSERT INTO [dbo].[AppDatabaseBackup] ([ID], [Name], [FileName], [AddTime], [IsCurrent], [AddUserID], [Comment]) VALUES (N'2', N'数据库2017-04-15备份', N'ExtApp20170415154144.bak', N'2017-04-15 15:41:44.000', N'0', N'1', null) GO GO SET IDENTITY_INSERT [dbo].[AppDatabaseBackup] OFF GO -- ---------------------------- -- Table structure for AppDept -- ---------------------------- DROP TABLE [dbo].[AppDept] GO CREATE TABLE [dbo].[AppDept] ( [ID] int NOT NULL IDENTITY(1,1) , [PID] int NULL , [Code] nvarchar(255) NULL , [Name] nvarchar(255) NULL , [Status] int NULL , [AddTime] datetime NULL , [Sort] int NULL , [Comment] nvarchar(255) NULL , [AddUserID] int NULL , [Type] int NULL ) GO DBCC CHECKIDENT(N'[dbo].[AppDept]', RESEED, 3026) GO -- ---------------------------- -- Records of AppDept -- ---------------------------- SET IDENTITY_INSERT [dbo].[AppDept] ON GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3014', null, N'001', N'董事会', N'1', N'2017-03-17 07:34:24.000', N'1', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3015', N'3014', N'001001', N'总经理办', N'1', N'2017-03-17 07:40:10.000', N'1', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3017', N'3014', N'001002', N'研发部', N'1', N'2017-03-18 07:41:25.000', N'2', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3018', N'3017', N'001002001', N'项目部', N'1', N'2017-03-18 07:43:18.000', N'1', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3019', N'3017', N'001002002', N'产品部', N'1', N'2017-03-18 07:43:28.000', N'2', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3020', N'3014', N'001003', N'财务部', N'1', N'2017-03-18 07:43:45.000', N'3', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3021', N'3014', N'001004', N'综合部', N'1', N'2017-03-18 07:43:56.000', N'4', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3024', N'3020', N'001003001', N'会计', N'1', N'2017-03-20 07:54:33.000', N'1', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3025', N'3020', N'001003002', N'出纳', N'1', N'2017-03-20 07:54:49.000', N'2', null, N'1', N'1') GO GO INSERT INTO [dbo].[AppDept] ([ID], [PID], [Code], [Name], [Status], [AddTime], [Sort], [Comment], [AddUserID], [Type]) VALUES (N'3026', N'3017', N'001002003', N'测试部', N'1', N'2017-03-25 07:30:07.000', N'3', null, N'1', N'1') GO GO SET IDENTITY_INSERT [dbo].[AppDept] OFF GO -- ---------------------------- -- Table structure for AppDic -- ---------------------------- DROP TABLE [dbo].[AppDic] GO CREATE TABLE [dbo].[AppDic] ( [ID] int NOT NULL IDENTITY(1,1) , [Code] nvarchar(255) NULL , [Type] int NULL , [Name] nvarchar(255) NULL , [Status] int NULL , [Sort] int NULL , [Comment] nvarchar(255) NULL ) GO DBCC CHECKIDENT(N'[dbo].[AppDic]', RESEED, 6) GO -- ---------------------------- -- Records of AppDic -- ---------------------------- SET IDENTITY_INSERT [dbo].[AppDic] ON GO INSERT INTO [dbo].[AppDic] ([ID], [Code], [Type], [Name], [Status], [Sort], [Comment]) VALUES (N'1', N'LogType', N'0', N'日志类型', N'1', N'1', null) GO GO INSERT INTO [dbo].[AppDic] ([ID], [Code], [Type], [Name], [Status], [Sort], [Comment]) VALUES (N'2', N'LogSource', N'0', N'日志来源', N'1', N'2', null) GO GO INSERT INTO [dbo].[AppDic] ([ID], [Code], [Type], [Name], [Status], [Sort], [Comment]) VALUES (N'3', N'LogLevel', N'0', N'日志等级', N'1', N'3', null) GO GO INSERT INTO [dbo].[AppDic] ([ID], [Code], [Type], [Name], [Status], [Sort], [Comment]) VALUES (N'4', N'Sex', N'0', N'性别', N'1', N'4', null) GO GO INSERT INTO [dbo].[AppDic] ([ID], [Code], [Type], [Name], [Status], [Sort], [Comment]) VALUES (N'5', N'FrameStyle', N'0', N'框架样式', N'1', N'5', null) GO GO INSERT INTO [dbo].[AppDic] ([ID], [Code], [Type], [Name], [Status], [Sort], [Comment]) VALUES (N'6', N'ExtJsTheme', N'0', N'ExtJs主题', N'1', N'6', null) GO GO SET IDENTITY_INSERT [dbo].[AppDic] OFF GO -- ----------------