query-orchestration/internal/database/migrations_archive/00000000000003_clients.up.sql

CREATE TABLE clients (
    clientId varchar(255) primary key,
    name TEXT not null,
    UNIQUE (name)
);

CREATE TABLE clientCanSync (
    syncId uuid primary key DEFAULT uuid_generate_v7(),
    clientId varchar(255) not null,
    canSync boolean not null,
    foreign key (clientId) references clients(clientId)
);