Sample schema for update mutations

hge-blog-update-mutations-schema.sql

CREATE TABLE author (
  id INTEGER PRIMARY KEY,
  name TEXT
);

CREATE TABLE article (
  id INTEGER PRIMARY KEY,
  title TEXT,
  content TEXT,
  author_id INTEGER,
  is_published BOOLEAN DEFAULT FALSE,
  published_on TIMESTAMP DEFAULT NOW(),
  likes INTEGER DEFAULT 0,
  
  CONSTRAINT author_id_fkey FOREIGN KEY (author_id)
    REFERENCES author (id)
);