mirror of
https://github.com/christianselig/apollo-backend
synced 2024-11-23 20:27:42 +00:00
7 lines
349 B
SQL
7 lines
349 B
SQL
CREATE TABLE IF NOT EXISTS devices_accounts (
|
|
id SERIAL PRIMARY KEY,
|
|
account_id integer,
|
|
device_id integer
|
|
);
|
|
CREATE UNIQUE INDEX IF NOT EXISTS devices_accounts_pkey ON devices_accounts(id int4_ops);
|
|
CREATE UNIQUE INDEX IF NOT EXISTS devices_accounts_account_id_device_id_idx ON devices_accounts(account_id int4_ops,device_id int4_ops);
|