Skip to content

Instantly share code, notes, and snippets.

@Breefield

Breefield/create-table.sql

Created November 16, 2020 21:42
Show Gist options
  • Save Breefield/8f13a3ebac988384b73c2e822d655057 to your computer and use it in GitHub Desktop.
Save Breefield/8f13a3ebac988384b73c2e822d655057 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create-table.sql
CREATE TABLE inventory (
id SERIAL PRIMARY KEY,
item VARCHAR(255) NOT NULL,
price INTEGER NOT NULL,
created_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment