List Info

Thread: Field name consistency in Presence tabels
Field name consistency in Presence tabels
country flaguser name
Netherlands		 2007-10-15 05:55:46 
Hello,

There are two tables having fields with as far as I
understand the  
same meaning but different names, which is very confusing. I
have  
identified here a few:

1. active_watchers.pres_uri and watchers.p_uri

Let's call it presentity_uri in both tables

2. active_watchers. status and watchers. subs_status

Let's call it status in both tables

3. active_watchers.from_user and wathers.w_user

Let's call it watcher_username in both tables

4. active_watchers.from_domain and wathers.w_domain

Let's call it watcher_domain in both tables

My 2 cents
Adrian


mysql> describe active_watchers;
+---------------+------------------+------+-----+----------

+----------------+
| Field         | Type             | Null | Key | Default  |
 
Extra          |
+---------------+------------------+------+-----+----------

+----------------+
| id            | int(10) unsigned | NO   | PRI | NULL     |
 
auto_increment |
| pres_uri      | varchar(128)     | NO   | MUL |          

|                |
| to_user       | varchar(64)      | NO   |     |          

|                |
| to_domain     | varchar(64)      | NO   |     |          

|                |
| from_user     | varchar(64)      | NO   |     |          

|                |
| from_domain   | varchar(64)      | NO   |     |          

|                |
| event         | varchar(64)      | NO   |     | presence 

|                |
| event_id      | varchar(64)      | YES  |     | NULL     

|                |
| to_tag        | varchar(64)      | NO   | UNI |          

|                |
| from_tag      | varchar(64)      | NO   |     |          

|                |
| callid        | varchar(64)      | NO   |     |          

|                |
| local_cseq    | int(11)          | NO   |     |          

|                |
| remote_cseq   | int(11)          | NO   |     |          

|                |
| contact       | varchar(64)      | NO   |     |          

|                |
| record_route  | text             | YES  |     | NULL     

|                |
| expires       | int(11)          | NO   | MUL |          

|                |
| status        | int(11)          | NO   |     | 2        

|                |
| reason        | varchar(64)      | NO   |     |          

|                |
| version       | int(11)          | NO   |     | 0        

|                |
| socket_info   | varchar(64)      | NO   |     |          

|                |
| local_contact | varchar(128)     | NO   |     |          

|                |
+---------------+------------------+------+-----+----------

+----------------+
21 rows in set (0.01 sec)

mysql> describe watchers;
+---------------+------------------+------+-----+----------

+----------------+
| Field         | Type             | Null | Key | Default  |
 
Extra          |
+---------------+------------------+------+-----+----------

+----------------+
| id            | int(10) unsigned | NO   | PRI | NULL     |
 
auto_increment |
| p_uri         | varchar(128)     | NO   | MUL |          

|                |
| w_user        | varchar(64)      | NO   |     |          

|                |
| w_domain      | varchar(64)      | NO   |     |          

|                |
| event         | varchar(64)      | NO   |     | presence 

|                |
| subs_status   | int(11)          | NO   |     |          

|                |
| reason        | varchar(64)      | YES  |     | NULL     

|                |
| inserted_time | int(11)          | NO   |     |          

|                |
+---------------+------------------+------+-----+----------

+----------------+



_______________________________________________
Devel mailing list
Developenser.org
htt
p://openser.org/cgi-bin/mailman/listinfo/devel
Fwd: Field name consistency in Presence tabels
country flaguser name
Netherlands		 2007-10-25 02:47:50 

  


  

    Same obsevration applies for rls_* tables

