-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstates.sql
54 lines (54 loc) · 3.66 KB
/
states.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
CREATE TABLE IF NOT EXISTS states (id INTEGER PRIMARY KEY AUTOINCREMENT, state VARCHAR NOT NULL UNIQUE, postal_code VARCHAR NOT NULL UNIQUE);
INSERT INTO states (state, postal_code) VALUES ("Alabama", "AL");
INSERT INTO states (state, postal_code) VALUES ("Alaska", "AK");
INSERT INTO states (state, postal_code) VALUES ("Arizona", "AZ");
INSERT INTO states (state, postal_code) VALUES ("Arkansas", "AR");
INSERT INTO states (state, postal_code) VALUES ("California", "CA");
INSERT INTO states (state, postal_code) VALUES ("Northern California", "nCA");
INSERT INTO states (state, postal_code) VALUES ("Southern California", "sCA");
INSERT INTO states (state, postal_code) VALUES ("Colorado", "CO");
INSERT INTO states (state, postal_code) VALUES ("Connecticut", "CT");
INSERT INTO states (state, postal_code) VALUES ("Delaware", "DE");
INSERT INTO states (state, postal_code) VALUES ("District of Columbia", "DC");
INSERT INTO states (state, postal_code) VALUES ("Florida", "FL");
INSERT INTO states (state, postal_code) VALUES ("Georgia", "GA");
INSERT INTO states (state, postal_code) VALUES ("Hawaii", "HI");
INSERT INTO states (state, postal_code) VALUES ("Idaho", "ID");
INSERT INTO states (state, postal_code) VALUES ("Illinois", "IL");
INSERT INTO states (state, postal_code) VALUES ("Indiana", "IN");
INSERT INTO states (state, postal_code) VALUES ("Iowa", "IA");
INSERT INTO states (state, postal_code) VALUES ("Kansas", "KS");
INSERT INTO states (state, postal_code) VALUES ("Kentucky", "KY");
INSERT INTO states (state, postal_code) VALUES ("Louisiana", "LA");
INSERT INTO states (state, postal_code) VALUES ("Maine", "ME");
INSERT INTO states (state, postal_code) VALUES ("Maryland", "MD");
INSERT INTO states (state, postal_code) VALUES ("Massachusetts", "MA");
INSERT INTO states (state, postal_code) VALUES ("Michigan", "MI");
INSERT INTO states (state, postal_code) VALUES ("Minnesota", "MN");
INSERT INTO states (state, postal_code) VALUES ("Mississippi", "MS");
INSERT INTO states (state, postal_code) VALUES ("Missouri", "MO");
INSERT INTO states (state, postal_code) VALUES ("Montana", "MT");
INSERT INTO states (state, postal_code) VALUES ("Nebraska", "NE");
INSERT INTO states (state, postal_code) VALUES ("Nevada", "NV");
INSERT INTO states (state, postal_code) VALUES ("New Hampshire", "NH");
INSERT INTO states (state, postal_code) VALUES ("New Jersey", "NJ");
INSERT INTO states (state, postal_code) VALUES ("New Mexico", "NM");
INSERT INTO states (state, postal_code) VALUES ("New York", "NY");
INSERT INTO states (state, postal_code) VALUES ("North Carolina", "NC");
INSERT INTO states (state, postal_code) VALUES ("North Dakota", "ND");
INSERT INTO states (state, postal_code) VALUES ("Ohio", "OH");
INSERT INTO states (state, postal_code) VALUES ("Oklahoma", "OK");
INSERT INTO states (state, postal_code) VALUES ("Oregon", "OR");
INSERT INTO states (state, postal_code) VALUES ("Pennsylvania", "PA");
INSERT INTO states (state, postal_code) VALUES ("Rhode Island", "RI");
INSERT INTO states (state, postal_code) VALUES ("South Carolina", "SC");
INSERT INTO states (state, postal_code) VALUES ("South Dakota", "SD");
INSERT INTO states (state, postal_code) VALUES ("Tennessee", "TN");
INSERT INTO states (state, postal_code) VALUES ("Texas", "TX");
INSERT INTO states (state, postal_code) VALUES ("Utah", "UT");
INSERT INTO states (state, postal_code) VALUES ("Vermont", "VT");
INSERT INTO states (state, postal_code) VALUES ("Virginia", "VA");
INSERT INTO states (state, postal_code) VALUES ("Washington", "WA");
INSERT INTO states (state, postal_code) VALUES ("West Virginia", "WV");
INSERT INTO states (state, postal_code) VALUES ("Wisconsin", "WI");
INSERT INTO states (state, postal_code) VALUES ("Wyoming", "WY");