導航

如果是多人聯合對maximo應用進行開發，那么對數據庫的更新操作最好是使用腳本來進行，對于maximo的config.db的操作一定要熟練。

在熟練的第一步也是進行數據庫備份。對數據庫的整體備份可使用：maximo tools –> tdtoolkit –export

第二步， 清理 maxsession sql： delete * from maxsession ;

第三步， 插入更新數據：

下面是更新一個表

 

set define off;

----------------ObjectDeleteScript----------------

delete  from maxobjectcfg  where objectname='C_INSP10';

delete  from maxtablecfg  where TABLENAME='C_INSP10';

delete  from maxattributecfg  where OBJECTNAME='C_INSP10';

delete  from maxsysindexes where TBNAME= 'C_INSP10';

delete from maxsyskeys where IXNAME='C_INSP10_NDX1';

delete  from maxrelationship where PARENT= 'C_INSP10';

delete  from maxsequence where TBNAME= 'C_INSP10';

----------------ObjectInsertScript----------------

----------------CreateObjectScript----------------

insert into maxobjectcfg ( OBJECTNAME, CLASSNAME, DESCRIPTION, EAUDITENABLED, EAUDITFILTER, ENTITYNAME, ESIGFILTER, EXTENDSOBJECT, IMPORTED, ISVIEW, PERSISTENT, SERVICENAME, SITEORGTYPE, USERDEFINED, CHANGED, MAINOBJECT, INTERNAL, MAXOBJECTID, TEXTDIRECTION) values ( 'C_INSP10', 'jtv.app.c_insp10.C_insp10Set', '人工添乘', 0, null, 'C_INSP10', null, null, 0, 0, 1, 'CUSTAPP', 'SITE', 1,'I', 0, 0, MAXOBJECTCFGSEQ.nextval, null);

----------------CreateTableScript----------------

insert into maxtablecfg ( TABLENAME, ADDROWSTAMP, EAUDITTBNAME, ISAUDITTABLE, RESTOREDATA, STORAGEPARTITION, TEXTSEARCHENABLED, LANGTABLENAME, LANGCOLUMNNAME, UNIQUECOLUMNNAME, ISLANGTABLE, MAXTABLEID, ALTIXNAME, TRIGROOT, CONTENTATTRIBUTE) values ( 'C_INSP10', 1, null, 0, 0, 'MAXDATA', 0, null, null, 'C_INSP10ID', 0, MAXTABLECFGSEQ.nextval, null, 'C_INSP10', null);

