AFAIK, there's few columns that are required, and for example sippeers can have as many columns as the corresponding configuration values of peers, and if not present they will claim default values...
On 9 May 2014 22:32, Stephen More <[email protected]> wrote: > I am trying to find where the authoritative sql definitions for Asterisk > Realtime Architecture ARA are located. I have found many locations but each > and everyone seems to be different. > > > http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html > > http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example > > Files included with the distribution: > > asterisk-11.9.0/contrib/realtime/mysql/iaxfriends.sql:CREATE TABLE > `iaxfriends` ( > asterisk-11.9.0/contrib/realtime/mysql/meetme.sql:CREATE TABLE meetme ( > asterisk-11.9.0/contrib/realtime/mysql/musiconhold.sql:CREATE TABLE > musiconhold ( > asterisk-11.9.0/contrib/realtime/mysql/queue_log.sql:CREATE TABLE > queue_log ( > asterisk-11.9.0/contrib/realtime/mysql/sippeers.sql:CREATE TABLE IF NOT > EXISTS `sippeers` ( > asterisk-11.9.0/contrib/realtime/mysql/voicemail.sql:CREATE TABLE > voicemail ( > asterisk-11.9.0/contrib/realtime/mysql/voicemail_data.sql:CREATE TABLE > voicemail_data ( > asterisk-11.9.0/contrib/realtime/mysql/voicemail_messages.sql:CREATE TABLE > voicemail_messages ( > > asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE > extensions_conf ( > asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE cdr ( > asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE > sip_conf ( > asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE > voicemail_users ( > asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE > queue_table ( > asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE > queue_member_table > asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE > "queue_log" ( > > Any help is appreciated. > -Stephen More > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
