--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------


--
-- Table structure for table `quliqtoxsel`
--

CREATE TABLE `quliqtoxsel` (
  `id_quliqtox` int(11) NOT NULL DEFAULT '0' COMMENT 'Id. Conector',
  `linea` int(11) NOT NULL DEFAULT '0' COMMENT 'Línea',
  `sw_insert_p` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Do Push en Insert Qup',
  `sw_update_p` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Do Push en Update Qup',
  `sw_delete_p` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Do Push en Delete Qup',
  `request` text NOT NULL COMMENT 'Parámetros request',
  `mapping` text NOT NULL COMMENT 'Mapping',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `id_quliqtoxsel` int(11) NOT NULL DEFAULT '0' COMMENT 'Línea',
  `block` int(11) NOT NULL DEFAULT '0' COMMENT 'Tamaño bloques',
  `ident` char(50) NOT NULL DEFAULT '' COMMENT 'Identificador',
  `idx_x` text NOT NULL COMMENT 'ID externo coma-sep',
  `idx_q` text NOT NULL COMMENT 'ID Quartup coma-sep',
  `sw_insert_g` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Do Insert Qup en Get',
  `sw_update_g` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Do Update Qup en Get',
  `sw_delete_g` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Do Delete Qup en Get',
  `qry_w` text NOT NULL COMMENT 'Parámetros',
  `blk_w` int(11) NOT NULL DEFAULT '10' COMMENT 'Nº rows página envío/push',
  `qry_r` text NOT NULL COMMENT 'Parámetros',
  `blk_r` int(11) NOT NULL DEFAULT '10' COMMENT 'Nº rows página recep/get',
  `map_w` text NOT NULL COMMENT 'Mapeo envíos',
  `map_r` text NOT NULL COMMENT 'Mapeo recepción',
  `sw_activo` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Activo',
  `sql_table` char(30) NOT NULL DEFAULT '' COMMENT 'Tabla',
  `construc_pars` text NOT NULL COMMENT 'Pars. constructor',
  `php_filter_p` text NOT NULL COMMENT 'Filtro php para push records &nbsp;<br/>($q=record, sin sql-rows)',
  `array_sql_cols_p` text NOT NULL COMMENT 'Array add sql cols para push',
  `qry_one_w` text NOT NULL COMMENT 'Segmento URL envío/push 1 row',
  `qry_one_r` text NOT NULL COMMENT 'Segmento URL recep/get 1 row',
  `sw_push_raw` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Envío/push RAW (solo GtL)',
  `php_filter_g` text NOT NULL COMMENT 'Filtro php para get records &nbsp;<br/>($r=record)',
  `array_cols_sel_p` text NOT NULL COMMENT 'Array cols select para push',
  `sw_manual_p` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Decidir manualmente qué registros enviar',
  `sw_reg_prev_p` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Los evals de push necesitan&nbsp;<br>el registro anterior ($a)',
  `php_filter_sel_p` text NOT NULL COMMENT 'Filtro php para push records &nbsp;<br/>($q=sql cols)',
  `sw_sws_tit01_p` text NOT NULL COMMENT 'Título indicador 1',
  `sw_sws_tit02_p` text NOT NULL COMMENT 'Título indicador 2',
  `sw_sws_tit03_p` text NOT NULL COMMENT 'Título indicador 3',
  `sw_sws_tit04_p` text NOT NULL COMMENT 'Título indicador 4',
  `sw_link_en_table` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Ver enlace en tabla',
  `method_w` char(1) NOT NULL DEFAULT '' COMMENT 'Method (solo API)',
  `response_w` text NOT NULL COMMENT 'Tratemiento respuesta (solo API)',
  `response_r` text NOT NULL COMMENT 'Tratemiento respuesta (solo API)',
  `global_w` char(250) NOT NULL DEFAULT '' COMMENT 'Almacenar en variable',
  `sw_sws_filter_sql` text NOT NULL COMMENT 'Filtro SQL (alias=a)',
  `sw_log` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Grabar Log',
  `sw_q2x_method` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Método de llamada',
  `sw_q2x_when` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Cuándo se llama',
  `sw_q2x_rollback` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Rollback caller',
  `php_eval_w` text NOT NULL COMMENT 'Expresión PHP a evaluar',
  `php_eval_r` text NOT NULL COMMENT 'Expresión PHP a evaluar',
  `sw_get_false_skip` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Return false en campo get salta registro',
  UNIQUE KEY `key0` (`id_tenant`,`id_quliqtox`,`ident`),
  UNIQUE KEY `key1` (`id_tenant`,`id_quliqtox`,`id_quliqtoxsel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quliqtoxsel`
--
-- WHERE:  id_tenant='1'