----------------CreateAttributeScript----------------

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'C_INSP10ID', 'C_INSP10ID', null, 1, 0, null, 'C_INSP10ID', null, null, 0, 'C_INSP10', 0, 0, 0, 12, 'INTEGER', 1, 1, 1, 1, 'C_insp10id', null, null, 0, 'C_insp10id', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'DESCRIPTION', 'DESCRIPTION', null, 2, 0, null, 'DESCRIPTION', null, null, 0, 'C_INSP10', 0, 1, 0, 50, 'ALN', 0, 0, 1, null, '描述', null, null, 0, '描述', 1,'I', 'NONE', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'DESCRIPTION_LONGDESCRIPTION', 'DESCRIPTION_LONGDESCRIPTION', null, 3, 0, null, null, null, null, 0, null, 0, 0, 0, 32000, 'LONGALN', 1, 0, 0, null, 'Description_longdescription', null, null, 0, 'Description_longdescription', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'HASLD', 'HASLD', null, 4, 0, null, 'HASLD', '0', null, 0, 'C_INSP10', 0, 0, 0, 1, 'YORN', 1, 1, 1, null, 'Hasld', null, null, 0, 'Hasld', 1,'I', 'NONE', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'ASSETNUM', 'ASSETNUM', null, 5, 0, 'mor.app.common.CustFldAssetnum', 'ASSETNUM', null, null, 0, 'C_INSP10', 0, 0, 0, 28, 'UPPER', 0, 0, 1, null, '添乘線路/行別', 'ASSETNUM', 'ASSET', 0, '添乘線路/行別', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'SITEID', 'SITEID', null, 6, 0, 'psdi.app.site.FldSiteID', 'SITEID', null, null, 0, 'C_INSP10', 0, 0, 0, 8, 'UPPER', 0, 0, 1, null, '地點', 'SITEID', 'SITE', 0, '地點', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'ORGID', 'ORGID', null, 7, 0, 'psdi.app.site.FldOrganizationID', 'ORGID', null, null, 0, 'C_INSP10', 0, 0, 0, 8, 'UPPER', 0, 0, 1, null, '組織', 'ORGID', 'ORGANIZATION', 0, '組織', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'ASSETDESC', 'ASSETDESC', null, 8, 0, null, 'ASSETDESC', null, null, 0, 'C_INSP10', 0, 0, 0, 50, 'ALN', 0, 0, 1, null, '線路/行別描述', null, null, 0, '線路/行別描述', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'STATUS', 'STATUS', null, 9, 0, 'mor.app.common.CustFldStatus', 'STATUS', null, 'C_INSPSTATUS', 0, 'C_INSP10', 0, 0, 0, 10, 'ALN', 0, 0, 1, null, '狀態', null, null, 0, '狀態', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'STATUSDESC', 'STATUSDESC', null, 10, 0, null, 'STATUSDESC', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'ALN', 0, 0, 1, null, '狀態描述', null, null, 0, '狀態描述', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'DEPT', 'DEPT', null, 11, 0, 'mor.app.common.CustFldDept', 'DEPT', null, 'CREWID', 0, 'C_INSP10', 0, 0, 0, 12, 'ALN', 1, 0, 1, null, '病害所屬部門', 'CREWID', 'LABOR', 0, '病害所屬部門', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'DEPTDESC', 'DEPTDESC', null, 12, 0, null, 'DEPTDESC', null, null, 0, 'C_INSP10', 0, 0, 0, 50, 'ALN', 0, 0, 1, null, '病害所屬部門描述', null, null, 0, '病害所屬部門描述', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'INSPWO', 'INSPWO', null, 13, 0, null, 'INSPWO', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'UPPER', 0, 0, 1, null, '檢測工單', 'WONUM', 'WORKORDER', 0, '檢測工單', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'REPWO', 'REPWO', null, 14, 0, null, 'REPWO', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'UPPER', 0, 0, 1, null, '維修工單', 'WONUM', 'WORKORDER', 0, '維修工單', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'DETECTLEVEL', 'DETECTLEVEL', null, 15, 0, null, 'DETECTLEVEL', null, 'C_DETECTLEVEL', 0, 'C_INSP10', 0, 0, 0, 2, 'ALN', 0, 0, 1, null, '嚴重等級', null, null, 0, '嚴重等級', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'PROBLEM', 'PROBLEM', null, 16, 0, 'mor.app.common.CustFldProblem', 'PROBLEM', null, null, 0, 'C_INSP10', 0, 0, 0, 18, 'UPPER', 0, 0, 1, null, '問題', 'FAILURECODE', 'FAILURECODE', 0, '問題', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'FAILURECODE', 'FAILURECODE', null, 17, 0, null, 'FAILURECODE', null, null, 0, 'C_INSP10', 0, 0, 0, 18, 'UPPER', 0, 0, 1, null, '問題代碼', 'FAILURECODE', 'FAILURECODE', 0, '問題代碼', 1,'I', 'NONE', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'ENTERBY', 'ENTERBY', null, 18, 0, 'mor.app.common.CustFldPersonID', 'ENTERBY', null, null, 0, 'C_INSP10', 0, 0, 0, 30, 'UPPER', 0, 0, 1, null, '錄入人', 'PERSONID', 'PERSON', 0, '錄入人', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'INPUTDATE', 'INPUTDATE', null, 19, 0, null, 'INPUTDATE', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'DATETIME', 0, 0, 1, null, '錄入時間', null, null, 0, '錄入時間', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'SPEC', 'SPEC', null, 20, 0, null, 'SPEC', null, null, 0, 'C_INSP10', 0, 0, 0, 50, 'ALN', 0, 0, 1, null, '備注', null, null, 0, '備注', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'INSPDATE', 'INSPDATE', null, 21, 0, null, 'INSPDATE', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'DATETIME', 0, 0, 1, null, '檢測日期', null, null, 0, '檢測日期', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'RESPONPERSON', 'RESPONPERSON', null, 22, 0, null, 'RESPONPERSON', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'ALN', 0, 0, 1, null, '添乘人', null, null, 0, '添乘人', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'BEGINSTATION', 'BEGINSTATION', null, 23, 0, null, 'BEGINSTATION', null, null, 0, 'C_INSP10', 0, 0, 0, 50, 'ALN', 0, 0, 1, null, '出發車站', null, null, 0, '出發車站', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'ENDSTATION', 'ENDSTATION', null, 24, 0, null, 'ENDSTATION', null, null, 0, 'C_INSP10', 0, 0, 0, 30, 'ALN', 0, 0, 1, null, '到達車站', null, null, 0, '到達車站', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'BEGINTIME', 'BEGINTIME', null, 25, 0, null, 'BEGINTIME', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'DATETIME', 0, 0, 1, null, '出發時間', null, null, 0, '出發時間', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'ENDTIME', 'ENDTIME', null, 26, 0, null, 'ENDTIME', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'DATETIME', 0, 0, 1, null, '到達時間', null, null, 0, '到達時間', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'TRAINSN', 'TRAINSN', null, 27, 0, null, 'TRAINSN', null, null, 0, 'C_INSP10', 0, 0, 0, 20, 'ALN', 0, 0, 1, null, '車次', null, null, 0, '車次', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'TRAINBELONGTO', 'TRAINBELONGTO', null, 28, 0, null, 'TRAINBELONGTO', null, null, 0, 'C_INSP10', 0, 0, 0, 50, 'ALN', 0, 0, 1, null, '機車所屬段', null, null, 0, '機車所屬段', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'TRAINTYPE', 'TRAINTYPE', null, 29, 0, null, 'TRAINTYPE', null, null, 0, 'C_INSP10', 0, 0, 0, 30, 'ALN', 0, 0, 1, null, '機車型號', null, null, 0, '機車型號', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'MILEAGE', 'MILEAGE', null, 30, 0, null, 'MILEAGE', null, null, 0, 'C_INSP10', 0, 0, 0, 50, 'ALN', 0, 0, 1, null, '問題里程', null, null, 0, '問題里程', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'INSPTYPE', 'INSPTYPE', null, 31, 0, null, 'INSPTYPE', null, 'C_INSPTYPE', 0, 'C_INSP10', 0, 0, 0, 28, 'ALN', 0, 0, 1, null, '檢測類型', 'INSPTYPE', 'C_INSP1', 0, '檢測類型', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'DETECTDEP', 'DETECTDEP', null, 32, 0, null, 'DETECTDEP', null, null, 0, 'C_INSP10', 0, 0, 0, 30, 'ALN', 0, 0, 1, null, '添乘部門', null, null, 0, '添乘部門', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'DEFECTCLASS', 'DEFECTCLASS', null, 33, 0, null, 'DEFECTCLASS', null, null, 0, 'C_INSP10', 0, 0, 0, 2, 'ALN', 0, 0, 1, null, '超限等級', null, null, 0, '超限等級', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'ENDMEASURE', 'ENDMEASURE', null, 34, 0, null, 'ENDMEASURE', null, null, 0, 'C_INSP10', 0, 0, 0, 15, 'DECIMAL', 0, 0, 1, null, '終止里程', 'STARTMEASURE', 'ASSET', 5, '終止里程', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'STARTMEASURE', 'STARTMEASURE', null, 35, 0, null, 'STARTMEASURE', null, null, 0, 'C_INSP10', 0, 0, 0, 15, 'DECIMAL', 0, 0, 1, null, '起始里程', 'STARTMEASURE', 'ASSET', 5, '起始里程', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'DEFECTTYPE', 'DEFECTTYPE', null, 36, 0, null, 'DEFECTTYPE', null, null, 0, 'C_INSP10', 0, 0, 0, 20, 'ALN', 0, 0, 1, null, '超限類型', null, null, 0, '超限類型', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'FVALUE', 'FVALUE', null, 37, 0, null, 'FVALUE', null, null, 0, 'C_INSP10', 0, 0, 0, 16, 'DECIMAL', 0, 0, 1, null, '超限值', null, null, 2, '超限值', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'CLOSEDATE', 'CLOSEDATE', null, 38, 0, null, 'CLOSEDATE', null, null, 0, 'C_INSP10', 0, 0, 0, 10, 'DATETIME', 0, 0, 1, null, '關閉日期', null, null, 0, '關閉日期', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'WEIGHT', 'WEIGHT', null, 39, 0, null, 'WEIGHT', null, null, 0, 'C_INSP10', 0, 0, 0, 16, 'DECIMAL', 0, 0, 1, null, '扣分權重', null, null, 2, '扣分權重', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'REVMEMO', 'REVMEMO', null, 40, 0, null, 'REVMEMO', null, null, 0, 'C_INSP10', 0, 0, 0, 100, 'ALN', 0, 0, 1, null, '回檢情況', 'REVMEMO', 'C_INSP1', 0, '回檢情況', 1,'I', 'WILDCARD', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 1, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'WORKHRS', 'WORKHRS', null, 41, 0, null, 'WORKHRS', null, null, 0, 'C_INSP10', 0, 0, 0, 8, 'DURATION', 0, 0, 1, null, '工作時間', 'WORKHRS', 'C_INSP1', 0, '工作時間', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

