CREATE TABLE users (
name varchar(32) NOT NULL PRIMARY KEY, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE keys (
user_name varchar(32) NOT NULL REFERENCES users (name) ON DELETE no action ON UPDATE no action, key varchar(1024) NOT NULL UNIQUE, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (user_name, key)
);
CREATE TABLE repositories (
name varchar(32) NOT NULL PRIMARY KEY, user_name varchar(32) NOT NULL REFERENCES users (name) ON DELETE no action ON UPDATE no action, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
);