ref: df4ccb956a6718407ddb1592677bebff36b83994
db/migrations/20240529_users.sql
1 2 3 4 |
create table users(id text primary key, matrix_handle text, name text); create type seat as enum('back', 'window', 'front', 'driver', 'pilot', 'garage'); create table subscriptions(id text primary key, subscribed_user text references users(id), valid_since timestamp with time zone, validity integer, plan seat, signature bytea, creator text references users(id)); create table keys(seed bytea) |