• 用户中心mysql数据库表结构的脚本


    /*
    Navicat MySQL Data Transfer
    
    Source Server : rm-m5e3xn7k26i026e75o.mysql.rds.aliyuncs.com
    Source Server Version : 50629
    Source Host : rm-m5e3xn7k26i026e75o.mysql.rds.aliyuncs.com:3306
    Source Database : base
    
    Target Server Type : MYSQL
    Target Server Version : 50629
    File Encoding : 65001
    
    Date: 2016-09-19 12:37:16
    */
    
    SET FOREIGN_KEY_CHECKS=0;
    
    -- ----------------------------
    -- Table structure for basearea
    -- ----------------------------
    DROP TABLE IF EXISTS `basearea`;
    CREATE TABLE `basearea` (
    `Id` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
    `ParentId` int(11) DEFAULT NULL COMMENT '父节点',
    `Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '内码',
    `FullName` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '全名',
    `ShortName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '短名',
    `Layer` int(11) DEFAULT NULL,
    `Whole` smallint(1) NOT NULL DEFAULT '0' COMMENT '整体',
    `Send` smallint(1) NOT NULL DEFAULT '0' COMMENT '发送',
    `Receive` smallint(1) NOT NULL DEFAULT '0',
    `Postalcode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Province` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `City` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `District` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `QuickQuery` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SimpleSpelling` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Longitude` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Latitude` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NetworkOrders` int(11) DEFAULT '0',
    `AllowToPay` int(11) NOT NULL DEFAULT '0',
    `MaxToPayment` int(11) NOT NULL DEFAULT '0',
    `AllowGoodsPay` int(11) NOT NULL DEFAULT '0',
    `MaxGoodsPayment` int(11) NOT NULL DEFAULT '0',
    `ManageCompanyId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ManageCompanyCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ManageCompany` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Mark` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OutOfRange` smallint(1) DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(1) NOT NULL DEFAULT '0',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DelayDay` int(2) NOT NULL DEFAULT '0',
    `Opening` smallint(1) NOT NULL DEFAULT '0',
    `PrintMark` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Statistics` smallint(1) NOT NULL DEFAULT '1',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`),
    KEY `ParentId` (`ParentId`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basecomment
    -- ----------------------------
    DROP TABLE IF EXISTS `basecomment`;
    CREATE TABLE `basecomment` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ObjectId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Worked` smallint(6) DEFAULT '0',
    `Contents` text COLLATE utf8_unicode_ci,
    `IPAddress` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TargetURL` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basecontact
    -- ----------------------------
    DROP TABLE IF EXISTS `basecontact`;
    CREATE TABLE `basecontact` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Title` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Contents` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Priority` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SendCount` int(11) DEFAULT '0',
    `ReadCount` int(11) DEFAULT '0',
    `ReplyCount` int(11) DEFAULT NULL,
    `IsOpen` int(11) DEFAULT NULL,
    `CommentUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CommentUserRealName` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CommentDate` datetime DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basecontactdetails
    -- ----------------------------
    DROP TABLE IF EXISTS `basecontactdetails`;
    CREATE TABLE `basecontactdetails` (
    `Id` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ContactId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Category` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ReceiverId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ReceiverRealName` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IsNew` int(11) NOT NULL DEFAULT '0',
    `NewComment` int(11) NOT NULL DEFAULT '0',
    `LastViewIP` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `LastViewDate` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basedepartment
    -- ----------------------------
    DROP TABLE IF EXISTS `basedepartment`;
    CREATE TABLE `basedepartment` (
    `ID` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `PARENTID` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CODE` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SHORTNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FULLNAME` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
    `CATEGORYCODE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OUTERPHONE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `INNERPHONE` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FAX` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `DESCRIPTION` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CREATEON` datetime DEFAULT NULL,
    `CREATEUSERID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CREATEBY` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MODIFIEDON` datetime DEFAULT NULL,
    `MODIFIEDUSERID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MODIFIEDBY` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MANAGER` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MANAGERMOBILE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MANAGERQQ` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `PARENTNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `COMPANYID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `COMPANYNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `COMPANYCODE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `PARENTCODE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CATEGORYNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MANAGERID` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `STANDARDNAME` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `STANDARDCODE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`ID`),
    KEY `BASEDEPARTMENT_I` (`COMPANYID`,`CATEGORYCODE`,`DeletionStateCode`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseexception
    -- ----------------------------
    DROP TABLE IF EXISTS `baseexception`;
    CREATE TABLE `baseexception` (
    `LogId` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `SystemCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `EventId` int(11) DEFAULT NULL,
    `Category` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Priority` int(11) DEFAULT NULL,
    `Severity` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Title` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Timestamp` datetime DEFAULT NULL,
    `MachineName` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddress` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `AppDomainName` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ProcessId` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ProcessName` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ThreadName` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Win32ThreadId` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Message` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FormattedMessage` text COLLATE utf8_unicode_ci,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`LogId`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basefile
    -- ----------------------------
    DROP TABLE IF EXISTS `basefile`;
    CREATE TABLE `basefile` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `FolderId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FileName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FilePath` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ImageUrl` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Contents` blob,
    `ReadCount` int(11) NOT NULL DEFAULT '0',
    `FileSize` int(11) NOT NULL DEFAULT '0',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basefolder
    -- ----------------------------
    DROP TABLE IF EXISTS `basefolder`;
    CREATE TABLE `basefolder` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FolderName` varchar(400) COLLATE utf8_unicode_ci NOT NULL,
    `StateCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SortCode` int(11) NOT NULL,
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` int(11) DEFAULT '0',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseholidays
    -- ----------------------------
    DROP TABLE IF EXISTS `baseholidays`;
    CREATE TABLE `baseholidays` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `Holiday` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseitemdetails
    -- ----------------------------
    DROP TABLE IF EXISTS `baseitemdetails`;
    CREATE TABLE `baseitemdetails` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseitems
    -- ----------------------------
    DROP TABLE IF EXISTS `baseitems`;
    CREATE TABLE `baseitems` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `ParentId` int(11) DEFAULT NULL COMMENT '父节点主键',
    `Code` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT '编号',
    `FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
    `TargetTable` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '目标存储表',
    `IsTree` smallint(6) NOT NULL DEFAULT '0' COMMENT '树型结构',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseknowledge
    -- ----------------------------
    DROP TABLE IF EXISTS `baseknowledge`;
    CREATE TABLE `baseknowledge` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ObjectId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Worked` smallint(11) DEFAULT NULL,
    `Contents` text COLLATE utf8_unicode_ci,
    `Important` smallint(11) DEFAULT '0',
    `PriorityId` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddress` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TargetURL` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baselog
    -- ----------------------------
    DROP TABLE IF EXISTS `baselog`;
    CREATE TABLE `baselog` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `StartTime` datetime NOT NULL,
    `TaskId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Service` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ElapsedTicks` int(11) DEFAULT NULL,
    `UserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UserRealName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ClientIP` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
    `ServerIP` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WebUrl` varchar(1600) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Parameters` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UrlReferrer` varchar(1600) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basemessage
    -- ----------------------------
    DROP TABLE IF EXISTS `basemessage`;
    CREATE TABLE `basemessage` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FunctionCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ObjectId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ReceiverDepartmentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ReceiverDepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ReceiverId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ReceiverRealname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `QQ` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Telephone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Title` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Contents` text COLLATE utf8_unicode_ci,
    `IsNew` int(11) NOT NULL DEFAULT '0',
    `ReadCount` int(11) NOT NULL DEFAULT '0',
    `ReadDate` datetime DEFAULT NULL,
    `IPAddress` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TargetURL` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateDepartmentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateDepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basemessagerecent
    -- ----------------------------
    DROP TABLE IF EXISTS `basemessagerecent`;
    CREATE TABLE `basemessagerecent` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `UserId` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
    `TargetCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TargetId` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RealName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basemodifyrecord
    -- ----------------------------
    DROP TABLE IF EXISTS `basemodifyrecord`;
    CREATE TABLE `basemodifyrecord` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `TableCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TableDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ColumnCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ColumnDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RecordKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OldKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OldValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NewKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NewValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2538 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basemodule
    -- ----------------------------
    DROP TABLE IF EXISTS `basemodule`;
    CREATE TABLE `basemodule` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'UUID主键',
    `ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '父节点主键',
    `Code` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编号',
    `FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
    `CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'Application' COMMENT '分类',
    `ImagUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标图片地址',
    `ImageIndex` smallint(6) DEFAULT NULL COMMENT '图标编号',
    `SelectedImageIndex` smallint(6) DEFAULT NULL COMMENT '选中状态图标编号',
    `NavigateUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '导航地址',
    `Target` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'fraContent' COMMENT '目标窗体中打开',
    `WebBrowser` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '浏览器',
    `FormName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '窗体名',
    `AssemblyName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '动态连接库',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标志',
    `IsMenu` smallint(6) DEFAULT '0' COMMENT '是菜单项',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '是公开',
    `Expand` smallint(6) NOT NULL DEFAULT '0' COMMENT '展开状态',
    `IsScope` smallint(6) NOT NULL DEFAULT '0' COMMENT '权限域(需要数据权限)',
    `IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '是可见',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',
    `AuthorizedDays` smallint(11) NOT NULL DEFAULT '0' COMMENT '默认授权天数、默认多少天有数、0表示无限制',
    `Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basenews
    -- ----------------------------
    DROP TABLE IF EXISTS `basenews`;
    CREATE TABLE `basenews` (
    `Id` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FolderId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Title` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FilePath` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Source` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Introduction` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Keywords` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Contents` text COLLATE utf8_unicode_ci,
    `ReadCount` int(11) NOT NULL DEFAULT '0',
    `FileSize` int(11) NOT NULL DEFAULT '0',
    `ImageUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `HomePage` int(11) DEFAULT '0',
    `SubPage` int(11) DEFAULT NULL,
    `DepartmentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `AuditStatus` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basenotice
    -- ----------------------------
    DROP TABLE IF EXISTS `basenotice`;
    CREATE TABLE `basenotice` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterContent` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Worked` smallint(11) NOT NULL DEFAULT '0',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseorganize
    -- ----------------------------
    DROP TABLE IF EXISTS `baseorganize`;
    CREATE TABLE `baseorganize` (
    `Id` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    `ParentId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParentName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Code` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `FullName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ShortName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `StandardName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `StandardCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `StatisticalName` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `QuickQuery` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `SimpleSpelling` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `CategoryCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `OuterPhone` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `InnerPhone` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Fax` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Postalcode` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ProvinceId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Province` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `CityId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `City` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `DistrictId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `District` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `StreetId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Street` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyId` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyCode` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyName` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Area` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `CostCenter` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `FinancialCenter` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Address` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Web` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Bank` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `BankAccount` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Layer` int(11) DEFAULT NULL,
    `JoiningMethods` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Longitude` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Latitude` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ContainChildNodes` int(11) NOT NULL DEFAULT '0',
    `IsInnerOrganize` int(11) NOT NULL DEFAULT '0',
    `SendAir` int(11) DEFAULT '0',
    `CalculateComeFee` int(11) DEFAULT '0',
    `CalculateReceiveFee` int(11) DEFAULT '0',
    `BillBalanceSite` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `LevelTwoTransferCenter` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ProvinceSite` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `BigArea` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `SendFee` decimal(10,0) DEFAULT NULL,
    `LevelTwoTransferFee` decimal(10,0) DEFAULT NULL,
    `BillSubsidy` decimal(10,0) DEFAULT NULL,
    `CostCenterId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `FinancialCenterId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ManageId` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ManageName` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `IsCheckBalance` smallint(6) DEFAULT '0',
    `WeightRatio` int(11) DEFAULT NULL,
    `Master` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `MasterMobile` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `MasterQQ` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ManagerMobile` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ManagerQQ` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `EmergencyCall` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `BusinessPhone` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `Manager` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for baseorganizescope
    -- ----------------------------
    DROP TABLE IF EXISTS `baseorganizescope`;
    CREATE TABLE `baseorganizescope` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '自增主键',
    `ResourceCategory` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么类型的',
    `ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么资源主键',
    `PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限(模块菜单)主键',
    `AllData` smallint(6) DEFAULT '0' COMMENT '全部数据',
    `Province` smallint(6) DEFAULT '0' COMMENT '所在省',
    `City` smallint(6) DEFAULT '0' COMMENT '所在市',
    `District` smallint(6) DEFAULT '0' COMMENT '所在区/县',
    `Street` smallint(6) DEFAULT '0' COMMENT '所在街道',
    `UserCompany` smallint(6) DEFAULT '0' COMMENT '用户所在公司的数据',
    `UserSubCompany` smallint(6) DEFAULT '0' COMMENT '用户所在分公司的数据',
    `UserDepartment` smallint(6) DEFAULT '0' COMMENT '用户所在部门的数据',
    `UserSubDepartment` smallint(6) DEFAULT '0' COMMENT '用户所在子部门的数据',
    `UserWorkgroup` smallint(6) DEFAULT '0' COMMENT '用户所在工作组的数据',
    `OnlyOwnData` smallint(6) NOT NULL DEFAULT '1' COMMENT '仅仅用户自己的数据',
    `NotAllowed` smallint(6) DEFAULT '0' COMMENT '不允许查看数据',
    `ByDetails` smallint(6) DEFAULT '0' COMMENT '按明细设置',
    `ContainChild` smallint(6) NOT NULL DEFAULT '0' COMMENT '包含子节点的数据',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标示',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseorganize_log
    -- ----------------------------
    DROP TABLE IF EXISTS `baseorganize_log`;
    CREATE TABLE `baseorganize_log` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `TableCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TableDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ColumnCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ColumnDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RecordKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OldKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OldValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NewKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NewValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseparameter
    -- ----------------------------
    DROP TABLE IF EXISTS `baseparameter`;
    CREATE TABLE `baseparameter` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterContent` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Worked` smallint(11) NOT NULL DEFAULT '0',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basepermission
    -- ----------------------------
    DROP TABLE IF EXISTS `basepermission`;
    CREATE TABLE `basepermission` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资料类别',
    `ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源主键',
    `PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限(菜单模块)主键',
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司主键',
    `CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司名称',
    `PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限条件限制',
    `Enabled` smallint(6) DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT NULL COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT NULL COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basepermissionscope
    -- ----------------------------
    DROP TABLE IF EXISTS `basepermissionscope`;
    CREATE TABLE `basepermissionscope` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '自增主键',
    `ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么类型的',
    `ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么资源主键',
    `TargetCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '对什么类型的',
    `TargetId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '对什么资源主键',
    `PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限(模块菜单)主键',
    `ContainChild` smallint(6) NOT NULL DEFAULT '0' COMMENT '包含子节点',
    `PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限约束表达式',
    `StartDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '开始生效日期',
    `EndDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '结束生效日期',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baserole
    -- ----------------------------
    DROP TABLE IF EXISTS `baserole`;
    CREATE TABLE `baserole` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '主键',
    `OrganizeId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织机构主键',
    `Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色编号',
    `RealName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',
    `CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '可显示',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseroleorganize
    -- ----------------------------
    DROP TABLE IF EXISTS `baseroleorganize`;
    CREATE TABLE `baseroleorganize` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',
    `OrganizeId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '组织机构主键',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime NOT NULL COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baserole_deleted
    -- ----------------------------
    DROP TABLE IF EXISTS `baserole_deleted`;
    CREATE TABLE `baserole_deleted` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '主键',
    `OrganizeId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织机构主键',
    `Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色编号',
    `RealName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',
    `CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '可显示',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basesequence
    -- ----------------------------
    DROP TABLE IF EXISTS `basesequence`;
    CREATE TABLE `basesequence` (
    `Id` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `FullName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `Prefix` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Delimiter` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Sequence` int(11) NOT NULL DEFAULT '10000000',
    `Reduction` int(11) NOT NULL DEFAULT '9999999',
    `Step` int(11) NOT NULL DEFAULT '0',
    `IsVisible` int(11) NOT NULL DEFAULT '0',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT '0',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basestaff
    -- ----------------------------
    DROP TABLE IF EXISTS `basestaff`;
    CREATE TABLE `basestaff` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UserId` int(11) DEFAULT NULL,
    `UserName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RealName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `QuickQuery` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SubCompanyId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WorkgroupId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WorkgroupName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DutyId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Gender` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Birthday` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Age` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Height` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Weight` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IdentificationCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IDCard` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Nation` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Education` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `School` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Major` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Degree` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TitleId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TitleDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TitleLevel` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WorkingDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `JoinInDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OfficePostCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OfficeAddress` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OfficeFax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OfficePhone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `HomePostCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `HomeAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `HomeFax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `HomePhone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CarCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RewarCard` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MedicalCard` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UnionMember` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Mobile` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ShortNumber` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Telephone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Extension` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `EmergencyContact` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `QQ` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DimissionDate` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DimissionCause` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DimissionWhither` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NativePlace` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `BankName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `BankCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `BankUserName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Province` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `City` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `District` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CurrentProvince` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CurrentCity` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basestafforganize
    -- ----------------------------
    DROP TABLE IF EXISTS `basestafforganize`;
    CREATE TABLE `basestafforganize` (
    `Id` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `StaffId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OrganizeId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` int(11) DEFAULT NULL,
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for basetablecolumns
    -- ----------------------------
    DROP TABLE IF EXISTS `basetablecolumns`;
    CREATE TABLE `basetablecolumns` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `TableCode` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ColumnCode` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ColumnName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `ColumnAccess` int(11) DEFAULT '0',
    `ColumnEdit` int(11) DEFAULT '0',
    `ColumnDeney` int(11) DEFAULT '0',
    `UseConstraint` int(11) NOT NULL DEFAULT '0',
    `DataType` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TargetTable` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseuser
    -- ----------------------------
    DROP TABLE IF EXISTS `baseuser`;
    CREATE TABLE `baseuser` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `UserFrom` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ManagerId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UserName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RealName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NickName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Code` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IDCard` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `QuickQuery` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SimpleSpelling` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SubCompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SubCompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SubDepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SubDepartmentName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WorkgroupId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WorkgroupName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WorkCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SecurityLevel` int(11) DEFAULT NULL,
    `Title` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Duty` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Lang` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Gender` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Birthday` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Score` int(11) DEFAULT NULL,
    `Fans` int(11) DEFAULT NULL,
    `HomeAddress` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Signature` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Theme` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IsStaff` smallint(1) NOT NULL DEFAULT '0',
    `IsVisible` smallint(1) NOT NULL DEFAULT '0',
    `IsAdministrator` smallint(1) DEFAULT '0',
    `Province` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `City` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `District` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MANAGERAUDITSTATUS` int(11) DEFAULT NULL,
    `MANAGERAUDITDATE` date DEFAULT NULL,
    `IsCheckBalance` smallint(1) DEFAULT '0',
    `AuditStatus` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(1) DEFAULT '0',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`),
    KEY `USERNAME` (`UserName`) USING HASH
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseuseraddress
    -- ----------------------------
    DROP TABLE IF EXISTS `baseuseraddress`;
    CREATE TABLE `baseuseraddress` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `UserId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RealName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ProvinceId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Province` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CityId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `City` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DistrictId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `District` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Address` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,
    `PostCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Phone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Mobile` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Fax` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Email` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeliverCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `DeletionStateCode` int(11) DEFAULT NULL,
    `Enabled` int(11) DEFAULT NULL,
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseusercontact
    -- ----------------------------
    DROP TABLE IF EXISTS `baseusercontact`;
    CREATE TABLE `baseusercontact` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `EmailValiated` smallint(11) NOT NULL DEFAULT '0',
    `Mobile` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MobileValiated` smallint(11) DEFAULT '0',
    `MobileVerificationDate` datetime DEFAULT NULL,
    `ShowMobile` smallint(1) DEFAULT NULL,
    `ShortNumber` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Telephone` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Extension` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `QQ` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WW` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WeChat` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WeChatValiated` smallint(1) NOT NULL DEFAULT '0',
    `YiXin` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `YiXinValiated` smallint(1) NOT NULL DEFAULT '0',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseuserextend
    -- ----------------------------
    DROP TABLE IF EXISTS `baseuserextend`;
    CREATE TABLE `baseuserextend` (
    `Id` varchar(40) NOT NULL COMMENT '用户ID',
    `Fund` int(11) NOT NULL DEFAULT '0' COMMENT '用户金额',
    `Rate` int(11) NOT NULL DEFAULT '0' COMMENT '费率',
    `Category` int(1) NOT NULL DEFAULT '0' COMMENT '用户类别',
    `SMSContent` varchar(255) DEFAULT NULL COMMENT '消息内容',
    `CardId` varchar(20) DEFAULT NULL COMMENT '身份卡ID',
    `Express` varchar(50) DEFAULT NULL COMMENT '快递',
    `Email` varchar(50) DEFAULT NULL COMMENT '邮箱',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for baseuserlogon
    -- ----------------------------
    DROP TABLE IF EXISTS `baseuserlogon`;
    CREATE TABLE `baseuserlogon` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UserPassword` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OpenId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `AllowStartTime` datetime DEFAULT NULL,
    `AllowEndTime` datetime DEFAULT NULL,
    `LockStartDate` datetime DEFAULT NULL,
    `LockEndDate` datetime DEFAULT NULL,
    `FirstVisit` datetime DEFAULT NULL,
    `PreviousVisit` datetime DEFAULT NULL,
    `LastVisit` datetime DEFAULT NULL,
    `ChangePasswordDate` datetime DEFAULT NULL,
    `LogOnCount` int(11) NOT NULL DEFAULT '0',
    `Salt` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OpenIdTimeout` datetime DEFAULT NULL,
    `MultiUserLogin` smallint(11) DEFAULT '0',
    `ShowCount` int(11) NOT NULL DEFAULT '0',
    `PasswordErrorCount` smallint(11) NOT NULL DEFAULT '0',
    `UserOnLine` smallint(11) NOT NULL DEFAULT '0',
    `CheckIPAddress` smallint(11) NOT NULL DEFAULT '0',
    `VerificationCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MACAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Question` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `AnswerQuestion` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT NULL,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT NULL,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SystemCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddressName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `PasswordStrength` int(11) DEFAULT NULL,
    `Enabled` smallint(11) NOT NULL DEFAULT '1',
    `NeedModifyPassword` smallint(11) DEFAULT '0',
    `ComputerName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseuserorganize
    -- ----------------------------
    DROP TABLE IF EXISTS `baseuserorganize`;
    CREATE TABLE `baseuserorganize` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `UserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SubCompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SubDepartmentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `WorkgroupId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(1) NOT NULL DEFAULT '0',
    `DeletionStateCode` smallint(1) DEFAULT '0',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseuserrole
    -- ----------------------------
    DROP TABLE IF EXISTS `baseuserrole`;
    CREATE TABLE `baseuserrole` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `UserId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '用户主键',
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime NOT NULL COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`),
    KEY `UserId` (`UserId`,`Enabled`,`DeletionStateCode`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseuserscore
    -- ----------------------------
    DROP TABLE IF EXISTS `baseuserscore`;
    CREATE TABLE `baseuserscore` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `UserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Username` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Score` int(11) DEFAULT NULL,
    `FunctionCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ObjectId` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Contents` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for baseuser_log
    -- ----------------------------
    DROP TABLE IF EXISTS `baseuser_log`;
    CREATE TABLE `baseuser_log` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `TableCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TableDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ColumnCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ColumnDescription` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RecordKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OldKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OldValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NewKey` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `NewValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
    
    -- ----------------------------
    -- Table structure for base_loginlog
    -- ----------------------------
    DROP TABLE IF EXISTS `base_loginlog`;
    CREATE TABLE `base_loginlog` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
    `Companyid` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `UserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UserName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SystemCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `LoginStatus` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MACAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddress` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IPAddressName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ElapsedTicks` int(11) DEFAULT NULL,
    `Service` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for businesscard
    -- ----------------------------
    DROP TABLE IF EXISTS `businesscard`;
    CREATE TABLE `businesscard` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `FullName` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Company` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Title` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Phone` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Postalcode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Mobile` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Address` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Email` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `OfficePhone` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `QQ` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Fax` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Web` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `BankName` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `BankAccount` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `TaxAccount` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Personal` smallint(11) DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsallowdelete
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsallowdelete`;
    CREATE TABLE `itemsallowdelete` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsallowedit
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsallowedit`;
    CREATE TABLE `itemsallowedit` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsauditidea
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsauditidea`;
    CREATE TABLE `itemsauditidea` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsauditstatus
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsauditstatus`;
    CREATE TABLE `itemsauditstatus` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsbuglevel
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsbuglevel`;
    CREATE TABLE `itemsbuglevel` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemscondition
    -- ----------------------------
    DROP TABLE IF EXISTS `itemscondition`;
    CREATE TABLE `itemscondition` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsdegree
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsdegree`;
    CREATE TABLE `itemsdegree` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsdeletionstatecode
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsdeletionstatecode`;
    CREATE TABLE `itemsdeletionstatecode` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsduty
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsduty`;
    CREATE TABLE `itemsduty` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemseducation
    -- ----------------------------
    DROP TABLE IF EXISTS `itemseducation`;
    CREATE TABLE `itemseducation` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsenabled
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsenabled`;
    CREATE TABLE `itemsenabled` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsgender
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsgender`;
    CREATE TABLE `itemsgender` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsindustry
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsindustry`;
    CREATE TABLE `itemsindustry` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsleavecategory
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsleavecategory`;
    CREATE TABLE `itemsleavecategory` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemslinks
    -- ----------------------------
    DROP TABLE IF EXISTS `itemslinks`;
    CREATE TABLE `itemslinks` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemslockwaitminute
    -- ----------------------------
    DROP TABLE IF EXISTS `itemslockwaitminute`;
    CREATE TABLE `itemslockwaitminute` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsmarriage
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsmarriage`;
    CREATE TABLE `itemsmarriage` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsnationality
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsnationality`;
    CREATE TABLE `itemsnationality` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsnewscategory
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsnewscategory`;
    CREATE TABLE `itemsnewscategory` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsorganizecategory
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsorganizecategory`;
    CREATE TABLE `itemsorganizecategory` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsparty
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsparty`;
    CREATE TABLE `itemsparty` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemspriority
    -- ----------------------------
    DROP TABLE IF EXISTS `itemspriority`;
    CREATE TABLE `itemspriority` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsrolecategory
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsrolecategory`;
    CREATE TABLE `itemsrolecategory` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemssecuritylevel
    -- ----------------------------
    DROP TABLE IF EXISTS `itemssecuritylevel`;
    CREATE TABLE `itemssecuritylevel` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemssystem
    -- ----------------------------
    DROP TABLE IF EXISTS `itemssystem`;
    CREATE TABLE `itemssystem` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `LogonUrl` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(11) NOT NULL DEFAULT '0',
    `AllowEdit` smallint(11) NOT NULL DEFAULT '0',
    `AllowDelete` smallint(11) NOT NULL DEFAULT '0',
    `IsPublic` smallint(11) NOT NULL DEFAULT '0',
    `DeletionStateCode` smallint(11) NOT NULL DEFAULT '0',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemstablepermissionscope
    -- ----------------------------
    DROP TABLE IF EXISTS `itemstablepermissionscope`;
    CREATE TABLE `itemstablepermissionscope` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemstitle
    -- ----------------------------
    DROP TABLE IF EXISTS `itemstitle`;
    CREATE TABLE `itemstitle` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsunits
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsunits`;
    CREATE TABLE `itemsunits` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsworkcategory
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsworkcategory`;
    CREATE TABLE `itemsworkcategory` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsworkflowactivitycategories
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsworkflowactivitycategories`;
    CREATE TABLE `itemsworkflowactivitycategories` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsworkflowactivityname
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsworkflowactivityname`;
    CREATE TABLE `itemsworkflowactivityname` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsworkflowcategories
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsworkflowcategories`;
    CREATE TABLE `itemsworkflowcategories` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsworkingproperty
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsworkingproperty`;
    CREATE TABLE `itemsworkingproperty` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsworkstatus
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsworkstatus`;
    CREATE TABLE `itemsworkstatus` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for itemsyesno
    -- ----------------------------
    DROP TABLE IF EXISTS `itemsyesno`;
    CREATE TABLE `itemsyesno` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `ParentId` int(11) DEFAULT NULL,
    `ItemCode` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ItemValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '公开标记',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for presalemodule
    -- ----------------------------
    DROP TABLE IF EXISTS `presalemodule`;
    CREATE TABLE `presalemodule` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT 'UUID主键',
    `ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '父节点主键',
    `Code` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编号',
    `FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
    `CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'Application' COMMENT '分类',
    `ImagUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标图片地址',
    `ImageIndex` smallint(6) DEFAULT NULL COMMENT '图标编号',
    `SelectedImageIndex` smallint(6) DEFAULT NULL COMMENT '选中状态图标编号',
    `NavigateUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '导航地址',
    `Target` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'fraContent' COMMENT '目标窗体中打开',
    `WebBrowser` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '浏览器',
    `FormName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '窗体名',
    `AssemblyName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '动态连接库',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标志',
    `IsMenu` smallint(6) DEFAULT '0' COMMENT '是菜单项',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '是公开',
    `Expand` smallint(6) NOT NULL DEFAULT '0' COMMENT '展开状态',
    `IsScope` smallint(6) NOT NULL DEFAULT '0' COMMENT '权限域(需要数据权限)',
    `IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '是可见',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',
    `AuthorizedDays` int(11) NOT NULL DEFAULT '0' COMMENT '默认授权天数、默认多少天有数、0表示无限制',
    `Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
    
    -- ----------------------------
    -- Table structure for presalepermission
    -- ----------------------------
    DROP TABLE IF EXISTS `presalepermission`;
    CREATE TABLE `presalepermission` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资料类别',
    `ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源主键',
    `PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限(菜单模块)主键',
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司主键',
    `CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司名称',
    `PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限条件限制',
    `Enabled` smallint(6) DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`),
    KEY `Permission` (`ResourceCategory`,`ResourceId`,`PermissionId`,`Enabled`,`DeletionStateCode`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
    
    -- ----------------------------
    -- Table structure for presalerole
    -- ----------------------------
    DROP TABLE IF EXISTS `presalerole`;
    CREATE TABLE `presalerole` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT 'UUID主键',
    `OrganizeId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织机构主键',
    `Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色编号',
    `RealName` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',
    `CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '可显示',
    `SortCode` int(11) DEFAULT '0' COMMENT '排序码',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
    
    -- ----------------------------
    -- Table structure for presaleuserrole
    -- ----------------------------
    DROP TABLE IF EXISTS `presaleuserrole`;
    CREATE TABLE `presaleuserrole` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `UserId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '用户主键',
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime NOT NULL COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`),
    KEY `userid` (`UserId`) USING BTREE,
    KEY `roleid` (`RoleId`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
    
    -- ----------------------------
    -- Table structure for smssentlog
    -- ----------------------------
    DROP TABLE IF EXISTS `smssentlog`;
    CREATE TABLE `smssentlog` (
    `Id` bigint(20) NOT NULL DEFAULT '0',
    `Channel` smallint(6) DEFAULT NULL,
    `SystemCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyId` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CompanyName` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UserId` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UserCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `UserName` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `AccountCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ApplicationCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MessageID` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MessageContent` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `MessageCode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ExtendCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `DestinationAddress` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CustomerName` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    `SendType` int(11) DEFAULT NULL,
    `SendTime` datetime DEFAULT NULL,
    `IsWapPush` int(255) DEFAULT NULL,
    `MessageCount` smallint(6) DEFAULT NULL,
    `WapUrl` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateTime` datetime DEFAULT NULL,
    `GatawayStatus` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`),
    KEY `Company_User_Address` (`CompanyId`,`UserId`,`DestinationAddress`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for systemparameter
    -- ----------------------------
    DROP TABLE IF EXISTS `systemparameter`;
    CREATE TABLE `systemparameter` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ParameterContent` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL,
    `Worked` smallint(11) NOT NULL DEFAULT '0',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
    
    -- ----------------------------
    -- Table structure for test_area
    -- ----------------------------
    DROP TABLE IF EXISTS `test_area`;
    CREATE TABLE `test_area` (
    `Id` int(11) NOT NULL,
    `ParentId` int(11) DEFAULT NULL,
    `Name` varchar(20) NOT NULL,
    `QuickQuery` varchar(20) NOT NULL,
    `SimpleSpelling` varchar(20) NOT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Table structure for test_items
    -- ----------------------------
    DROP TABLE IF EXISTS `test_items`;
    CREATE TABLE `test_items` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `ParentId` int(11) DEFAULT NULL COMMENT '父节点主键',
    `Code` varchar(200) COLLATE utf8_unicode_ci NOT NULL COMMENT '编号',
    `FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
    `TargetTable` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT '目标存储表',
    `IsTree` smallint(6) NOT NULL DEFAULT '0' COMMENT '树型结构',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for test_module
    -- ----------------------------
    DROP TABLE IF EXISTS `test_module`;
    CREATE TABLE `test_module` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'UUID主键',
    `ParentId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '父节点主键',
    `Code` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编号',
    `FullName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
    `CategoryCode` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'Application' COMMENT '分类',
    `ImagUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '图标图片地址',
    `ImageIndex` smallint(6) DEFAULT NULL COMMENT '图标编号',
    `SelectedImageIndex` smallint(6) DEFAULT NULL COMMENT '选中状态图标编号',
    `NavigateUrl` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '导航地址',
    `Target` varchar(200) COLLATE utf8_unicode_ci DEFAULT 'fraContent' COMMENT '目标窗体中打开',
    `WebBrowser` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '浏览器',
    `FormName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '窗体名',
    `AssemblyName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '动态连接库',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标志',
    `IsMenu` smallint(6) DEFAULT '0' COMMENT '是菜单项',
    `IsPublic` smallint(6) NOT NULL DEFAULT '0' COMMENT '是公开',
    `Expand` smallint(6) NOT NULL DEFAULT '0' COMMENT '展开状态',
    `IsScope` smallint(6) NOT NULL DEFAULT '0' COMMENT '权限域(需要数据权限)',
    `IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '是可见',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `LastCall` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后被调用日期',
    `AuthorizedDays` int(11) NOT NULL DEFAULT '0' COMMENT '默认授权天数、默认多少天有数、0表示无限制',
    `Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for test_organizescope
    -- ----------------------------
    DROP TABLE IF EXISTS `test_organizescope`;
    CREATE TABLE `test_organizescope` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '自增主键',
    `ResourceCategory` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么类型的',
    `ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么资源主键',
    `PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限(模块菜单)主键',
    `AllData` smallint(6) DEFAULT '0' COMMENT '全部数据',
    `Province` smallint(6) DEFAULT '0' COMMENT '所在省',
    `City` smallint(6) DEFAULT '0' COMMENT '所在市',
    `District` smallint(6) DEFAULT '0' COMMENT '所在区/县',
    `Street` smallint(6) DEFAULT '0' COMMENT '所在街道',
    `UserCompany` smallint(6) DEFAULT '0' COMMENT '用户所在公司的数据',
    `UserSubCompany` smallint(6) DEFAULT '0' COMMENT '用户所在分公司的数据',
    `UserDepartment` smallint(6) DEFAULT '0' COMMENT '用户所在部门的数据',
    `UserSubDepartment` smallint(6) DEFAULT '0' COMMENT '用户所在子部门的数据',
    `UserWorkgroup` smallint(6) DEFAULT '0' COMMENT '用户所在工作组的数据',
    `OnlyOwnData` smallint(6) NOT NULL DEFAULT '1' COMMENT '仅仅用户自己的数据',
    `NotAllowed` smallint(6) DEFAULT '0' COMMENT '不允许查看数据',
    `ByDetails` smallint(6) DEFAULT '0' COMMENT '按明细设置',
    `ContainChild` smallint(6) NOT NULL DEFAULT '0' COMMENT '包含子节点的数据',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标示',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for test_permission
    -- ----------------------------
    DROP TABLE IF EXISTS `test_permission`;
    CREATE TABLE `test_permission` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资料类别',
    `ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资源主键',
    `PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限(菜单模块)主键',
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司主键',
    `CompanyName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '公司名称',
    `PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '权限条件限制',
    `Enabled` smallint(6) DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT NULL COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT NULL COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for test_permissionscope
    -- ----------------------------
    DROP TABLE IF EXISTS `test_permissionscope`;
    CREATE TABLE `test_permissionscope` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '自增主键',
    `ResourceCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么类型的',
    `ResourceId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '什么资源主键',
    `TargetCategory` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '对什么类型的',
    `TargetId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '对什么资源主键',
    `PermissionId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限(模块菜单)主键',
    `ContainChild` smallint(6) NOT NULL DEFAULT '0' COMMENT '包含子节点',
    `PermissionConstraint` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '有什么权限约束表达式',
    `StartDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '开始生效日期',
    `EndDate` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '结束生效日期',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for test_role
    -- ----------------------------
    DROP TABLE IF EXISTS `test_role`;
    CREATE TABLE `test_role` (
    `Id` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '主键',
    `OrganizeId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '组织机构主键',
    `Code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色编号',
    `RealName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '角色名称',
    `CategoryCode` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分类',
    `AllowEdit` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许编辑',
    `AllowDelete` smallint(6) NOT NULL DEFAULT '1' COMMENT '允许删除',
    `IsVisible` smallint(6) NOT NULL DEFAULT '1' COMMENT '可显示',
    `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for test_roleorganize
    -- ----------------------------
    DROP TABLE IF EXISTS `test_roleorganize`;
    CREATE TABLE `test_roleorganize` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',
    `OrganizeId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '组织机构主键',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime NOT NULL COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Table structure for test_userrole
    -- ----------------------------
    DROP TABLE IF EXISTS `test_userrole`;
    CREATE TABLE `test_userrole` (
    `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `UserId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '用户主键',
    `CompanyId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
    `RoleId` varchar(40) COLLATE utf8_unicode_ci NOT NULL COMMENT '角色主键',
    `Enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '有效标志',
    `DeletionStateCode` smallint(6) NOT NULL DEFAULT '0' COMMENT '删除标记',
    `Description` varchar(400) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
    `CreateOn` datetime NOT NULL COMMENT '创建日期',
    `CreateUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户主键',
    `CreateBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '创建用户',
    `ModifiedOn` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改日期',
    `ModifiedUserId` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户主键',
    `ModifiedBy` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '修改用户',
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=449 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    DROP TRIGGER IF EXISTS `TR_BaseCommentId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseCommentId` BEFORE INSERT ON `basecomment` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseContactId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseContactId` BEFORE INSERT ON `basecontact` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseContactDetailsId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseContactDetailsId` BEFORE INSERT ON `basecontactdetails` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseExceptionId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseExceptionId` BEFORE INSERT ON `baseexception` FOR EACH ROW if(NEW.LogId='' or NEW.LogId is null) then set NEW.LogId = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseFolderId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseFolderId` BEFORE INSERT ON `basefolder` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseKnowledgeId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseKnowledgeId` BEFORE INSERT ON `baseknowledge` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseModule`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseModule` BEFORE INSERT ON `basemodule` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseNewsId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseNewsId` BEFORE INSERT ON `basenews` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseParameterId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseParameterId` BEFORE INSERT ON `baseparameter` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseSequenceId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseSequenceId` BEFORE INSERT ON `basesequence` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseStaffOrganizeId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseStaffOrganizeId` BEFORE INSERT ON `basestafforganize` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BaseUserLogOnId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BaseUserLogOnId` BEFORE INSERT ON `baseuserlogon` FOR EACH ROW if(NEW.OpenId='' or NEW.OpenId is null) then set NEW.OpenId = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_BusinessCardId`;
    DELIMITER ;;
    CREATE TRIGGER `TR_BusinessCardId` BEFORE INSERT ON `businesscard` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_presaleModule`;
    DELIMITER ;;
    CREATE TRIGGER `TR_presaleModule` BEFORE INSERT ON `presalemodule` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_presaleRole`;
    DELIMITER ;;
    CREATE TRIGGER `TR_presaleRole` BEFORE INSERT ON `presalerole` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    DROP TRIGGER IF EXISTS `TR_module`;
    DELIMITER ;;
    CREATE TRIGGER `TR_module` BEFORE INSERT ON `test_module` FOR EACH ROW if(NEW.Id='' or NEW.Id is null) then set NEW.Id = uuid(); end if
    ;;
    DELIMITER ;
    UserCenter

    这是最新的用户中心的mysql数据库表结构脚本,直接可以运行的。

    执行都是成功的。

    下面是区域表的数据写入脚本

    执行也是可以的。

    下载:http://files.cnblogs.com/files/wohexiaocai/%E7%9C%81%E5%B8%82%E5%8C%BAMysql%E7%89%88%E6%9C%AC.zip

    这是自己平时工作一点点的随笔记录,就不放在首页了,用心做好每件事情不容易

    很多问题不见得会出在你身上,但你亦需要想法解决问题,否则就会变成你的问题。

  • 相关阅读:
    音频可视化
    accunulate
    node
    js 中编码(encode)和解码(decode)的三种方法
    ES6高阶 同步和异步 回调地狱 promise async和await
    区间dp
    树形dp1
    背包dp(多重)
    树形dp
    背包dp(完全)
  • 原文地址:https://www.cnblogs.com/wohexiaocai/p/5884782.html
Copyright © 2020-2023  润新知