-- phpMyAdmin SQL Dump
-- version 2.11.5
-- http://www.phpmyadmin.net
--
-- Máquina: localhost
-- Data de Criação: 19-Jan-2010 às 12:38
-- Versão do servidor: 5.0.45
-- versão do PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de Dados: `sitemanager5`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `form_element_es`
--

CREATE TABLE IF NOT EXISTS `form_element_es` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `form_id` int(10) unsigned NOT NULL,
  `label` varchar(200) default NULL,
  `element` varchar(20) NOT NULL,
  `size` varchar(3) default NULL,
  `rows` varchar(2) default NULL,
  `cols` varchar(2) default NULL,
  `options` longtext,
  `multiple` tinyint(1) default '0',
  `ordem` int(11) default NULL,
  `validators` longtext,
  `required` tinyint(1) default NULL,
  `db_type` varchar(50) default NULL,
  `db_host` varchar(50) default NULL,
  `db_user` varchar(50) default NULL,
  `db_pass` varchar(50) default NULL,
  `db_name` varchar(50) default NULL,
  `db_table` varchar(50) default NULL,
  `db_table_value` varchar(50) default NULL,
  `db_table_desc` varchar(50) default NULL,
  `clausulas_extras` longtext,
  `actualizado` datetime NOT NULL,
  `criado` datetime NOT NULL,
  `ip` char(15) default NULL,
  PRIMARY KEY  (`id`),
  KEY `form_id` (`form_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;

--
-- Extraindo dados da tabela `form_element_es`
--

INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(14, 2, 'Nombre:', 'text', '', NULL, NULL, NULL, 0, 1, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:40:30', '2009-03-12 17:54:57', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(16, 2, 'Dirección:', 'text', '', NULL, NULL, NULL, 0, 2, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:30:42', '2009-03-12 18:02:29', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(18, 2, 'Teléfono de contacto:', 'text', '', NULL, NULL, NULL, 0, 4, 'a:1:{i:0;s:7:"Integer";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:31:29', '2009-03-12 18:03:30', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(19, 2, 'Fecha de nacimiento:', 'text', '', NULL, NULL, NULL, 0, 3, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:31:08', '2009-03-12 18:04:01', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(34, 2, 'Formación adicional:', 'textarea', NULL, '5', '25', NULL, 0, 9, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:37:22', '2009-03-12 20:09:23', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(21, 2, 'Email de contacto:', 'text', '', NULL, NULL, NULL, 0, 5, 'a:1:{i:0;s:7:"Integer";}', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:32:01', '2009-03-12 18:05:34', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(22, 2, 'Información Personal', 'separator', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:29:42', '2009-03-12 18:32:56', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(23, 2, 'Cualificaciones', 'separator', NULL, NULL, NULL, NULL, 0, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:33:41', '2009-03-12 18:46:08', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(24, 2, 'Titulación:', 'select', NULL, '1', NULL, '-----------------\r\n1 º Ciclo\r\n2 º Ciclo\r\n3er Ciclo\r\nSecundaria\r\nLicenciatura\r\nGrado\r\nPostgrado\r\nMaestro\r\nOtro', 0, 7, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:33:19', '2009-03-12 18:47:53', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(25, 2, 'Categoría profesional', 'text', '', NULL, NULL, NULL, 0, 8, 'N;', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:35:56', '2009-03-12 18:49:13', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(26, 2, 'Experiencia profesional', 'separator', NULL, NULL, NULL, NULL, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:37:53', '2009-03-12 18:50:46', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(27, 2, '1 - Función de trabajo:', 'text', '', NULL, NULL, NULL, 0, 11, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:38:28', '2009-03-12 19:07:36', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(28, 2, 'Empresa:', 'text', '', NULL, NULL, NULL, 0, 12, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:38:45', '2009-03-12 19:07:47', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(29, 2, 'Área Profesional', 'select', NULL, '', NULL, '-------------------\r\nAdministración\r\nFinanzas\r\nContabilidad\r\nIngeniería\r\nComercialización\r\nComputadoras\r\nArquitectura\r\nConstrucción\r\nAbogados\r\nCalidad\r\nSeguridad\r\nRecursos\r\nOtro', 0, 13, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:39:42', '2009-03-12 19:08:32', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(30, 2, 'De:', 'text', '', NULL, NULL, NULL, 0, 14, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:40:07', '2009-03-12 19:46:36', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(31, 2, 'Hasta:', 'text', '', NULL, NULL, NULL, 0, 15, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:40:47', '2009-03-12 19:46:58', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(32, 2, '2 - La función de trabajo:', 'text', '', NULL, NULL, NULL, 0, 17, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:43:03', '2009-03-12 19:55:22', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(33, 2, 'Área Profesional', 'select', NULL, '', NULL, '-------------------\r\nAdministración\r\nFinanzas\r\nContabilidad\r\nIngeniería\r\nComercialización\r\nComputadoras\r\nArquitectura\r\nConstrucción\r\nAbogados', 0, 18, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:43:50', '2009-03-12 19:56:31', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(35, 2, 'Descripción de la función:', 'textarea', NULL, '5', '25', NULL, 0, 16, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:42:32', '2009-03-12 20:11:22', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(36, 2, 'De:', 'text', '', NULL, NULL, NULL, 0, 19, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:44:30', '2009-03-12 20:13:57', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(37, 2, 'Hasta:', 'text', '', NULL, NULL, NULL, 0, 20, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:44:21', '2009-03-12 20:14:18', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(38, 2, 'Descripción de la función:', 'textarea', NULL, '5', '25', NULL, 0, 21, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:44:54', '2009-03-12 20:14:36', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(39, 2, 'Otros datos', 'separator', NULL, NULL, NULL, NULL, 0, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:45:12', '2009-03-12 20:15:16', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(40, 2, 'Disponibilidad para viajar: ', 'checkbox', NULL, NULL, NULL, 'Si', 0, 23, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:45:51', '2009-03-12 20:17:28', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(41, 2, 'Información a tener en cuenta:', 'textarea', NULL, '5', '25', NULL, 0, 24, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:46:09', '2009-03-12 20:18:47', '10.0.0.181');
INSERT INTO `form_element_es` (`id`, `form_id`, `label`, `element`, `size`, `rows`, `cols`, `options`, `multiple`, `ordem`, `validators`, `required`, `db_type`, `db_host`, `db_user`, `db_pass`, `db_name`, `db_table`, `db_table_value`, `db_table_desc`, `clausulas_extras`, `actualizado`, `criado`, `ip`) VALUES(42, 2, 'Archivo Curriculum Vitae Normalizado:', 'file', NULL, NULL, NULL, NULL, 0, 25, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2010-01-13 15:46:53', '2009-03-12 20:19:15', '10.0.0.181');

--
-- Estrutura da tabela `form_form_es`
--

CREATE TABLE IF NOT EXISTS `form_form_es` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `titulo` varchar(200) NOT NULL,
  `mensagem_sucesso` longtext NOT NULL,
  `email` varchar(200) default NULL,
  `submissoes` int(11) default '0',
  `actualizado` datetime NOT NULL,
  `criado` datetime NOT NULL,
  `ip` char(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Extraindo dados da tabela `form_form_es`
--

INSERT INTO `form_form_es` (`id`, `titulo`, `mensagem_sucesso`, `email`, `submissoes`, `actualizado`, `criado`, `ip`) VALUES(2, 'Carreras', '<span id="result_box" class="short_text"><span title="O seu formul&aacute;rio foi submetido com sucesso.">El formulario se ha enviado correctamente. </span><span style="background-color: #ffffff;" title="Agradecemos o seu interesse em colaborar com a nossa Equipa.">Gracias por su inter&eacute;s en colaborar con nuestro equipo.</span></span>', 'info@goweb.pt', 0, '2010-01-13 15:25:14', '2009-03-09 10:44:23', '10.0.0.181');