CREATE TABLE rls_watchers (
    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
    pres_uri VARCHAR(128) NOT NULL,
    to_user VARCHAR(64) NOT NULL,
    to_domain VARCHAR(64) NOT NULL,
    from_user VARCHAR(64) NOT NULL,
    from_domain VARCHAR(64) NOT NULL,

Adrian


Begin forwarded message:

From: Adrian Georgescu < agag-projects.com">agag-projects.com>
Date: October 15, 2007 12:55:46 PM GMT+02:00
To: devel < developenser.org">developenser.org>
Subject: Field name consistency in Presence tabels

 
Hello,

There are two tables having fields with as far as I understand the same meaning but different names, which is very confusing. I have identified here a few:

1. active_watchers.pres_uri and watchers.p_uri

Let's call it presentity_uri in both tables

2. active_watchers. status and watchers. subs_status

Let's call it status in both tables

3. active_watchers.from_user and wathers.w_user

Let's call it watcher_username in both tables

4. active_watchers.from_domain and wathers.w_domain

Let's call it watcher_domain in both tables

My 2 cents
Adrian


mysql> describe active_watchers;
+---------------+------------------+------+-----+----------+----------------+
| Field         | Type             | Null | Key | Default  | Extra          |
+---------------+------------------+------+-----+----------+----------------+
| id            | int(10) unsigned | NO   | PRI | NULL     | auto_increment |
| pres_uri      | varchar(128)     | NO   | MUL |          |                |
| to_user       | varchar(64)      | NO   |     |          |                |
| to_domain     | varchar(64)      | NO   |     |          |                |
| from_user     | varchar(64)      | NO   |     |          |                |
| from_domain   | varchar(64)      | NO   |     |          |                |
| event         | varchar(64)      | NO   |     | presence |                |
| event_id      | varchar(64)      | YES  |     | NULL     |                |
| to_tag        | varchar(64)      | NO   | UNI |          |                |
| from_tag      | varchar(64)      | NO   |     |          |                |
| callid        | varchar(64)      | NO   |     |          |                |
| local_cseq    | int(11)          | NO   |     |          |                |
| remote_cseq   | int(11)          | NO   |     |          |                |
| contact       | varchar(64)      | NO   |     |          |                |
| record_route  | text             | YES  |     | NULL     |                |
| expires       | int(11)          | NO   | MUL |          |                |
| status        | int(11)          | NO   |     | 2        |                |
| reason        | varchar(64)      | NO   |     |          |                |
| version       | int(11)          | NO   |     | 0        |                |
| socket_info   | varchar(64)      | NO   |     |          |                |
| local_contact | varchar(128)     | NO   |     |          |                |
+---------------+------------------+------+-----+----------+----------------+
21 rows in set (0.01 sec)

mysql> describe watchers;
+---------------+------------------+------+-----+----------+----------------+
| Field         | Type             | Null | Key | Default  | Extra          |
+---------------+------------------+------+-----+----------+----------------+
| id            | int(10) unsigned | NO   | PRI | NULL     | auto_increment |
| p_uri         | varchar(128)     | NO   | MUL |          |                |
| w_user        | varchar(64)      | NO   |     |          |                |
| w_domain      | varchar(64)      | NO   |     |          |                |
| event         | varchar(64)      | NO   |     | presence |                |
| subs_status   | int(11)          | NO   |     |          |                |
| reason        | varchar(64)      | YES  |     | NULL     |                |
| inserted_time | int(11)          | NO   |     |          |                |
+---------------+------------------+------+-----+----------+----------------+


 


  

  
  
   
     
    

  

    Re:  Fwd: Field name consistency in
Presence tabels
  


  

     country flaguser name
Romania		
     2007-10-25 03:45:11
  


  

    
Hello Adrian,

In fact the consistency was a requirement as rls used an
update in 
database function from presence, that I have forgotten
about. Fixed now.
Thanks,
Anca

Adrian Georgescu wrote:
> Same obsevration applies for rls_* tables
>
> CREATE TABLE rls_watchers (
>     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT
NULL,
>     pres_uri VARCHAR(128) NOT NULL,
>     to_user VARCHAR(64) NOT NULL,
>     to_domain VARCHAR(64) NOT NULL,
>     from_user VARCHAR(64) NOT NULL,
>     from_domain VARCHAR(64) NOT NULL,
>
> Adrian
>
>
> Begin forwarded message:
>
>> *From: *Adrian Georgescu <agag-projects.com <mailto:agag-projects.com>>
>> *Date: *October 15, 2007 12:55:46 PM GMT+02:00
>> *To: *devel <developenser.org
<mailto:developenser.org>>
>> *Subject: **Field name consistency in Presence
tabels*
>>
>> Hello,
>>
>> There are two tables having fields with as far as I
understand the 
>> same meaning but different names, which is very
confusing. I have 
>> identified here a few:
>>
>> 1. active_watchers.pres_uri and watchers.p_uri
>>
>> Let's call it presentity_uri in both tables
>>
>> 2. active_watchers. status and watchers.
subs_status
>>
>> Let's call it status in both tables
>>
>> 3. active_watchers.from_user and wathers.w_user
>>
>> Let's call it watcher_username in both tables
>>
>> 4. active_watchers.from_domain and
wathers.w_domain
>>
>> Let's call it watcher_domain in both tables
>>
>> My 2 cents
>> Adrian
>>
>>
>> mysql> describe active_watchers;
>>
+---------------+------------------+------+-----+----------+
----------------+
>> | Field         | Type             | Null | Key |
Default  | Extra    
>>       |
>>
+---------------+------------------+------+-----+----------+
----------------+
>> | id            | int(10) unsigned | NO   | PRI |
NULL     | 
>> auto_increment |
>> | pres_uri      | varchar(128)     | NO   | MUL |  
       |          
>>       |
>> | to_user       | varchar(64)      | NO   |     |  
       |          
>>       |
>> | to_domain     | varchar(64)      | NO   |     |  
       |          
>>       |
>> | from_user     | varchar(64)      | NO   |     |  
       |          
>>       |
>> | from_domain   | varchar(64)      | NO   |     |  
       |          
>>       |
>> | event         | varchar(64)      | NO   |     |
presence |          
>>       |
>> | event_id      | varchar(64)      | YES  |     |
NULL     |          
>>       |
>> | to_tag        | varchar(64)      | NO   | UNI |  
       |          
>>       |
>> | from_tag      | varchar(64)      | NO   |     |  
       |          
>>       |
>> | callid        | varchar(64)      | NO   |     |  
       |          
>>       |
>> | local_cseq    | int(11)          | NO   |     |  
       |          
>>       |
>> | remote_cseq   | int(11)          | NO   |     |  
       |          
>>       |
>> | contact       | varchar(64)      | NO   |     |  
       |          
>>       |
>> | record_route  | text             | YES  |     |
NULL     |          
>>       |
>> | expires       | int(11)          | NO   | MUL |  
       |          
>>       |
>> | status        | int(11)          | NO   |     | 2
       |          
>>       |
>> | reason        | varchar(64)      | NO   |     |  
       |          
>>       |
>> | version       | int(11)          | NO   |     | 0
       |          
>>       |
>> | socket_info   | varchar(64)      | NO   |     |  
       |          
>>       |
>> | local_contact | varchar(128)     | NO   |     |  
       |          
>>       |
>>
+---------------+------------------+------+-----+----------+
----------------+
>> 21 rows in set (0.01 sec)
>>
>> mysql> describe watchers;
>>
+---------------+------------------+------+-----+----------+
----------------+
>> | Field         | Type             | Null | Key |
Default  | Extra    
>>       |
>>
+---------------+------------------+------+-----+----------+
----------------+
>> | id            | int(10) unsigned | NO   | PRI |
NULL     | 
>> auto_increment |
>> | p_uri         | varchar(128)     | NO   | MUL |  
       |          
>>       |
>> | w_user        | varchar(64)      | NO   |     |  
       |          
>>       |
>> | w_domain      | varchar(64)      | NO   |     |  
       |          
>>       |
>> | event         | varchar(64)      | NO   |     |
presence |          
>>       |
>> | subs_status   | int(11)          | NO   |     |  
       |          
>>       |
>> | reason        | varchar(64)      | YES  |     |
NULL     |          
>>       |
>> | inserted_time | int(11)          | NO   |     |  
       |          
>>       |
>>
+---------------+------------------+------+-----+----------+
----------------+
>>
>>
>
>
------------------------------------------------------------
------------
>
> _______________________________________________
> Devel mailing list
> Developenser.org
> htt
p://openser.org/cgi-bin/mailman/listinfo/devel
>   


_______________________________________________
Devel mailing list
Developenser.org
htt
p://openser.org/cgi-bin/mailman/listinfo/devel



  


  

    
  

  
  
   
     
    






 [1-3]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )