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

SF.net SVN: ledger-smb:[3503] trunk/sql/upgrade/1.2-1.3-work-in-progress. sql



Revision: 3503
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3503&view=rev
Author:   einhverfr
Date:     2011-07-13 20:04:03 +0000 (Wed, 13 Jul 2011)

Log Message:
-----------
Adding missing parentheses

Modified Paths:
--------------
    trunk/sql/upgrade/1.2-1.3-work-in-progress.sql

Modified: trunk/sql/upgrade/1.2-1.3-work-in-progress.sql
===================================================================
--- trunk/sql/upgrade/1.2-1.3-work-in-progress.sql	2011-07-13 19:55:26 UTC (rev 3502)
+++ trunk/sql/upgrade/1.2-1.3-work-in-progress.sql	2011-07-13 20:04:03 UTC (rev 3503)
@@ -597,66 +597,66 @@
 
 INSERT INTO  custom_field_catalog  SELECT * FROM lsmb12. custom_field_catalog;
 
-SELECT setval('id', max(id)) FROM transactions;
+SELECT setval('id', max(id))) FROM transactions;
 
- SELECT setval('acc_trans_entry_id_seq', max(entry_id) FROM acc_trans;
- SELECT setval('partsvendor_entry_id_seq', max(entry_id) FROM partsvendor;
- SELECT setval('inventory_entry_id_seq', max(entry_id) FROM inventory;
- SELECT setval('partscustomer_entry_id_seq', max(entry_id) FROM partscustomer;
- SELECT setval('audittrail_entry_id_seq', max(entry_id) FROM audittrail;
- SELECT setval('account_id_seq', max(id) FROM account;
- SELECT setval('account_heading_id_seq', max(id) FROM account_heading;
- SELECT setval('account_checkpoint_id_seq', max(id) FROM account_checkpoint;
- SELECT setval('pricegroup_id_seq', max(id) FROM pricegroup;
- SELECT setval('country_id_seq', max(id) FROM country;
- SELECT setval('country_tax_form_id_seq', max(id) FROM country_tax_form;
- SELECT setval('asset_dep_method_id_seq', max(id) FROM asset_dep_method;
- SELECT setval('asset_class_id_seq', max(id) FROM asset_class;
- SELECT setval('entity_class_id_seq', max(id) FROM entity_class;
- SELECT setval('session_session_id_seq', max(id) FROM session_session;
- SELECT setval('asset_item_id_seq', max(id) FROM asset_item;
- SELECT setval('asset_disposal_method_id_seq', max(id) FROM asset_disposal_method;
- SELECT setval('users_id_seq', max(id) FROM users;
- SELECT setval('entity_id_seq', max(id) FROM entity;
- SELECT setval('company_id_seq', max(id) FROM company;
- SELECT setval('location_id_seq', max(id) FROM location;
- SELECT setval('open_forms_id_seq', max(id) FROM open_forms;
- SELECT setval('location_class_id_seq', max(id) FROM location_class;
- SELECT setval('asset_report_id_seq', max(id) FROM asset_report;
- SELECT setval('salutation_id_seq', max(id) FROM salutation;
- SELECT setval('person_id_seq', max(id) FROM person;
- SELECT setval('contact_class_id_seq', max(id) FROM contact_class;
- SELECT setval('entity_credit_account_id_seq', max(id) FROM entity_credit_account;
- SELECT setval('entity_bank_account_id_seq', max(id) FROM entity_bank_account;
- SELECT setval('note_class_id_seq', max(id) FROM note_class;
- SELECT setval('note_id_seq', max(id) FROM note;
- SELECT setval('trial_balance_id_seq', max(id) FROM trial_balance;
- SELECT setval('batch_class_id_seq', max(id) FROM batch_class;
- SELECT setval('batch_id_seq', max(id) FROM batch;
- SELECT setval('invoice_id_seq', max(id) FROM invoice;
- SELECT setval('voucher_id_seq', max(id) FROM voucher;
- SELECT setval('parts_id_seq', max(id) FROM parts;
- SELECT setval('taxmodule_taxmodule_id_seq', max(id) FROM taxmodule_taxmodule;
- SELECT setval('taxcategory_taxcategory_id_seq', max(id) FROM taxcategory_taxcategory;
- SELECT setval('oe_id_seq', max(id) FROM oe;
- SELECT setval('orderitems_id_seq', max(id) FROM orderitems;
- SELECT setval('business_id_seq', max(id) FROM business;
- SELECT setval('warehouse_id_seq', max(id) FROM warehouse;
- SELECT setval('partsgroup_id_seq', max(id) FROM partsgroup;
- SELECT setval('project_id_seq', max(id) FROM project;
- SELECT setval('department_id_seq', max(id) FROM department;
- SELECT setval('jcitems_id_seq', max(id) FROM jcitems;
- SELECT setval('payment_type_id_seq', max(id) FROM payment_type;
- SELECT setval('custom_table_catalog_table_id_seq', max(id) FROM custom_table_catalog_table;
- SELECT setval('custom_field_catalog_field_id_seq', max(id) FROM custom_field_catalog_field;
- SELECT setval('menu_node_id_seq', max(id) FROM menu_node;
- SELECT setval('menu_attribute_id_seq', max(id) FROM menu_attribute;
- SELECT setval('menu_acl_id_seq', max(id) FROM menu_acl;
- SELECT setval('pending_job_id_seq', max(id) FROM pending_job;
- SELECT setval('new_shipto_id_seq', max(id) FROM new_shipto;
- SELECT setval('payment_id_seq', max(id) FROM payment;
- SELECT setval('cr_report_id_seq', max(id) FROM cr_report;
- SELECT setval('cr_report_line_id_seq', max(id) FROM cr_report_line;
+ SELECT setval('acc_trans_entry_id_seq', max(entry_id)) FROM acc_trans;
+ SELECT setval('partsvendor_entry_id_seq', max(entry_id)) FROM partsvendor;
+ SELECT setval('inventory_entry_id_seq', max(entry_id)) FROM inventory;
+ SELECT setval('partscustomer_entry_id_seq', max(entry_id)) FROM partscustomer;
+ SELECT setval('audittrail_entry_id_seq', max(entry_id)) FROM audittrail;
+ SELECT setval('account_id_seq', max(id)) FROM account;
+ SELECT setval('account_heading_id_seq', max(id)) FROM account_heading;
+ SELECT setval('account_checkpoint_id_seq', max(id)) FROM account_checkpoint;
+ SELECT setval('pricegroup_id_seq', max(id)) FROM pricegroup;
+ SELECT setval('country_id_seq', max(id)) FROM country;
+ SELECT setval('country_tax_form_id_seq', max(id)) FROM country_tax_form;
+ SELECT setval('asset_dep_method_id_seq', max(id)) FROM asset_dep_method;
+ SELECT setval('asset_class_id_seq', max(id)) FROM asset_class;
+ SELECT setval('entity_class_id_seq', max(id)) FROM entity_class;
+ SELECT setval('session_session_id_seq', max(id)) FROM session_session;
+ SELECT setval('asset_item_id_seq', max(id)) FROM asset_item;
+ SELECT setval('asset_disposal_method_id_seq', max(id)) FROM asset_disposal_method;
+ SELECT setval('users_id_seq', max(id)) FROM users;
+ SELECT setval('entity_id_seq', max(id)) FROM entity;
+ SELECT setval('company_id_seq', max(id)) FROM company;
+ SELECT setval('location_id_seq', max(id)) FROM location;
+ SELECT setval('open_forms_id_seq', max(id)) FROM open_forms;
+ SELECT setval('location_class_id_seq', max(id)) FROM location_class;
+ SELECT setval('asset_report_id_seq', max(id)) FROM asset_report;
+ SELECT setval('salutation_id_seq', max(id)) FROM salutation;
+ SELECT setval('person_id_seq', max(id)) FROM person;
+ SELECT setval('contact_class_id_seq', max(id)) FROM contact_class;
+ SELECT setval('entity_credit_account_id_seq', max(id)) FROM entity_credit_account;
+ SELECT setval('entity_bank_account_id_seq', max(id)) FROM entity_bank_account;
+ SELECT setval('note_class_id_seq', max(id)) FROM note_class;
+ SELECT setval('note_id_seq', max(id)) FROM note;
+ SELECT setval('trial_balance_id_seq', max(id)) FROM trial_balance;
+ SELECT setval('batch_class_id_seq', max(id)) FROM batch_class;
+ SELECT setval('batch_id_seq', max(id)) FROM batch;
+ SELECT setval('invoice_id_seq', max(id)) FROM invoice;
+ SELECT setval('voucher_id_seq', max(id)) FROM voucher;
+ SELECT setval('parts_id_seq', max(id)) FROM parts;
+ SELECT setval('taxmodule_taxmodule_id_seq', max(id)) FROM taxmodule_taxmodule;
+ SELECT setval('taxcategory_taxcategory_id_seq', max(id)) FROM taxcategory_taxcategory;
+ SELECT setval('oe_id_seq', max(id)) FROM oe;
+ SELECT setval('orderitems_id_seq', max(id)) FROM orderitems;
+ SELECT setval('business_id_seq', max(id)) FROM business;
+ SELECT setval('warehouse_id_seq', max(id)) FROM warehouse;
+ SELECT setval('partsgroup_id_seq', max(id)) FROM partsgroup;
+ SELECT setval('project_id_seq', max(id)) FROM project;
+ SELECT setval('department_id_seq', max(id)) FROM department;
+ SELECT setval('jcitems_id_seq', max(id)) FROM jcitems;
+ SELECT setval('payment_type_id_seq', max(id)) FROM payment_type;
+ SELECT setval('custom_table_catalog_table_id_seq', max(id)) FROM custom_table_catalog_table;
+ SELECT setval('custom_field_catalog_field_id_seq', max(id)) FROM custom_field_catalog_field;
+ SELECT setval('menu_node_id_seq', max(id)) FROM menu_node;
+ SELECT setval('menu_attribute_id_seq', max(id)) FROM menu_attribute;
+ SELECT setval('menu_acl_id_seq', max(id)) FROM menu_acl;
+ SELECT setval('pending_job_id_seq', max(id)) FROM pending_job;
+ SELECT setval('new_shipto_id_seq', max(id)) FROM new_shipto;
+ SELECT setval('payment_id_seq', max(id)) FROM payment;
+ SELECT setval('cr_report_id_seq', max(id)) FROM cr_report;
+ SELECT setval('cr_report_line_id_seq', max(id)) FROM cr_report_line;
 
 
 COMMIT;


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