src-util/modulescript/src/org/openbravo/modulescript/UpdateBpPaymentLine_data.xsql
changeset 26141 b9fc7e8e60ae
parent 25772 5ef45cfcb9a5
--- a/src-util/modulescript/src/org/openbravo/modulescript/UpdateBpPaymentLine_data.xsql	Fri Mar 06 16:52:17 2015 +0100
+++ b/src-util/modulescript/src/org/openbravo/modulescript/UpdateBpPaymentLine_data.xsql	Fri Mar 06 17:03:04 2015 +0100
@@ -74,4 +74,28 @@
       ]]>
     </Sql>
   </SqlMethod>
+  <SqlMethod name="createInvoiceIndex" type="preparedStatement" return="rowcount">
+    <SqlMethodComment></SqlMethodComment>
+    <Sql>
+      <![CDATA[
+        alter table c_invoice add constraint c_invoice_key primary key (c_invoice_id)    
+      ]]>
+    </Sql>
+  </SqlMethod>
+  <SqlMethod name="dropInvoiceIndex" type="preparedStatement" return="rowcount">
+    <SqlMethodComment></SqlMethodComment>
+    <Sql>
+      <![CDATA[
+        alter table c_invoice drop constraint c_invoice_key cascade    
+      ]]>
+    </Sql>
+  </SqlMethod>
+  <SqlMethod name="analyzeInvoice" type="preparedStatement" return="rowcount">
+    <SqlMethodComment></SqlMethodComment>
+    <Sql>
+      <![CDATA[
+        ANALYZE c_invoice  
+      ]]>
+    </Sql>
+  </SqlMethod>
 </SqlClass>
\ No newline at end of file