Plume/migrations/postgres/2018-04-30-170445_timestamps/up.sql

6 lines
334 B
MySQL
Raw Permalink Normal View History

2018-04-30 19:46:27 +02:00
-- Your SQL goes here
ALTER TABLE posts ADD COLUMN creation_date TIMESTAMP NOT NULL DEFAULT now();
ALTER TABLE blogs ADD COLUMN creation_date TIMESTAMP NOT NULL DEFAULT now();
ALTER TABLE users ADD COLUMN creation_date TIMESTAMP NOT NULL DEFAULT now();
ALTER TABLE instances ADD COLUMN creation_date TIMESTAMP NOT NULL DEFAULT now();