-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Mar 17, 2009 as 08:03 PM
-- Versão do Servidor: 5.0.67
-- Versão do PHP: 5.2.6




--
-- Banco de Dados: `ptreal_aeisla`
--

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

--
-- 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, 'Associação de Estudantes ISLA', '111111111', '', '111111111', 'rua rua', '', 'Leiria', '', '2043-707', '', 1, '', 1, 'geral@aeisla.com', 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', 'Associação de Estudantes ISLA Leiria', 'text', 'sys'),
(118, 'title', 'Associação de Estudantes ISLA Leiria', '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', '4', 'text', 'sys'),
(127, 'logo', 'logo.jpg', 'text', 'sys'),
(128, 'numero_submenus', '4', 'text', 'sys'),
(129, 'default_m', 'headline', '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=4 ;

--
-- 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, 'Jorge', 'Estrada', '', NULL, NULL, NULL, '1', NULL, NULL, 'geral@aeisla.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'obj/contact', 1, 0),
(3, 'Jorge', 'Estrada', '', NULL, NULL, NULL, '1', NULL, '2', 'geral@aeisla.pt', 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=5 ;

--
-- 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',
  `type` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

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

INSERT INTO `freepage` (`id`, `name`, `description`, `ordered`, `parentId`, `type`) VALUES
(1, 'A Associação', '', 1, 1, 1),
(2, 'Estatutos', '<span style="font-size: 10pt; color: #333333; font-family: Tahoma"><span style="letter-spacing: 4px"><span style="font-size: 9pt; color: #000080; font-family: Tahoma">Estatutos</span></span></span>\r\n', 2, 1, 0),
(3, 'Cartão de sócio', '<span style="font-size: 10pt; font-family: Tahoma; color: #333333"><span style="letter-spacing: 4px"><span style="font-size: 9pt; font-family: Tahoma; color: #000080">Cart&atilde;o de s&oacute;cio</span></span></span>\r\n', 3, 1, 1),
(4, 'Apoios', '<span style="letter-spacing: 4px"><span style="font-size: 9pt; color: #000080; font-family: Tahoma">Apoios</span></span>\r\n', 11, 1, 0),
(5, 'Links úteis', '<span style="letter-spacing: 4px"><span style="font-size: 9pt; color: #000080; font-family: Tahoma">Links &uacute;teis</span></span>\r\n', 12, 1, 1),
(6, 'Projecto solidário', '<span style="letter-spacing: 4px"><span style="font-size: 9pt; color: #000080; font-family: Tahoma">Projecto solid&aacute;rio</span></span>\r\n', 10, 1, 1),
(7, 'Área Académica', '<span style="letter-spacing: 4px"><span style="font-size: 9pt; font-family: Tahoma; color: #000080">&Aacute;reas acad&eacute;micas</span></span>\r\n', 5, 1, 1),
(8, 'Contactos', '<p>\r\n<span style="letter-spacing: 4px"><span style="font-size: 9pt; font-family: Tahoma; color: #000080"><span style="text-decoration: none">Contactos</span></span></span>\r\n</p>\r\n<p>\r\n&nbsp;\r\n</p>\r\n<br />\r\n<p class="style6" align="center">\r\n&nbsp;\r\n</p>\r\n<p class="style6" align="center">\r\n&nbsp;<br />\r\n<span style="font-size: 12pt; font-family: tahoma,arial,helvetica,sans-serif"> Rua da da Cooperativa S. Rom&atilde;o 214-017 Leiria</span>\r\n</p>\r\n<p class="style6" align="center">\r\n&nbsp;\r\n</p>\r\n<p class="style6" align="center">\r\n<span style="font-size: 12pt; font-family: tahoma,arial,helvetica,sans-serif">ae.islaleiria@gmail.com&nbsp;</span>\r\n</p>\r\n<p class="style6" align="center">\r\n&nbsp;\r\n</p>\r\n<p>\r\n<span style="font-size: 12pt; font-family: tahoma,arial,helvetica,sans-serif">&nbsp;</span>\r\n</p>\r\n<span style="letter-spacing: 4px"><span style="font-size: 9pt; font-family: Tahoma; color: #000080"></span></span>\r\n', 4, 1, 1),
(12, 'Área Pedagógica', '<p align="justify">\r\n&nbsp;\r\n</p>\r\n<p align="justify">\r\n<span style="font-size: 12pt; font-family: comic sans ms,sand">&Eacute; um dos organismos mais importante na vida acad&eacute;mica, veio proporcionar ao estudante, atrav&eacute;s dos delegados de turma representantes de cada ano e curso, um partilhar de ideias, iniciativas, debate de situa&ccedil;&otilde;es do quotidiano escolar; de modo garantir o bem estar social e acad&eacute;mico dentro da institui&ccedil;&atilde;o do Isla Leiria.</span>\r\n</p>\r\n', 7, 1, 1),
(10, 'Área Desportiva', 'Mais um Contacto\r\n', 6, 1, 1),
(11, 'Tuna Académica', '<p>\r\noiuutr \r\n</p>\r\n', 9, 1, 1),
(13, 'Área Sócio Cultural', '<p>\r\nBrevemente dispon&iacute;vel\r\n</p>\r\n', 8, 1, 1),
(16, 'Teste', 'sy&lt;ery\r\n', 13, 1, 1);

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

--
-- Estrutura da tabela `headline`
--

CREATE TABLE IF NOT EXISTS `headline` (
  `id` int(5) NOT NULL auto_increment,
  `image` varchar(100) NOT NULL default '',
  `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',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

--
-- Extraindo dados da tabela `headline`
--

INSERT INTO `headline` (`id`, `image`, `name`, `description`, `active`, `startDate`, `endDate`, `link`, `ordered`) VALUES
(35, 'Array', 'Jantar dos Óscares 2008', '\r\n', 1, '0000-00-00', '0000-00-00', NULL, 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', 1, '', '', 0),
(2, 'System Administration', 'system', '1.0.0', '', 'core', 1, 0, 'System Admin', '48_my_computer.png', 2, '', '', 0),
(3, 'Help', 'help', '1.00', 'Setup.php', 'core', 0, 0, 'Help', '', 3, '', '', 0),
(4, 'freepage', 'freepage', '1.0.0', 'Setup', 'user', 1, 0, 'Institucional', 'freepage.png', 6, 'left', 'module text', 1),
(8, 'headline', 'headline&a=index2', '1.0.0', '', 'user', 1, 0, 'headlines', 'headline.png', 5, 'left', 'module text', 1),
(6, 'Company', 'company', '1.0.0', 'Setup', 'user', 1, 0, 'My company', 'companies.gif', 7, 'left', 'Porque queremos servi-lo melhor!', 0),
(7, 'headline', 'headline', '1.0.0', 'Setup', 'user', 1, 1, 'Administration', 'headline.png', 0, 'left', 'module que permite destacar algo de importante', 1);

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

--
-- 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, 'typeOfMenu', '0|nenhum\r\n1|menu principal\r\n2|menu de topo\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=3 ;

--
-- 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, 3, 'user', '76a2173be6393254e72ffa4d6df1030a', 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=18 ;

--
-- 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.138.208.177', '2008-02-22 20:37:57', '2008-02-22 20:42:49', '0000-00-00 00:00:00'),
(2, 2, '85.138.208.177', '2008-02-22 20:43:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 1, '85.138.208.177', '2008-02-23 18:27:46', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 2, '85.138.208.177', '2008-02-26 18:51:19', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 2, '85.243.197.156', '2008-02-27 02:09:01', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 2, '213.58.161.76', '2008-02-29 16:49:07', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 2, '213.58.161.76', '2008-03-03 18:10:31', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 1, '85.138.208.177', '2008-03-06 20:24:43', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 2, '213.58.161.76', '2008-03-12 19:39:19', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 2, '85.240.165.116', '2008-03-19 02:50:50', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 2, '213.22.178.193', '2008-03-24 16:25:02', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 1, '81.84.123.32', '2008-05-02 17:35:22', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 2, '213.58.161.76', '2008-05-02 22:31:04', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 2, '213.58.161.76', '2008-05-02 22:32:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 2, '213.58.161.76', '2008-05-05 20:24:06', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 1, '193.137.239.24', '2008-05-29 20:32:10', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 1, '85.240.163.24', '2008-11-20 18:10:11', '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`
--

