[OpenSER-Devel] Fwd: Field name consistency in Presence tabels

[Anca Vamanu]

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 <ag at ag-projects.com <mailto:ag at ag-projects.com>>
>> *Date: *October 15, 2007 12:55:46 PM GMT+02:00
>> *To: *devel <devel at openser.org <mailto:devel at openser.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
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>