Created
May 20, 2016 14:17
-
-
Save dan81989/d765aeb831a5165b1bc74cb7607c3afd to your computer and use it in GitHub Desktop.
From Troy Thibodeaux's SQL tutorial: https://github.com/tthibo/SQL-Tutorial/blob/master/tutorial_files/part3.textile
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE "contributors" ( | |
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, | |
"last_name" VARCHAR, | |
"first_name" VARCHAR, | |
"middle_name" VARCHAR, | |
"street_1" VARCHAR, | |
"street_2" VARCHAR, | |
"city" VARCHAR, | |
"state" VARCHAR, | |
"zip" VARCHAR, | |
"amount" INTEGER, | |
"date" DATETIME, | |
"candidate_id" INTEGER NOT NULL, | |
FOREIGN KEY(candidate_id) REFERENCES candidates(id) | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment