[Devel] modifying the database structure
skg1010 at hotmail.com
Fri May 26 21:46:05 CEST 2006
Adding an ID field should not affect openser as most modules bind by column
name. I had to do the same to a some of my tables.
>From: Mike Williams <mwilliams at etc1.net>
>To: devel at openser.org
>Subject: [Devel] modifying the database structure
>Date: Fri, 26 May 2006 11:53:20 -0400
>I was wondering if modifying the database structure would have some kind of
>ill effects on the operation of OpenSER. For instance, the domain table has
>two columns, domain and last_modified. Having the value column also be the
>primary key is making it difficult for me to use it in any object
>mapping code, specifically in ruby on rails. Likewise, I can't do any
>key constraints at the database level, so consistency checking is zero. I
>would like to add an id field instead and just specify that domain is
>I would like to release some source code for a very basic web interface I
>working on, but I don't want to do so if I will immediately receive a
>emails about how broken it is.
>Often, I consider redoing the database structure completely, and then
>views from it for OpenSER's use. This would also alleviate some of the
>problems I'm having with integrating OpenSER and Asterisk effectively
>adding a million columns to the subscriber table. However, I also don't
>to break the modularity that OpenSER currently has.
>Devel mailing list
>Devel at openser.org
Express yourself instantly with MSN Messenger! Download today - it's FREE!
More information about the Devel