15 lines
281 B
MySQL
15 lines
281 B
MySQL
|
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
|
||
|
|
);
|