28 lines
781 B
SQL
28 lines
781 B
SQL
create table users (
|
|
id text primary key,
|
|
email text not null unique
|
|
);
|
|
|
|
create table websites (
|
|
name text primary key,
|
|
is_ready integer not null default 0
|
|
);
|
|
|
|
create table builds (
|
|
id integer primary key autoincrement,
|
|
website_name text not null,
|
|
-- waiting | in_progress | success | error
|
|
build_status text not null,
|
|
|
|
foreign key(website_name) references websites(name) on update cascade on delete cascade
|
|
);
|
|
|
|
create table website_members (
|
|
website_name text not null,
|
|
user_id text not null,
|
|
is_admin integer not null default 0,
|
|
|
|
foreign key(website_name) references websites(name) on update cascade on delete cascade,
|
|
foreign key(user_id) references users(id) on delete cascade,
|
|
primary key (website_name, user_id)
|
|
);
|