Java 企业应用
不要温柔的走入那个良夜

 

如果是多人联合对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;
posted on 2012-03-31 12:06 cpegtop 阅读(1303) 评论(1)  编辑  收藏
Comments
  • # re: maximo 更改数据库[未登录]
    li
    Posted @ 2014-03-11 13:41
    这个工具怎么用啊,maximo初学者,谢谢了  回复  更多评论   

只有注册用户登录后才能发表评论。


网站导航: