15 lines
No EOL
281 B
SQL
15 lines
No EOL
281 B
SQL
CREATE TABLE users (
|
|
user_id TEXT PRIMARY KEY,
|
|
name TEXT UNIQUE
|
|
);
|
|
|
|
CREATE TABLE user_keys (
|
|
user_key TEXT PRIMARY KEY,
|
|
user_id TEXT NOT NULL,
|
|
FOREIGN KEY (user_id) REFERENCES users(user_id)
|
|
);
|
|
|
|
CREATE TABLE repo (
|
|
repo_id TEXT PRIMARY KEY,
|
|
repo_name TEXT NOT NULL
|
|
); |