insert into maxattributecfg ( OBJECTNAME, ATTRIBUTENAME, ALIAS, AUTOKEYNAME, ATTRIBUTENO, CANAUTONUM, CLASSNAME, COLUMNNAME, DEFAULTVALUE, DOMAINID, EAUDITENABLED, ENTITYNAME, ESIGENABLED, ISLDOWNER, ISPOSITIVE, LENGTH, MAXTYPE, MUSTBE, REQUIRED, PERSISTENT, PRIMARYKEYCOLSEQ, REMARKS, SAMEASATTRIBUTE, SAMEASOBJECT, SCALE, TITLE, USERDEFINED, CHANGED, SEARCHTYPE, MLSUPPORTED, MLINUSE, HANDLECOLUMNNAME, MAXATTRIBUTEID, RESTRICTED, LOCALIZABLE, TEXTDIRECTION, COMPLEXEXPRESSION) values ( 'C_INSP10', 'COMP', 'COMP', null, 42, 0, null, 'COMP', '0', null, 0, 'C_INSP10', 0, 0, 0, 1, 'YORN', 0, 1, 1, null, '完成', null, null, 0, '完成', 1,'I', 'EXACT', 0, 0, null, MAXATTRIBUTECFGSEQ.nextval, 0, 0, null, null);

