[dev] [patch] juno sql script

[Ben Chavet]

I had to make these changes in order to create the juno tables in 
postgreSQL.

Modified files:
  juno/scripts/drivers/juno.sql

--Ben
-------------- next part --------------
Index: juno.sql
===================================================================
RCS file: /repository/juno/scripts/drivers/juno.sql,v
retrieving revision 1.9
diff -u -r1.9 juno.sql
--- juno.sql	12 Apr 2004 19:39:54 -0000	1.9
+++ juno.sql	13 Apr 2004 18:09:05 -0000
@@ -25,12 +25,15 @@
     transaction_id          INT NOT NULL default '0',
     account_id              INT NOT NULL default '0',
     entry_desc              TEXT NOT NULL,
-    entry_amount            INT(12) NOT NULL default '0',
-    book_amount             INT(12) NOT NULL default '0',
+    entry_amount            INT NOT NULL default '0',
+    book_amount             INT NOT NULL default '0',
     entry_reconciledate     INT NOT NULL default '0',
 
     PRIMARY KEY (entry_id)
 );
 
-CREATE INDEX entry_account_id_idx ON juno_transactions (account_id);
-CREATE INDEX entry_reconciledate_idx ON juno_transactions (entry_reconciledate);
+CREATE INDEX entry_account_id_idx ON juno_entries (account_id);
+CREATE INDEX entry_reconciledate_idx ON juno_entries (entry_reconciledate);
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON juno_transactions TO horde;
+GRANT SELECT, INSERT, UPDATE, DELETE ON juno_entries TO horde;