details: https://code.openbravo.com/erp/devel/pi/rev/55c000c91897 changeset: 20997:55c000c91897 user: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com> date: Tue Aug 20 09:33:47 2013 +0200 summary: related to issue 24389: backed out changeset 21d0baeb6c99
details: https://code.openbravo.com/erp/devel/pi/rev/8d3f43817c4f changeset: 20998:8d3f43817c4f user: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com> date: Tue Aug 20 09:37:09 2013 +0200 summary: related to issue 24389: Backed out changesets 4080460baf19 and ca15098edeb0 diffstat: src-db/database/model/tables/M_TRANSACTION.xml | 4 -- src-db/database/model/triggers/M_TRANSACTION_TRG2.xml | 2 - src-db/database/sourcedata/AD_COLUMN.xml | 35 ------------------- src-db/database/sourcedata/AD_ELEMENT.xml | 13 ------- 4 files changed, 0 insertions(+), 54 deletions(-) diffs (94 lines): diff -r c29367b38105 -r 8d3f43817c4f src-db/database/model/tables/M_TRANSACTION.xml --- a/src-db/database/model/tables/M_TRANSACTION.xml Wed Aug 14 14:04:44 2013 +0530 +++ b/src-db/database/model/tables/M_TRANSACTION.xml Tue Aug 20 09:37:09 2013 +0200 @@ -117,10 +117,6 @@ <default><![CDATA[NC]]></default> <onCreateDefault/> </column> - <column name="ISRESERVATIONTRIGGERDISABLED" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false"> - <default><![CDATA[N]]></default> - <onCreateDefault/> - </column> <foreign-key foreignTable="M_INTERNAL_CONSUMPTIONLINE" name="M_INTL_CONSUMP_MTRANSACTION"> <reference local="M_INTERNAL_CONSUMPTIONLINE_ID" foreign="M_INTERNAL_CONSUMPTIONLINE_ID"/> </foreign-key> diff -r c29367b38105 -r 8d3f43817c4f src-db/database/model/triggers/M_TRANSACTION_TRG2.xml --- a/src-db/database/model/triggers/M_TRANSACTION_TRG2.xml Wed Aug 14 14:04:44 2013 +0530 +++ b/src-db/database/model/triggers/M_TRANSACTION_TRG2.xml Tue Aug 20 09:37:09 2013 +0200 @@ -35,8 +35,6 @@ END IF; IF (INSERTING) THEN - IF (:NEW.isreservationtriggerdisabled = 'Y') THEN RETURN; - END IF; IF (:NEW.movementqty < 0 AND :NEW.m_product_uom_id IS NULL) THEN -- Check reservations. Reserved stock must be released before inserting the transacion. SELECT count(1) INTO v_count diff -r c29367b38105 -r 8d3f43817c4f src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Wed Aug 14 14:04:44 2013 +0530 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Tue Aug 20 09:37:09 2013 +0200 @@ -231643,41 +231643,6 @@ <!--411B6E7873FC4939906984022DDF9F6D--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--411B6E7873FC4939906984022DDF9F6D--></AD_COLUMN> -<!--4134E579F126409C920AB9FEBFEF7685--><AD_COLUMN> -<!--4134E579F126409C920AB9FEBFEF7685--> <AD_COLUMN_ID><![CDATA[4134E579F126409C920AB9FEBFEF7685]]></AD_COLUMN_ID> -<!--4134E579F126409C920AB9FEBFEF7685--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> -<!--4134E579F126409C920AB9FEBFEF7685--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--4134E579F126409C920AB9FEBFEF7685--> <NAME><![CDATA[Isreservationtriggerdisabled]]></NAME> -<!--4134E579F126409C920AB9FEBFEF7685--> <HELP><![CDATA[If active this field skip the trigger which check the stock reservations]]></HELP> -<!--4134E579F126409C920AB9FEBFEF7685--> <COLUMNNAME><![CDATA[Isreservationtriggerdisabled]]></COLUMNNAME> -<!--4134E579F126409C920AB9FEBFEF7685--> <AD_TABLE_ID><![CDATA[329]]></AD_TABLE_ID> -<!--4134E579F126409C920AB9FEBFEF7685--> <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID> -<!--4134E579F126409C920AB9FEBFEF7685--> <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH> -<!--4134E579F126409C920AB9FEBFEF7685--> <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISKEY><![CDATA[N]]></ISKEY> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISPARENT><![CDATA[N]]></ISPARENT> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> -<!--4134E579F126409C920AB9FEBFEF7685--> <SEQNO><![CDATA[83]]></SEQNO> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> -<!--4134E579F126409C920AB9FEBFEF7685--> <AD_ELEMENT_ID><![CDATA[E7BCD1D77238483FA6C648AD50A1E5B4]]></AD_ELEMENT_ID> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> -<!--4134E579F126409C920AB9FEBFEF7685--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> -<!--4134E579F126409C920AB9FEBFEF7685--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> -<!--4134E579F126409C920AB9FEBFEF7685--> <POSITION><![CDATA[31]]></POSITION> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> -<!--4134E579F126409C920AB9FEBFEF7685--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> -<!--4134E579F126409C920AB9FEBFEF7685--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> -<!--4134E579F126409C920AB9FEBFEF7685--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> -<!--4134E579F126409C920AB9FEBFEF7685--></AD_COLUMN> - <!--41F88DE1D95E4BDB8EEEEE8C78EA72AA--><AD_COLUMN> <!--41F88DE1D95E4BDB8EEEEE8C78EA72AA--> <AD_COLUMN_ID><![CDATA[41F88DE1D95E4BDB8EEEEE8C78EA72AA]]></AD_COLUMN_ID> <!--41F88DE1D95E4BDB8EEEEE8C78EA72AA--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r c29367b38105 -r 8d3f43817c4f src-db/database/sourcedata/AD_ELEMENT.xml --- a/src-db/database/sourcedata/AD_ELEMENT.xml Wed Aug 14 14:04:44 2013 +0530 +++ b/src-db/database/sourcedata/AD_ELEMENT.xml Tue Aug 20 09:37:09 2013 +0200 @@ -31379,19 +31379,6 @@ <!--E5702FB7A0A14BF782A5723A131B8F8C--> <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY> <!--E5702FB7A0A14BF782A5723A131B8F8C--></AD_ELEMENT> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--><AD_ELEMENT> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <AD_ELEMENT_ID><![CDATA[E7BCD1D77238483FA6C648AD50A1E5B4]]></AD_ELEMENT_ID> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <COLUMNNAME><![CDATA[Isreservationtriggerdisabled]]></COLUMNNAME> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <NAME><![CDATA[Disable reservations trigger]]></NAME> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <PRINTNAME><![CDATA[Disable reservations trigger]]></PRINTNAME> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <HELP><![CDATA[If active this field skip the trigger which check the stock reservations]]></HELP> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--> <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY> -<!--E7BCD1D77238483FA6C648AD50A1E5B4--></AD_ELEMENT> - <!--E7D1B98BBBDD491E9AF666B510D61188--><AD_ELEMENT> <!--E7D1B98BBBDD491E9AF666B510D61188--> <AD_ELEMENT_ID><![CDATA[E7D1B98BBBDD491E9AF666B510D61188]]></AD_ELEMENT_ID> <!--E7D1B98BBBDD491E9AF666B510D61188--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> ------------------------------------------------------------------------------ Introducing Performance Central, a new site from SourceForge and AppDynamics. Performance Central is your source for news, insights, analysis and resources for efficient Application Performance Management. Visit us today! http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
