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


--
-- Table structure for table `maesvend`
--

CREATE TABLE `maesvend` (
  `cod_vendedor` char(6) NOT NULL DEFAULT '' COMMENT 'Código Vendedor',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `conexion` text NOT NULL COMMENT 'Responsable',
  `direccion` text NOT NULL COMMENT 'Dirección',
  `cod_postal` char(10) NOT NULL DEFAULT '' COMMENT 'Código Postal',
  `poblacion` text NOT NULL COMMENT 'Población',
  `provincia` text NOT NULL COMMENT 'Provincia',
  `cod_nacion` char(4) NOT NULL DEFAULT 'ES' COMMENT 'País',
  `cif` char(30) NOT NULL DEFAULT '' COMMENT 'Cif.',
  `horario` text NOT NULL COMMENT 'Horario',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `file_firma` text NOT NULL COMMENT 'Imagen Firma',
  `telefono` text NOT NULL COMMENT 'Teléfono',
  `fax` text NOT NULL COMMENT 'Fax',
  `movil` text NOT NULL COMMENT 'Móvil',
  `email` text NOT NULL COMMENT 'Email',
  `web` text NOT NULL COMMENT 'Página Web',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `sw_helio` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Acceso Helio',
  `id_heliperf` int(11) NOT NULL DEFAULT '0' COMMENT 'Perfil',
  `password` text NOT NULL COMMENT 'Password',
  `fecha_baja` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha Baja',
  `sw_para_ven` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Operario para ventas',
  `sw_para_com` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Operario para compras',
  `sw_para_rma` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Operario para RMAs',
  UNIQUE KEY `key0` (`id_tenant`,`cod_vendedor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `maesvend` (`cod_vendedor`, `nombre`, `conexion`, `direccion`, `cod_postal`, `poblacion`, `provincia`, `cod_nacion`, `cif`, `horario`, `observaciones`, `file_firma`, `telefono`, `fax`, `movil`, `email`, `web`, `id_tenant`, `sw_helio`, `id_heliperf`, `password`, `fecha_baja`, `sw_para_ven`, `sw_para_com`, `sw_para_rma`) VALUES ('021','YOLANDA GONZALEZ','','','','','','ES','','','','','','','','','',1,0,0,'e78ff8966ed6ce227e','0000-00-00',1,1,0),('12','Montse','','','','','','ES','','','','','','','','','XAVI',1,0,0,'cfe95002421859c421e7a3097eac64b8cf','0000-00-00',1,1,0),('13','DAVID BRAVO','','','','','','ES','','','','','','','','','XAVI',1,0,0,'c9beab4793fa1630760d878e2399580042','0000-00-00',1,1,0),('19','Andrés','','','','','','ES','','','','','','','','','XAVI19',1,0,0,'c248d0b6b8c4a9ea601dfa386bf3610073','0000-00-00',1,1,0),('2','Adam','','','','','','ES','','','','','','','','','',1,0,0,'','0000-00-00',1,1,0),('20','Agusti Bernabeu','','','','','','ES','','','','','','','','','',1,0,0,'','0000-00-00',1,1,0),('21','Carmen Martín Fernández','Facturación y Caja','','','','','ES','','','','','','','','','',1,0,0,'dbd27821f874c89887','0000-00-00',1,1,0),('22','Jordi','','','','','','ES','','','','','','','','','',1,0,0,'','0000-00-00',1,1,0),('23','Isaac Gabriel','','','','','','ES','','','','','','','','','',1,0,0,'621fbb3eb306461e9c','0000-00-00',1,1,0),('24','Adri','','','','','','ES','','','','','','','','','XAVI24',1,0,0,'006f8d8289c4beb11f48f11d3dd3a2c52c','0000-00-00',1,1,0),('3','Luís  ','Tejido Técnico','','','','','ES','','Turno partido','','','','','','','',1,0,0,'1621b46928107b7418','0000-00-00',1,1,0),('31','Pedro','','','','','','ES','','','','','','','','','XAVI',1,0,0,'b3e0fabc56e2b6736f737267307962c507','0000-00-00',1,1,0),('35','Isaac','Palillería','','','','','ES','','','','','','','','','',1,0,0,'24b63979ae2f9854a1','0000-00-00',1,1,0),('38','Dérek','','','','','','ES','','','','','','','','','',1,0,0,'71f9e130d9485d456d','0000-00-00',1,1,0),('45','David Vela','','','','','','ES','','','','','','','','','',1,0,0,'3a883d404e0bcb90ec','0000-00-00',1,1,0),('47','Fabricio','','','','','','ES','','','','','','','','','',1,0,0,'7a9adf64e9d900cf79','0000-00-00',1,1,0),('55','FERRAN','','','','','','ES','','','','','','','','','',1,0,0,'977d1f31a4247c5d07','0000-00-00',1,1,0),('7','Fiti','Ensamblaje y carga de camiones','','','','','ES','','','','','','','','','',1,0,0,'0b07b255f3673e6aa9','0000-00-00',1,1,0),('8','Andrés','','','','','','ES','','','','','','','','','',1,0,0,'4034d5986e8acdd261','0000-00-00',1,1,0),('9','NEME','','','','','','ES','','','','','','','','','',1,0,0,'2080c9b72df9d728bc','0000-00-00',1,1,0),('90','Rubén','','','','','','ES','','','','','','','','','XAVI',1,0,0,'a2196099deeb292781ce06733f539c46cd','0000-00-00',1,1,0);


