gitdot

Mobile support to come.

..20260117042027_create_users.down.sql 20260117042027_create_users.up.sql 20260117043157_create_organizations.down.sql 20260117043157_create_organizations.up.sql 20260118222626_create_repositories.down.sql 20260118222626_create_repositories.up.sql 20260125182548_create_questions.down.sql 20260125182548_create_questions.up.sql 20260126215900_create_votes.down.sql 20260126215900_create_votes.up.sql 20260201050312_create_oauth.down.sql 20260201050312_create_oauth.up.sql 20260206190315_create_commits.down.sql 20260206190315_create_commits.up.sql 20260207120000_disable_auth_user_trigger.down.sql 20260207120000_disable_auth_user_trigger.up.sql

CREATE TABLE IF NOT EXISTS votes (
    user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    target_id UUID NOT NULL,
    value SMALLINT NOT NULL CHECK (value IN (-1, 1)),
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    PRIMARY KEY(user_id, target_id)
);

CREATE INDEX idx_votes_target_id ON votes(target_id);