Geodb locations

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Version vom 28. März 2008, 22:05 Uhr von HeinzJ (Diskussion | Beiträge) (Definition)

(Unterschied) ← Nächstältere Version | Aktuelle Version ansehen (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche

Fields

PKName Data type Size Precision Values Default Auto Increment Binary Not null Unsigned Zero Fill Unique
Yes.gif loc_id INTEGER 11 0 Yes.gif
loc_type INTEGER 11 0 Yes.gif

Indices

Name Fields Unique Collation Full Text
PRIMARY loc_id Yes.gif 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
Yes.gif 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;