Update the MySQL voicemail_data contrib script to reflect Asterisk 11 changes

[asterisk/asterisk.git] / contrib / realtime / mysql / voicemail_data.sql

diff --git a/contrib/realtime/mysql/voicemail_data.sql b/contrib/realtime/mysql/voicemail_data.sql
index 743bd44..3e25f6e 100644 (file)
--- a/contrib/realtime/mysql/voicemail_data.sql
+++ b/contrib/realtime/mysql/voicemail_data.sql
@@ -23,7 +23,9 @@ CREATE TABLE voicemail_data (
        -- Value of the channel variable VM_CATEGORY, if set
        category CHAR(30),
        -- Length of the message, in seconds
-       duration INT(11)
+       duration INT(11),
+       -- Unique identifier for the message
+       msg_id CHAR(32)
 );