diff options
author | Jonathan Buchanan <jonathan.russ.buchanan@gmail.com> | 2020-06-09 19:49:10 -0400 |
---|---|---|
committer | Jonathan Buchanan <jonathan.russ.buchanan@gmail.com> | 2020-06-09 19:49:10 -0400 |
commit | 7a9c8b206332c3500ffd733b79aa56b0ea01338a (patch) | |
tree | e0abca170eab3980d3beadc2892501c8c1242ca0 /src/backenddb/merchant-0001.sql | |
parent | 83bd17148ee72fd1110b192cbefee18b15a22f56 (diff) | |
download | merchant-7a9c8b206332c3500ffd733b79aa56b0ea01338a.tar.gz merchant-7a9c8b206332c3500ffd733b79aa56b0ea01338a.tar.bz2 merchant-7a9c8b206332c3500ffd733b79aa56b0ea01338a.zip |
created lookup_tips method for backenddb
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
-rw-r--r-- | src/backenddb/merchant-0001.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql index 34e2cb4b..b89f7792 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -462,7 +462,7 @@ COMMENT ON TABLE merchant_tip_reserves CREATE TABLE IF NOT EXISTS merchant_tips (tip_serial BIGSERIAL PRIMARY KEY - ,reserve_serial BIGINT NOT NULL UNIQUE + ,reserve_serial BIGINT NOT NULL REFERENCES merchant_tip_reserves (reserve_serial) ON DELETE CASCADE ,tip_id BYTEA NOT NULL UNIQUE CHECK (LENGTH(tip_id)=64) ,justification VARCHAR NOT NULL |