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

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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev