[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[6366] trunk/sql/modules

Subject: SF.net SVN: ledger-smb:[6366] trunk/sql/modules
From: ..hidden..
Date: Fri, 3 Jan 2014 22:19:13 +0000
Revision: 6366
          http://sourceforge.net/p/ledger-smb/code/6366
Author:   ehuelsmann
Date:     2014-01-03 22:19:11 +0000 (Fri, 03 Jan 2014)
Log Message:
-----------
Create and document a protocol for modules to indicate success
to the module loader.

Modified Paths:
--------------
    trunk/sql/modules/1099_reports.sql
    trunk/sql/modules/Account.sql
    trunk/sql/modules/App_Module.sql
    trunk/sql/modules/Assets.sql
    trunk/sql/modules/Backup.sql
    trunk/sql/modules/Budgetting.sql
    trunk/sql/modules/Business_Dates.sql
    trunk/sql/modules/Business_Unit.sql
    trunk/sql/modules/Business_type.sql
    trunk/sql/modules/COGS.sql
    trunk/sql/modules/Company.sql
    trunk/sql/modules/Customer.sql
    trunk/sql/modules/Date.sql
    trunk/sql/modules/Drafts.sql
    trunk/sql/modules/Employee.sql
    trunk/sql/modules/EndOfYear.sql
    trunk/sql/modules/Entity.sql
    trunk/sql/modules/Files.sql
    trunk/sql/modules/Fixes.sql
    trunk/sql/modules/Goods.sql
    trunk/sql/modules/Inventory.sql
    trunk/sql/modules/Inventory_Report.sql
    trunk/sql/modules/Journal.sql
    trunk/sql/modules/LOADORDER
    trunk/sql/modules/Location.sql
    trunk/sql/modules/Menu.sql
    trunk/sql/modules/OrderEntry.sql
    trunk/sql/modules/PNL.sql
    trunk/sql/modules/Parts.sql
    trunk/sql/modules/Payment.sql
    trunk/sql/modules/Payroll.sql
    trunk/sql/modules/Person.sql
    trunk/sql/modules/Reconciliation.sql
    trunk/sql/modules/Report.sql
    trunk/sql/modules/Roles.sql
    trunk/sql/modules/Session.sql
    trunk/sql/modules/Settings.sql
    trunk/sql/modules/TaxForm.sql
    trunk/sql/modules/Templates.sql
    trunk/sql/modules/Timecards.sql
    trunk/sql/modules/Transaction_Templates.sql
    trunk/sql/modules/Util.sql
    trunk/sql/modules/Vendor.sql
    trunk/sql/modules/Voucher.sql
    trunk/sql/modules/admin.sql
    trunk/sql/modules/arap.sql
    trunk/sql/modules/menu_rebuild.sql
    trunk/sql/modules/trial_balance.sql

Modified: trunk/sql/modules/1099_reports.sql
===================================================================
--- trunk/sql/modules/1099_reports.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/1099_reports.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -360,4 +360,7 @@
 is intended to allow an organization to adjust what is reported on the 1099 
 before printing them.$$;
 
+
+update defaults set value='yes' where setting_key='module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Account.sql
===================================================================
--- trunk/sql/modules/Account.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Account.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -629,4 +629,6 @@
 SELECT * FROM gifi ORDER BY accno;
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/App_Module.sql
===================================================================
--- trunk/sql/modules/App_Module.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/App_Module.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -12,4 +12,6 @@
 COMMENT ON FUNCTION lsmb_module__list() IS
 $$ Returns a list of all defined modules, ordered by id. $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Assets.sql
===================================================================
--- trunk/sql/modules/Assets.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Assets.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1316,4 +1316,6 @@
 alter table asset_report alter column entered_by 
 set default person__get_my_entity_id();
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Backup.sql
===================================================================
--- trunk/sql/modules/Backup.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Backup.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -119,5 +119,8 @@
 disclosure.
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
 
+
+
 COMMIT;

Modified: trunk/sql/modules/Budgetting.sql
===================================================================
--- trunk/sql/modules/Budgetting.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Budgetting.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -341,4 +341,7 @@
 COMMENT ON FUNCTION budget__reject(in_id int) IS
 $$ Deletes unapproved budgets only.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
+
 COMMIT;

Modified: trunk/sql/modules/Business_Dates.sql
===================================================================
--- trunk/sql/modules/Business_Dates.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Business_Dates.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -3,6 +3,7 @@
 -- the GNU GPL version 2 or at your option any future version.  Please see the
 -- accompanying LICENSE file for details.
 
+begin;
 
 --
 -- Content
@@ -335,3 +336,9 @@
   return t_end_date;
 end;
 $$;
+
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
+
+
+commit;
\ No newline at end of file

Modified: trunk/sql/modules/Business_Unit.sql
===================================================================
--- trunk/sql/modules/Business_Unit.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Business_Unit.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -215,4 +215,8 @@
        ON entity_credit_account
        FOR EACH ROW EXECUTE PROCEDURE eca_bu_trigger();
 
+
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
+
 COMMIT;

Modified: trunk/sql/modules/Business_type.sql
===================================================================
--- trunk/sql/modules/Business_type.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Business_type.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -13,4 +13,6 @@
 COMMENT ON function business_type__list() IS 
 $$Returns a list of all business types. Ordered by description by default.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/COGS.sql
===================================================================
--- trunk/sql/modules/COGS.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/COGS.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -372,4 +372,6 @@
 
 $$ LANGUAGE PLPGSQL;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Company.sql
===================================================================
--- trunk/sql/modules/Company.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Company.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1701,4 +1701,8 @@
 SELECT * FROM sic ORDER BY code;
 $$;
 
+
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
+
 COMMIT;

Modified: trunk/sql/modules/Customer.sql
===================================================================
--- trunk/sql/modules/Customer.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Customer.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1,3 +1,6 @@
+
+begin;
+
 CREATE OR REPLACE FUNCTION customer_location_save (
     in_entity_id int,
     in_location_class int, in_line_one text, in_line_two text, 
@@ -13,3 +16,7 @@
 
 $$ language 'plpgsql';
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
+
+commit;
\ No newline at end of file

Modified: trunk/sql/modules/Date.sql
===================================================================
--- trunk/sql/modules/Date.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Date.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -146,4 +146,6 @@
 COMMENT ON FUNCTION periods_get() IS
 $$ Returns dates for year to date, and last year.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Drafts.sql
===================================================================
--- trunk/sql/modules/Drafts.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Drafts.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -142,4 +142,6 @@
 $$ Deletes the draft from the book.  Only will delete unapproved transactions.
 Otherwise an exception is raised and the transaction terminated.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Employee.sql
===================================================================
--- trunk/sql/modules/Employee.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Employee.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -258,4 +258,6 @@
  ORDER BY ee.employeenumber;
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/EndOfYear.sql
===================================================================
--- trunk/sql/modules/EndOfYear.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/EndOfYear.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -248,4 +248,6 @@
 COMMENT ON FUNCTION eoy_earnings_accounts() IS
 $$ Lists equity accounts for the retained earnings dropdown.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Entity.sql
===================================================================
--- trunk/sql/modules/Entity.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Entity.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -141,4 +141,6 @@
 $$ Deletes the bank account identitied by in_id if it is attached to the entity
 identified by entity_id.  Returns true if a record is deleted, false if not.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Files.sql
===================================================================
--- trunk/sql/modules/Files.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Files.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -354,4 +354,6 @@
 COMMENT ON FUNCTION file__list_links(in_ref_key int, in_file_class int) IS
 $$ This function retrieves a list of file attachments on a specified object.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Fixes.sql
===================================================================
--- trunk/sql/modules/Fixes.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Fixes.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -313,3 +313,8 @@
 
 commit;
 
+-- ### not a real check, but we rely on failing transactions above
+-- for the purpose of rejecting bits of script which might have already
+-- been executed before.
+
+update defaults set value='yes' where setting_key='module_load_ok';
\ No newline at end of file

Modified: trunk/sql/modules/Goods.sql
===================================================================
--- trunk/sql/modules/Goods.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Goods.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -379,4 +379,6 @@
 SELECT * FROM warehouse ORDER BY DESCRIPTION;
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Inventory.sql
===================================================================
--- trunk/sql/modules/Inventory.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Inventory.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -97,4 +97,6 @@
 SELECT * FROM parts WHERE id = $1;
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Inventory_Report.sql
===================================================================
--- trunk/sql/modules/Inventory_Report.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Inventory_Report.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -69,4 +69,6 @@
 
 $$ language sql;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Journal.sql
===================================================================
--- trunk/sql/modules/Journal.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Journal.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1,3 +1,5 @@
+begin;
+
 --Journal entry stored procedures for LedgerSMB
 --Copyright (C) 2011, The LedgerSMB Core Team
 
@@ -216,3 +218,7 @@
 
 SELECT je_get(currval('journal_entry_id_seq'));
 $$ LANGUAGE SQL SECURITY DEFINER;
+
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
+commit;
\ No newline at end of file

Modified: trunk/sql/modules/LOADORDER
===================================================================
--- trunk/sql/modules/LOADORDER	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/LOADORDER	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1,5 +1,9 @@
-# This is a simple list of files to be loaded from sql/modules in the order
-# they shall be loaded.
+# This is a simple list of files to be loaded from sql/modules
+# in the order they shall be loaded.
+#
+# Note: These files all adhere to the protocol where
+#  they change the value of the setting_key 'module_load_ok'
+#  from 'no' to 'yes' on success.
 Fixes.sql
 Settings.sql
 Util.sql

Modified: trunk/sql/modules/Location.sql
===================================================================
--- trunk/sql/modules/Location.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Location.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -209,4 +209,6 @@
 
 $$ language sql;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Menu.sql
===================================================================
--- trunk/sql/modules/Menu.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Menu.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -163,4 +163,6 @@
 $$ A nice human-readable view for investigating the menu tree.  Does not
 show menu attributes or acls.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/OrderEntry.sql
===================================================================
--- trunk/sql/modules/OrderEntry.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/OrderEntry.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -183,4 +183,8 @@
 END;
 $$;
 
+
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
+
 COMMIT;

Modified: trunk/sql/modules/PNL.sql
===================================================================
--- trunk/sql/modules/PNL.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/PNL.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -233,4 +233,6 @@
  ORDER BY a.category DESC, a.accno ASC;
 $$ LANGUAGE SQL;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Parts.sql
===================================================================
--- trunk/sql/modules/Parts.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Parts.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -30,4 +30,6 @@
 SELECT * FROM pricegroup;
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Payment.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1566,4 +1566,6 @@
        ($5 IS NULL OR e.name @@ plainto_tsquery($5));
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Payroll.sql
===================================================================
--- trunk/sql/modules/Payroll.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Payroll.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -147,4 +147,6 @@
        (unit = $5 or $5 IS NULL);
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Person.sql
===================================================================
--- trunk/sql/modules/Person.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Person.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -363,4 +363,8 @@
 ) IS
 $$ Saves a location mapped to the person with the specified information.
 Returns the location id saved.$$;
+
+
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Reconciliation.sql
===================================================================
--- trunk/sql/modules/Reconciliation.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Reconciliation.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -629,4 +629,6 @@
 COMMENT ON FUNCTION reconciliation__report_details_payee (in_report_id INT) IS
 $$ Pulls the payee information for the reconciliation report.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Report.sql
===================================================================
--- trunk/sql/modules/Report.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Report.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -608,4 +608,6 @@
 $$ This produces a balance sheet and the paths (acount numbers) of all headings
 necessary. $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Roles.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1112,4 +1112,6 @@
 BEFORE INSERT OR UPDATE OR DELETE ON entity_credit_account
 FOR EACH ROW EXECUTE PROCEDURE tg_enforce_perms_eclass();
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Session.sql
===================================================================
--- trunk/sql/modules/Session.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Session.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -179,4 +179,6 @@
 Returns true if the transaction was unlocked by this routine, false 
 otherwise.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Settings.sql
===================================================================
--- trunk/sql/modules/Settings.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Settings.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -230,4 +230,6 @@
 SELECT NULL::lsmb_sequence;
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/TaxForm.sql
===================================================================
--- trunk/sql/modules/TaxForm.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/TaxForm.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -42,7 +42,7 @@
 COMMENT ON FUNCTION tax_form__get(in_form_id int) IS
 $$ Retrieves specified tax form information from the database.$$;
 
-DROP TYPE IF EXISTS tax_form_list;
+DROP TYPE IF EXISTS tax_form_list CASCADE;
 
 CREATE TYPE tax_form_list AS (
    id int,
@@ -89,4 +89,6 @@
 $$ Returns a list of tax forms with an added field, country_name, to specify the
 name of the country.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Templates.sql
===================================================================
--- trunk/sql/modules/Templates.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Templates.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -47,4 +47,6 @@
 END;
 $$;
 
+update defaults set value='yes' where setting_key='module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Timecards.sql
===================================================================
--- trunk/sql/modules/Timecards.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Timecards.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -179,4 +179,6 @@
 
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Transaction_Templates.sql
===================================================================
--- trunk/sql/modules/Transaction_Templates.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Transaction_Templates.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -181,4 +181,6 @@
 RETURNING *;
 $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Util.sql
===================================================================
--- trunk/sql/modules/Util.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Util.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -121,4 +121,6 @@
 LANGUAGE SQL AS
 $$ SELECT max(transdate) FROM acc_trans; $$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/Vendor.sql
===================================================================
--- trunk/sql/modules/Vendor.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Vendor.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1 +1,5 @@
+begin;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
+commit;

Modified: trunk/sql/modules/Voucher.sql
===================================================================
--- trunk/sql/modules/Voucher.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/Voucher.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -534,4 +534,6 @@
 COMMENT ON FUNCTION voucher__delete(in_voucher_id int) IS
 $$ Deletes the specified voucher from the batch.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/admin.sql
===================================================================
--- trunk/sql/modules/admin.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/admin.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -775,4 +775,6 @@
 COMMENT ON FUNCTION admin__drop_session(in_session_id int) IS
 $$ Drops the session identified, releasing all locks held.$$;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/arap.sql
===================================================================
--- trunk/sql/modules/arap.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/arap.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -127,4 +127,6 @@
 $$ language plpgsql;
 
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

Modified: trunk/sql/modules/menu_rebuild.sql
===================================================================
--- trunk/sql/modules/menu_rebuild.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/menu_rebuild.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -1108,4 +1108,7 @@
 --
 -- PostgreSQL database dump complete
 --
+
+update defaults set value='yes' where setting_key='module_load_ok';
+
 commit;

Modified: trunk/sql/modules/trial_balance.sql
===================================================================
--- trunk/sql/modules/trial_balance.sql	2014-01-03 16:39:45 UTC (rev 6365)
+++ trunk/sql/modules/trial_balance.sql	2014-01-03 22:19:11 UTC (rev 6366)
@@ -323,4 +323,6 @@
     END;
 $body$ LANGUAGE PLPGSQL;
 
+update defaults set value = 'yes' where setting_key = 'module_load_ok';
+
 COMMIT;

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
Prev by Date: SF.net SVN: ledger-smb:[6365] trunk/sql/upgrade/sl2.8-1.3.sql
Next by Date: SF.net SVN: ledger-smb:[6367] trunk/sql/modules/README
Previous by thread: SF.net SVN: ledger-smb:[6365] trunk/sql/upgrade/sl2.8-1.3.sql
Next by thread: SF.net SVN: ledger-smb:[6367] trunk/sql/modules/README
Index(es):
- Date
- Thread