1# SQLiteManager Dump
2# Version: 1.2.4
3# http://www.sqlitemanager.org/
4#
5# Host: test.glocalfocal.com
6# Generation Time: Thursday 21st 2013f November 2013 03:17 pm
7# SQLite Version: 2.8.17
8# PHP Version: 5.3.27
9# Database: test.sqlite
10# --------------------------------------------------------
11
12#
13# Table structure for table: states
14#
15CREATE TABLE states ( state_id int UNIQUE PRIMARY KEY, state char(32) NOT NULL, state_abbr char(8) DEFAULT NULL, is_state int NOT NULL);
16
17#
18# Dumping data for table: states
19#
20INSERT INTO 'states' VALUES ('1', 'Alabama', 'AL', '1');
21INSERT INTO 'states' VALUES ('2', 'Alaska', 'AK', '1');
22INSERT INTO 'states' VALUES ('3', 'Arizona', 'AZ', '1');
23INSERT INTO 'states' VALUES ('4', 'Arkansas', 'AR', '1');
24INSERT INTO 'states' VALUES ('5', 'California', 'CA', '1');
25INSERT INTO 'states' VALUES ('6', 'Colorado', 'CO', '1');
26INSERT INTO 'states' VALUES ('7', 'Connecticut', 'CT', '1');
27INSERT INTO 'states' VALUES ('8', 'Delaware', 'DE', '1');
28INSERT INTO 'states' VALUES ('9', 'District of Columbia', 'DC', '1');
29INSERT INTO 'states' VALUES ('10', 'Florida', 'FL', '1');
30INSERT INTO 'states' VALUES ('11', 'Georgia', 'GA', '1');
31INSERT INTO 'states' VALUES ('12', 'Hawaii', 'HI', '1');
32INSERT INTO 'states' VALUES ('13', 'Idaho', 'ID', '1');
33INSERT INTO 'states' VALUES ('14', 'Illinois', 'IL', '1');
34INSERT INTO 'states' VALUES ('15', 'Indiana', 'IN', '1');
35INSERT INTO 'states' VALUES ('16', 'Iowa', 'IA', '1');
36INSERT INTO 'states' VALUES ('17', 'Kansas', 'KS', '1');
37INSERT INTO 'states' VALUES ('18', 'Kentucky', 'KY', '1');
38INSERT INTO 'states' VALUES ('19', 'Louisiana', 'LA', '1');
39INSERT INTO 'states' VALUES ('20', 'Maine', 'ME', '1');
40INSERT INTO 'states' VALUES ('21', 'Maryland', 'MD', '1');
41INSERT INTO 'states' VALUES ('22', 'Massachusetts', 'MA', '1');
42INSERT INTO 'states' VALUES ('23', 'Michigan', 'MI', '1');
43INSERT INTO 'states' VALUES ('24', 'Minnesota', 'MN', '1');
44INSERT INTO 'states' VALUES ('25', 'Mississippi', 'MS', '1');
45INSERT INTO 'states' VALUES ('26', 'Missouri', 'MO', '1');
46INSERT INTO 'states' VALUES ('27', 'Montana', 'MT', '1');
47INSERT INTO 'states' VALUES ('28', 'Nebraska', 'NE', '1');
48INSERT INTO 'states' VALUES ('29', 'Nevada', 'NV', '1');
49INSERT INTO 'states' VALUES ('30', 'New Hampshire', 'NH', '1');
50INSERT INTO 'states' VALUES ('31', 'New Jersey', 'NJ', '1');
51INSERT INTO 'states' VALUES ('32', 'New Mexico', 'NM', '1');
52INSERT INTO 'states' VALUES ('33', 'New York', 'NY', '1');
53INSERT INTO 'states' VALUES ('34', 'North Carolina', 'NC', '1');
54INSERT INTO 'states' VALUES ('35', 'North Dakota', 'ND', '1');
55INSERT INTO 'states' VALUES ('36', 'Ohio', 'OH', '1');
56INSERT INTO 'states' VALUES ('37', 'Oklahoma', 'OK', '1');
57INSERT INTO 'states' VALUES ('38', 'Oregon', 'OR', '1');
58INSERT INTO 'states' VALUES ('39', 'Pennsylvania', 'PA', '1');
59INSERT INTO 'states' VALUES ('40', 'Rhode Island', 'RI', '1');
60INSERT INTO 'states' VALUES ('41', 'South Carolina', 'SC', '1');
61INSERT INTO 'states' VALUES ('42', 'South Dakota', 'SD', '1');
62INSERT INTO 'states' VALUES ('43', 'Tennessee', 'TN', '1');
63INSERT INTO 'states' VALUES ('44', 'Texas', 'TX', '1');
64INSERT INTO 'states' VALUES ('45', 'Utah', 'UT', '1');
65INSERT INTO 'states' VALUES ('46', 'Vermont', 'VT', '1');
66INSERT INTO 'states' VALUES ('47', 'Virginia', 'VA', '1');
67INSERT INTO 'states' VALUES ('48', 'Washington', 'WA', '1');
68INSERT INTO 'states' VALUES ('49', 'West Virginia', 'WV', '1');
69INSERT INTO 'states' VALUES ('50', 'Wisconsin', 'WI', '1');
70INSERT INTO 'states' VALUES ('51', 'Wyoming', 'WY', '1');
71INSERT INTO 'states' VALUES ('52', 'Puerto Rico', NULL, '0');
72INSERT INTO 'states' VALUES ('53', 'Virgin Islands', NULL, '0');
73INSERT INTO 'states' VALUES ('54', 'Guam', NULL, '0');
74INSERT INTO 'states' VALUES ('55', 'American Samoa', NULL, '0');
75INSERT INTO 'states' VALUES ('56', 'Northern Marianas', NULL, '0');
76INSERT INTO 'states' VALUES ('57', 'United States', 'US', '0');