用户中心mysql数据库表结构的脚本
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
/* 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 ;
这是最新的用户中心的mysql数据库表结构脚本,直接可以运行的。
执行都是成功的。
下面是区域表的数据写入脚本
执行也是可以的。
下载:https://files.cnblogs.com/files/wohexiaocai/%E7%9C%81%E5%B8%82%E5%8C%BAMysql%E7%89%88%E6%9C%AC.zip
这是自己平时工作一点点的随笔记录,就不放在首页了,用心做好每件事情不容易
很多问题不见得会出在你身上,但你亦需要想法解决问题,否则就会变成你的问题。