通用权限管理系统组件3.9 的 Oracle 数据库创建脚本参考
2013-09-06 15:42 通用C#系统架构 阅读(466) 评论(0) 编辑 收藏 举报---------------------------------------------------- -- Export file for user USERCENTER -- -- Created by Administrator on 2013/9/6, 13:42:13 -- ---------------------------------------------------- spool userCenter.log prompt prompt Creating table BASEITEMDETAILS prompt ============================== prompt create table BASEITEMDETAILS ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEITEMDETAILS add constraint PK_BASEITEMDETAILS primary key (ID); prompt prompt Creating table BASEITEMS prompt ======================== prompt create table BASEITEMS ( ID NUMBER(10) not null, PARENTID NUMBER(10), CODE VARCHAR2(50), FULLNAME VARCHAR2(200) not null, TARGETTABLE VARCHAR2(50), ISTREE NUMBER(1) default 0, USEITEMCODE VARCHAR2(50), USEITEMNAME VARCHAR2(50), USEITEMVALUE VARCHAR2(50), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, DESCRIPTION VARCHAR2(800), ENABLED NUMBER(1) default 1 not null, SORTCODE NUMBER(10), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEITEMS add constraint PK_BASEITEMS primary key (ID); prompt prompt Creating table BASEKNOWLEDGE prompt ============================ prompt create table BASEKNOWLEDGE ( ID VARCHAR2(50) not null, PARENTID VARCHAR2(50), RECEIVERDEPARTMENTID VARCHAR2(50), RECEIVERDEPARTMENTNAME VARCHAR2(50), RECEIVERID VARCHAR2(50), RECEIVERREALNAME VARCHAR2(50), CATEGORYCODE VARCHAR2(50) default 'Message', FUNCTIONCODE VARCHAR2(50), OBJECTID VARCHAR2(50), TITLE VARCHAR2(100), CONTENTS VARCHAR2(800), ISNEW NUMBER(1) default 1, READCOUNT NUMBER(1) default 0 not null, READDATE DATE, TARGETURL VARCHAR2(400), IPADDRESS VARCHAR2(50), QQ CHAR(10), EMAIL CHAR(10), TELEPHONE CHAR(10), CREATEDEPARTMENTID VARCHAR2(50), CREATEDEPARTMENTNAME VARCHAR2(50), DELETIONSTATECODE NUMBER(1) default 0, ENABLED NUMBER(1) default 1 not null, DESCRIPTION VARCHAR2(200), SORTCODE NUMBER(10), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEKNOWLEDGE add constraint PK_BASEKNOWLEDGE primary key (ID); prompt prompt Creating table BASELOG prompt ====================== prompt create table BASELOG ( LOGID NUMBER(10) not null, USERID VARCHAR2(50), USERREALNAME VARCHAR2(50), PROCESSID VARCHAR2(200), PROCESSNAME VARCHAR2(200), METHODID VARCHAR2(200), METHODNAME VARCHAR2(200), PARAMETERS VARCHAR2(200), URLREFERRER VARCHAR2(200), IPADDRESS VARCHAR2(50), WEBURL VARCHAR2(800), DESCRIPTION VARCHAR2(800), CREATEON DATE, MODIFIEDON DATE ) ; alter table BASELOG add constraint PK_BASELOG primary key (LOGID); prompt prompt Creating table BASEMESSAGE prompt ========================== prompt create table BASEMESSAGE ( ID VARCHAR2(50) not null, PARENTID VARCHAR2(50), RECEIVERDEPARTMENTID VARCHAR2(50), RECEIVERDEPARTMENTNAME VARCHAR2(50), RECEIVERID VARCHAR2(50), RECEIVERREALNAME VARCHAR2(50), CATEGORYCODE VARCHAR2(50) default 'Message', FUNCTIONCODE VARCHAR2(50), OBJECTID VARCHAR2(50), TITLE VARCHAR2(100), CONTENTS VARCHAR2(800), ISNEW NUMBER(1) default 1, READCOUNT NUMBER(10) default 0 not null, READDATE DATE, TARGETURL VARCHAR2(400), IPADDRESS VARCHAR2(50), QQ VARCHAR2(50), EMAIL VARCHAR2(50), TELEPHONE VARCHAR2(50), CREATEDEPARTMENTID VARCHAR2(50), CREATEDEPARTMENTNAME VARCHAR2(50), DELETIONSTATECODE NUMBER(1) default 0, ENABLED NUMBER(1) default 1 not null, DESCRIPTION VARCHAR2(200), SORTCODE NUMBER(10), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEMESSAGE add constraint PK_BASEMESSAGE primary key (ID); prompt prompt Creating table BASEMODULE prompt ========================= prompt create table BASEMODULE ( ID NUMBER(10) not null, PARENTID NUMBER(10), CODE VARCHAR2(100), FULLNAME VARCHAR2(200) not null, CATEGORYCODE VARCHAR2(50), IMAGURL VARCHAR2(200), IMAGEINDEX VARCHAR2(50), SELECTEDIMAGEINDEX VARCHAR2(50), NAVIGATEURL VARCHAR2(500), TARGET VARCHAR2(100), FORMNAME VARCHAR2(100), ASSEMBLYNAME VARCHAR2(100), PERMISSIONSCOPETABLES VARCHAR2(500), ISMENU NUMBER(1) default 1, ISSCOPE NUMBER(1) default 0, ISPUBLIC NUMBER(1) default 1 not null, ISVISIBLE NUMBER(1) default 1, LASTCALL DATE, SORTCODE NUMBER(10), ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1), EXPAND NUMBER(1) default 0 not null, ALLOWEDIT NUMBER(1) default 1, ALLOWDELETE NUMBER(1) default 1, DESCRIPTION VARCHAR2(500), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEMODULE add constraint PK_BASEMODULE primary key (ID); prompt prompt Creating table BASEORGANIZE prompt =========================== prompt create table BASEORGANIZE ( ID NUMBER(10) not null, PARENTID NUMBER(10), CODE VARCHAR2(50), SHORTNAME VARCHAR2(50), FULLNAME VARCHAR2(200) not null, CATEGORYCODE VARCHAR2(50), LAYER NUMBER(2) default 0, OUTERPHONE VARCHAR2(50), INNERPHONE VARCHAR2(50), FAX VARCHAR2(50), POSTALCODE VARCHAR2(50), ADDRESS VARCHAR2(200), WEB VARCHAR2(200), ISINNERORGANIZE NUMBER(1) default 1 not null, BANK VARCHAR2(50), BANKACCOUNT VARCHAR2(50), DELETIONSTATECODE NUMBER(1) default 0, ENABLED NUMBER(1) default 1, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEORGANIZE add constraint PK_BASEORGANIZE primary key (ID); prompt prompt Creating table BASEPARAMETER prompt ============================ prompt create table BASEPARAMETER ( ID VARCHAR2(50) not null, CATEGORYCODE VARCHAR2(50), PARAMETERID VARCHAR2(50), PARAMETERCODE VARCHAR2(50), PARAMETERCONTENT VARCHAR2(800), WORKED NUMBER(1) default 0 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(200), CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), CREATEON DATE, MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEPARAMETER add constraint PK_BASEPARAMETER primary key (ID); prompt prompt Creating table BASEPERMISSION prompt ============================= prompt create table BASEPERMISSION ( ID NUMBER(10) not null, RESOURCECATEGORY VARCHAR2(50), RESOURCEID VARCHAR2(50), PERMISSIONID NUMBER(10), PERMISSIONCONSTRAINT VARCHAR2(200), ENABLED NUMBER(1) default 1, DELETIONSTATECODE NUMBER(1) default 0, DESCRIPTION VARCHAR2(500), CREATEON DATE, CREATEBY VARCHAR2(50), CREATEUSERID VARCHAR2(50), MODIFIEDON DATE, MODIFIEDBY VARCHAR2(50), MODIFIEDUSERID VARCHAR2(50) ) ; alter table BASEPERMISSION add constraint PK_BASEPERMISSION primary key (ID); prompt prompt Creating table BASEPERMISSIONSCOPE prompt ================================== prompt create table BASEPERMISSIONSCOPE ( ID NUMBER(10) not null, RESOURCECATEGORY VARCHAR2(50) not null, RESOURCEID VARCHAR2(50) not null, TARGETCATEGORY VARCHAR2(50) not null, TARGETID VARCHAR2(50) not null, PERMISSIONID NUMBER(10) not null, PERMISSIONCONSTRAINT VARCHAR2(200), STARTDATE DATE, ENDDATE DATE, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEBY VARCHAR2(50), CREATEUSERID VARCHAR2(50), MODIFIEDON DATE, MODIFIEDBY VARCHAR2(50), MODIFIEDUSERID VARCHAR2(50) ) ; alter table BASEPERMISSIONSCOPE add constraint PK_BASEPERMISSIONSCOPE primary key (ID); prompt prompt Creating table BASEROLE prompt ======================= prompt create table BASEROLE ( ID NUMBER(10) not null, ORGANIZEID NUMBER(10), CODE VARCHAR2(50), REALNAME VARCHAR2(200) not null, CATEGORYCODE VARCHAR2(50), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISVISIBLE NUMBER(1), SORTCODE NUMBER(10) not null, DELETIONSTATECODE NUMBER(1), ENABLED NUMBER(1), DESCRIPTION VARCHAR2(200), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEROLE add constraint BASEROLE_PK primary key (ID); prompt prompt Creating table BASEROLEDELETED prompt ============================== prompt create table BASEROLEDELETED ( ID NUMBER(10) not null, ORGANIZEID NUMBER(10), CODE VARCHAR2(50), REALNAME VARCHAR2(200) not null, CATEGORYCODE VARCHAR2(50), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISVISIBLE NUMBER(1) default 1, SORTCODE NUMBER(10) not null, DELETIONSTATECODE NUMBER(1) default 0, ENABLED NUMBER(1) default 1, DESCRIPTION VARCHAR2(200), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEROLEDELETED add constraint PK_BASEROLE primary key (ID); prompt prompt Creating table BASESEQUENCE prompt =========================== prompt create table BASESEQUENCE ( ID VARCHAR2(50) not null, FULLNAME VARCHAR2(200) not null, PREFIX VARCHAR2(50), DELIMITER VARCHAR2(50), SEQUENCE NUMBER(10) default 10000000 not null, REDUCTION NUMBER(10) default 9999999 not null, STEP NUMBER(2) default 1 not null, ISVISIBLE NUMBER(1) default 0, DESCRIPTION VARCHAR2(200), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASESEQUENCE add constraint PK_BASESEQUENCE primary key (ID); prompt prompt Creating table BASESTAFF prompt ======================== prompt create table BASESTAFF ( ID NUMBER(10) not null, USERID NUMBER(10), USERNAME VARCHAR2(50), REALNAME VARCHAR2(50), CODE VARCHAR2(50), GENDER VARCHAR2(50), COMPANYID VARCHAR2(50), SUBCOMPANYID VARCHAR2(50), DEPARTMENTID VARCHAR2(50), WORKGROUPID VARCHAR2(50), QUICKQUERY VARCHAR2(100), DUTYID VARCHAR2(50), IDENTIFICATIONCODE VARCHAR2(50), IDCARD VARCHAR2(50), BANKCODE VARCHAR2(50), REWARCARD VARCHAR2(50), MEDICALCARD VARCHAR2(50), UNIONMEMBER VARCHAR2(50), EMAIL VARCHAR2(200), MOBILE VARCHAR2(50), SHORTNUMBER VARCHAR2(50), TELEPHONE VARCHAR2(50), QQ VARCHAR2(50), OFFICEPHONE VARCHAR2(50), OFFICEZIPCODE VARCHAR2(50), OFFICEADDRESS VARCHAR2(200), OFFICEFAX VARCHAR2(50), AGE VARCHAR2(50), BIRTHDAY VARCHAR2(50), HEIGHT VARCHAR2(50), WEIGHT VARCHAR2(50), EDUCATION VARCHAR2(50), SCHOOL VARCHAR2(50), GRADUATIONDATE VARCHAR2(50), MAJOR VARCHAR2(100), DEGREE VARCHAR2(50), TITLEID VARCHAR2(50), TITLEDATE VARCHAR2(50), TITLELEVEL VARCHAR2(50), WORKINGDATE VARCHAR2(50), JOININDATE VARCHAR2(50), HOMEZIPCODE VARCHAR2(50), HOMEADDRESS VARCHAR2(200), HOMEPHONE VARCHAR2(50), HOMEFAX VARCHAR2(50), PROVINCE VARCHAR2(50), CARCODE VARCHAR2(50), CITY VARCHAR2(50), AREA VARCHAR2(50), NATIVEPLACE VARCHAR2(50), PARTY VARCHAR2(50), NATION VARCHAR2(50), NATIONALITY VARCHAR2(50), WORKINGPROPERTY VARCHAR2(100), COMPETENCY VARCHAR2(100), EMERGENCYCONTACT VARCHAR2(200), WEDDINGDAY DATE, DIVORCE DATE, CHILDBIRTHDAY1 DATE, CHILDBIRTHDAY2 DATE, ISDIMISSION NUMBER(1) default 0, DIMISSIONDATE VARCHAR2(50), DIMISSIONCAUSE VARCHAR2(800), DIMISSIONWHITHER VARCHAR2(100), ENABLED NUMBER(1) default 1, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASESTAFF add constraint PK_BASESTAFF primary key (ID); prompt prompt Creating table BASESTAFFORGANIZE prompt ================================ prompt create table BASESTAFFORGANIZE ( ID NUMBER(10) not null, STAFFID VARCHAR2(50), ORGANIZEID VARCHAR2(50) not null, DELETIONSTATECODE NUMBER(1) default 0, ENABLED NUMBER(1) default 1 not null, DESCRIPTION VARCHAR2(200), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASESTAFFORGANIZE add constraint PK_BASESTAFFORGANIZE primary key (ID); prompt prompt Creating table BASETABLECOLUMNS prompt =============================== prompt create table BASETABLECOLUMNS ( ID NUMBER(10) not null, TABLECODE VARCHAR2(200), COLUMNCODE VARCHAR2(200), COLUMNNAME VARCHAR2(50), ISPUBLIC NUMBER(1) default 0 not null, COLUMNACCESS NUMBER(1), COLUMNEDIT NUMBER(1), COLUMNDENEY NUMBER(1), DATATYPE VARCHAR2(50), USECONSTRAINT VARCHAR2(200), TARGETTABLE VARCHAR2(50), ENABLED NUMBER(1) default 1 not null, ALLOWEDIT NUMBER(1) default 1, ALLOWDELETE NUMBER(1) default 1, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10) not null, DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASETABLECOLUMNS add constraint PK_BASETABLECOLUMNS primary key (ID); prompt prompt Creating table BASEUSER prompt ======================= prompt create table BASEUSER ( ID NUMBER(10) not null, CODE VARCHAR2(50), USERNAME VARCHAR2(50) not null, REALNAME VARCHAR2(50), NICKNAME VARCHAR2(50), QUICKQUERY VARCHAR2(100), COMPANYID VARCHAR2(50), COMPANYNAME VARCHAR2(50), SUBCOMPANYID VARCHAR2(50), SUBCOMPANYNAME VARCHAR2(50), DEPARTMENTID VARCHAR2(50), DEPARTMENTNAME VARCHAR2(50), WORKGROUPID VARCHAR2(50), WORKGROUPNAME VARCHAR2(50), WORKCATEGORY VARCHAR2(50), SECURITYLEVEL NUMBER(2), SIGNATURE VARCHAR2(200), CHANGEPASSWORDDATE DATE, DUTY VARCHAR2(50), TITLE VARCHAR2(50), GENDER VARCHAR2(50), BIRTHDAY VARCHAR2(50), MOBILE VARCHAR2(50), TELEPHONE VARCHAR2(50), QQ VARCHAR2(50), WW VARCHAR2(50), EMAIL VARCHAR2(200), LANG VARCHAR2(50), THEME VARCHAR2(50), SCORE NUMBER(1) default 0, FANS NUMBER(1) default 0, HOMEADDRESS VARCHAR2(200), ISSTAFF NUMBER(1) default 1, ISVISIBLE NUMBER(1) default 1, ENABLED NUMBER(1) default 1 not null, AUDITSTATUS VARCHAR2(50), DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEUSER add constraint PK_BASEUSER primary key (ID); prompt prompt Creating table BASEUSERLOGON prompt ============================ prompt create table BASEUSERLOGON ( ID NUMBER(10) not null, USERFROM VARCHAR2(50), USERPASSWORD VARCHAR2(200), OPENID VARCHAR2(50), ALLOWSTARTTIME DATE, ALLOWENDTIME DATE, LOCKSTARTDATE DATE, LOCKENDDATE DATE, FIRSTVISIT DATE, PREVIOUSVISIT DATE, LASTVISIT DATE, LOGONCOUNT NUMBER(1) default 0, PASSWORDERRORCOUNT NUMBER(1) default 0, CHANGEPASSWORDDATE DATE, ISSTAFF NUMBER(1) default 1, USERONLINE NUMBER(1) default 0, MULTIUSERLOGIN NUMBER(1) default 1, SHOWCOUNT NUMBER(1) default 0, ISVISIBLE NUMBER(1) default 1, CHECKIPADDRESS NUMBER(1) default 0, VERIFICATIONCODE VARCHAR2(50), IPADDRESS VARCHAR2(50), MACADDRESS VARCHAR2(50), QUESTION VARCHAR2(50), ANSWERQUESTION VARCHAR2(50), ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEUSERLOGON add constraint PK_BASEUSERLOGON primary key (ID); prompt prompt Creating table BASEUSERORGANIZE prompt =============================== prompt create table BASEUSERORGANIZE ( ID NUMBER(10) not null, USERID NUMBER(10), COMPANYID VARCHAR2(50), SUBCOMPANYID VARCHAR2(50), DEPARTMENTID VARCHAR2(50), WORKGROUPID VARCHAR2(50), ENABLED NUMBER(1) default 1 not null, DESCRIPTION VARCHAR2(800), DELETIONSTATECODE NUMBER(1) default 0, CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEUSERORGANIZE add constraint PK_BASEUSERORGANIZE primary key (ID); prompt prompt Creating table BASEUSERROLE prompt =========================== prompt create table BASEUSERROLE ( ID NUMBER(10) not null, USERID NUMBER(10) not null, ROLEID NUMBER(10) not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table BASEUSERROLE add constraint PK_BASEUSERROLE primary key (ID); prompt prompt Creating table ITEMSAUDITSTATUS prompt =============================== prompt create table ITEMSAUDITSTATUS ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSAUDITSTATUS add constraint PK_ITEMSAUDITSTATUS primary key (ID); prompt prompt Creating table ITEMSCONDITION prompt ============================= prompt create table ITEMSCONDITION ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSCONDITION add constraint PK_ITEMSCONDITION primary key (ID); prompt prompt Creating table ITEMSDUTY prompt ======================== prompt create table ITEMSDUTY ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSDUTY add constraint PK_ITEMSDUTY primary key (ID); prompt prompt Creating table ITEMSEDUCATION prompt ============================= prompt create table ITEMSEDUCATION ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSEDUCATION add constraint PK_ITEMSEDUCATION primary key (ID); prompt prompt Creating table ITEMSGENDER prompt ========================== prompt create table ITEMSGENDER ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSGENDER add constraint PK_ITEMSGENDER primary key (ID); prompt prompt Creating table ITEMSLOCKWAITMINUTE prompt ================================== prompt create table ITEMSLOCKWAITMINUTE ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSLOCKWAITMINUTE add constraint PK_ITEMSLOCKWAITMINUTE primary key (ID); prompt prompt Creating table ITEMSMARRIAGE prompt ============================ prompt create table ITEMSMARRIAGE ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSMARRIAGE add constraint PK_ITEMSMARRIAGE primary key (ID); prompt prompt Creating table ITEMSORGANIZECATEGORY prompt ==================================== prompt create table ITEMSORGANIZECATEGORY ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSORGANIZECATEGORY add constraint PK_ITEMSORGANIZECATEGORY primary key (ID); prompt prompt Creating table ITEMSROLECATEGORY prompt ================================ prompt create table ITEMSROLECATEGORY ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSROLECATEGORY add constraint PK_ITEMSROLECATEGORY primary key (ID); prompt prompt Creating table ITEMSSECURITYLEVEL prompt ================================= prompt create table ITEMSSECURITYLEVEL ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSSECURITYLEVEL add constraint PK_ITEMSSECURITYLEVEL primary key (ID); prompt prompt Creating table ITEMSSYSTEM prompt ========================== prompt create table ITEMSSYSTEM ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSSYSTEM add constraint PK_ITEMSSYSTEM primary key (ID); prompt prompt Creating table ITEMSTITLE prompt ========================= prompt create table ITEMSTITLE ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSTITLE add constraint PK_ITEMSTITLE primary key (ID); prompt prompt Creating table ITEMSWORKCATEGORY prompt ================================ prompt create table ITEMSWORKCATEGORY ( ID NUMBER(10) not null, PARENTID NUMBER(10), ITEMCODE VARCHAR2(200), ITEMNAME VARCHAR2(200) not null, ITEMVALUE VARCHAR2(200), ALLOWEDIT NUMBER(1) default 1 not null, ALLOWDELETE NUMBER(1) default 1 not null, ISPUBLIC NUMBER(1) default 1 not null, ENABLED NUMBER(1) default 1 not null, DELETIONSTATECODE NUMBER(1) default 0, SORTCODE NUMBER(10), DESCRIPTION VARCHAR2(800), CREATEON DATE, CREATEUSERID VARCHAR2(50), CREATEBY VARCHAR2(50), MODIFIEDON DATE, MODIFIEDUSERID VARCHAR2(50), MODIFIEDBY VARCHAR2(50) ) ; alter table ITEMSWORKCATEGORY add constraint PK_ITEMSWORKCATEGORY primary key (ID); prompt prompt Creating sequence SEQ_BASEITEMDETAILS prompt ===================================== prompt create sequence SEQ_BASEITEMDETAILS minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEITEMS prompt =============================== prompt create sequence SEQ_BASEITEMS minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEKNOWLEDGE prompt =================================== prompt create sequence SEQ_BASEKNOWLEDGE minvalue 1 maxvalue 9999999999999999999999999999 start with 100000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASELOG prompt ============================= prompt create sequence SEQ_BASELOG minvalue 1 maxvalue 9999999999999999999999999999 start with 1000060 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEMESSAGE prompt ================================= prompt create sequence SEQ_BASEMESSAGE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEMODULE prompt ================================ prompt create sequence SEQ_BASEMODULE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEORGANIZE prompt ================================== prompt create sequence SEQ_BASEORGANIZE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEPARAMETER prompt =================================== prompt create sequence SEQ_BASEPARAMETER minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEPERMISSION prompt ==================================== prompt create sequence SEQ_BASEPERMISSION minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEPERMISSIONSCOPE prompt ========================================= prompt create sequence SEQ_BASEPERMISSIONSCOPE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEROLE prompt ============================== prompt create sequence SEQ_BASEROLE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEROLEDELETED prompt ===================================== prompt create sequence SEQ_BASEROLEDELETED minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASESEQUENCE prompt ================================== prompt create sequence SEQ_BASESEQUENCE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASESTAFF prompt =============================== prompt create sequence SEQ_BASESTAFF minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASESTAFFORGANIZE prompt ======================================= prompt create sequence SEQ_BASESTAFFORGANIZE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASETABLECOLUMNS prompt ====================================== prompt create sequence SEQ_BASETABLECOLUMNS minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEUSER prompt ============================== prompt create sequence SEQ_BASEUSER minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEUSERLOGON prompt =================================== prompt create sequence SEQ_BASEUSERLOGON minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEUSERORGANIZE prompt ====================================== prompt create sequence SEQ_BASEUSERORGANIZE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_BASEUSERROLE prompt ================================== prompt create sequence SEQ_BASEUSERROLE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSAUDITSTATUS prompt ====================================== prompt create sequence SEQ_ITEMSAUDITSTATUS minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSCONDITION prompt ==================================== prompt create sequence SEQ_ITEMSCONDITION minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSDUTY prompt =============================== prompt create sequence SEQ_ITEMSDUTY minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSEDUCATION prompt ==================================== prompt create sequence SEQ_ITEMSEDUCATION minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSGENDER prompt ================================= prompt create sequence SEQ_ITEMSGENDER minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSLOCKWAITMINUTE prompt ========================================= prompt create sequence SEQ_ITEMSLOCKWAITMINUTE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSMARRIAGE prompt =================================== prompt create sequence SEQ_ITEMSMARRIAGE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSORGANIZECATEGORY prompt =========================================== prompt create sequence SEQ_ITEMSORGANIZECATEGORY minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSROLECATEGORY prompt ======================================= prompt create sequence SEQ_ITEMSROLECATEGORY minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSSECURITYLEVEL prompt ======================================== prompt create sequence SEQ_ITEMSSECURITYLEVEL minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSSYSTEM prompt ================================= prompt create sequence SEQ_ITEMSSYSTEM minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSTITLE prompt ================================ prompt create sequence SEQ_ITEMSTITLE minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; prompt prompt Creating sequence SEQ_ITEMSWORKCATEGORY prompt ======================================= prompt create sequence SEQ_ITEMSWORKCATEGORY minvalue 1 maxvalue 9999999999999999999999999999 start with 1000000 increment by 1 cache 20; spool off
INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000000,10005235,'Resource.AccessPermission','资源访问权限','System',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10006600,1,0,0,0,0,1,1,1,1,NULL,'10000000','超级管理员','1','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000001,10005235,'Resource.ManagePermission','资源管理权限','System',NULL,NULL,NULL,NULL,'fraContent',NULL,NULL,NULL,10006566,1,0,0,0,0,1,1,1,1,NULL,NULL,NULL,'1','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000004,10005235,'DotNet.Base','基础数据管理','System',NULL,NULL,NULL,'','','','',NULL,10006603,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'121','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000005,10000004,'RequestAnAccount','用户申请','System',NULL,NULL,NULL,'','','FrmRequestAnAccount','DotNet.WinForm',NULL,10006379,1,0,1,1,0,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000006,10005145,'UserAudit','用户审核','System',NULL,NULL,NULL,'','','FrmUserAudit','DotNet.WinForm',NULL,10006382,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000007,10000004,'StaffAddressEdit','我的联系方式','Application',NULL,NULL,NULL,'','','FrmStaffAddressEdit','DotNet.WinForm',NULL,10006391,1,0,1,1,0,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000008,10000004,'StaffAddressAdmin','内部通讯录','Application',NULL,NULL,NULL,'','','FrmStaffAddressAdmin','DotNet.WinForm',NULL,10006390,1,0,1,1,0,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000009,10005145,'Impersonation','扮演用户','System',NULL,NULL,NULL,'','','FrmImpersonation','DotNet.WinForm',NULL,10006380,0,1,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000010,10005145,'Accredit','用户授权','System',NULL,NULL,NULL,'','','FrmAccredit','DotNet.WinForm',NULL,10006381,0,1,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000011,10005145,'UserAdmin','用户管理','System',NULL,NULL,NULL,'','','FrmUserAdmin','DotNet.WinForm','Base_User',10006383,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000012,10005145,'OrganizeAdmin','组织机构','System',NULL,NULL,NULL,'','','FrmOrganizeAdmin','DotNet.WinForm',NULL,10006384,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000013,10005145,'StaffAdmin','员工管理','System',NULL,NULL,NULL,'','','FrmStaffAdmin','DotNet.WinForm','Base_Staff',10006386,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000014,10005145,'RoleAdmin','角色管理','System',NULL,NULL,NULL,'','','FrmRoleAdmin','DotNet.WinForm','Base_Role',10006384,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000015,10000004,'Appliction','软件频道','Application',NULL,NULL,NULL,'','',NULL,NULL,NULL,10006396,1,0,1,1,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000016,10000004,'MessageSend','发送消息','System',NULL,NULL,NULL,'','','FrmMessageSend','DotNet.WinForm',NULL,10006393,1,0,1,1,0,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000017,10000004,'Message','即时通讯','System',NULL,NULL,NULL,'','','FrmMessage','DotNet.WinForm',NULL,10006392,1,0,1,1,0,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000018,10005145,'ItemsAdmin','选项管理','System',NULL,NULL,NULL,'','','FrmItemsAdmin','DotNet.WinForm',NULL,10006402,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000019,10005145,'LogAdmin','系统日志管理','System',NULL,NULL,NULL,'','',NULL,NULL,NULL,10006410,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000021,10000004,'OnlineEmailSupport','在线技术支持','Application',NULL,NULL,NULL,'','','FrmOnlineEmailSupport','DotNet.WinForm',NULL,10006419,0,1,1,1,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000022,10000004,'AboutThis','关于本软件','Application',NULL,NULL,NULL,'','','FrmAboutThis','DotNet.WinForm',NULL,10006417,1,0,1,1,0,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000023,10000004,'UserPermission','我的权限','System',NULL,NULL,NULL,'','','FrmUserPermission','DotNet.WinForm',NULL,10006420,0,1,1,1,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000024,10000004,'UserChangePassword','修改密码','System',NULL,NULL,NULL,'','','FrmUserChangePassword','DotNet.WinForm',NULL,10006484,1,0,1,1,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000029,10000004,'FileAdmin','文档管理','Application',NULL,NULL,NULL,'','','FrmFileAdmin','DotNet.WinForm',NULL,10006400,0,1,1,1,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000031,10000019,'LogGeneral','用户访问情况','System',NULL,NULL,NULL,'','','FrmLogGeneral','DotNet.WinForm',NULL,10006412,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'121','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000032,10000019,'LogByUser','按用户查询','System',NULL,NULL,NULL,'','','FrmLogByUser','DotNet.WinForm',NULL,10006413,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'121','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000033,10000019,'LogByModule','按菜单查询','System',NULL,NULL,NULL,'','','FrmLogByModule','DotNet.WinForm',NULL,10006414,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'121','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000034,10000019,'SystemLogByDate','按日期查询','System',NULL,NULL,NULL,'','','FrmSystemLogByDate','DotNet.WinForm',NULL,10006415,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'121','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000035,10000019,'ExceptionAdmin','系统异常情况','System',NULL,NULL,NULL,'','','FrmExceptionAdmin','DotNet.WinForm',NULL,10006416,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'121','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000036,10005145,'ModuleAdmin','菜单管理','System',NULL,NULL,NULL,'','','FrmModuleAdmin','DotNet.WinForm','Base_Module',10006389,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000037,10005145,'SequenceAdmin','序列管理','System',NULL,NULL,NULL,'','','FrmSequenceAdmin','DotNet.WinForm',NULL,10006408,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10000039,10005145,'PermissionItemAdmin','操作权限项定义','System',NULL,NULL,NULL,'','','FrmPermissionItemAdmin','DotNet.WinForm',NULL,10006388,1,1,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10003000,10005145,'UserPermissionAdmin','用户权限管理','System',NULL,NULL,NULL,'','','FrmUserPermissionAdmin','DotNet.WinForm',NULL,10006397,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10003001,10000004,'WinWorkFlow','审核审批流程','System',NULL,NULL,NULL,'','','','',NULL,10006409,0,0,1,1,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10003003,10003001,'WorkFlowWaitForAudit','待审核单据','System',NULL,NULL,NULL,'','','FrmWorkFlowWaitForAudit','DotNet.WinForm',NULL,10006404,0,0,1,1,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10003004,10003001,'WorkFlowMonitor','审核流程监控','System',NULL,NULL,NULL,'','','FrmWorkFlowMonitor','DotNet.WinForm',NULL,10006405,0,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10003005,10003001,'WorkFlowProcessAdmin','审核流程定义管理','System',NULL,NULL,NULL,'','','FrmWorkFlowProcessAdmin','DotNet.WinForm',NULL,10006406,0,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10004429,10000015,'CodeGenerator','代码生成器','Application',NULL,NULL,NULL,'','','FrmCodeGenerator','DotNet.WinForm',NULL,10006483,1,0,1,0,0,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005093,10000004,'Lock','锁屏','System',NULL,NULL,NULL,'','','FrmLock','DotNet.WinForm',NULL,10006485,1,0,1,1,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005094,10000004,'Config','系统配置','System',NULL,NULL,NULL,'','','FrmConfig','DotNet.WinForm',NULL,10006421,1,0,1,0,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005095,10003001,'WorkFlowStatr','启动审核流程','System',NULL,NULL,NULL,'','','FrmWorkFlowStatr','DotNet.WinForm',NULL,10006403,0,1,1,0,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005096,10005145,'RolePermissionAdmin','角色权限管理','System',NULL,NULL,NULL,'','','FrmRolePermissionAdmin','DotNet.WinForm',NULL,10006398,1,0,1,0,1,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005097,10000004,'UserPermissionView','我的权限','System',NULL,NULL,NULL,'','','FrmUserPermissionView','DotNet.WinForm',NULL,10006387,0,1,0,0,0,0,1,0,0,'',NULL,NULL,'10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005143,10000015,'BusinessCardAdmin','名片管理','Application',NULL,'','','','','FrmBusinessCardAdmin','DotNet.WinForm','',10006395,1,0,1,0,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005144,10000004,'MessageBroadcast','广播消息','Application',NULL,'','','','','FrmMessageBroadcast','DotNet.WinForm','',10006394,1,0,1,0,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005145,10000004,'SystemAdmin','系统后台管理','System',NULL,'','','','','','','',10006401,1,0,1,0,1,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005146,10000015,'WebUrl_cnblogs','博客园','Application',NULL,'','','http://jirigala.cnblogs.com/','',NULL,NULL,'',10006489,1,0,1,1,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005147,10000015,'WebUrl_taobao','淘宝','Application',NULL,'','','http://jirigala.taobao.com/','',NULL,NULL,'',10006490,1,0,1,1,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005148,10000015,'WebUrl_hairihan','公司外网','Application',NULL,'','','http://www.hairihan.com.cn?OpenId={OpenId}','',NULL,NULL,'',10006487,1,0,1,0,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005149,10000015,'WebUrl_PowerDesigner','PowerDesigner','Application',NULL,'','','','','','C:\Program Files\Sybase\PowerDesigner 15\pdshell15','',10006488,1,0,1,0,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005150,10000015,'WebUrl_OA','内部办公系统','Application',NULL,'','','http://www.hairihan.com.cn?UserCode={UserCode}&Use','_blank','','','',10006486,1,0,1,1,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005175,10005145,'OrganizeDutyAdmin','岗位管理','System',NULL,'','','','','FrmOrganizeRoleAdmin','DotNet.WinForm','',10006386,1,0,1,0,0,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005231,10005145,'OrganizePermissionAdmin','组织机构权限','System',NULL,NULL,NULL,'','','FrmOrganizePermissionAdmin','DotNet.WinForm',NULL,10006399,1,0,1,0,1,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005235,NULL,'DotNet.Common','快速开发平台','System',NULL,NULL,NULL,'','','','',NULL,10006565,1,0,1,0,1,0,1,0,0,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005242,10003001,'Holidays','节假日设置','Application',NULL,NULL,NULL,'','','FrmHolidays','DotNet.WinForm',NULL,10006572,0,0,1,0,0,0,1,1,1,'','10000000','超级管理员','10000000','超级管理员'); INSERT INTO BaseModule(Id,ParentId,Code,FullName,CategoryCode,ImagUrl,ImageIndex,SelectedImageIndex,NavigateUrl,Target,FormName,AssemblyName,PermissionScopeTables,SortCode,Enabled,DeletionStateCode,IsMenu,IsPublic,Expand,IsScope,IsVisible,AllowEdit,AllowDelete,Description,CreateUserId,CreateBy,ModifiedUserId,ModifiedBy) VALUES(10005243,10005145,'BaseItemsAdmin','系统选项','System',NULL,NULL,NULL,'','','FrmBaseItemsAdmin','DotNet.WinForm',NULL,10006407,1,0,1,0,1,0,1,1,1,'','10000000','超级管理员','10000000','超级管理员');
将权限管理、工作流管理做到我能力的极致，一个人只能做好那么很少的几件事情。
