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');