-- 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_en`
--

CREATE TABLE IF NOT EXISTS `form_element_en` (
  `id` int(10) unsigned NOT NULL,
  `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;

--
-- Extraindo dados da tabela `form_element_en`
--

INSERT INTO `form_element_en` (`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, '(*)Name:', 'text', '', NULL, NULL, NULL, 0, 1, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:46:37', '2009-03-12 17:54:57', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '(*)Adress:', 'text', '', NULL, NULL, NULL, 0, 2, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:18:24', '2009-03-12 18:02:29', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Function Description:', 'textarea', NULL, '5', '25', NULL, 0, 16, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:32:29', '2009-03-12 20:11:22', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '(*)Telephone Contact:', 'text', '', NULL, NULL, NULL, 0, 4, 'a:1:{i:0;s:7:"Integer";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:19:48', '2009-03-12 18:03:30', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '(*)Date of Birth:', 'text', '', NULL, NULL, NULL, 0, 3, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:19:11', '2009-03-12 18:04:01', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Complementary Training', 'textarea', NULL, '5', '25', NULL, 0, 9, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:46:44', '2009-03-12 20:09:23', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'E-mail:', 'text', '', NULL, NULL, NULL, 0, 5, 'a:1:{i:0;s:7:"Integer";}', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-10-19 17:43:04', '2009-03-12 18:05:34', '10.0.0.140');
INSERT INTO `form_element_en` (`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, 'Personal Information', 'separator', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:18:06', '2009-03-12 18:32:56', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Qualifications', 'separator', NULL, NULL, NULL, NULL, 0, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:20:10', '2009-03-12 18:46:08', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '(*)Degree:', 'select', NULL, '1', NULL, '-----------------\r\n1st Cycle\r\n2nd Cycle\r\n3rd Cycle\r\nSecondary\r\nBachelor\r\nDegree\r\nGraduate\r\nMaster\r\nOther', 0, 7, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:21:25', '2009-03-12 18:47:53', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Profissional Information', 'text', '', NULL, NULL, NULL, 0, 8, 'N;', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:45:30', '2009-03-12 18:49:13', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Profissional Experience', 'separator', NULL, NULL, NULL, NULL, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:46:50', '2009-03-12 18:50:46', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Function', 'text', '', NULL, NULL, NULL, 0, 11, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:46:56', '2009-03-12 19:07:36', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Company', 'text', '', NULL, NULL, NULL, 0, 12, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:47:02', '2009-03-12 19:07:47', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Profissional Status', 'select', NULL, '', NULL, '-------------------\r\nAdministration\r\nFinance\r\nAccounting\r\nEngineering\r\nMarketing\r\nComputers\r\nArchitecture\r\nConstruction\r\nLawyers\r\nQuality\r\nSecurity\r\nResources\r\nOther', 0, 13, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:31:29', '2009-03-12 19:08:32', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '(*)From:', 'text', '', NULL, NULL, NULL, 0, 14, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:31:39', '2009-03-12 19:46:36', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '(*)Until:', 'text', '', NULL, NULL, NULL, 0, 15, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:31:52', '2009-03-12 19:46:58', '10.0.0.180');
INSERT INTO `form_element_en` (`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 - (*)Function performed:', 'text', '', NULL, NULL, NULL, 0, 17, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:47:47', '2009-03-12 19:55:22', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '2 - (*)Function Performed:', 'select', NULL, '', NULL, '-------------------\r\nAdministration\r\nFinance\r\nAccounting\r\nEngineering\r\nMarketing\r\nComputers\r\nArchitecture\r\nConstruction\r\nLawyers', 0, 18, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:47:34', '2009-03-12 19:56:31', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '(*)From:', 'text', '', NULL, NULL, NULL, 0, 19, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:34:13', '2009-03-12 20:13:57', '10.0.0.180');
INSERT INTO `form_element_en` (`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, '(*)Until:', 'text', '', NULL, NULL, NULL, 0, 20, 'a:1:{i:0;s:4:"Date";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:47:56', '2009-03-12 20:14:18', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Job Description:', 'textarea', NULL, '5', '25', NULL, 0, 21, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:34:51', '2009-03-12 20:14:36', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Other Information', 'separator', NULL, NULL, NULL, NULL, 0, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:35:12', '2009-03-12 20:15:16', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Willingness to Travel:', 'checkbox', NULL, NULL, NULL, 'Yes\r\nNo', 0, 23, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:35:52', '2009-03-12 20:17:28', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Information to Consider', 'textarea', NULL, '5', '25', NULL, 0, 24, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:46:26', '2009-03-12 20:18:47', '10.0.0.180');
INSERT INTO `form_element_en` (`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, 'Normalized CV File:', 'file', NULL, NULL, NULL, NULL, 0, 25, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:36:31', '2009-03-12 20:19:15', '10.0.0.180');

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

--
-- Estrutura da tabela `form_form_en`
--

CREATE TABLE IF NOT EXISTS `form_form_en` (
  `id` int(10) unsigned NOT NULL,
  `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;

--
-- Extraindo dados da tabela `form_form_en`
--

INSERT INTO `form_form_en` (`id`, `titulo`, `mensagem_sucesso`, `email`, `submissoes`, `actualizado`, `criado`, `ip`) VALUES(2, 'Careers', '<span id="result_box" class="short_text"><span style="background-color: #ffffff;" title="Your form was submitted successfully.">Your form was submitted successfully. </span><span style="background-color: #ffffff;" title="Thank you for your interest in collaborating with our team.">Thank you for your interest in collaborating with our team.</span></span>', 'info@goweb.pt', 0, '2009-12-18 12:44:35', '2009-03-09 10:44:23', '10.0.0.180');