mirror of https://github.com/coturn/coturn
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
56 lines
1.0 KiB
56 lines
1.0 KiB
7 years ago
|
|
||
|
|
CREATE TABLE turnusers_lt (
|
||
|
|
realm varchar(127) default '',
|
||
|
|
name varchar(512),
|
||
|
|
hmackey char(128),
|
||
|
|
PRIMARY KEY (realm,name)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE turn_secret (
|
||
|
|
realm varchar(127) default '',
|
||
|
|
value varchar(256),
|
||
|
|
primary key (realm,value)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE allowed_peer_ip (
|
||
|
|
realm varchar(127) default '',
|
||
|
|
ip_range varchar(256),
|
||
|
|
primary key (realm,ip_range)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE denied_peer_ip (
|
||
|
|
realm varchar(127) default '',
|
||
|
|
ip_range varchar(256),
|
||
|
|
primary key (realm,ip_range)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE turn_origin_to_realm (
|
||
|
|
origin varchar(127),
|
||
|
|
realm varchar(127),
|
||
|
|
primary key (origin)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE turn_realm_option (
|
||
|
|
realm varchar(127) default '',
|
||
|
|
opt varchar(32),
|
||
|
|
value varchar(128),
|
||
|
|
primary key (realm,opt)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE oauth_key (
|
||
|
|
kid varchar(128),
|
||
|
|
ikm_key varchar(256),
|
||
|
|
timestamp bigint default 0,
|
||
|
|
lifetime integer default 0,
|
||
|
|
as_rs_alg varchar(64) default '',
|
||
|
|
realm varchar(127),
|
||
|
|
primary key (kid)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE admin_user (
|
||
|
|
name varchar(32),
|
||
|
|
realm varchar(127),
|
||
|
|
password varchar(127),
|
||
|
|
primary key (name)
|
||
|
|
);
|