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/10/30 10:54] catherine.balleydier@grenoble-inp.fr [stat_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 98: | Ligne 102: | ||
| | 5 | | | 5 | | ||
| | 10 | | | 10 | | ||
| - | | toto@grenoble-inp.fr,titi@grenoble-inp.fr,tata@grenoble-inp.fr | | + | | toto@inp.fr,titi@inp.fr,tata@inp.fr | |
| | 1403850253 | | | 1403850253 | | ||
| | dsi-owner@grenoble-inp.fr | | | dsi-owner@grenoble-inp.fr | | ||
| - | | listes.grenoble-inp.fr | | + | | listes.inp.fr | |
| | 0 | | | 0 | | ||
| | 0 | | | 0 | | ||
| Ligne 464: | Ligne 468: | ||
| | 1446652800 | | | 1446652800 | | ||
| | liste-test | | | liste-test | | ||
| - | | listestest.grenoble-inp.fr | | + | | listestest.inp.fr | |
| +----------------------------+ | +----------------------------+ | ||
| </code> | </code> | ||
| Ligne 517: | Ligne 521: | ||
| | bounce_subscriber | varchar(35) | YES | | NULL | | | | bounce_subscriber | varchar(35) | YES | | NULL | | | ||
| | comment_subscriber | varchar(150) | YES | | NULL | | | | comment_subscriber | varchar(150) | YES | | NULL | | | ||
| - | | date_subscriber | datetime | NO | | | | | ||
| | include_sources_subscriber | varchar(50) | YES | | NULL | | | | include_sources_subscriber | varchar(50) | YES | | NULL | | | ||
| | included_subscriber | int(1) | YES | | NULL | | | | included_subscriber | int(1) | YES | | NULL | | | ||
| Ligne 532: | Ligne 535: | ||
| | suspend_start_date_subscriber | int(11) | YES | | NULL | | | | suspend_start_date_subscriber | int(11) | YES | | NULL | | | ||
| | suspend_subscriber | int(1) | YES | | NULL | | | | suspend_subscriber | int(1) | YES | | NULL | | | ||
| - | |||
| | number_messages_subscriber | int(5) | YES | | NULL | | | | number_messages_subscriber | int(5) | YES | | NULL | | | ||
| + | | date_epoch_subscriber | int(11) | YES | | NULL | | | ||
| + | | update_epoch_subscriber | int(11) | YES | | NULL | | | ||
| +-------------------------------+--------------+------+-----+---------+-------+ | +-------------------------------+--------------+------+-----+---------+-------+ | ||
| </code> | </code> | ||
| Ligne 546: | Ligne 550: | ||
| +--------------------------------------------------------------------------------+ | +--------------------------------------------------------------------------------+ | ||
| | NULL | | | NULL | | ||
| + | | 15 | | ||
| + | | 1695055638 1757431985 11 5.1.1 | | ||
| | NULL | | | NULL | | ||
| - | | NULL | | ||
| - | | NULL | | ||
| - | | 2008-01-29 20:04:46 | | ||
| | NULL | | | NULL | | ||
| | 0 | | | 0 | | ||
| | dsi-test | | | dsi-test | | ||
| | mail | | | mail | | ||
| - | | listestest.grenoble-inp.fr | | + | | listestest.inp.fr | |
| | 1 | | | 1 | | ||
| | NULL | | | NULL | | ||
| | 2008-02-12 11:03:24 | | | 2008-02-12 11:03:24 | | ||
| - | | catherine.balleydier@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 587: | 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 | | | ||
| +------------------------+--------------+------+-----+---------+-------+ | +------------------------+--------------+------+-----+---------+-------+ | ||
| Ligne 598: | Ligne 601: | ||
| | NULL | | | NULL | | ||
| | NULL | | | NULL | | ||
| - | | catherine.balleydier@inpg.fr | | + | | catherine@inpg.fr | |
| | NULL | | | NULL | | ||
| | NULL | | | NULL | | ||
