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 12:41] catherine.balleydier@grenoble-inp.fr [subscriber_table] |
base:structure [2025/12/19 15:05] (Version actuelle) catherine.balleydier@grenoble-inp.fr [user_table] |
||
|---|---|---|---|
| Ligne 7: | Ligne 7: | ||
| SHOW COLUMNS FROM <table>; | SHOW COLUMNS FROM <table>; | ||
| + | ou | ||
| + | desc <table>; | ||
| - | [[http://www.sympa.org/internals/database|Description complète de la base v6]] | + | [[https://www.sympa.community/gpldoc/man/sympa_database.5.html|Description complète de la base v6]] |
| Version de sympa pour la base : ~sympa/etc/data_structure | Version de sympa pour la base : ~sympa/etc/data_structure | ||
| Ligne 24: | 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 37: | 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 45: | 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 58: | Ligne 60: | ||
| | cath@inpg.fr | cath@inpg.fr | | | cath@inpg.fr | cath@inpg.fr | | ||
| | noconceal | noconceal | | | noconceal | noconceal | | ||
| + | | | | | ||
| + | | | | | ||
| +-------------------------+-------------------------+ | +-------------------------+-------------------------+ | ||
| </code> | </code> | ||
| Ligne 546: | Ligne 550: | ||
| +--------------------------------------------------------------------------------+ | +--------------------------------------------------------------------------------+ | ||
| | NULL | | | NULL | | ||
| - | | 15 | | + | | 15 | |
| - | | NULL | | + | | 1695055638 1757431985 11 5.1.1 | |
| | NULL | | | NULL | | ||
| | NULL | | | NULL | | ||
| Ligne 559: | Ligne 563: | ||
| | catherine@inpg.fr | | | catherine@inpg.fr | | ||
| | noconceal | | | noconceal | | ||
| - | | <?xml version="1.0" encoding="UTF-8" ?><custom_attributes></custom_attributes> | | ||
| | NULL | | | NULL | | ||
| | NULL | | | NULL | | ||
| | NULL | | | NULL | | ||
| - | |||
| | NULL | | | NULL | | ||
| + | | 0 | | ||
| + | | 1681984984 | | ||
| + | | 1766141362 | | ||
| +--------------------------------------------------------------------------------+ | +--------------------------------------------------------------------------------+ | ||
| Ligne 586: | 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 | | | ||
| +------------------------+--------------+------+-----+---------+-------+ | +------------------------+--------------+------+-----+---------+-------+ | ||
