exchange

commit 8c16c7372a2c9617e1ff8f235718f9e82cb6414a
parent a458eab0ccccc1d2dd3ecd724e629728ba686b7d
Author: Sree Harsha Totakura <sreeharsha@totakura.in>
Date:   Fri,  6 Mar 2015 17:52:24 +0100

db: Add `reserves_out' table.

Diffstat:
M
src/mint/mint_db.c
 | 
15
++++++++++++++-

1 file changed, 14 insertions(+), 1 deletion(-)
diff --git a/src/mint/mint_db.c b/src/mint/mint_db.c
@@ -174,7 +174,20 @@ TALER_MINT_DB_create_tables (int temporary)
           ",expiration_date INT8 NOT NULL"
           ");");
   /* Create an index on the foreign key as it is not created automatically by PSQL */
-  SQLEXEC ("CREATE INDEX reserves_in_index ON reserves_in (reserve_pub);");
+  SQLEXEC ("CREATE INDEX reserves_in_reserve_pub_index"
+           " ON reserves_in (reserve_pub);");
+  SQLEXEC ("CREATE TABLE IF NOT EXISTS reserves_out"
+           "("
+           " reserve_pub BYTEA REFERENCES reserves (reserve_pub) ON DELETE CASCADE"
+           ",value INT4 NOT NULL"
+           ",fraction INT4 NOT NULL"
+           ",blind_ev BYTEA PRIMARY KEY"
+           ",denom_pub BYTEA NOT NULL" /* FIXME: Make this a foreign key? */
+           ",auth_sig BYTEA NOT NULL"
+           ")");
+  SQLEXEC ("CREATE INDEX reserves_out_reserve_pub_index"
+           " ON reserves_out (reserve_pub);");
+
   SQLEXEC ("CREATE TABLE IF NOT EXISTS collectable_blindcoins"
            "("
            "blind_ev BYTEA PRIMARY KEY"