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


--
-- Table structure for table `quemftps`
--

CREATE TABLE `quemftps` (
  `id_quemftps` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº servidor FTP',
  `nombre` char(250) NOT NULL DEFAULT '' COMMENT 'Descripción',
  `sw_protocolo` char(1) NOT NULL DEFAULT '1' COMMENT 'Protocolo',
  `ftp_host` text NOT NULL COMMENT 'Servidor FTP',
  `ftp_port` int(11) NOT NULL DEFAULT '0' COMMENT 'Puerto FTP',
  `ftp_root` text NOT NULL COMMENT 'Directorio',
  `ftp_user` text NOT NULL COMMENT 'Usuario FTP',
  `ftp_password` text NOT NULL COMMENT 'Contraseña FTP',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `sw_passive` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Modo Pasivo',
  UNIQUE KEY `key0` (`id_tenant`,`id_quemftps`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `quemftps` (`id_quemftps`, `nombre`, `sw_protocolo`, `ftp_host`, `ftp_port`, `ftp_root`, `ftp_user`, `ftp_password`, `id_tenant`, `sw_passive`) VALUES (1,'temporal','3','95.217.59.110',2122,'/home/ftpuser/temp','ftpuser','611415e6463c3209ae4a8f780cc5b107e3',1,1);


