aboutsummaryrefslogtreecommitdiff
path: root/src/backenddb/merchant-0001.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
-rw-r--r--src/backenddb/merchant-0001.sql86
1 files changed, 43 insertions, 43 deletions
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql
index e959a071..1c9a8aaf 100644
--- a/src/backenddb/merchant-0001.sql
+++ b/src/backenddb/merchant-0001.sql
@@ -79,10 +79,10 @@ CREATE TABLE IF NOT EXISTS merchant_instances
,merchant_pub BYTEA NOT NULL UNIQUE CHECK (LENGTH(merchant_pub)=32)
,auth_hash BYTEA CHECK(LENGTH(auth_hash)=64)
,auth_salt BYTEA CHECK(LENGTH(auth_salt)=32)
- ,merchant_id VARCHAR NOT NULL UNIQUE
- ,merchant_name VARCHAR NOT NULL
- ,website VARCHAR
- ,email VARCHAR
+ ,merchant_id TEXT NOT NULL UNIQUE
+ ,merchant_name TEXT NOT NULL
+ ,website TEXT
+ ,email TEXT
,logo BYTEA
,address BYTEA NOT NULL
,jurisdiction BYTEA NOT NULL
@@ -132,10 +132,10 @@ CREATE TABLE IF NOT EXISTS merchant_accounts
REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE
,h_wire BYTEA NOT NULL CHECK (LENGTH(h_wire)=64)
,salt BYTEA NOT NULL CHECK (LENGTH(salt)=16)
- ,credit_facade_url VARCHAR
- ,credit_facade_credentials VARCHAR
+ ,credit_facade_url TEXT
+ ,credit_facade_credentials TEXT
,last_bank_serial INT8 NOT NULL DEFAULT (0)
- ,payto_uri VARCHAR NOT NULL
+ ,payto_uri TEXT NOT NULL
,active BOOLEAN NOT NULL
,UNIQUE (merchant_serial,payto_uri)
,UNIQUE (h_wire)
@@ -164,10 +164,10 @@ CREATE TABLE IF NOT EXISTS merchant_inventory
(product_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
,merchant_serial BIGINT NOT NULL
REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE
- ,product_id VARCHAR NOT NULL
- ,description VARCHAR NOT NULL
+ ,product_id TEXT NOT NULL
+ ,description TEXT NOT NULL
,description_i18n BYTEA NOT NULL
- ,unit VARCHAR NOT NULL
+ ,unit TEXT NOT NULL
,image BYTEA NOT NULL
,taxes BYTEA NOT NULL
,price taler_amount NOT NULL
@@ -234,13 +234,13 @@ CREATE TABLE IF NOT EXISTS merchant_orders
(order_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
,merchant_serial BIGINT NOT NULL
REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE
- ,order_id VARCHAR NOT NULL
+ ,order_id TEXT NOT NULL
,claim_token BYTEA NOT NULL CHECK (LENGTH(claim_token)=16)
,h_post_data BYTEA NOT NULL CHECK (LENGTH(h_post_data)=64)
,pay_deadline INT8 NOT NULL
,creation_time INT8 NOT NULL
,contract_terms BYTEA NOT NULL
- ,pos_key VARCHAR DEFAULT NULL
+ ,pos_key TEXT DEFAULT NULL
,pos_algorithm INT NOT NULL DEFAULT (0)
,UNIQUE (merchant_serial, order_id)
);
@@ -288,7 +288,7 @@ CREATE TABLE IF NOT EXISTS merchant_contract_terms
(order_serial BIGINT PRIMARY KEY
,merchant_serial BIGINT NOT NULL
REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE
- ,order_id VARCHAR NOT NULL
+ ,order_id TEXT NOT NULL
,contract_terms BYTEA NOT NULL
,h_contract_terms BYTEA NOT NULL CHECK (LENGTH(h_contract_terms)=64)
,creation_time INT8 NOT NULL
@@ -296,9 +296,9 @@ CREATE TABLE IF NOT EXISTS merchant_contract_terms
,refund_deadline INT8 NOT NULL
,paid BOOLEAN DEFAULT FALSE NOT NULL
,wired BOOLEAN DEFAULT FALSE NOT NULL
- ,fulfillment_url VARCHAR
- ,session_id VARCHAR DEFAULT '' NOT NULL
- ,pos_key VARCHAR DEFAULT NULL
+ ,fulfillment_url TEXT
+ ,session_id TEXT DEFAULT '' NOT NULL
+ ,pos_key TEXT DEFAULT NULL
,pos_algorithm INT NOT NULL DEFAULT (0)
,claim_token BYTEA NOT NULL CHECK (LENGTH(claim_token)=16)
,UNIQUE (merchant_serial, order_id)
@@ -360,7 +360,7 @@ CREATE TABLE IF NOT EXISTS merchant_deposits
REFERENCES merchant_contract_terms (order_serial) ON DELETE CASCADE
,deposit_timestamp INT8 NOT NULL
,coin_pub BYTEA NOT NULL CHECK (LENGTH(coin_pub)=32)
- ,exchange_url VARCHAR NOT NULL
+ ,exchange_url TEXT NOT NULL
,amount_with_fee taler_amount NOT NULL
,deposit_fee taler_amount NOT NULL
,refund_fee taler_amount NOT NULL
@@ -390,7 +390,7 @@ CREATE TABLE IF NOT EXISTS merchant_refunds
,rtransaction_id BIGINT NOT NULL
,refund_timestamp INT8 NOT NULL
,coin_pub BYTEA NOT NULL
- ,reason VARCHAR NOT NULL
+ ,reason TEXT NOT NULL
,refund_amount taler_amount NOT NULL
,UNIQUE (order_serial, coin_pub, rtransaction_id)
);
@@ -418,7 +418,7 @@ COMMENT ON TABLE merchant_refund_proofs
CREATE TABLE IF NOT EXISTS merchant_transfers
(credit_serial INT8 GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
- ,exchange_url VARCHAR NOT NULL
+ ,exchange_url TEXT NOT NULL
,wtid BYTEA CHECK (LENGTH(wtid)=32)
,credit_amount taler_amount NOT NULL
,account_serial INT8 NOT NULL
@@ -549,7 +549,7 @@ CREATE TABLE IF NOT EXISTS merchant_reward_reserve_keys
(reserve_serial BIGINT NOT NULL UNIQUE
REFERENCES merchant_reward_reserves (reserve_serial) ON DELETE CASCADE
,reserve_priv BYTEA NOT NULL UNIQUE CHECK (LENGTH(reserve_priv)=32)
- ,exchange_url VARCHAR NOT NULL
+ ,exchange_url TEXT NOT NULL
,master_pub BYTEA NOT NULL CHECK (LENGTH(master_pub)=32)
);
COMMENT ON TABLE merchant_reward_reserves
@@ -563,8 +563,8 @@ CREATE TABLE IF NOT EXISTS merchant_rewards
,reserve_serial BIGINT NOT NULL
REFERENCES merchant_reward_reserves (reserve_serial) ON DELETE CASCADE
,reward_id BYTEA NOT NULL UNIQUE CHECK (LENGTH(reward_id)=64)
- ,justification VARCHAR NOT NULL
- ,next_url VARCHAR NOT NULL
+ ,justification TEXT NOT NULL
+ ,next_url TEXT NOT NULL
,expiration INT8 NOT NULL
,amount taler_amount NOT NULL
,picked_up taler_amount NOT NULL DEFAULT (0, 0)
@@ -619,7 +619,7 @@ CREATE TABLE IF NOT EXISTS merchant_kyc
,exchange_kyc_serial INT8 NOT NULL DEFAULT(0)
,account_serial INT8 NOT NULL
REFERENCES merchant_accounts (account_serial) ON DELETE CASCADE
-,exchange_url VARCHAR NOT NULL
+,exchange_url TEXT NOT NULL
,PRIMARY KEY (account_serial,exchange_url)
);
COMMENT ON TABLE merchant_kyc
@@ -646,11 +646,11 @@ CREATE TABLE IF NOT EXISTS merchant_template
(template_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
,merchant_serial BIGINT NOT NULL
REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE
- ,template_id VARCHAR NOT NULL
- ,template_description VARCHAR NOT NULL
- ,pos_key VARCHAR DEFAULT NULL
+ ,template_id TEXT NOT NULL
+ ,template_description TEXT NOT NULL
+ ,pos_key TEXT DEFAULT NULL
,pos_algorithm INT NOT NULL DEFAULT (0)
- ,template_contract VARCHAR NOT NULL -- in JSON format
+ ,template_contract TEXT NOT NULL -- in JSON format
,UNIQUE (merchant_serial, template_id)
);
COMMENT ON TABLE merchant_template
@@ -669,12 +669,12 @@ CREATE TABLE IF NOT EXISTS merchant_webhook
(webhook_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
,merchant_serial BIGINT NOT NULL
REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE
- ,webhook_id VARCHAR NOT NULL
- ,event_type VARCHAR NOT NULL
- ,url VARCHAR NOT NULL
- ,http_method VARCHAR NOT NULL
- ,header_template VARCHAR
- ,body_template VARCHAR
+ ,webhook_id TEXT NOT NULL
+ ,event_type TEXT NOT NULL
+ ,url TEXT NOT NULL
+ ,http_method TEXT NOT NULL
+ ,header_template TEXT
+ ,body_template TEXT
,UNIQUE (merchant_serial, webhook_id)
);
COMMENT ON TABLE merchant_webhook
@@ -699,10 +699,10 @@ CREATE TABLE IF NOT EXISTS merchant_pending_webhooks
REFERENCES merchant_webhook (webhook_serial) ON DELETE CASCADE
,next_attempt INT8 NOT NULL DEFAULT(0)
,retries INT4 NOT NULL DEFAULT(0)
- ,url VARCHAR NOT NULL
- ,http_method VARCHAR NOT NULL
- ,header VARCHAR
- ,body VARCHAR
+ ,url TEXT NOT NULL
+ ,http_method TEXT NOT NULL
+ ,header TEXT
+ ,body TEXT
,UNIQUE (merchant_serial, webhook_pending_serial)
);
COMMENT ON TABLE merchant_pending_webhooks
@@ -726,10 +726,10 @@ COMMENT ON COLUMN merchant_pending_webhooks.body
CREATE TABLE IF NOT EXISTS merchant_exchange_accounts
(mea_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
,master_pub BYTEA NOT NULL CHECK (LENGTH(master_pub)=32)
- ,payto_uri VARCHAR NOT NULL
- ,conversion_url VARCHAR
- ,debit_restrictions VARCHAR NOT NULL
- ,credit_restrictions VARCHAR NOT NULL
+ ,payto_uri TEXT NOT NULL
+ ,conversion_url TEXT
+ ,debit_restrictions TEXT NOT NULL
+ ,credit_restrictions TEXT NOT NULL
,master_sig BYTEA NOT NULL CHECK (LENGTH(master_sig)=64)
);
COMMENT ON TABLE merchant_exchange_accounts
@@ -748,8 +748,8 @@ COMMENT ON COLUMN merchant_exchange_accounts.credit_restrictions
CREATE TABLE IF NOT EXISTS merchant_exchange_keys
(mek_serial BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
- ,exchange_url VARCHAR PRIMARY KEY
- ,keys_json VARCHAR NOT NULL
+ ,exchange_url TEXT PRIMARY KEY
+ ,keys_json TEXT NOT NULL
,expiration_time INT8 NOT NULL
);
COMMENT ON TABLE merchant_exchange_keys