[Devel] db schema status, questions

[Mike Williams]

I believe that at least for auto incremented ids, they should always be 
unsigned.

On Monday 21 May 2007 08:45:46 Henning Westerholt wrote:
> Hello all,
>
> during my work with the database schemas i've noticed and fixed some issues
> with the current schema:
>
> - addition of a version field to pdt table
> - change uri: uri_user field length from 50 to 64 (standard user data
> length) - change sip_trace: callid and :status from 254 to 255, and
> sip_trace: traced_user from 128 to 255 (standard hf and uri length)
> - acc: sip_code from CHAR to VARCHAR changed (CHAR not available in the
>   schema scripts atm)
> - grp:grp group name from 50 to 64 increased (std id length)
> - trusted:src_ip from 39 to 50 increased
> - speeddial: new_uri from 192 to 255 increased, lname and fname from 128 to
> 64 decreased (std user name length)
> - usr_preferences: avp_val_len from 128 to 255 increased (to make this
>   consistent to domainpolicy), :last_modified from TIMESTAMP to DATETIME
>   changed (TIMESTAMP not available in schema scripts atm, DATETIME more
> safe in different mysql versions)
> - subscriber: lname, fname and email fields to 64 increased
> - presentity: domain from 124 to 128 increased
> - xcap_xml: user from 66 to 64 decreased
> - pua:watcher_uri and pres_user increased from 128 to 255 (std. URI length)
>
> In my opinion it's more resonable to have some standard length for
> datatypes, what do you think about this changes?
>
>
> For the serweb tables i used only the given lengths, there should be no
> changes except two CHAR to VARCHAR conversions.
>
> At the moment the IDs for the tables are either signed or unsigned. Should
> i change this to only one type?
>
>
> I finished the schema definitions today, and began to working on the
> database setup script. I hope that i can commit a first working version in
> the next days, but first i want to do some tests and finish a little bit
> other work..
>
> Cheers,
>
> Henning
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel