通用权限管理系统组件3.9 的 Oracle 数据库创建脚本参考

最新推荐文章于 2024-08-05 18:56:17 发布
最新推荐文章于 2024-08-05 18:56:17 发布
阅读量93 收藏
点赞数
文章标签： 数据库
原文链接：http://www.cnblogs.com/jirigala/p/3305598.html
版权 
----------------------------------------------------
-- 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','超级管理员');

 

转载于:https://www.cnblogs.com/jirigala/p/3305598.html

weixin_30488313
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
脚本
zengquan2014的博客
11-15 499
emp脚本 prompt Importing table emp... set feedback off set define off insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) values (7369, 'SMITH', 'CLERK', 7902, to_date('17-12-1980
绿色网新企业网站管理系统 v3.9
12-07
网新企业网站管理系统(绿色)是专业为个人和企业网站建设而开发的一款智能化程序。该程序基于ASP+ACCESS环境开发，拥有完善的网站前台和后台全智能化管理功能，完全由后台操作（如添加、修改网站基本信息、产品、企业...
mysql权限脚本_权限管理系统 mysql 数据脚本
weixin_39927144的博客
01-28 77
1 # SQL-Front 5.1 (Build 4.16)23 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE*/;4 /*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/;5 /*!40111 SET @OLD_SQL_NOTES=@@SQL...
从Export Dumpfile file 中读出DDL 语句
cuanxiu7017的博客
04-29 142
从Export Dumpfile 读出DDL 语句： EXPDP/IMPDP [oracle@itc-test9 exp_dir]expdp system/ocm DIRECTORY=my_dump DUMP...
Oracle Export/Import工具使用介绍
crabboy
04-30 975
Oracle Export/Import工具使用介绍 Oracle Exp/Imp工具是一个操作简单、方便灵活的备份恢复和数据迁移工具，它可以实施全库级、用户级、表级的数据备份和恢复。对于数据量在G级或G级以内，强调高可用性，可以容忍少量数据丢失的数据库系统，Exp/Imp是普遍使用的逻辑备份方式。  Export从数据库中导出数据到dump文件中  Impo...
Export MODO file for MAYA
xiaokaneier的专栏
01-07 803
上一个学期的的动画作业中使用了MODO进行人物角色的建模，再导入Maya进行animation和rendering。MODO有很多很出色的特性，当然也有不少让新手很苦恼的问题。 数据导出是个很棘手的问题，因为并不熟悉MODO的设置，导致这一问题在后面的render环节给我造成了很大的困扰，一直没能找到问题的根源。 主要问题包括 1、UV碎片化 2、模型比例失调 导致的主要问题有 1、U
亿景企业网站管理系统 v3.9
11-30
亿景企业网站管理系统是面向中小企业的网站管理系统，网页精美、大气。具有稳性定强，功能多、安全、代码加载速度快、网站内容管理的易操作性、维护方便等优点。采用div+css构架
贴心猫(IntimateCat) 通用网站系统 v3.9
12-30
贴心猫(IntimateCat) 是以PHP+MySQL架构设计的通用网站系统，简约、轻量、实用、、共享。 适用于：网店，医院，学校，企业站，个人网站，企业内部Intranet，中小型行业门户站点等 功
红色网新企业网站管理系统 v3.9
12-07
网新企业网站管理系统(红色)是专业为个人和企业网站建设而开发的一款智能化程序。该程序基于ASP+ACCESS环境开发，拥有完善的网站前台和后台全智能化管理功能，完全由后台操作（如添加、修改网站基本信息、产品、企业...
银色网新企业网站管理系统 v3.9
12-02
网新企业网站管理系统是专业为个人和企业网站建设而开发的一款智能化程序。该程序基于ASP+ACCESS环境开发，拥有完善的网站前台和后台全智能化管理功能，完全由后台操作（如添加、修改网站基本信息、产品、企业新闻...
Oracle 开发（一） 数据库导入导出
weixin_33805557的博客
11-19 80
导出: 语句 exp UserName/password@orcl file=d:\20111119DB.dmp      exp: export 导出关键字      UserName/password: 导出用户      @orcl: 导出的Oracle服务器名字      file=d:\20111119DB.dmp : 导出的文件地址，后缀为dmp。      导入: 1.建表空间 2....
plsql基本操作 复制表 导出表 导出表结构 及其导入
全盛
05-22 4551
plsql基本操作 复制表 导出表 导出表结构 及其导入上一片中介绍了安装instantclient +plsql取代庞大客户端的安装，这里说下plsql的基本操作plsql操作界面图： 1、复制表 语句：create table IGIS_COPY as select * from IGIS_LOCATION2、查询前5行数据select * from IGIS_LOCATION where r...
oracle存储过程导出txt例子
IT 乞丐
06-18 133
--------------------------------------------- -- Export file for user JHMCC -- -- Created by sysman on 2009-4-1, 13:49:27 -- --------------------------------------------- spool 123....
一个账单存储过程
叶落枫亭
12-23 723
-------------------------------------------------------- Export file for user PRM ---- Created by Administrator on 2008-12-17, 15:30:58 ----------------------------------------
文本处理学习笔记1
sail988的专栏
02-26 109
环境情况如下： python-2.5.2 ibatis-2.3.4.726 jdk1.6.0_07 Oracle9i Enterprise Edition 9.2.0.1.0 一个简单的ibatis配置文件生成工具： 测试文件如下(test.sql)： [code="sql"] --------------------------------------------------...
java笔记 mybatis 基本增删改
最新发布
qq_63095129的博客
08-05 723
在pom.xml文件中添加依赖。
【MySQL】慢sql优化全流程解析
k123456kah的博客
08-04 1093
explain 是 MySQL 提供的一种用于分析和调试 SQL 查询的工具。 通过使用 explain，可以了解 MySQL 在执行查询时采用的具体执行计划，包括访问数据表的方式、使用的索引、连接表的顺序等信息。这些信息对于优化查询性能至关重要。
Python爬虫与MongoDB的完美结合
weixin_52392194的博客
08-03 811
我们掌握了在Windows和Linux系统下安装MongoDB，设计适合爬虫存储数据的写入规范，并通过实际爬虫示例展示了如何将爬取到的数据存储到MongoDB中。此外，还进行了MongoDB性能优化，提高了数据存储和查询的效率。
SpringBoot+Vue图书(图书借阅)管理系统-附项目源码与配套文档
m0_74283290的博客
08-03 1309
本论文阐述了一套先进的图书管理系统的设计与实现，该系统采用Java语言，结合现代Web开发框架和技术，旨在为图书馆提供高效、灵活且用户友好的资源管理解决方案。系统利用Spring Boot框架为核心，整合MyBatis ORM工具，以及MySQL数据库，构建了一个高性能、可扩展的后端服务。前端界面则采用了Vue.js框架，以提供流畅的用户交互体验。论文首先进行了详尽的需求分析，确定了系统的核心功能，包括图书的添加、编辑、删除、查询，读者的注册、登录、个人信息管理，以及图书的借阅、归还、续借流程。
Oracle数据库体系结构解析与应用开发
这本书是关于Oracle 9i和10g数据库系统编程和体系结构的深入指南，旨在帮助开发者和数据库管理员更好地理解和优化他们的Oracle应用。书中涵盖了从基础概念到高级特性的广泛主题。 在【前言】中，作者提到了本书的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值