Geodb changelog: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) |
HeinzJ (Diskussion | Beiträge) (→Fields) |
||
Zeile 1: | Zeile 1: | ||
==Fields== | ==Fields== | ||
− | < | + | <TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90%> |
− | < | + | <TH WIDTH="1%"><B>PK</B> |
− | + | ||
− | </ | + | <TH WIDTH="1%"><B>Name</B> |
− | < | + | <TH WIDTH="1%"><B>Data type</B> |
− | < | + | <TH WIDTH="1%"><B>Size</B> |
− | < | + | <TH WIDTH="1%"><B>Precision</B> |
− | < | + | <TH WIDTH="1%"><B>Values</B> |
− | < | + | <TH WIDTH="1%"><B>Default</B> |
− | < | + | <TH WIDTH="1%"><B>Auto Increment</B> |
− | < | + | <TH WIDTH="1%"><B>Binary</B> |
− | + | <TH WIDTH="1%"><B>Not null</B> | |
− | </ | + | <TH WIDTH="1%"><B>Unsigned</B> |
− | < | + | <TH WIDTH="1%"><B>Zero Fill</B> |
− | < | + | <TH WIDTH="1%"><B>Unique</B> |
− | < | + | <TR> |
− | < | + | <TD ALIGN="middle">[[Image:Yes.gif]]</TD> |
− | < | + | <TD>id</TD> |
− | < | + | <TD>INTEGER</TD> |
− | < | + | <TD>11</TD> |
− | < | + | <TD>0</TD> |
− | + | <TD></TD> | |
− | + | ||
− | < | + | <TD></TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle">[[Image:Yes.gif]]</TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | </ | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | </TR> |
− | < | + | <TR> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD>datum</TD> |
− | < | + | <TD>DATE</TD> |
− | + | <TD>0</TD> | |
+ | <TD>0</TD> | ||
− | < | + | <TD></TD> |
− | < | + | <TD></TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle">[[Image:Yes.gif]]</TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | </ | + | <TD ALIGN="middle"> </TD> |
− | < | + | </TR> |
− | < | + | <TR> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD>beschreibung</TD> |
− | + | <TD>TEXT</TD> | |
− | < | + | <TD>0</TD> |
− | < | + | <TD>0</TD> |
− | < | + | <TD></TD> |
− | < | + | <TD></TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle">[[Image:Yes.gif]]</TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | </ | + | <TD ALIGN="middle"> </TD> |
− | < | + | </TR> |
− | < | + | <TR> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD>autor</TD> |
− | + | <TD>VARCHAR</TD> | |
− | < | + | <TD>50</TD> |
− | < | + | <TD>0</TD> |
− | < | + | <TD></TD> |
− | < | + | <TD></TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle">[[Image:Yes.gif]]</TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | </ | + | <TD ALIGN="middle"> </TD> |
− | < | + | </TR> |
− | < | + | <TR> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | + | <TD>version</TD> | |
− | < | + | <TD>VARCHAR</TD> |
− | < | + | <TD>8</TD> |
− | < | + | <TD>0</TD> |
− | < | + | <TD></TD> |
− | < | + | <TD></TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | < | + | <TD ALIGN="middle"> </TD> |
− | </ | + | <TD ALIGN="middle"> </TD> |
− | </table> | + | </TR> |
+ | </TABLE> | ||
+ | |||
+ | |||
+ | ==Indices== | ||
+ | <TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90%> | ||
+ | <TH WIDTH="1%"><B>Name</B> | ||
+ | <TH WIDTH="1%"><B>Fields</B> | ||
+ | <TH WIDTH="1%"><B>Unique</B> | ||
+ | <TH WIDTH="1%"><B>Collation</B> | ||
+ | <TH WIDTH="1%"><B>Full Text</B> | ||
+ | <TR> | ||
+ | <TD>PRIMARY</TD> | ||
+ | |||
+ | <TD>id</TD> | ||
+ | <TD ALIGN="middle">[[Image:Yes.gif]]</TD> | ||
+ | <TD>Ascending</TD> | ||
+ | <TD ALIGN="middle"> </TD> | ||
+ | </TR> | ||
+ | </TABLE> | ||
+ | |||
+ | |||
+ | ==Foreign Keys== | ||
+ | There are no foreign keys for table geodb_changelog | ||
+ | ==Triggers== | ||
+ | There are no triggers for table geodb_changelog | ||
+ | |||
+ | ==Options== | ||
+ | <TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90%> | ||
+ | <TH WIDTH="1%"><B>TransactSafe</B> | ||
+ | <TH WIDTH="1%"><B>TableType</B> | ||
+ | <TH WIDTH="1%"><B>Row Format</B> | ||
+ | <TH WIDTH="1%"><B>Check Sum</B> | ||
+ | <TH WIDTH="1%"><B>Delay Key Write</B> | ||
+ | <TH WIDTH="1%"><B>Pack Keys</B> | ||
+ | <TH WIDTH="1%"><B>Temporary</B> | ||
+ | |||
+ | <TH WIDTH="1%"><B>Min Rows</B> | ||
+ | <TH WIDTH="1%"><B>Max Rows</B> | ||
+ | <TH WIDTH="1%"><B>Union</B> | ||
+ | <TR> | ||
+ | <TD ALIGN="middle">[[Image:Yes.gif]]</TD> | ||
+ | <TD>InnoDB</TD> | ||
+ | <TD>Ascending</TD> | ||
+ | <TD ALIGN="middle"> </TD> | ||
+ | <TD ALIGN="middle"> </TD> | ||
+ | <TD ALIGN="middle"> </TD> | ||
+ | <TD ALIGN="middle"> </TD> | ||
+ | <TD>0</TD> | ||
+ | |||
+ | <TD>0</TD> | ||
+ | <TD></TD> | ||
+ | </TR> | ||
+ | </TABLE> | ||
+ | |||
+ | |||
+ | ==Definition== | ||
+ | |||
+ | <code sql> | ||
+ | <b>CREATE</b> TABLE</b> </b>`geodb_changelog` ( | ||
+ | `id` <b>int</b>(11) <b>NOT</b> NULL</b>, | ||
+ | `datum` <b>date</b> NOT</b> NULL</b>, | ||
+ | `beschreibung` <b>text</b> NOT</b> NULL</b>, | ||
+ | `autor` <b>varchar</b>(50) <b>NOT</b> NULL</b>, | ||
+ | `<b>version</b>` <b>varchar</b>(8) <b>default</b> NULL</b>, | ||
+ | <b>PRIMARY</b> KEY</b> </b>(`id`) | ||
+ | ) <b>ENGINE</b>=<b>InnoDB</b> DEFAULT</b> CHARSET</b>=utf8; | ||
+ | </code> |
Version vom 8. März 2007, 21:52 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;