18 lines
435 B
MySQL
18 lines
435 B
MySQL
|
-- Add migration script here
|
||
|
|
|
||
|
|
create table if not exists items (
|
||
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
||
|
|
title varchar not null,
|
||
|
|
description varchar default null,
|
||
|
|
state integer not null,
|
||
|
|
user_id varchar not null,
|
||
|
|
project_id UUID not null,
|
||
|
|
created_at timestamp not null,
|
||
|
|
updated_at timestamp not null,
|
||
|
|
CONSTRAINT fk_project
|
||
|
|
FOREIGN KEY(project_id)
|
||
|
|
REFERENCES projects(id)
|
||
|
|
ON DELETE CASCADE
|
||
|
|
)
|
||
|
|
|