Diferencia entre revisiones de «BD.MET PERFILES SALA»

De VIVAitwiki
Ir a la navegaciónIr a la búsqueda
 
(No se muestran 10 ediciones intermedias de 2 usuarios)
Línea 1: Línea 1:
 
==Descripción==
 
==Descripción==
  
−
; Campos del archivo de configuración que no he localizado
 
  
−
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)
 
−
 
−
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===
Línea 53: Línea 37:
  
 
<max video bitrate for senders> (e.g., 128000)
 
<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===
Línea 98: Línea 87:
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
  
−
yes|no (whether the ssrc-audio-level RTP extension must
+
yes|no  
−
      be negotiated/used or not for new publishers, default=yes)
+
(whether the ssrc-audio-level RTP extension must be negotiated/used or not for new publishers, default=yes)
  
 
===B_AUDIOLEVEL_EVENT===
 
===B_AUDIOLEVEL_EVENT===
Línea 119: Línea 108:
 
TINYINT(1) NULL DEFAULT NULL,
 
TINYINT(1) NULL DEFAULT NULL,
  
−
yes|no (whether the video-orientation RTP extension must
+
yes|no  
−
        be negotiated/used or not for new publishers, default=yes)
+
 
 +
(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
+
yes|no  
−
        be negotiated/used or not for new publishers, default=yes)
+
 
 +
(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===
Línea 135: Línea 133:
 
===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»