-- http://www.phpmyadmin.net
--
-- Máquina: localhost
-- Data de Criação: 11-Nov-2009 às 20:52
-- Versão do servidor: 5.0.81
-- versão do PHP: 5.2.6


--
-- Base de Dados: `amcarv_amcarvalho`
--

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

--
-- Estrutura da tabela `catalog`
--

CREATE TABLE IF NOT EXISTS `catalog` (
  `id` int(5) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `active` int(1) unsigned NOT NULL default '0',
  `startDate` date NOT NULL default '0000-00-00',
  `endDate` date NOT NULL default '0000-00-00',
  `link` varchar(120) default NULL,
  `ordered` tinyint(3) NOT NULL default '0',
  `categoryId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;

--
-- Extraindo dados da tabela `catalog`
--

INSERT INTO `catalog` (`id`, `name`, `description`, `active`, `startDate`, `endDate`, `link`, `ordered`, `categoryId`) VALUES
(67, 'REVISTAS', 'AKDSFLISJRLWAFÇAKMGFFDMG.X-DFGBGX-BBXCVBNBCBBVBCV\r\nFGDZGDFGDFHGHFGJH\r\nDFGDFGDFGXFHFHFGHGHFFGHFGHHFGHFV', 1, '0000-00-00', '0000-00-00', NULL, 1, 1);

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

--
-- Estrutura da tabela `company`
--

CREATE TABLE IF NOT EXISTS `company` (
  `id` int(10) NOT NULL auto_increment,
  `module` int(10) NOT NULL default '0',
  `name` varchar(100) default '',
  `phone1` varchar(30) default '',
  `phone2` varchar(30) default '',
  `fax` varchar(30) default '',
  `address1` varchar(50) default '',
  `address2` varchar(50) default '',
  `city` varchar(30) default '',
  `state` varchar(30) default '',
  `zip` varchar(11) default '',
  `primaryUrl` varchar(255) default '',
  `owner` int(11) NOT NULL default '0',
  `description` text NOT NULL,
  `type` int(3) NOT NULL default '0',
  `email` varchar(255) default NULL,
  `custom` longtext,
  PRIMARY KEY  (`id`),
  KEY `idx_cpy1` (`owner`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Extraindo dados da tabela `company`
--

INSERT INTO `company` (`id`, `module`, `name`, `phone1`, `phone2`, `fax`, `address1`, `address2`, `city`, `state`, `zip`, `primaryUrl`, `owner`, `description`, `type`, `email`, `custom`) VALUES
(1, 0, 'AMCarvalho', '111111111', '', '111111111', 'rua rua', '', 'Leiria', '', '2043-707', '', 1, '', 1, 'geral@amcarvalho.pt', NULL);

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

--
-- Estrutura da tabela `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  `type` varchar(255) NOT NULL default '',
  `cGroup` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `nameConfig` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=133 ;

--
-- Extraindo dados da tabela `config`
--

INSERT INTO `config` (`id`, `name`, `value`, `type`, `cGroup`) VALUES
(115, 'local', 'pt', 'text', 'sys'),
(116, 'style', 'default', 'text', 'sys'),
(117, 'company', 'AMCarvalho', 'text', 'sys'),
(118, 'title', 'AMCarvalho', 'text', 'sys'),
(119, 'site', 'trivus-si.com', 'text', 'sys'),
(120, 'email_prefix', '[trivus-si]', 'text', 'sys'),
(121, 'admin_username', 'admin', 'text', 'sys'),
(122, 'username_min_len', '4', 'text', 'sys'),
(123, 'password_min_len', '4', 'text', 'sys'),
(124, 'log_changes', 'false', 'checkbox', 'sys'),
(125, 'locale_warn', 'false', 'checkbox', 'sys'),
(126, 'numero_menus', '6', 'text', 'sys'),
(127, 'logo', 'logo.jpg', 'text', 'sys'),
(128, 'numero_submenus', '4', 'text', 'sys'),
(129, 'default_m', 'catalog', 'text', 'sys'),
(130, 'default_a', 'index', 'text', 'sys'),
(131, 'default_ma', 'freepage', 'text', 'sys'),
(132, 'default_aa', 'index', 'text', 'sys');

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

--
-- Estrutura da tabela `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(11) NOT NULL auto_increment,
  `firstName` varchar(30) default NULL,
  `lastName` varchar(30) default NULL,
  `orderBy` varchar(30) NOT NULL default '',
  `title` varchar(50) default NULL,
  `birthday` date default NULL,
  `job` varchar(255) default NULL,
  `company` varchar(100) NOT NULL default '',
  `department` tinytext,
  `type` varchar(20) default NULL,
  `email` varchar(255) default NULL,
  `email2` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `phone` varchar(30) default NULL,
  `phone2` varchar(30) default NULL,
  `fax` varchar(30) default NULL,
  `mobile` varchar(30) default NULL,
  `address1` varchar(60) default NULL,
  `address2` varchar(60) default NULL,
  `city` varchar(30) default NULL,
  `state` varchar(30) default NULL,
  `zip` varchar(11) default NULL,
  `country` varchar(30) default NULL,
  `jabber` varchar(255) default NULL,
  `icq` varchar(20) default NULL,
  `msn` varchar(255) default NULL,
  `yahoo` varchar(255) default NULL,
  `aol` varchar(30) default NULL,
  `notes` text,
  `icon` varchar(20) default 'obj/contact',
  `owner` int(10) unsigned default '0',
  `private` tinyint(3) unsigned default '0',
  PRIMARY KEY  (`id`),
  KEY `idx_oby` (`orderBy`),
  KEY `idx_co` (`company`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Extraindo dados da tabela `contact`
--

INSERT INTO `contact` (`id`, `firstName`, `lastName`, `orderBy`, `title`, `birthday`, `job`, `company`, `department`, `type`, `email`, `email2`, `url`, `phone`, `phone2`, `fax`, `mobile`, `address1`, `address2`, `city`, `state`, `zip`, `country`, `jabber`, `icq`, `msn`, `yahoo`, `aol`, `notes`, `icon`, `owner`, `private`) VALUES
(1, 'Luciano', 'Letra', '', NULL, NULL, NULL, '', NULL, NULL, 'admin@localhost', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 0, 0),
(2, 'AM', 'CArvalho', '', NULL, NULL, NULL, '1', NULL, NULL, 'geral@amcarvalho.pt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0),
(3, 'AM', 'Carvalho', '', NULL, NULL, NULL, '1', NULL, NULL, 'geral@amcarvalho.pt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0),
(4, 'AM', 'Carvalho', '', NULL, NULL, NULL, '1', NULL, NULL, 'geral@amcarvalho.pt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0),
(5, 'AM', 'Carvalho', '', NULL, '0000-00-00', NULL, '1', NULL, NULL, 'geral@amcarvalho.pt', NULL, NULL, '', '', NULL, '', '', '', '', '', '', '', NULL, '', NULL, NULL, '', NULL, 'obj/contact', 0, 0),
(6, 'AM', 'Carvalho', '', NULL, NULL, NULL, '1', NULL, NULL, 'geral@am-carvalho.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0);

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

--
-- Estrutura da tabela `file`
--

CREATE TABLE IF NOT EXISTS `file` (
  `id` int(19) NOT NULL auto_increment,
  `name` varchar(128) NOT NULL default '',
  `title` varchar(128) NOT NULL default '',
  `description` mediumtext NOT NULL,
  `owner` int(11) default '0',
  `date` varchar(50) default NULL,
  `size` int(11) default '0',
  `parentId` int(11) NOT NULL default '0',
  `moduleId` int(11) NOT NULL default '0',
  `category` int(11) default '0',
  `ext` varchar(128) NOT NULL,
  `url` varchar(254) NOT NULL default '',
  `thumbUrl` varchar(254) default NULL,
  `published` tinyint(1) NOT NULL default '0',
  `firstimage` tinyint(1) default NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_file_parentId` (`parentId`),
  KEY `idx_file_moduleId` (`moduleId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;

--
-- Extraindo dados da tabela `file`
--


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

--
-- Estrutura da tabela `freepage`
--

CREATE TABLE IF NOT EXISTS `freepage` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `ordered` int(11) NOT NULL default '0',
  `parentId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Extraindo dados da tabela `freepage`
--

INSERT INTO `freepage` (`id`, `name`, `description`, `ordered`, `parentId`) VALUES
(6, 'Contactos', 'A.M.&nbsp; CARVALHO&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\nDISTRIBUIDOR INTERNACIONAL DE PUBLICA&Ccedil;&Otilde;ES&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\nRUA DO CENTRO N.- 293&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\nURBANIZA&Ccedil;&Atilde;O MIRADOURO&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\n4760-502 GONDIFELOS&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\nTEL.( 00351 ) 914562522&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\nFAX.(&nbsp; 00351) 2529556230&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\n&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\nEmail:&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;<br />\r\n<br />\r\n', 4, 0),
(9, 'Quem Somos', 'DISTRIBUIDOR INTERNACIONAL DE PUBLICA&Ccedil;&Otilde;ES<br />\r\n<br />\r\n<br />\r\nA Empresa A M Carvalho &eacute; uma empresa direccionada para a comercializa&ccedil;&atilde;o de todo o tipo de publica&ccedil;&otilde;es <br />\r\nPortuguesas junto de distribuidores em todo o mundo.<br />\r\nTrabalhamos com uma vasta gama de publica&ccedil;&otilde;es e temos uma politica empresarial baseada na maior<br />\r\nresponsabilidade, na pontualidade e no cumprimento das exig&ecirc;ncias dos nossos clientes.<br />\r\nProcurando sempre as melhores condi&ccedil;&otilde;es a todos os n&iacute;veis colocamos sempre os nossos clientes em primeiro<br />\r\nplano criando assim da nossa empresa uma imagem de total idoneidade<br />\r\n<br />\r\nAos comerciantes / distribuidores espalhados por todo o mundo estamos sempre disponiveis para contactos <br />\r\nacerca das nossas ofertas e dos nossos servi&ccedil;os.<br />\r\n<br />\r\n', 5, 0),
(2, 'Produtos', '<p>\r\n<strong><span style="font-size: 10pt; color: #333333; font-family: Tahoma">Produtos</span></strong>\r\n</p>\r\n', 2, 0),
(3, 'Empresa', '<p>\r\nDISTRIBUIDOR INTERNACIONAL DE PUBLICA&Ccedil;&Otilde;ES<br />\r\n<br />\r\n<br />\r\nA Empresa A M Carvalho &eacute; uma empresa direccionada para a comercializa&ccedil;&atilde;o de todo o tipo de publica&ccedil;&otilde;es <br />\r\nPortuguesas junto de distribuidores em todo o mundo.<br />\r\nTrabalhamos com uma vasta gama de publica&ccedil;&otilde;es e temos uma politica empresarial baseada na maior<br />\r\nresponsabilidade, na pontualidade e no cumprimento das exig&ecirc;ncias dos nossos clientes.<br />\r\nProcurando sempre as melhores condi&ccedil;&otilde;es a todos os n&iacute;veis colocamos sempre os nossos clientes em primeiro<br />\r\nplano criando assim da nossa empresa uma imagem de total idoneidade<br />\r\n<br />\r\nAos comerciantes / distribuidores espalhados por todo o mundo estamos sempre disponiveis para contactos <br />\r\nacerca das nossas ofertas e dos nossos servi&ccedil;os.<br />\r\n</p>\r\n', 1, 0),
(4, 'Serviços', '<p>\r\nCONDI&Ccedil;&Otilde;ES DE SERVI&Ccedil;O<br />\r\nFazemos envios para todo o mundo dos nossos produtos , sendo os custos de envio a encargo do cliente<br />\r\nO envio da mercadoria &eacute; feito via terreste ou aerea conforme o cliente desejar sendo o local de carga da respectiva mercadoria acordado com o cliente<br />\r\nO fornecimento regular ou ocasional para o estrangeiro &eacute; possivel apenas mediante o cumprimento dos requesitos necessarios <br />\r\nimpostos pela nossa empresa ( pe&ccedil;a informa&ccedil;&otilde;es sobre as nossas condi&ccedil;oes )<br />\r\n</p>\r\n<p>\r\nATENDEMOS PEDIDOS DE LIVROS PORTUGUESES DAS MAIS DIVERSAS EDITORAS&nbsp; A PRE&Ccedil;OS PARA REVENDA<br />\r\n</p>\r\n', 3, 0),
(8, 'introduÃ§Ã£o', '<blockquote>\r\n	<p>\r\n	<span style="font-size: 10pt; font-family: arial,helvetica,sans-serif; color: #660000"><strong>Distribuidor Internacional de Publica&ccedil;&otilde;es</strong><br />\r\n	<br />\r\n	A Empresa A M Carvalho &eacute; uma empresa direccionada para a comercializa&ccedil;&atilde;o de todo o tipo de publica&ccedil;&otilde;es portuguesas junto de distribuidores em todo o mundo.\r\n	Trabalhamos com uma vasta gama de publica&ccedil;&otilde;es e temos... <a href="http://am-carvalho.com/index.php?m=freepage&amp;a=view&amp;id=3">Ler +</a> </span><br />\r\n	</p>\r\n</blockquote>\r\n', 6, 1);

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

--
-- Estrutura da tabela `module`
--

CREATE TABLE IF NOT EXISTS `module` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `directory` varchar(64) NOT NULL default '',
  `version` varchar(10) NOT NULL default '',
  `setup` varchar(64) NOT NULL default '',
  `type` varchar(64) NOT NULL default '',
  `active` int(1) unsigned NOT NULL default '0',
  `uiActive` int(1) unsigned NOT NULL default '0',
  `uiName` varchar(20) NOT NULL default '',
  `icon` varchar(64) NOT NULL default '',
  `ordered` tinyint(3) NOT NULL default '0',
  `position` varchar(5) default 'left',
  `description` varchar(255) NOT NULL default '',
  `frame` tinyint(1) default '0',
  PRIMARY KEY  (`id`,`directory`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Extraindo dados da tabela `module`
--

INSERT INTO `module` (`id`, `name`, `directory`, `version`, `setup`, `type`, `active`, `uiActive`, `uiName`, `icon`, `ordered`, `position`, `description`, `frame`) VALUES
(1, 'User Administration', 'user', '1.0.0', '', 'core', 1, 0, 'User Admin', 'helix-setup-users.png', 0, '', '', 0),
(2, 'System Administration', 'system', '1.0.0', '', 'core', 1, 0, 'System Admin', '48_my_computer.png', 1, '', '', 0),
(3, 'Help', 'help', '1.00', 'Setup.php', 'core', 0, 0, 'Help', '', 2, '', '', 0),
(4, 'freepage', 'freepage', '1.0.0', 'Setup', 'user', 1, 0, 'Institucional', 'freepage.png', 4, 'left', 'module text', 1),
(8, 'catalog', 'catalog', '1.0.0', 'Setup', 'user', 1, 0, 'catalogs', 'catalog.png', 6, 'left', 'module que permite destacar algo de importante', 1),
(6, 'Company', 'company', '1.0.0', 'Setup', 'user', 1, 0, 'My company', 'companies.gif', 5, 'left', 'Porque queremos servi-lo melhor!', 0);

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

--
-- Estrutura da tabela `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(11) NOT NULL auto_increment,
  `permission_user` int(11) NOT NULL default '0',
  `permission_grant_on` varchar(12) NOT NULL default '',
  `permission_item` int(11) NOT NULL default '0',
  `permission_value` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_pgrant_on` (`permission_grant_on`,`permission_item`,`permission_user`),
  KEY `idx_puser` (`permission_user`),
  KEY `idx_pvalue` (`permission_value`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Extraindo dados da tabela `permissions`
--

INSERT INTO `permissions` (`id`, `permission_user`, `permission_grant_on`, `permission_item`, `permission_value`) VALUES
(1, 1, 'all', -1, -1);

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

--
-- Estrutura da tabela `syskeys`
--

CREATE TABLE IF NOT EXISTS `syskeys` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(48) NOT NULL default '',
  `label` varchar(255) NOT NULL default '',
  `type` int(1) unsigned NOT NULL default '0',
  `sep1` char(2) default '\n',
  `sep2` char(2) NOT NULL default '|',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `idx_syskey_name` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Extraindo dados da tabela `syskeys`
--

INSERT INTO `syskeys` (`id`, `name`, `label`, `type`, `sep1`, `sep2`) VALUES
(1, 'SelectList', 'Enter values for list', 0, '\n', '|'),
(2, 'CustomField', 'Serialized array in the following format:\r\n<KEY>|<SERIALIZED ARRAY>\r\n\r\nSerialized Array:\r\n[type] => text | checkbox | select | textarea | label\r\n[name] => <Field''s name>\r\n[options] => <html capture options>\r\n[selects] => <options for select and checkbox>', 0, '\n', '|'),
(3, 'ColorSelection', 'Hex color values for type=>color association.', 0, '\n', '|');

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

--
-- Estrutura da tabela `sysvals`
--

CREATE TABLE IF NOT EXISTS `sysvals` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `keyId` int(10) unsigned NOT NULL default '0',
  `title` varchar(48) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ;

--
-- Extraindo dados da tabela `sysvals`
--

INSERT INTO `sysvals` (`id`, `keyId`, `title`, `value`) VALUES
(1, 1, 'typeOfUnit', '0|Nenhum\r\n1|UnitÃ¡rio\r\n2|Quilo\r\n'),
(76, 1, 'headline', '0|normal\r\n1|destaque\n'),
(5, 1, 'title', '0|-------\r\n1|Sr.\r\n2|Sra.\r\n3|Srta.\r\n4|Dr.\r\n5|Dra.\r\n6|Arq.\r\n7|Arqa.\r\n8|Mestre\r\n9|Eng.\r\n10|Enga.\r\n11|Prof.\r\n12|Prof Dr.\r\n13|Prof Dra.\r\n'),
(77, 1, 'category', '0|\r\n1|revistas\r\n2|jornais\r\n3|passatempos\r\n4|romances harlequin\r\n5|livros\r\n');

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

--
-- Estrutura da tabela `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL auto_increment,
  `contactId` int(11) NOT NULL default '0',
  `username` varchar(255) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `parent` int(11) NOT NULL default '0',
  `type` tinyint(3) NOT NULL default '0',
  `companyId` int(11) default '0',
  `owner` int(11) NOT NULL default '0',
  `signature` text,
  PRIMARY KEY  (`id`),
  KEY `idx_uid` (`username`),
  KEY `idx_pwd` (`password`),
  KEY `idx_user_parent` (`parent`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Extraindo dados da tabela `user`
--

#INSERT INTO `user` (`id`, `contactId`, `username`, `password`, `parent`, `type`, `companyId`, `owner`, `signature`) VALUES
#(1, 1, 'admin', '76a2173be6393254e72ffa4d6df1030a', 0, 1, 0, 0, ''),
#(2, 5, 'amcarvalho', '94f5a09513abc98f5318ac8beadb23e6', 0, 2, 0, 0, NULL),
#(3, 6, 'amcarv', 'f6213989501349a478be935ab3098541', 0, 2, 0, 0, NULL);

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

--
-- Estrutura da tabela `user_access_log`
--

CREATE TABLE IF NOT EXISTS `user_access_log` (
  `user_access_log_id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned NOT NULL,
  `user_ip` varchar(15) NOT NULL,
  `date_time_in` datetime default '0000-00-00 00:00:00',
  `date_time_out` datetime default '0000-00-00 00:00:00',
  `date_time_last_action` datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user_access_log_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Extraindo dados da tabela `user_access_log`
--

INSERT INTO `user_access_log` (`user_access_log_id`, `user_id`, `user_ip`, `date_time_in`, `date_time_out`, `date_time_last_action`) VALUES
(1, 1, '85.240.175.67', '2009-01-10 18:12:55', '2009-01-10 18:13:21', '0000-00-00 00:00:00'),
(2, 1, '85.240.175.67', '2009-01-10 18:13:29', '2009-01-10 18:17:36', '0000-00-00 00:00:00'),
(3, 2, '85.240.175.67', '2009-01-10 18:17:49', '2009-01-10 18:19:09', '0000-00-00 00:00:00'),
(4, 2, '85.240.175.67', '2009-01-10 18:19:13', '2009-01-10 18:20:24', '0000-00-00 00:00:00'),
(5, 2, '85.240.175.67', '2009-01-10 18:20:35', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 1, '85.240.175.67', '2009-01-12 17:08:14', '2009-01-30 19:19:50', '0000-00-00 00:00:00'),
(7, 1, '85.242.241.114', '2009-01-19 19:44:54', '2009-01-30 19:19:50', '0000-00-00 00:00:00'),
(8, 1, '85.242.243.97', '2009-01-30 19:19:38', '2009-01-30 19:19:50', '0000-00-00 00:00:00'),
(9, 1, '85.242.243.97', '2009-01-30 19:20:13', '2009-01-30 19:21:00', '0000-00-00 00:00:00'),
(10, 1, '85.242.243.97', '2009-01-30 19:21:24', '2009-01-30 19:21:50', '0000-00-00 00:00:00'),
(11, 1, '85.242.243.97', '2009-01-30 19:22:24', '2009-01-30 19:24:12', '0000-00-00 00:00:00'),
(12, 3, '85.242.243.97', '2009-01-30 19:24:21', '2009-01-30 20:16:06', '0000-00-00 00:00:00'),
(13, 3, '84.73.223.176', '2009-01-30 19:46:04', '2009-01-30 20:16:06', '0000-00-00 00:00:00'),
(14, 3, '85.242.243.97', '2009-02-02 16:39:17', '2009-02-02 16:39:33', '0000-00-00 00:00:00'),
(15, 3, '85.242.243.97', '2009-02-02 16:39:44', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 1, '85.243.36.205', '2009-02-07 16:55:14', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 1, '85.243.36.205', '2009-02-07 17:00:01', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 1, '85.243.36.161', '2009-02-07 20:07:58', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 1, '85.243.36.161', '2009-02-07 20:11:38', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 2, '84.73.220.225', '2009-02-07 20:32:37', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 1, '85.240.110.195', '2009-02-28 19:46:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 1, '85.240.169.12', '2009-06-02 18:20:22', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, 1, '85.241.43.248', '2009-10-16 17:26:58', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Estrutura da tabela `user_preferences`
--

CREATE TABLE IF NOT EXISTS `user_preferences` (
  `pref_user` varchar(12) NOT NULL default '',
  `pref_name` varchar(72) NOT NULL default '',
  `pref_value` varchar(32) NOT NULL default '',
  KEY `pref_user` (`pref_user`,`pref_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `user_preferences`
--

INSERT INTO `user_preferences` (`pref_user`, `pref_name`, `pref_value`) VALUES
('0', 'LOCALE', 'pt'),
('0', 'SHDATEFORMAT', '%d/%m/%Y'),
('0', 'TIMEFORMAT', '%I:%M %p'),
('0', 'UISTYLE', 'default');

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

--
-- Estrutura da tabela `user_roles`
--

CREATE TABLE IF NOT EXISTS `user_roles` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `role_id` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `user_roles`
--

