Hi Chris, Is the commit below missing an sql/upgrade/ equivalent?
Bye, Erik. On Tue, Aug 16, 2011 at 1:19 AM, <[email protected]> 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits >
------------------------------------------------------------------------------ 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-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
