SF.net SVN: ledger-smb:[6424] trunk/sql/upgrade/sl2.8-1.3.sql

[..hidden..]

Revision: 6424
          http://sourceforge.net/p/ledger-smb/code/6424
Author:   ehuelsmann
Date:     2014-01-08 08:51:47 +0000 (Wed, 08 Jan 2014)
Log Message:
-----------
Update after talking to Chris:
 * entry_id is an LSMB specific column serving as a unique key
 * customfield_catagol and customtable_catalog are LSMB specific tables
 * Add comments on regarding next steps on other TODOs

Modified Paths:
--------------
    trunk/sql/upgrade/sl2.8-1.3.sql

Modified: trunk/sql/upgrade/sl2.8-1.3.sql
===================================================================
--- trunk/sql/upgrade/sl2.8-1.3.sql	2014-01-08 07:46:49 UTC (rev 6423)
+++ trunk/sql/upgrade/sl2.8-1.3.sql	2014-01-08 08:51:47 UTC (rev 6424)
@@ -482,6 +482,7 @@
 
 
 -- ### TODO: Customer tax does not exist in LSMB. What is its function in SL??
+-- ###  LSMB moved these tables jointly to eca_tax
 -- INSERT INTO customertax (customer_id, chart_id)
 --      SELECT c.credit_id,  a.id
 --        FROM sl28.customertax pt
@@ -547,7 +548,6 @@
 
 INSERT INTO warehouse SELECT * FROM sl28.warehouse;
 
--- ### TODO: Had to delete the column i.entry_id from the SELECT??
 INSERT INTO inventory(entity_id, warehouse_id, parts_id, trans_id,
             orderitems_id, qty, shippingdate)
      SELECT e.entity_id, warehouse_id, parts_id, trans_id,
@@ -557,7 +557,6 @@
 
 INSERT INTO yearend (trans_id, transdate) SELECT * FROM sl28.yearend;
 
--- ### TODO: Had to delete the column 'entry_id' from the SELECT??
 INSERT INTO partsvendor(credit_id, parts_id, partnumber, leadtime, lastcost,
             curr)
      SELECT v.credit_id, parts_id, partnumber, leadtime, lastcost,
@@ -565,7 +564,6 @@
        FROM sl28.partsvendor pv
        JOIN sl28.vendor v ON v.id = pv.vendor_id;
 
--- ### TODO: Had to delete the column 'entry_id'??
 INSERT INTO partscustomer(parts_id, credit_id, pricegroup_id, pricebreak,
             sellprice, validfrom, validto, curr)
      SELECT parts_id, credit_id, pv.pricegroup_id, pricebreak,
@@ -575,7 +573,6 @@
 
 INSERT INTO language SELECT * FROM sl28.language;
 
--- ### TODO: Had to delete entry_id??
 INSERT INTO audittrail(trans_id, tablename, reference, formname, action,
             transdate, person_id)
      SELECT trans_id, tablename, reference, formname, action,
@@ -609,10 +606,6 @@
        JOIN sl28.employee e ON j.employee_id = e.id
        JOIN person p ON e.entity_id = p.entity_id;
 
---  ### Don't understand? These two don't exist??
--- INSERT INTO  custom_table_catalog  SELECT * FROM sl28. custom_table_catalog;
--- INSERT INTO  custom_field_catalog  SELECT * FROM sl28. custom_field_catalog;
-
 INSERT INTO parts_translation SELECT * FROM sl28.translation where trans_id in (select id from parts);
 
 INSERT INTO partsgroup_translation SELECT * FROM sl28.translation where trans_id in

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits