SF.net SVN: ledger-smb:[5813] trunk/sql

[..hidden..]

Revision: 5813
          http://sourceforge.net/p/ledger-smb/code/5813
Author:   einhverfr
Date:     2013-05-17 05:28:16 +0000 (Fri, 17 May 2013)
Log Message:
-----------
Adding an index to menu_node(node_id) because new Roles.sql will severely benefit from one

Modified Paths:
--------------
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Fixes.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2013-05-16 21:20:08 UTC (rev 5812)
+++ trunk/sql/Pg-database.sql	2013-05-17 05:28:16 UTC (rev 5813)
@@ -3519,15 +3519,11 @@
 'deny'.$$;
 
 
-
 ALTER TABLE ONLY menu_acl
     ADD CONSTRAINT menu_acl_node_id_fkey FOREIGN KEY (node_id) REFERENCES menu_node(id);
 
+CREATE INDEX menu_acl_node_id_idx ON menu_acl (node_id);
 
---
--- PostgreSQL database dump complete
---
-
 CREATE OR REPLACE FUNCTION to_args (in_base text[], in_args text[])
 RETURNS text[] AS
 $$

Modified: trunk/sql/modules/Fixes.sql
===================================================================
--- trunk/sql/modules/Fixes.sql	2013-05-16 21:20:08 UTC (rev 5812)
+++ trunk/sql/modules/Fixes.sql	2013-05-17 05:28:16 UTC (rev 5813)
@@ -176,3 +176,7 @@
 ALTER TABLE file_order_to_tx ADD FOREIGN KEY ref_key REFERENCES gl(id);
 
 COMMIT;
+
+BEGIN;
+CREATE INDEX menu_acl_node_id_idx ON menu_acl (node_id);
+COMMIT;

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