Différences
Ci-dessous, les différences entre deux révisions de la page.
| Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
|
base:structure [2025/12/19 14:50] catherine.balleydier@grenoble-inp.fr [Structure de la base] |
base:structure [2025/12/19 15:05] (Version actuelle) catherine.balleydier@grenoble-inp.fr [user_table] |
||
|---|---|---|---|
| Ligne 26: | Ligne 26: | ||
| +-----------------------+-------------------------------------+------+-----+---------+-------+ | +-----------------------+-------------------------------------+------+-----+---------+-------+ | ||
| | comment_admin | varchar(150) | YES | | NULL | | | | comment_admin | varchar(150) | YES | | NULL | | | ||
| - | | date_admin | datetime | NO | | | | | ||
| | include_sources_admin | varchar(50) | YES | | NULL | | | | include_sources_admin | varchar(50) | YES | | NULL | | | ||
| | included_admin | int(1) | YES | | NULL | | | | included_admin | int(1) | YES | | NULL | | | ||
| Ligne 39: | Ligne 38: | ||
| | user_admin | varchar(100) | NO | PRI | | | | | user_admin | varchar(100) | NO | PRI | | | | ||
| | visibility_admin | varchar(20) | YES | | NULL | | | | visibility_admin | varchar(20) | YES | | NULL | | | ||
| + | | date_epoch_admin | int(11) | YES | | NULL | | | ||
| + | | update_epoch_admin | int(11) | YES | | NULL | | | ||
| +-----------------------+-------------------------------------+------+-----+---------+-------+ | +-----------------------+-------------------------------------+------+-----+---------+-------+ | ||
| </code> | </code> | ||
| Ligne 47: | Ligne 48: | ||
| +-------------------------+-------------------------+ | +-------------------------+-------------------------+ | ||
| | NULL | NULL | | | NULL | NULL | | ||
| - | | 2008-09-10 10:15:25 | 2008-09-15 16:03:31 | | ||
| | NULL | a386b2d3 | | | NULL | a386b2d3 | | ||
| | 0 | 1 | | | 0 | 1 | | ||
| Ligne 60: | Ligne 60: | ||
| | cath@inpg.fr | cath@inpg.fr | | | cath@inpg.fr | cath@inpg.fr | | ||
| | noconceal | noconceal | | | noconceal | noconceal | | ||
| + | | | | | ||
| + | | | | | ||
| +-------------------------+-------------------------+ | +-------------------------+-------------------------+ | ||
| </code> | </code> | ||
| Ligne 589: | Ligne 591: | ||
| | last_login_host_user | varchar(60) | YES | | NULL | | | | last_login_host_user | varchar(60) | YES | | NULL | | | ||
| | wrong_login_count_user | int(11) | YES | | NULL | | | | wrong_login_count_user | int(11) | YES | | NULL | | | ||
| - | |||
| | last_active_date_user | int(11) | YES | | NULL | | | | last_active_date_user | int(11) | YES | | NULL | | | ||
| +------------------------+--------------+------+-----+---------+-------+ | +------------------------+--------------+------+-----+---------+-------+ | ||
