-
Notifications
You must be signed in to change notification settings - Fork 3
Geodb_changelog
Die Tabelle '''geodb changelog''' hat mit der Datenbank an sich eigentlich nichts zu tun. Die Tabelle enthält Kommentare zu größeren Änderungen an der Datenbank.
==Fields== <TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90% {{prettytable}}> <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> </TR> </TABLE>
==Indices== <TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90% {{prettytable}}> <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% {{prettytable}}> <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==
<source lang="mysql">
CREATE TABLE geodb_changelog (
id int(11) NOT NULL,
datum date NOT NULL,
beschreibung text NOT NULL,
autor varchar(50) NOT NULL,
version varchar(8) default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
</source>
==Änderungen== {{:Änderungen}}