Geodb floatdata: Unterschied zwischen den Versionen

Version vom 9. März 2007, 14:32 Uhr (Quelltext anzeigen) HeinzJ (Diskussion | Beiträge)		Version vom 9. März 2007, 14:34 Uhr (Quelltext anzeigen) HeinzJ (Diskussion | Beiträge) (→‎Fields) Zum nächsten (jüngeren) Versionsunterschied ?
Zeile 16:		Zeile 16:
	<th><b>Unique</b></p></th>		<th><b>Unique</b></p></th>
	</tr>		</tr>
−		+	</table>
		+	==Test==
	<tr>		<tr>
	<td align="center"></td>		<td align="center"></td>
Zeile 146:		Zeile 147:
	</table>		</table>
−
	==Indices==		==Indices==

---

Version vom 9. März 2007, 14:34 Uhr

Fields

<th>Name</p></th> <th>Data type</p></th> <th>Size</p></th> <th>Precision</p></th> <th>Values</p></th> <th>Default</p></th> <th>Auto Increment</p></th> <th>Binary</p></th> <th>Not null</p></th> <th>Unsigned</p></th> <th>Zero Fill</p></th> <th>Unique</p></th>

</table>

Test

<tr> <td align="center"></td>

<td>

loc_id

</td> <td>

INTEGER

</td> <td>

11

</td> <td>

0

</td>

<td></td> <td></td> <td align="center"></td> <td align="center"></td>

<td align="center">

</td>

<td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

<tr> <td align="center"></td>

<td>

float_val

</td> <td>

DOUBLE

</td> <td>

0

</td> <td>

0

</td>

<td></td> <td></td> <td align="center"></td> <td align="center"></td>

<td align="center">

</td>

<td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

<tr> <td align="center"></td>

<td>

float_type

</td> <td>

INTEGER

</td> <td>

11

</td> <td>

0

</td>

<td></td> <td></td> <td align="center"></td> <td align="center"></td>

<td align="center">

</td>

<td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

<tr> <td align="center"></td>

<td>

float_subtype

</td> <td>

INTEGER

</td> <td>

11

</td> <td>

0

</td>

<td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

<tr> <td align="center"></td>

<td>

valid_since

</td> <td>

DATE

</td> <td>

0

</td> <td>

0

</td>

<td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

<tr> <td align="center"></td>

<td>

date_type_since

</td> <td>

INTEGER

</td> <td>

11

</td> <td>

0

</td>

<td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

<tr> <td align="center"></td>

<td>

valid_until

</td> <td>

DATE

</td> <td>

0

</td> <td>

0

</td>

<td></td> <td></td> <td align="center"></td> <td align="center"></td>

<td align="center">

</td>

<td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

<tr> <td align="center"></td>

<td>

date_type_until

</td> <td>

INTEGER

</td> <td>

11

</td> <td>

0

</td>

<td></td> <td></td> <td align="center"></td> <td align="center"></td>

<td align="center">

</td>

<td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

</table>

Indices

PK</p>

<th>Fields</p></th> <th>Unique</p></th> <th>Collation</p></th> <th>Full Text</p></th>

<tr> <td>

float_lid_idx

</td> <td>

loc_id

</td>

<td align="center"></td>

<td>

Ascending

</td>

<td align="center"></td> </tr>

<tr>

<td>

float_val_idx

</td> <td>

float_val

</td>

<td align="center"></td>

<td>

Ascending

</td>

<td align="center"></td> </tr>

<tr>

<td>

float_type_idx

</td> <td>

float_type

</td>

<td align="center"></td>

<td>

Ascending

</td>

<td align="center"></td> </tr>

<tr>

<td>

float_stype_idx

</td> <td>

float_subtype

</td>

<td align="center"></td>

<td>

Ascending

</td>

<td align="center"></td> </tr>

<tr>

<td>

float_since_idx

</td> <td>

valid_since

</td>

<td align="center"></td>

<td>

Ascending

</td>

<td align="center"></td> </tr>

<tr>

<td>

float_until_idx

</td> <td>

valid_until

</td>

<td align="center"></td>

<td>

Ascending

</td>

<td align="center"></td> </tr>

</table>

Foreign Keys

There are no foreign keys for table geodb_floatdata

Triggers</p>

There are no triggers for table geodb_floatdata==

Options

Name</p>

<th>TableType</p></th> <th>Row Format</p></th> <th>Check Sum</p></th> <th>Delay Key Write</p></th> <th>Pack Keys</p></th> <th>Temporary</p></th> <th>Min Rows</p></th> <th>Max Rows</p></th> <th>Union</p></th>

<tr> <td align="center">

</td> <td>

InnoDB

</td> <td>

Ascending

</td>

<td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td>

<td>

0

</td> <td>

0

</td>

<td></td> </tr>

</table>

Definition

 CREATE</b> TABLE `geodb_floatdata` (
 `loc_id` int(11) NOT NULL,
 `float_val` double NOT NULL,
 `float_type` int(11) NOT NULL,
 `float_subtype` int(11) default NULL,
 `valid_since` date default NULL,
 `date_type_since` int(11) default NULL,
 `valid_until` date NOT NULL,
 `date_type_until` int(11) NOT NULL,
 KEY `float_lid_idx` (`loc_id`),
 KEY `float_val_idx` (`float_val`),
 KEY `float_type_idx` (`float_type`),
 KEY `float_stype_idx` (`float_subtype`),
 KEY `float_since_idx` (`valid_since`),
 KEY `float_until_idx` (`valid_until`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

TransactSafe</p>