Geodb locations

Fields

PK	Name	Data type	Size	Precision	Values	Default	Auto Increment	Binary	Not null	Unsigned	Zero Fill	Unique
	loc_id	INTEGER	11	0
	loc_type	INTEGER	11	0

Indices

Name	Fields	Unique	Collation	Full Text
PRIMARY	loc_id		Ascending
loc_type_idx	loc_type		Ascending

Foreign Keys

There are no foreign keys for table geodb_locations

Triggers

There are no triggers for table geodb_locations

Options

TransactSafe	TableType	Row Format	Check Sum	Delay Key Write	Pack Keys	Temporary	Min Rows	Max Rows	Union
	InnoDB	Ascending					0	0

Definition

  CREATE TABLE `geodb_locations` (
  `loc_id` int(11) NOT NULL,
  `loc_type` int(11) NOT NULL,
  PRIMARY KEY  (`loc_id`),
  KEY `loc_type_idx` (`loc_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;