Skip to content

Instantly share code, notes, and snippets.

@shark-h

shark-h/create-table.sql

Created March 4, 2019 09:12
Show Gist options
  • Save shark-h/767708108d7e4e5f8a35009adeb5794e to your computer and use it in GitHub Desktop.
Save shark-h/767708108d7e4e5f8a35009adeb5794e to your computer and use it in GitHub Desktop.
Download ZIP
creating tables for voting app
Raw
create-table.sql
CREATE TABLE "public"."loved_language" (
"name" text NOT NULL,
"user_id" text NOT NULL,
CONSTRAINT loved_language_pkey PRIMARY KEY (name, user_id),
CONSTRAINT loved_language_programming_language_fky FOREIGN KEY (name) REFERENCES programming_language(name),
)
@cad0p
Copy link

cad0p commented Apr 28, 2020

hi, just wanted to say that i've been trying to run this and I found out that the comma on line 5 https://gist.github.com/shark-h/767708108d7e4e5f8a35009adeb5794e#file-create-table-sql-L5

needs to be deleted in order for the query to run!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment