mirror of
https://github.com/christianselig/apollo-backend
synced 2024-11-23 20:27:42 +00:00
9 lines
317 B
MySQL
9 lines
317 B
MySQL
|
CREATE TABLE IF NOT EXISTS devices (
|
||
|
|
id SERIAL PRIMARY KEY,
|
||
|
|
apns_token character(100) UNIQUE,
|
||
|
|
sandbox boolean,
|
||
|
|
last_pinged_at integer
|
||
|
|
);
|
||
|
|
CREATE UNIQUE INDEX IF NOT EXISTS devices_pkey ON devices(id int4_ops);
|
||
|
|
CREATE UNIQUE INDEX IF NOT EXISTS devices_apns_token_key ON devices(apns_token bpchar_ops);
|