Diferencia entre revisiones de «BD.MET PERFILES SALA»

De VIVAitwiki
Ir a la navegaciónIr a la búsqueda
 
(No se muestran 13 ediciones intermedias de 2 usuarios)
Línea 2: Línea 2:
  
  
−
; [<unique room ID>]
 
−
; description = This is my awesome room
 
−
; is_private = yes|no (whether this room should be in the public list, default=yes)
 
−
; secret = <optional password needed for manipulating (e.g. destroying) the room>
 
−
; pin = <optional password needed for joining the room>
 
−
; require_pvtid = yes|no (whether subscriptions are required to provide a valid
 
−
;            a valid private_id to associate with a publisher, default=no)
 
−
; publishers = <max number of concurrent senders> (e.g., 6 for a video
 
−
;              conference or 1 for a webinar)
 
−
; bitrate = <max video bitrate for senders> (e.g., 128000)
 
−
; fir_freq = <send a FIR to publishers every fir_freq seconds> (0=disable)
 
−
; audiocodec = opus|isac32|isac16|pcmu|pcma (audio codec to force on publishers, default=opus)
 
−
; videocodec = vp8|vp9|h264 (video codec to force on publishers, default=vp8)
 
−
; video_svc = yes|no (whether SVC support must be enabled; works only for VP9, default=no)
 
−
; audiolevel_ext = yes|no (whether the ssrc-audio-level RTP extension must
 
−
;        be negotiated/used or not for new publishers, default=yes)
 
−
; audiolevel_event = yes|no (whether to emit event to other users or not, default=no)
 
−
; audio_active_packets = 100 (number of packets with audio level, default=100, 2 seconds)
 
−
; audio_level_average = 25 (average value of audio level, 127=muted, 0='too loud', default=25)
 
−
; videoorient_ext = yes|no (whether the video-orientation RTP extension must
 
−
;        be negotiated/used or not for new publishers, default=yes)
 
−
; playoutdelay_ext = yes|no (whether the playout-delay RTP extension must
 
−
;        be negotiated/used or not for new publishers, default=yes)
 
−
; record = true|false (whether this room should be recorded, default=false)
 
−
; rec_dir = <folder where recordings should be stored, when enabled>
 
−
; notify_joining = true|false (optional, whether to notify all participants when a new
 
−
;              participant joins the room. The Videoroom plugin by design only notifies
 
−
;              new feeds (publishers), and enabling this may result extra notification
 
−
;              traffic. This flag is particularly useful when enabled with require_pvtid
 
−
;              for admin to manage listening only participants. default=false)
 
  
 
==Campos==
 
==Campos==
  
 
===ID===
 
===ID===
−
INT NOT NULL AUTO_INCREMENT,
+
INT(11) NOT NULL AUTO_INCREMENT,
  
 
===C_NOMBRE===
 
===C_NOMBRE===
−
VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,
+
VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NULL DEFAULT NULL,
  
 
===C_DESCRIPCION===
 
===C_DESCRIPCION===
−
VARCHAR(128) CHARACTER SET 'utf8' NULL DEFAULT NULL,
+
 
 +
VARCHAR(128) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NULL DEFAULT NULL,
  
 
===N_MAX_PUBLISHER===
 
===N_MAX_PUBLISHER===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
<max number of concurrent senders> (e.g., 6 for a video
 +
;              conference or 1 for a webinar)
  
 
===N_DYN_USER_MAX_MINS===
 
===N_DYN_USER_MAX_MINS===
Línea 61: Línea 35:
 
===N_BITRATE===
 
===N_BITRATE===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
<max video bitrate for senders> (e.g., 128000)
 +
 +
===B_BITRATE_CAP===
 +
TINYINT(1) NOT NULL DEFAULT '0',
 +
 +
Si el valor es true el bitrate no puede sobrepasarse.
  
 
===N_FIR_FREQ===
 
===N_FIR_FREQ===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
<send a FIR to publishers every fir_freq seconds> (0=disable)
  
 
===E_AUDIO_CODEC===
 
===E_AUDIO_CODEC===
Línea 98: Línea 81:
 
===B_VIDEO_SVC===
 
===B_VIDEO_SVC===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no (whether SVC support must be enabled; works only for VP9, default=no)
  
 
===B_AUDIOLEVEL_EXT===
 
===B_AUDIOLEVEL_EXT===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no
 +
(whether the ssrc-audio-level RTP extension must be negotiated/used or not for new publishers, default=yes)
  
 
===B_AUDIOLEVEL_EVENT===
 
===B_AUDIOLEVEL_EVENT===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no (whether to emit event to other users or not, default=no)
  
 
===N_AUDIO_ACTIVE_PACKETS===
 
===N_AUDIO_ACTIVE_PACKETS===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
100 (number of packets with audio level, default=100, 2 seconds)
  
 
===N_AUDIO_LEVEL_AVERAGE===
 
===N_AUDIO_LEVEL_AVERAGE===
 
INT(11) NULL DEFAULT NULL,
 
INT(11) NULL DEFAULT NULL,
 +
 +
25 (average value of audio level, 127=muted, 0='too loud', default=25)
  
 
===B_VIDEOORIENT_EXT===
 
===B_VIDEOORIENT_EXT===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no
 +
 +
(whether the video-orientation RTP extension must be negotiated/used or not for new publishers, default=yes)
  
 
===B_PLAYOUTDELAY_EXT===
 