----------------CreateindexScript----------------

insert into maxsysindexes ( NAME, TBNAME, UNIQUERULE, CHANGED, CLUSTERRULE, STORAGEPARTITION, REQUIRED, TEXTSEARCH, MAXSYSINDEXESID) values ( 'C_INSP10_NDX1', 'C_INSP10',

上面的步驟是很規范的，但是要保證自己的數據是最新的，如果只是對某一個表進行操作，可以不刪除該表后在重建的操作，直接使用下面的語句進行：

注意：下面各個表中的 changed 意思： A 待變更 I 添加 N 完成

對 MBO 表的mbo類進行更改：

----------------UpdateObjectScript----------------

insert into maxobjectcfg ( OBJECTNAME, CLASSNAME, DESCRIPTION, EAUDITENABLED, EAUDITFILTER, ENTITYNAME, ESIGFILTER, EXTENDSOBJECT, IMPORTED, ISVIEW, PERSISTENT, SERVICENAME,  SITEORGTYPE, USERDEFINED, CHANGED, MAINOBJECT, INTERNAL, MAXOBJECTID, TEXTDIRECTION) values ( 'C_INSP10', 'jtv.app.c_insp10.C_insp10Set', '人工添乘', 0, null, 'C_INSP10', null,  null, 0, 0, 1, 'CUSTAPP', 'SITE', 1,'A', 0, 0, MAXOBJECTCFGSEQ.nextval, null);

----------------CreateAutokeyScript----------------

commit;