taskcafe/migrations/0005_add-task-group-table.up.sql

8 lines
232 B
MySQL
Raw Permalink Normal View History

2020-04-10 04:40:22 +02:00
CREATE TABLE task_group (
task_group_id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
project_id uuid NOT NULL REFERENCES project(project_id),
created_at timestamptz NOT NULL,
name text NOT NULL,
position float NOT NULL
);