Donnie Brandt donniebrandt

I hereby claim:

I am donniebrandt on github.
I am donnie (https://keybase.io/donnie) on keybase.
I have a public key whose fingerprint is 4CF9 E1FC 515C 12F1 008B 2764 60BA 5A49 B49A FAF9

To claim this, I am signing this object:

	CREATE TABLE `states` (
	`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
	`abbreviation` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
	`country` enum('United States','Canada') COLLATE utf8_unicode_ci NOT NULL,
	`region` enum('South','West','Northeast','Midwest') COLLATE utf8_unicode_ci NOT NULL,
	`division` enum('East South Central','East North Central','West South Central','West North Central','New England','Pacific','Mountain','Middle Atlantic','South Atlantic') COLLATE utf8_unicode_ci NOT NULL,
	PRIMARY KEY (`name`,`country`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

	INSERT INTO `states` (`name`, `abbreviation`, `country`, `region`, `division`)

	CREATE TABLE `options` (
	`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
	`group` enum('Timezones') COLLATE utf8_unicode_ci NOT NULL,
	`order` tinyint(4) NOT NULL DEFAULT '0',
	PRIMARY KEY (`name`,`group`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

	INSERT INTO `options` (`name`, `group`, `order`)
	VALUES
	("Africa/Abidjan", 'Timezones', 0),

	SELECT
	latitude,
	longitude
	(3959
	* ACOS(COS(RADIANS(%.6f /Lat/))
	* COS(RADIANS(latitude))
	* COS(RADIANS(longitude) - RADIANS(%.6f /Long/)) + SIN(RADIANS(%.6f /Lat/))
	* SIN(RADIANS(latitude)))) AS distance
	FROM coordinates
	WHERE latitude BETWEEN %.6f AND %.6f

	INSERT INTO `target` (`column1`, `column2`)
	SELECT `column1`, `column2` FROM `source`
	WHERE `column1` > 0;