Geodb changelog: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) (→Indices) |
HeinzJ (Diskussion | Beiträge) (→Options) |
||
Zeile 121: | Zeile 121: | ||
==Options== | ==Options== | ||
− | <TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90%> | + | <TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90% {{prettytable}}> |
<TH WIDTH="1%"><B>TransactSafe</B> | <TH WIDTH="1%"><B>TransactSafe</B> | ||
<TH WIDTH="1%"><B>TableType</B> | <TH WIDTH="1%"><B>TableType</B> | ||
Zeile 147: | Zeile 147: | ||
</TR> | </TR> | ||
</TABLE> | </TABLE> | ||
− | |||
==Definition== | ==Definition== |
Version vom 8. März 2007, 22:53 Uhr
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;