Geodb changelog: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
 
(Fields)
Zeile 1: Zeile 1:
 
==Fields==
 
==Fields==
<table class="dtArg" cellspacing="0" width="90%">
+
<TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90%>
<tr><th width="1%"><b>PK</b>
+
<TH WIDTH="1%"><B>PK</B>
</th><th width="1%"><b>Name</b>
+
  
</th><th width="1%"><b>Data type</b>
+
<TH WIDTH="1%"><B>Name</B>
</th><th width="1%"><b>Size</b>
+
<TH WIDTH="1%"><B>Data type</B>
</th><th width="1%"><b>Precision</b>
+
<TH WIDTH="1%"><B>Size</B>
</th><th width="1%"><b>Values</b>
+
<TH WIDTH="1%"><B>Precision</B>
</th><th width="1%"><b>Default</b>
+
<TH WIDTH="1%"><B>Values</B>
</th><th width="1%"><b>Auto Increment</b>
+
<TH WIDTH="1%"><B>Default</B>
</th><th width="1%"><b>Binary</b>
+
<TH WIDTH="1%"><B>Auto Increment</B>
</th><th width="1%"><b>Not null</b>
+
<TH WIDTH="1%"><B>Binary</B>
</th><th width="1%"><b>Unsigned</b>
+
<TH WIDTH="1%"><B>Not null</B>
  
</th><th width="1%"><b>Zero Fill</b>
+
<TH WIDTH="1%"><B>Unsigned</B>
</th><th width="1%"><b>Unique</b>
+
<TH WIDTH="1%"><B>Zero Fill</B>
</th></tr><tr>
+
<TH WIDTH="1%"><B>Unique</B>
<td align="center">[[Image:Yes.gif]]</td>
+
<TR>
<td>id</td>
+
<TD ALIGN="middle">[[Image:Yes.gif]]</TD>
<td>INTEGER</td>
+
<TD>id</TD>
<td>11</td>
+
<TD>INTEGER</TD>
<td>0</td>
+
<TD>11</TD>
<td></td>
+
<TD>0</TD>
<td></td>
+
<TD></TD>
<td align="center"></td>
+
  
<td align="center"></td>
+
<TD></TD>
<td align="center">[[Image:Yes.gif]]</td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">[[Image:Yes.gif]]</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
</tr>
+
<TD ALIGN="middle">&nbsp;</TD>
<tr>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
</TR>
<td>datum</td>
+
<TR>
<td>DATE</td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td>0</td>
+
<TD>datum</TD>
<td>0</td>
+
<TD>DATE</TD>
<td></td>
+
<TD>0</TD>
 +
<TD>0</TD>
  
<td></td>
+
<TD></TD>
<td align="center"></td>
+
<TD></TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center">[[Image:Yes.gif]]</td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">[[Image:Yes.gif]]</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
</tr>
+
<TD ALIGN="middle">&nbsp;</TD>
<tr>
+
</TR>
<td align="center"></td>
+
<TR>
<td>beschreibung</td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td>TEXT</td>
+
<TD>beschreibung</TD>
<td>0</td>
+
<TD>TEXT</TD>
<td>0</td>
+
<TD>0</TD>
  
<td></td>
+
<TD>0</TD>
<td></td>
+
<TD></TD>
<td align="center"></td>
+
<TD></TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center">[[Image:Yes.gif]]</td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">[[Image:Yes.gif]]</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
</tr>
+
<TD ALIGN="middle">&nbsp;</TD>
<tr>
+
</TR>
<td align="center"></td>
+
<TR>
<td>autor</td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td>VARCHAR</td>
+
<TD>autor</TD>
<td>50</td>
+
<TD>VARCHAR</TD>
  
<td>0</td>
+
<TD>50</TD>
<td></td>
+
<TD>0</TD>
<td></td>
+
<TD></TD>
<td align="center"></td>
+
<TD></TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center">[[Image:Yes.gif]]</td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">[[Image:Yes.gif]]</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
</tr>
+
<TD ALIGN="middle">&nbsp;</TD>
<tr>
+
</TR>
<td align="center"></td>
+
<TR>
<td>version</td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td>VARCHAR</td>
+
<TD>version</TD>
  
<td>8</td>
+
<TD>VARCHAR</TD>
<td>0</td>
+
<TD>8</TD>
<td></td>
+
<TD>0</TD>
<td></td>
+
<TD></TD>
<td align="center"></td>
+
<TD></TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
<td align="center"></td>
+
<TD ALIGN="middle">&nbsp;</TD>
</tr>
+
<TD ALIGN="middle">&nbsp;</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">&nbsp;</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">&nbsp;</TD>
 +
<TD ALIGN="middle">&nbsp;</TD>
 +
<TD ALIGN="middle">&nbsp;</TD>
 +
<TD ALIGN="middle">&nbsp;</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

Fields

PK Name Data type Size Precision Values Default Auto Increment Binary Not null Unsigned Zero Fill Unique
Yes.gif id INTEGER 11 0     Yes.gif      
  datum DATE 0 0     Yes.gif      
  beschreibung TEXT 0 0     Yes.gif      
  autor VARCHAR 50 0     Yes.gif      
  version VARCHAR 8 0            


Indices

Name Fields Unique Collation Full Text
PRIMARY id Yes.gif 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
Yes.gif 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;