# HG changeset patch # User Goffi # Date 1652273273 -7200 # Node ID cfa40fa108a4c8c4db2ecb70ba66f0bf8af4d71f # Parent b544109ab4c4a2792368fd745a064d53a393a2f3 db: fix pubsub.sql syntax diff -r b544109ab4c4 -r cfa40fa108a4 db/pubsub.sql --- a/db/pubsub.sql Wed May 11 13:39:08 2022 +0200 +++ b/db/pubsub.sql Wed May 11 14:47:53 2022 +0200 @@ -65,9 +65,9 @@ subscription_depth text CHECK (subscription_depth IN (NULL, '1', 'all')), public boolean NOT NULL DEFAULT FALSE, - UNIQUE (entity_id, resource, node_id)), - UNIQUE (entity_id, ext_service, ext_node)), - ; + UNIQUE (entity_id, resource, node_id), + UNIQUE (entity_id, ext_service, ext_node) +); CREATE TABLE items ( item_id serial PRIMARY KEY,