3 Jul
2009
3 Jul
'09
12:08 p.m.
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
3 Jul
3 Jul
12:12 p.m.
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.
1:54 p.m.
On 07/03/2009 06:17 PM, Juha Heinanen wrote:
Jan Janak writes:
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 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
which does not exist in any s table.
-- juha
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla
http://www.asipto.com/
5670
days inactive
5670
days old
3 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Jan Janak -
jh＠tutpro.com