diff options
| author | Jonathan Buchanan <jonathan.russ.buchanan@gmail.com> | 2020-05-27 18:26:44 -0400 |
|---|---|---|
| committer | Jonathan Buchanan <jonathan.russ.buchanan@gmail.com> | 2020-05-27 18:26:44 -0400 |
| commit | 6b908a8147b98312bc447a6c0bf2705789d197cb (patch) | |
| tree | 2debbe30b6e1e1505bb23ad2d364c15bcbdcdec8 /src/backenddb/merchant-0001.sql | |
| parent | 8fdaf760379e3c3edae52ee3552e625482e02ad0 (diff) | |
| download | merchant-6b908a8147b98312bc447a6c0bf2705789d197cb.tar.gz merchant-6b908a8147b98312bc447a6c0bf2705789d197cb.tar.bz2 merchant-6b908a8147b98312bc447a6c0bf2705789d197cb.zip | |
fixed inventory locking, test code for transfer lookups
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
| -rw-r--r-- | src/backenddb/merchant-0001.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql index 1aa54253..beef2cd8 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -163,9 +163,9 @@ COMMENT ON COLUMN merchant_inventory.next_restock CREATE TABLE IF NOT EXISTS merchant_inventory_locks (product_serial BIGINT NOT NULL REFERENCES merchant_inventory (product_serial) -- NO "ON DELETE CASCADE": locks prevent deletion! - ,lock_uuid BYTEA NOT NULL CHECK (LENGTH(lock_uuid)=32) + ,lock_uuid BYTEA NOT NULL CHECK (LENGTH(lock_uuid)=16) ,total_locked BIGINT NOT NULL - ,expiration TIMESTAMP NOT NULL + ,expiration INT8 NOT NULL ); CREATE INDEX IF NOT EXISTS merchant_inventory_locks_by_expiration ON merchant_inventory_locks |