Skip to content

Instantly share code, notes, and snippets.

@ivorscott

ivorscott/000001_create_products_table.up.sql

Created June 5, 2020 07:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ivorscott/d2569dede9fc5e3ea3a1fcb582f3f290 to your computer and use it in GitHub Desktop.
Save ivorscott/d2569dede9fc5e3ea3a1fcb582f3f290 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
000001_create_products_table.up.sql
-- 000001_create_products_table.up.sql
CREATE TABLE products (
id UUID not null unique,
name varchar(100) not null,
price real not null,
description varchar(100) not null,
created timestamp without time zone default (now() at time zone 'utc')
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment