aboutsummaryrefslogtreecommitdiffstats
path: root/contrib/realtime/mysql/meetme.sql
blob: 7e79a8c747ddb5cedf7cfa6973de302d72123172 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
-- 
-- Table structure for Realtime meetme
-- 

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,
	index confno (confno,starttime,endtime)
	PRIMARY KEY (bookid),
);