Geodb_locations

==Fields==

<table>

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

<tr> <td align="center">Image:Yes.gif</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">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

<tr> <td align="center"></td> <td>loc_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">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>

</table>

==Indices== <table> <tr> <th><b>Name</b></th> <th><b>Fields</b></th> <th><b>Unique</b></th> <th><b>Collation</b></th> <th><b>Full Text</b></th> </tr>

<tr> <td>PRIMARY</td> <td>loc_id</td> <td align="center">Image:Yes.gif</td> <td>Ascending</td> <td align="center"></td> </tr>

<tr> <td>loc_type_idx</td> <td>loc_type</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>

</table>

==Foreign Keys== There are no foreign keys for table geodb_locations

==Triggers==

There are no triggers for table geodb_locations

==Options== <table>

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

<tr> <td align="center">Image:Yes.gif</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==

<source lang="mysql"> CREATE TABLE geodb_locations ( loc_id int(11) NOT NULL, loc_type int(11) NOT NULL, PRIMARY KEY (loc_id), KEY loc_type_idx (loc_type) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

</source>

Kategorie:Datenbank