-- 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(5, 1, 'Subject:', 'select', NULL, '1', NULL, '--------------------\r\nInformation Request\r\nContact Request', 0, 39, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:14:13', '2009-03-11 17:50: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(2, 1, '(*)Name:', 'text', '30', NULL, NULL, NULL, 0, 36, 'N;', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:12:36', '2009-03-11 17:33:07', '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(3, 1, '(*)Phone Number:', 'text', '30', NULL, NULL, NULL, 0, 37, 'a:1:{i:0;s:7:"Integer";}', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:14:27', '2009-03-11 17:48:38', '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(4, 1, 'E-mail adress:', 'text', '30', NULL, NULL, NULL, 0, 38, 'a:1:{i:0;s:5:"Email";}', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:14:19', '2009-03-11 17:49:03', '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(7, 1, '(*)Mensage:', 'textarea', NULL, '5', '30', NULL, 0, 40, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2009-12-18 12:14:04', '2009-03-11 18:53:25', '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(1, 'Contact', 'Your form was submitted successfully. Thanks for the contact.', 'info@goweb.pt', 0, '2009-12-18 12:26:54', '2009-03-09 10:42:56', '10.0.0.180');