[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

Revision: 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:

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,
      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!
Ledger-smb-commits mailing list