aboutsummaryrefslogtreecommitdiffstats
path: root/contrib/scripts/meetme.sql
blob: cb96e630c7a56a3184979b22bfaf966781335837 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
-- 
-- Table structure for Realtime meetme
-- 

CREATE TABLE meetme (
	confno char(80) DEFAULT '0' NOT NULL,
	-- Web booking id for the conference
	bookId char(50) NULL,
	-- Must set schedule=yes in meetme.conf to use starttime and endtime
	starttime datetime NULL,
	endtime datetime NULL,
	-- PIN to enter the conference, if any
	pin char(30) NULL,
	-- Options to associate with normal users of the conference
	opts char(100) NULL,
	-- PIN to enter the conference as an administrator, if any
	adminpin char(30) NULL,
	-- Options to associate with administrator users of the conference
	adminopts char(100) NULL,
	-- Current count of conference participants
	members integer DEFAULT 0 NOT NULL,
	-- Maximum conference participants allowed concurrently
	maxusers integer DEFAULT 0 NOT NULL,
	-- Recording of the conference, if any
	recordingfilename char(255) NULL,
	-- File format of the conference recording, if any
	recordingformat char(10) NULL,
	PRIMARY KEY (confno, starttime)
);