===B_PLAYOUTDELAY_EXT===
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no
 +
 +
(whether the playout-delay RTP extension must be negotiated/used or not for new publishers, default=yes)
 +
 +
===B_TRANSPORT_WIDE_CC_EXT===
 +
TINYINT(1) NULL DEFAULT NULL,
 +
 +
yes|no
 +
 +
(whether the transport wide CC RTP extension must be negotiated/used or not for new publishers, default=no; note that this currently doesn't work correctly when the publisher is doing simulcasting)
  
 
===B_GRABAR===
 
===B_GRABAR===
 
TINYINT(1) NOT NULL DEFAULT '0',
 
TINYINT(1) NOT NULL DEFAULT '0',
 +
 +
true|false (whether this room should be recorded, default=false)
  
 
===B_HAY_PAD===
 
===B_HAY_PAD===
 
TINYINT(1) NOT NULL DEFAULT '0',
 
TINYINT(1) NOT NULL DEFAULT '0',
 +
 +
Si hay documentos compartidos
  
 
===B_NO_USAR===
 
===B_NO_USAR===

Revisión actual del 12:45 28 oct 2021

1 Descripción

2 Campos

2.1 ID

INT(11) NOT NULL AUTO_INCREMENT,

2.2 C_NOMBRE

VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NULL DEFAULT NULL,

2.3 C_DESCRIPCION

VARCHAR(128) CHARACTER SET 'utf8' COLLATE 'utf8_spanish_ci' NULL DEFAULT NULL,

2.4 N_MAX_PUBLISHER

INT(11) NULL DEFAULT NULL,

<max number of concurrent senders> (e.g., 6 for a video

conference or 1 for a webinar)

2.5 N_DYN_USER_MAX_MINS

INT(11) NULL DEFAULT NULL,

2.6 N_DYN_USER_MAX_DELAY_HOURS

INT(11) NULL DEFAULT NULL,

2.7 ID_PLANTILLA_ASUNTO_INVITACION

INT(11) NULL DEFAULT NULL,

2.8 ID_PLANTILLA_CUERPO_INVITACION

INT(11) NULL DEFAULT NULL,

2.9 N_BITRATE

INT(11) NULL DEFAULT NULL,

<max video bitrate for senders> (e.g., 128000)

2.10 B_BITRATE_CAP

TINYINT(1) NOT NULL DEFAULT '0',

Si el valor es true el bitrate no puede sobrepasarse.

2.11 N_FIR_FREQ

INT(11) NULL DEFAULT NULL,

<send a FIR to publishers every fir_freq seconds> (0=disable)

2.12 E_AUDIO_CODEC

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanAudioCodec.

2.13 E_AUDIO_CODEC_1

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanAudioCodec.

2.14 E_AUDIO_CODEC_2

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanAudioCodec.

2.15 E_VIDEO_CODEC

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanVideoCodec.


2.16 E_VIDEO_CODEC_1

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanVideoCodec.

2.17 E_VIDEO_CODEC_2

INT(11) NULL DEFAULT NULL

Este campo usa el enumerado TConferenciaAvanVideoCodec.

2.18 B_VIDEO_SVC

TINYINT(1) NULL DEFAULT NULL,

yes|no (whether SVC support must be enabled; works only for VP9, default=no)

2.19 B_AUDIOLEVEL_EXT

TINYINT(1) NULL DEFAULT NULL,

yes|no (whether the ssrc-audio-level RTP extension must be negotiated/used or not for new publishers, default=yes)

2.20 B_AUDIOLEVEL_EVENT

TINYINT(1) NULL DEFAULT NULL,

yes|no (whether to emit event to other users or not, default=no)

2.21 N_AUDIO_ACTIVE_PACKETS

INT(11) NULL DEFAULT NULL,

100 (number of packets with audio level, default=100, 2 seconds)

2.22 N_AUDIO_LEVEL_AVERAGE

INT(11) NULL DEFAULT NULL,

25 (average value of audio level, 127=muted, 0='too loud', default=25)

2.23 B_VIDEOORIENT_EXT

TINYINT(1) NULL DEFAULT NULL,

yes|no

(whether the video-orientation RTP extension must be negotiated/used or not for new publishers, default=yes)

2.24 B_PLAYOUTDELAY_EXT

TINYINT(1) NULL DEFAULT NULL,

yes|no

(whether the playout-delay RTP extension must be negotiated/used or not for new publishers, default=yes)

2.25 B_TRANSPORT_WIDE_CC_EXT

TINYINT(1) NULL DEFAULT NULL,

yes|no

(whether the transport wide CC RTP extension must be negotiated/used or not for new publishers, default=no; note that this currently doesn't work correctly when the publisher is doing simulcasting)

2.26 B_GRABAR

TINYINT(1) NOT NULL DEFAULT '0',

true|false (whether this room should be recorded, default=false)

2.27 B_HAY_PAD

TINYINT(1) NOT NULL DEFAULT '0',

Si hay documentos compartidos

2.28 B_NO_USAR

TINYINT(1) NOT NULL DEFAULT '0',

3 índices

 PRIMARY KEY (`ID`)

4 índices réplica

Obtenido de «http://vivait-wiki.mdnova.local/wiki/vivait/index.php?title=BD.MET_PERFILES_SALA&oldid=8419»