--------------------------------------------------------------
-- fix6062030.sql
--
-- 07/13/07 CJS
--------------------------------------------------------------
-- add new property and propertyUsage: OPTIMIZE_MERGE
--------------------------------------------------------------


declare
    classId number;
    propertySetId number;
    propertyId number;

    begin
        select elementid into classId from classdefinition_v
        where name='oracle.wh.service.impl.mapping.component.Table';

        select elementid into propertySetId from propertysetdefinition_v
        where classdefinition=classId and name='PLSQL'
        and propertytype=2; 

 -- add new property: OPTIMIZE_MERGE
        insert into propertydefinition_v (
          LOADINGPARENT
          ,DELETIONPARENT
          ,AGGREGATEDSIGNATURE
          ,CLASSNAME
          ,COMPLETED
          ,CREATEDBY
          ,CREATIONTIMESTAMP
          ,CUSTOMERDELETABLE
          ,CUSTOMEREDITABLE
          ,CUSTOMERRENAMABLE
          ,DESCRIPTION
          ,DISABLED
          ,EDITABLE
          ,ELEMENTID
          ,FROZEN
          ,GENERATED
          ,IMPORTED
          ,LOGICALNAME
          ,METADATASIGNATURE
          ,NAME
          ,NOTE
          ,NOTM
          ,PERSISTENT
          ,SEEDED
          ,UOID
          ,UPDATEDBY
          ,UPDATETIMESTAMP
          ,VERSION
          ,ISLOADINGPARENT
          ,PROPERTYTYPE
          ,DEFINITIONKEY
          ,EXPORTCONTROL
          ,OVERRIDE
          ,POSITION
          ,CLASSDEFINITION
          ,DATATYPE
          ,ISROLE
          ,ROLEDEFINITION
          ,TRANSLATABLE
          ,ISPASSWORD
          ,HIDDEN
          ,PROPERTYREADONLY
          ,NAMECHECKED
          ,USERCHOICEALLOWED
          ,DYNAMICDEFAULT
          ,INPLACEEDITOR
          ,CUSTOMEDITOR
          ,PROPERTYGROUPDEFINITION
        )
        values (
          classId
          , 0
          , null
          , 'PropertyDefinition'
          , 0
          , (select createdby from cmpinstallation_v)
          , (select creationtimestamp from cmpinstallation_v)
          , 0
          , 0
          , 0
          , 'Optimize code generated to defer transformations until actually needed'
          , 0
          , 0
          , cwmseq.nextval
          , 0
          , 0
          , 0
          , 'OPTIMIZE_MERGE'
          , '2ebec2acaf7982186613878879f33d78'
          , 'OPTIMIZE_MERGE'
          , null
          , 0
          , null
          , 1
          , '0CA84DCDE8304915991E0A292A89BA4F'
          , (select updatedby from cmpinstallation_v)
          , sysdate
          , null
          , 0
          , 2 
          , 'optimizeMerge' 
          , 0
          , 0
          , 67
          , classId
          , 113
          , 0
          , 0
          , 0
          , 0
          , 0
          , 0
          , 0
          , 0
          , null
          , null
          , null
          , 0
        );

        select elementid into propertyId from propertydefinition_v
        where classdefinition=classId and name='OPTIMIZE_MERGE';

        insert into propertyusagedefinition_v (
          LOADINGPARENT
          , DELETIONPARENT
          , AGGREGATEDSIGNATURE
          , CLASSNAME
          , COMPLETED
          , CREATEDBY
          , CREATIONTIMESTAMP
          , CUSTOMERDELETABLE
          , CUSTOMEREDITABLE
          , CUSTOMERRENAMABLE
          , DESCRIPTION
          , DISABLED
          , EDITABLE
          , ELEMENTID
          , FROZEN
          , GENERATED
          , IMPORTED
          , LOGICALNAME
          , METADATASIGNATURE
          , NAME
          , NOTE
          , NOTM
          , PERSISTENT
          , SEEDED
          , UOID
          , UPDATEDBY
          , UPDATETIMESTAMP
          , VERSION
          , ISLOADINGPARENT
          , PROPERTYSETDEFINITION
          , PROPERTYDEFINITION
          , DEFINITIONKEY
        )
        values (
          classId
          , 0
          , null
          , 'PropertyUsageDefinition'
          , 0
          , (select createdby from cmpinstallation_v)
          , (select creationtimestamp from cmpinstallation_v)
          , 0
          , 0
          , 0
          , 'Optimize code generated to defer transformations until actually needed'
          , 0
          , 0
          , cwmseq.nextval
          , 0
          , 0
          , 0
          , 'OPTIMIZE_MERGE'
          , '2ebec2acaf7982186613878879f33d78'
          , 'OPTIMIZE_MERGE'
          , null
          , 0
          , null
          , 1
          , '0CA84DCDE8304915991E0A292A89BA4F'
          , (select updatedby from cmpinstallation_v)
          , sysdate
          , null
          , 0
          , propertySetId
          , propertyId
          , '8i.MAPPING.TABLE.OPTIMIZE_MERGE'
        );
end;
/

commit;
/