SQL schema diff tool

-- New table: comments
-- Generated by dbdiagramr (https://www.dbdiagramr.space)
-- PostgreSQL DDL exported from the interactive ER diagram below.

CREATE TABLE comments (
  id uuid PRIMARY KEY,
  post_id uuid,
  body text NOT NULL
);

ALTER TABLE comments ADD CONSTRAINT fk_comments_post_id FOREIGN KEY (post_id) REFERENCES posts (id);
-- Changes to users
ALTER TABLE users ADD COLUMN created_at timestamptz NOT NULL DEFAULT now();
ALTER TABLE users DROP COLUMN name;
ALTER TABLE users ALTER COLUMN email TYPE varchar(320) USING email::varchar(320);
-- Changes to posts
ALTER TABLE posts ADD COLUMN published boolean DEFAULT false;