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

Re: SF.net SVN: ledger-smb:[3656] trunk/sql/modules



Hi Chris,

Is the commit below missing an sql/upgrade/ equivalent?

Bye,


Erik.

On Tue, Aug 16, 2011 at 1:19 AM, <..hidden..> wrote:
Revision: 3656
         http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3656&view=rev
Author:   einhverfr
Date:     2011-08-15 23:19:51 +0000 (Mon, 15 Aug 2011)

Log Message:
-----------
Correcting test failures and fixing bug 3387887

Modified Paths:
--------------
   trunk/sql/modules/Roles.sql
   trunk/sql/modules/Voucher.sql

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql 2011-08-15 23:07:17 UTC (rev 3655)
+++ trunk/sql/modules/Roles.sql 2011-08-15 23:19:51 UTC (rev 3656)
@@ -6,7 +6,7 @@
 WITH INHERIT NOLOGIN;

 GRANT SELECT ON file_base, file_secondary_attachment, file_transaction,
-file_order, file_links
+file_order, file_links, file_part
      TO "lsmb_<?lsmb dbname ?>__file_read";

 CREATE ROLE "lsmb_<?lsmb dbname ?>__file_attach_tx"
@@ -15,6 +15,7 @@
 GRANT INSERT, UPDATE ON file_transaction, file_order_to_tx TO
 "lsmb_<?lsmb dbname ?>__file_attach_tx";

+
 CREATE ROLE "lsmb_<?lsmb dbname ?>__file_attach_order"
 WITH INHERIT NOLOGIN;

@@ -22,9 +23,23 @@
      ON file_order,
         file_order_to_order,
         file_tx_to_order
-      TO "lsmb_<?lsmb dbname ?>__file_attach_tx";
+      TO "lsmb_<?lsmb dbname ?>__file_attach_order";

+GRANT INSERT, UPDATE ON file_transaction, file_order_to_tx TO
+ "lsmb_<?lsmb dbname ?>__file_attach_tx";

+
+CREATE ROLE "lsmb_<?lsmb dbname ?>__file_attach_part"
+WITH INHERIT NOLOGIN;
+
+GRANT INSERT, UPDATE
+      ON file_part
+      TO "lsmb_<?lsmb dbname ?>__file_attach_part";
+
+
+GRANT ALL ON file_base_id_seq TO "lsmb_<?lsmb dbname ?>__file_attach_tx";
+GRANT ALL ON file_base_id_seq TO "lsmb_<?lsmb dbname ?>__file_attach_part";
+GRANT ALL ON file_base_id_seq TO "lsmb_<?lsmb dbname ?>__file_attach_order";
 -- Contacts

 CREATE ROLE "lsmb_<?lsmb dbname ?>__contact_read"

Modified: trunk/sql/modules/Voucher.sql
===================================================================
--- trunk/sql/modules/Voucher.sql       2011-08-15 23:07:17 UTC (rev 3655)
+++ trunk/sql/modules/Voucher.sql       2011-08-15 23:19:51 UTC (rev 3656)
@@ -101,7 +101,7 @@
                       AND a.voucher_id = v.id
                       AND (bc.class like 'receipt%' AND c.link = 'AR')
               GROUP BY v.id, a.source, cr.meta_number, co.legal_name ,
-                        v.batch_id, v.trans_id, a.transdate, bc.class
+                        a.memo, v.batch_id, v.trans_id, a.transdate, bc.class
               UNION ALL
               SELECT v.id, g.reference, g.description,
                       v.batch_id, v.trans_id,


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

------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at:  http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits