[sr-dev] unique id column missing in s tables

Daniel-Constantin Mierla miconda at gmail.com
Fri Jul 3 19:54:16 CEST 2009



On 07/03/2009 06:17 PM, Juha Heinanen wrote:
> Jan Janak writes:
>
>  > Which tables? Do you mean the uuid column?
>
> all tables.  in every k table there is column
>
>     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL
>   
this is intended as unique reference to the db record. Some modules uses 
it  internally (e.g., msilo), but mainly is there to be faster in 
updates/delete once you get a record, that can happen from config file 
by using avp_db_query()/sql_query() or from other applications.

Cheers,
Daniel

> which does not exist in any s table.
>
> -- juha
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
>
>   

-- 
Daniel-Constantin Mierla
http://www.asipto.com/




More information about the sr-dev mailing list