4,395
edits
Table llx c country: Difference between revisions
Jump to navigation
Jump to search
no edit summary
mNo edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
= Contenu = | = Contenu = | ||
La table '''llx_c_pays''' contient la liste des pays disponibles. Utilisée pour générer des listes déroulantes et filtrer des résultats. | {{flag fr}} La table '''llx_c_pays''' contient la liste des pays disponibles. Utilisée pour générer des listes déroulantes et filtrer des résultats. | ||
Contains the list of countries available. Used to generate drop-down list and filter results. | {{flag en}} Contains the list of countries available. Used to generate drop-down list and filter results. | ||
{{flag sp}} Contiene la lista de paises disponibles. Usada para generar una lista desplegabe y filtrar los resultados. | |||
= Structure = | = Structure = | ||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | |||
|style="background-color: #e9e9ef"| <b>Field</b> | |||
|style="background-color: #e9e9ef"| <b>Type</b> | |||
| | |style="background-color: #e9e9ef"| <b>Null</b> | ||
|style="background-color: #e9e9ef"| <b>Key</b> | |||
| rowid | |style="background-color: #e9e9ef"| <b>Default</b> | ||
| code | |style="background-color: #e9e9ef"| <b>Extra</b> | ||
| code_iso | varchar(3) | |style="background-color: #e9e9ef"| <b>Description</b> | ||
| libelle | |- | ||
| active | | rowid | ||
| int(11) | |||
| | |||
| PRI | |||
| NULL | |||
| auto_increment | |||
| technical index | |||
|- | |||
| code | |||
| varchar(2) | |||
| NO | |||
| UNI | |||
| | |||
| | |||
| | |||
|- | |||
| code_iso | |||
| varchar(3) | |||
| YES | |||
| UNI | |||
| NULL | |||
| | |||
| | |||
|- | |||
| libelle | |||
| varchar(50) | |||
| NO | |||
| UNI | |||
| | |||
| | |||
| | |||
|- | |||
| active | |||
| tinyint(4) | |||
| NO | |||
| | |||
| 1 | |||
| | |||
| | |||
|} | |||