Geodb locations: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
 
(Definition)
Zeile 120: Zeile 120:
 
==Definition==
 
==Definition==
  
<code sql>
+
<source lang="mysql">
 
   CREATE TABLE `geodb_locations` (
 
   CREATE TABLE `geodb_locations` (
 
   `loc_id` int(11) NOT NULL,
 
   `loc_id` int(11) NOT NULL,
Zeile 128: Zeile 128:
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
</code>
+
</source>

Version vom 4. November 2007, 16:01 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;