Geodb locations: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
(Definition)
(Definition)
 
Zeile 129: Zeile 129:
  
 
</source>
 
</source>
 +
 +
[[Kategorie:Datenbank]]

Aktuelle Version vom 28. März 2008, 22:05 Uhr

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;