----------------------------------------------------
-- 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','超级管理员');
