summaryrefslogtreecommitdiff
path: root/contrib/realtime/mysql/meetme.sql
diff options
context:
space:
mode:
authorTilghman Lesher <tilghman@meg.abyt.es>2010-07-16 04:18:58 +0000
committerTilghman Lesher <tilghman@meg.abyt.es>2010-07-16 04:18:58 +0000
commit3cd3824171cf3440fde1b431f0a7d1cf64d26970 (patch)
tree7c40cda56c3bcb72f6854bae4607839fc844df07 /contrib/realtime/mysql/meetme.sql
parent3299f13d9458ba3864428e306074d5a60ed93858 (diff)
Allow ipaddress to contain the maximum IPv6 address.
Also, update meetme to the full list of supported fields. git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@276869 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'contrib/realtime/mysql/meetme.sql')
-rw-r--r--contrib/realtime/mysql/meetme.sql11
1 files changed, 10 insertions, 1 deletions
diff --git a/contrib/realtime/mysql/meetme.sql b/contrib/realtime/mysql/meetme.sql
index 19c4ed745..7e79a8c74 100644
--- a/contrib/realtime/mysql/meetme.sql
+++ b/contrib/realtime/mysql/meetme.sql
@@ -3,10 +3,19 @@
--
CREATE TABLE meetme (
+ bookid int(11) auto_increment,
confno char(80) DEFAULT '0' NOT NULL,
+ starttime datetime default '1900-01-01 12:00:00',
+ endtime datetime default '2038-01-01 12:00:00',
pin char(20) NULL,
adminpin char(20) NULL,
+ opts char(20) NULL,
+ adminopts char(20) NULL,
+ recordingfilename char(80) NULL,
+ recordingformat char(10) NULL,
+ maxusers int(11) NULL,
members integer DEFAULT 0 NOT NULL,
- PRIMARY KEY (confno)
+ index confno (confno,starttime,endtime)
+ PRIMARY KEY (bookid),
);