aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/plugin_exchangedb_postgres.c
diff options
context:
space:
mode:
Diffstat (limited to 'src/exchangedb/plugin_exchangedb_postgres.c')
-rw-r--r--src/exchangedb/plugin_exchangedb_postgres.c91
1 files changed, 0 insertions, 91 deletions
diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c
index b1f1aba8e..2d4e0889f 100644
--- a/src/exchangedb/plugin_exchangedb_postgres.c
+++ b/src/exchangedb/plugin_exchangedb_postgres.c
@@ -140,8 +140,6 @@ postgres_drop_tables (void *cls)
{
struct PostgresClosure *pc = cls;
struct GNUNET_PQ_ExecuteStatement es[] = {
- GNUNET_PQ_make_execute ("DROP TABLE IF EXISTS kyc_events CASCADE;"),
- GNUNET_PQ_make_execute ("DROP TABLE IF EXISTS kyc_merchants CASCADE;"),
GNUNET_PQ_make_execute ("DROP TABLE IF EXISTS prewire CASCADE;"),
GNUNET_PQ_make_execute ("DROP TABLE IF EXISTS payback CASCADE;"),
GNUNET_PQ_make_execute ("DROP TABLE IF EXISTS payback_refresh CASCADE;"),
@@ -498,34 +496,6 @@ postgres_create_tables (void *cls)
");"),
- /**
- * The 'general_id' column represents _some_ identificator
- * from the institution that cares about the merchant KYC status.
- * If the institution is a bank, then this values might be
- * _any_ alphanumeric code that uniquely identifies that merchant
- * at that bank. Could also be NULL, if that bank's policy
- * admits so.
- */
- GNUNET_PQ_make_execute("CREATE TABLE IF NOT EXISTS kyc_merchants "
- "(merchant_serial_id BIGSERIAL PRIMARY KEY"
- ",kyc_checked BOOLEAN NOT NULL DEFAULT FALSE"
- ",payto_url VARCHAR UNIQUE NOT NULL"
- ",general_id VARCHAR NOT NULL"
- ");"),
-
- GNUNET_PQ_make_try_execute ("CREATE INDEX kyc_merchants_payto_url ON "
- "kyc_merchants (payto_url);"),
-
- GNUNET_PQ_make_execute("CREATE TABLE IF NOT EXISTS kyc_events "
- "(merchant_serial_id BIGSERIAL NOT NULL REFERENCES kyc_merchants (merchant_serial_id) ON DELETE CASCADE"
- ",amount_val INT8 NOT NULL"
- ",amount_frac INT4 NOT NULL"
- ",timestamp INT8 NOT NULL"
- ");"),
-
- GNUNET_PQ_make_try_execute ("CREATE INDEX kyc_events_timestamp ON "
- "kyc_events (timestamp);"),
-
/* Index for wire_prepare_data_get and gc_prewire statement */
GNUNET_PQ_make_try_execute("CREATE INDEX prepare_iteration_index "
"ON prewire(finished);"),
@@ -1368,67 +1338,6 @@ postgres_prepare (PGconn *db_conn)
" LIMIT 1;",
0),
- GNUNET_PQ_make_prepare ("clean_kyc_events",
- "DELETE"
- " FROM kyc_events"
- " WHERE merchant_serial_id=$1",
- 1),
-
- /* Assume a merchant _unchecked_ if their events
- * are stored into the table queried below. */
- GNUNET_PQ_make_prepare ("get_kyc_events",
- "SELECT"
- " merchant_serial_id"
- ",amount_val"
- ",amount_frac"
- " FROM kyc_events"
- " WHERE merchant_serial_id=$1",
- 1),
-
- GNUNET_PQ_make_prepare ("get_kyc_status",
- "SELECT"
- " general_id"
- ",kyc_checked"
- ",merchant_serial_id"
- " FROM kyc_merchants"
- " WHERE payto_url=$1",
- 1),
-
- GNUNET_PQ_make_prepare ("insert_kyc_merchant",
- "INSERT INTO kyc_merchants "
- "(payto_url"
- ",general_id"
- ",kyc_checked) VALUES "
- "($1, $2, FALSE)",
- 2),
-
-
- /* NOTE: NOT used yet, just _potentially_ needed. */
- GNUNET_PQ_make_prepare ("unmark_kyc_merchant",
- "UPDATE kyc_merchants"
- " SET"
- " kyc_checked=FALSE"
- " WHERE"
- " payto_url=$1",
- 1),
-
- GNUNET_PQ_make_prepare ("mark_kyc_merchant",
- "UPDATE kyc_merchants"
- " SET"
- " kyc_checked=TRUE"
- " WHERE"
- " payto_url=$1",
- 1),
-
- GNUNET_PQ_make_prepare ("insert_kyc_event",
- "INSERT INTO kyc_events "
- "(merchant_serial_id"
- ",amount_val"
- ",amount_frac"
- ",timestamp)"
- " VALUES ($1, $2, $3, $4)",
- 4),
-
/* Used in #postgres_select_deposits_missing_wire */
GNUNET_PQ_make_prepare ("deposits_get_overdue",
"SELECT"