yat-server/migrations/2021-10-07-114229_create_lists/up.sql

8 lines
228 B
MySQL
Raw Permalink Normal View History

-- Your SQL goes here
create table if not exists lists (
id integer primary key,
user_id integer not null,
name text not null,
description text,
foreign key (user_id) references users(id) on delete cascade
);