From c1f61c458e0e97586796a3acdbd21aedf8b2e8ad Mon Sep 17 00:00:00 2001 From: Santo Cariotti Date: Mon, 3 Oct 2022 20:24:38 +0200 Subject: Likes model and them to a model --- migrations/20221003064044_add-likes.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 migrations/20221003064044_add-likes.sql (limited to 'migrations') diff --git a/migrations/20221003064044_add-likes.sql b/migrations/20221003064044_add-likes.sql new file mode 100644 index 0000000..c94d488 --- /dev/null +++ b/migrations/20221003064044_add-likes.sql @@ -0,0 +1,6 @@ +CREATE TABLE likes ( + id SERIAL PRIMARY KEY, + user_id INTEGER REFERENCES users(id) ON DELETE SET NULL, + model_id INTEGER REFERENCES models(id) ON DELETE SET NULL, + created TIMESTAMP NOT NULL +); -- cgit v1.2.3-71-g8e6c