Skip to content

Instantly share code, notes, and snippets.

@d6rkaiz d6rkaiz/gist:873974
Created Mar 17, 2011

Embed
What would you like to do?
SHOW CREATE TABLE location;
| location | CREATE TABLE `location` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`location_name` varchar(255) DEFAULT NULL,
`country_id` int(11) DEFAULT NULL,
`latitude` double NOT NULL DEFAULT '0',
`longitude` double NOT NULL DEFAULT '0',
`location_visible` tinyint(4) NOT NULL DEFAULT '1',
`location_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3877 DEFAULT CHARSET=utf8 |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.