[Spce-user] Voicemail Folders

Jonathan Scott jonathan at xpressamerica.net
Tue Oct 11 17:51:56 EDT 2011


ALTER TABLE kamailio.voicemail_spool CHANGE COLUMN origtime origtime 
VARCHAR(16) DEFAULT ''; ALTER TABLE kamailio.voicemail_spool CHANGE 
COLUMN duration duration VARCHAR(16) DEFAULT '';

That is how it was done.

show create table voicemail_spool;
voicemail_spool 	CREATE TABLE `voicemail_spool` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `msgnum` int(11) NOT NULL DEFAULT '0',
  `dir` varchar(127) DEFAULT '',
  `context` varchar(63) DEFAULT '',
  `macrocontext` varchar(63) DEFAULT '',
  `callerid` varchar(255) DEFAULT '',
  `origtime` varchar(16) DEFAULT '',
  `duration` varchar(16) DEFAULT '',
  `mailboxuser` varchar(255) DEFAULT '',
  `mailboxcontext` varchar(63) DEFAULT '',
  `recording` longblob,
  PRIMARY KEY (`id`),
  KEY `dir` (`dir`),
  KEY `mailboxuser_idx` (`mailboxuser`),
  CONSTRAINT `v_s_mailboxuser_ref` FOREIGN KEY (`mailboxuser`) 
REFERENCES `voicemail_users` (`customer_id`) ON DELETE CASCADE ON UPDATE 
CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=218 DEFAULT CHARSET=latin1



Every has the uuid in the customer_id table and these match in the 
subscriber table as well.

All three statements you provided, return the same result as you said it 
should.


On 10/11/2011 5:36 PM, Daniel Tiefnig wrote:
> On 10/11/2011 09:24 PM, Jonathan Scott wrote:
>> The one thing I did manually change in the database was in
>> voicemail_spool the table structure was not correct and you could not
>> record your own greetings... other than that, I have not touched
>> anything.
>
> Well, so how did you change it? Can you send the SQL statement(s) you
> have used? The output of "show create table voicemail_spool;" could also
> be helpful.
>
> Further you could check if the entries in the voicemail_users table are
> correct. Does every entry have a UUID in the customer_id column? Do
> these match to UUIDs in the subscriber table?
> You can do a quick check with the following three statements, all should
> output the same value:
>
> select count(*) from subscriber;
>
> select count(*) from voicemail_users;
>
> select count(*) from subscriber
>        inner join voicemail_users on uuid = customer_id;
>
> br,
> daniel
>
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user
>


-- 
Jonathan Scott Knox
Systems Administrator
XATel Communication
7 Green Street, Biddeford ME. 04005
(207)391.1000 (Mon - Thur, 9AM - 6PM. Friday - 9AM - 5PM.)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20111011/23435860/attachment-0001.html>


More information about the Spce-user mailing list