30 lines
886 B
SQL
30 lines
886 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)
|
|
);
|
|
|
|
insert into users (id, email) values ('9bc7c91b-a990-4bcf-ad00-625d8d4ea2e9', 'user@scribouilli.test');
|