unique id column missing in s tables

[Juha Heinanen]

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


_______________________________________________
sr-dev mailing list
[hidden email]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

[Jan Janak]

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.

_______________________________________________
sr-dev mailing list
[hidden email]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

[Juha Heinanen]

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

which does not exist in any s table.

-- juha

_______________________________________________
sr-dev mailing list
[hidden email]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

[Daniel-Constantin Mierla]

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

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


_______________________________________________
sr-dev mailing list
[hidden email]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev