when looking at s mysql tables, i noticed that (unlike k tables) they don't contain a unique id column. is there some reason for that or, the other way around, what exactly is the reason why k tables do have this column?
-- juha
On 03-07 19:08, Juha Heinanen wrote:
when looking at s mysql tables, i noticed that (unlike k tables) they don't contain a unique id column. is there some reason for that or, the other way around, what exactly is the reason why k tables do have this column?
Which tables? Do you mean the uuid column?
Jan.
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
-
Daniel-Constantin Mierla -
Jan Janak -
jh＠tutpro.com