> just poor data modeling How so? How would you change it? Are you aware that they have written code into app_voicemail.c that allows you to store the actual soundfiles for voicemail in the database itself? You want to talk about poor database design...sheesh..
> Read it, makes no difference, it's broken :) Whats broken? > Also, it doesn't say why the table structure is the way it is. It most certainly does. Seems you didn't read the REAME after all. Quoted from README.extconfig: <quote> It is designed to provide a flexible, seamless integration between Asterisk's internal configuration structure and external SQL other other databases the columns in your tables should line up with the fields you would specify in the given entity declaration. For example, an entity that looks like: [foo] host=dynamic secret=bar context=default context=local could be stored in a table like this: +------+--------+-------+--------------+----------+-----+-----------+ | name | host | secret| context | ipaddr | port| regseconds| +------+--------+-------+--------------+----------+-----+-----------+ | foo | dynamic| bar | default;local| 127.0.0.1| 4569| 1096954152| +------+--------+-------+--------------+----------+-----+-----------+ </quote> Seems pretty simple and easy to use. This way if new config options are ever added, all you have to do to support them is to add a new column. And if all you are storing in most columns is 1 byte, it can't take up that much space. -Matthew ----- Original Message ----- From: "Greg - Cirelle Enterprises" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Sent: Thursday, December 23, 2004 9:00 AM Subject: Re: [Asterisk-Users] Realtime sipbuddies table structure why????? > At 09:53 AM 12/23/04, you wrote: > >It was written the way it is because that is how RealTime works. =P If you > >don't like the schema design, talk to Mark so he can rewrite RealTime for > >you. > > > >Read up some more on how RealTime works then you will understand why all the > >tables are designed the way they are. > > > >Read docs/README.extconfig > > > >-Matthew > > > Read it, makes no difference, it's broken :) > > Also, it doesn't say why the table structure is the > way it is. just poor data modeling. > > greg > > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users