Plan: 1 to add, 1 to modify, 1 to drop.

Summary by type:
  tables: 1 to add, 1 to modify, 1 to drop

Tables:
  + addresses
  - orders
  ~ users
    + city (column)

Transaction: true

DDL to be executed:
--------------------------------------------------

DROP TABLE IF EXISTS orders CASCADE;

CREATE TABLE IF NOT EXISTS addresses (
    id integer PRIMARY KEY,
    user_id integer NOT NULL REFERENCES users(id),
    street_address text NOT NULL,
    city text NOT NULL,
    state_province text,
    postal_code text,
    country text DEFAULT 'USA' NOT NULL,
    is_default boolean DEFAULT false
);

ALTER TABLE users ADD COLUMN city text NOT NULL;