[Obm] structures des tables en 2.3/2.4

[pascal.salaun at mclabosse.fr]

Bonjour,

A-priori, les structures des tables MailboxEntity, UserObm et EntityRight
n'ont pas l'air d'avoir trop évolué entre la 2.3.19 et la 2.4-rc2.

J'ai une petite question à destination des Codeurs OBM :

Si EntityRight.entityright_entity_id ==
MailboxEntity.mailboxentity_entity_id

alors est-ce que :

EntityRight.entityright_consumer_id ==
(MailboxEntity.mailboxentity_entity_id - 2)


C'est ce que j'en ai déduit depuis mes entrées dans la DB (cf fichier)



Merci

Bonne après-midi


Pascal
-------------- next part --------------
mysql> select * from  MailboxEntity ;
+-------------------------+--------------------------+
| mailboxentity_entity_id | mailboxentity_mailbox_id |
+-------------------------+--------------------------+
|                      14 |                        2 | 
|                      19 |                        3 | 
|                      24 |                        4 | 
|                      29 |                        5 | 
|                      34 |                        6 | 
|                      39 |                        7 | 
+-------------------------+--------------------------+
6 rows in set (0.00 sec)

mysql> select userobm_id,userobm_login from UserObm order by userobm_id;
+------------+-----------------+
| userobm_id | userobm_login   |
+------------+-----------------+
|          1 | admin0          | 
|          2 | manager-abc     | 
|          3 | albert.einstein | 
|          4 | marie.curie     | 
|          5 | manager-def     | 
|          6 | blaise.pascal   | 
|          7 | isaac.newton    | 
+------------+-----------------+
7 rows in set (0.00 sec)

mysql> select * from EntityRight ;
+----------------+-----------------------+-------------------------+--------------------+------------------+-------------------+-------------------+
| entityright_id | entityright_entity_id | entityright_consumer_id | entityright_access | entityright_read | entityright_write | entityright_admin |
+----------------+-----------------------+-------------------------+--------------------+------------------+-------------------+-------------------+
|              1 |                     6 |                    NULL |                  1 |                1 |                 0 |                 0 | 
|              2 |                     9 |                    NULL |                  1 |                1 |                 0 |                 0 | 
|              9 |                    39 |                      22 |                  0 |                1 |                 0 |                 0 | 
|             10 |                    39 |                      37 |                  0 |                0 |                 0 |                 1 | 
|             11 |                    19 |                      37 |                  1 |                1 |                 0 |                 0 | 
|             12 |                    19 |                      17 |                  0 |                0 |                 0 |                 1 | 
+----------------+-----------------------+-------------------------+--------------------+------------------+-------------------+-------------------+