2023-09-11 20:12:49 +02:00
|
|
|
-- Add migration script here
|
2023-09-13 00:44:59 +02:00
|
|
|
CREATE TABLE "trip_todos" (
|
|
|
|
|
id VARCHAR(36) NOT NULL,
|
|
|
|
|
trip_id VARCHAR(36) NOT NULL,
|
|
|
|
|
description TEXT NOT NULL,
|
|
|
|
|
done BOOLEAN NOT NULL,
|
|
|
|
|
PRIMARY KEY (id),
|
|
|
|
|
FOREIGN KEY(trip_id) REFERENCES "trips" (id)
|
|
|
|
|
)
|
