The mailing list for listmasters using Sympa

["antonelli@cnaf" <address@concealed>]

Hi Soji

thank you for your answer; I'm using mariadb 10.0.38

this is the output of the select query (SELECT TABLE_NAME, INDEX_NAME, 
COLUMN_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 
'my_sympa_db') (I attach the file too)

thank you
regards Stefano

+-----------------------+-----------------------+------------------------+
| TABLE_NAME            | INDEX_NAME            | COLUMN_NAME            |
+-----------------------+-----------------------+------------------------+
| admin_table           | PRIMARY               | list_admin             |
| admin_table           | PRIMARY               | user_admin             |
| admin_table           | PRIMARY               | robot_admin            |
| admin_table           | PRIMARY               | role_admin             |
| admin_table           | list_admin_2          | list_admin             |
| admin_table           | list_admin_2          | user_admin             |
| admin_table           | admin_user_index      | user_admin             |
| bulkmailer_table      | PRIMARY               | messagekey_bulkmailer  |
| bulkmailer_table      | PRIMARY               | packetid_bulkmailer    |
| bulkspool_table       | PRIMARY               | messagekey_bulkspool   |
| conf_table            | PRIMARY               | robot_conf             |
| conf_table            | PRIMARY               | label_conf             |
| exclusion_table       | PRIMARY               | user_exclusion         |
| exclusion_table       | PRIMARY               | robot_exclusion        |
| exclusion_table       | PRIMARY               | family_exclusion       |
| exclusion_table       | PRIMARY               | list_exclusion         |
| inclusion_table       | PRIMARY               | source_inclusion       |
| inclusion_table       | PRIMARY               | role_inclusion         |
| inclusion_table       | PRIMARY               | target_inclusion       |
| list_table            | PRIMARY               | name_list              |
| list_table            | PRIMARY               | robot_list             |
| netidmap_table        | PRIMARY               | netid_netidmap         |
| netidmap_table        | PRIMARY               | serviceid_netidmap     |
| netidmap_table        | PRIMARY               | robot_netidmap         |
| notification_table    | PRIMARY               | pk_notification        |
| one_time_ticket_table | PRIMARY               | ticket_one_time_ticket |
| session_table         | PRIMARY               | id_session             |
| session_table         | session_prev_id_index | prev_id_session        |
| stat_table            | stats_user_index      | email_stat             |
| subscriber_table      | PRIMARY               | list_subscriber        |
| subscriber_table      | PRIMARY               | user_subscriber        |
| subscriber_table      | PRIMARY               | robot_subscriber       |
| subscriber_table      | subscriber_user_index | user_subscriber        |
| user_table            | PRIMARY               | email_user             |
+-----------------------+-----------------------+------------------------+



Il 16/06/23 07:50, IKEDA Soji ha scritto:
> WHERE TABLE_SCHEMA = '

+-----------------------+-----------------------+------------------------+
| TABLE_NAME            | INDEX_NAME            | COLUMN_NAME            |
+-----------------------+-----------------------+------------------------+
| admin_table           | PRIMARY               | list_admin             |
| admin_table           | PRIMARY               | user_admin             |
| admin_table           | PRIMARY               | robot_admin            |
| admin_table           | PRIMARY               | role_admin             |
| admin_table           | list_admin_2          | list_admin             |
| admin_table           | list_admin_2          | user_admin             |
| admin_table           | admin_user_index      | user_admin             |
| bulkmailer_table      | PRIMARY               | messagekey_bulkmailer  |
| bulkmailer_table      | PRIMARY               | packetid_bulkmailer    |
| bulkspool_table       | PRIMARY               | messagekey_bulkspool   |
| conf_table            | PRIMARY               | robot_conf             |
| conf_table            | PRIMARY               | label_conf             |
| exclusion_table       | PRIMARY               | user_exclusion         |
| exclusion_table       | PRIMARY               | robot_exclusion        |
| exclusion_table       | PRIMARY               | family_exclusion       |
| exclusion_table       | PRIMARY               | list_exclusion         |
| inclusion_table       | PRIMARY               | source_inclusion       |
| inclusion_table       | PRIMARY               | role_inclusion         |
| inclusion_table       | PRIMARY               | target_inclusion       |
| list_table            | PRIMARY               | name_list              |
| list_table            | PRIMARY               | robot_list             |
| netidmap_table        | PRIMARY               | netid_netidmap         |
| netidmap_table        | PRIMARY               | serviceid_netidmap     |
| netidmap_table        | PRIMARY               | robot_netidmap         |
| notification_table    | PRIMARY               | pk_notification        |
| one_time_ticket_table | PRIMARY               | ticket_one_time_ticket |
| session_table         | PRIMARY               | id_session             |
| session_table         | session_prev_id_index | prev_id_session        |
| stat_table            | stats_user_index      | email_stat             |
| subscriber_table      | PRIMARY               | list_subscriber        |
| subscriber_table      | PRIMARY               | user_subscriber        |
| subscriber_table      | PRIMARY               | robot_subscriber       |
| subscriber_table      | subscriber_user_index | user_subscriber        |
| user_table            | PRIMARY               | email_user             |
+-----------------------+-----------------------+------------------------+