Geodb locations: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) |
HeinzJ (Diskussion | Beiträge) (→Definition) |
||
(Eine dazwischenliegende Version desselben Benutzers wird nicht angezeigt) | |||
Zeile 120: | Zeile 120: | ||
==Definition== | ==Definition== | ||
− | < | + | <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; | ||
− | </ | + | </source> |
+ | |||
+ | [[Kategorie:Datenbank]] |
Aktuelle Version vom 28. März 2008, 23:05 Uhr
Inhaltsverzeichnis
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;