Geodb changelog: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
(Fields)
(Felder)
Zeile 1: Zeile 1:
==Felder==
+
==Fields==
 
<TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90% {{prettytable}}>
 
<TABLE CLASS="dtArg" CELLSPACING="0" WIDTH=90% {{prettytable}}>
 
<TH WIDTH="1%"><B>PK</B>
 
<TH WIDTH="1%"><B>PK</B>

Version vom 8. März 2007, 21:54 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;