SHOW CREATE TABLE location;
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| location | CREATE TABLE `location` (
  `eid` int(10) unsigned NOT NULL default '0',
  `lid` int(10) unsigned NOT NULL default '0',
  `type` varchar(6) NOT NULL default '',
  `name` varchar(255) default NULL,
  `street` varchar(255) default NULL,
  `additional` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `province` varchar(16) default NULL,
  `postal_code` varchar(16) default NULL,
  `country` char(2) default NULL,
  `latitude` decimal(10,6) default NULL,
  `longitude` decimal(10,6) default NULL,
  `source` tinyint(4) default '0',
  `is_primary` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`lid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)