aboutsummaryrefslogtreecommitdiffstats
path: root/contrib/realtime/mysql/meetme.sql
diff options
context:
space:
mode:
authortilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b>2010-07-16 04:18:58 +0000
committertilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b>2010-07-16 04:18:58 +0000
commit22b2dbca0bfbe7ad64528623e368afdfb76f7876 (patch)
tree7c40cda56c3bcb72f6854bae4607839fc844df07 /contrib/realtime/mysql/meetme.sql
parentceff8cd7884ba1c07c236938ced5553730f3c33e (diff)
Allow ipaddress to contain the maximum IPv6 address.
Also, update meetme to the full list of supported fields. git-svn-id: http://svn.digium.com/svn/asterisk/trunk@276869 f38db490-d61c-443f-a65b-d21fe96a405b
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),
);