On Wed, Mar 17, 2010 at 11:39 PM, Luke <[email protected]> wrote: > Very nice--thanks for this. It will help a lot. > > Luke > > On Wed, 17 Mar 2010, Chris Travers wrote: > >> The first part was to move the defaults data over. >> >> alter table defaults add column setting_key text, value text; >> alter table defaults add column setting_key text; >> alter table defaults add column value text; >> update defaults set setting_key = fldname, value = fldvalue; >> alter table defaults drop fldname; >> alter table defaults drop fldvalue; >> >> I then ran pg_central.sql on the database. >> >> I then renamed vendor and customer to old_* >> I created new customer/vendor/transactions tables >> >> The key here then was to populate the customer/vendor tables, this was >> not too bad. It just involves insert/select against the old_* and >> address tables. >> >> I then copied and pasted relevant portions of each of the upgrade >> scripts and applied all the sql/fixes/scripts. >> >> The other things that I had to do was run the upgrade_templates.pl and >> import_members.pl against appropriate targets. >> >> I found out later I had to add "notes" fields on the invoice and >> orderitems tables.
A couple more things I apparently missed: acc_trans.invoice_id had to be added acc_trans.cleared had to be changed to a boolean from a date field. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
