|
|
| Zeile 1: |
Zeile 1: |
| | ==Fields== | | ==Fields== |
| | <table {{prettytable}}> | | <table {{prettytable}}> |
| | + | |
| | <tr> | | <tr> |
| − | <th><b>PK</b></p></th> | + | <th><b>PK</b></th> |
| − | <th><b>Name</b></p></th> | + | <th><b>Name</b></th> |
| − | <th><b>Data type</b></p></th> | + | <th><b>Data type</b></th> |
| − | <th><b>Size</b></p></th> | + | <th><b>Size</b></th> |
| − | <th><b>Precision</b></p></th> | + | <th><b>Precision</b></th> |
| − | <th><b>Values</b></p></th> | + | <th><b>Values</b></th> |
| − | <th><b>Default</b></p></th> | + | <th><b>Default</b></th> |
| − | <th><b>Auto Increment</b></p></th> | + | <th><b>Auto Increment</b></th> |
| − | <th><b>Binary</b></p></th> | + | <th><b>Binary</b></th> |
| − | <th><b>Not null</b></p></th> | + | <th><b>Not null</b></th> |
| − | <th><b>Unsigned</b></p></th> | + | <th><b>Unsigned</b></th> |
| − | <th><b>Zero Fill</b></p></th> | + | <th><b>Zero Fill</b></th> |
| − | <th><b>Unique</b></p></th> | + | <th><b>Unique</b></th> |
| | </tr> | | </tr> |
| | </table> | | </table> |
| | + | |
| | ==Test== | | ==Test== |
| | <table> | | <table> |
Version vom 9. März 2007, 14:36 Uhr
Fields
| PK |
Name |
Data type |
Size |
Precision |
Values |
Default |
Auto Increment |
Binary |
Not null |
Unsigned |
Zero Fill |
Unique |
Test
|
loc_id |
INTEGER |
11 |
0 |
|
|
|
|
|
|
|
|
|
float_val |
DOUBLE |
0 |
0 |
|
|
|
|
|
|
|
|
|
float_type |
INTEGER |
11 |
0 |
|
|
|
|
|
|
|
|
|
float_subtype |
INTEGER |
11 |
0 |
|
|
|
|
|
|
|
|
|
valid_since |
DATE |
0 |
0 |
|
|
|
|
|
|
|
|
|
date_type_since |
INTEGER |
11 |
0 |
|
|
|
|
|
|
|
|
|
valid_until |
DATE |
0 |
0 |
|
|
|
|
|
|
|
|
|
date_type_until |
INTEGER |
11 |
0 |
|
|
|
|
|
|
|
|
Indices
| Name</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
| TransactSafe</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;
