Geodb changelog
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Inhaltsverzeichnis
Fields
PK | Name | Data type | Size | Precision | Values | Default | Auto Increment | Binary | Not null | Unsigned | Zero Fill | Unique |
---|---|---|---|---|---|---|---|---|---|---|---|---|
id | INTEGER | 11 | 0 | |||||||||
datum | DATE | 0 | 0 | |||||||||
beschreibung | TEXT | 0 | 0 | |||||||||
autor | VARCHAR | 50 | 0 | |||||||||
version | VARCHAR | 8 | 0 |
Indices
Name | Fields | Unique | Collation | Full Text |
---|---|---|---|---|
PRIMARY | id | Ascending |
Foreign Keys
There are no foreign keys for table geodb_changelog
Triggers
There are no triggers for table geodb_changelog
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</b> </b>`geodb_changelog` (
`id` int(11) NOT NULL</b>, `datum` date NOT</b> NULL</b>, `beschreibung` text NOT</b> NULL</b>, `autor` varchar(50) NOT NULL</b>, `version` varchar(8) default NULL</b>, PRIMARY KEY</b> </b>(`id`)
) ENGINE=InnoDB DEFAULT</b> CHARSET</b>=utf8;