diff options
Diffstat (limited to 'contrib/realtime/mysql/meetme.sql')
-rw-r--r-- | contrib/realtime/mysql/meetme.sql | 11 |
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), ); |