-- phpMyAdmin SQL Dump
-- version 2.11.9.4
-- 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
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- 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', 'Estatutos\r\n', 2, 1, 0),
(3, 'Cartão de sócio', 'Cartão de sócio\r\n', 3, 1, 1),
(4, 'Apoios', 'Apoios\r\n', 11, 1, 0),
(5, 'Links úteis', 'Links úteis\r\n', 12, 1, 1),
(6, 'Projecto solidário', 'Projecto solidário\r\n', 10, 1, 1),
(7, 'Área Académica', 'Áreas académicas\r\n', 5, 1, 1),
(8, 'Contactos', '\r\nContactos\r\n
\r\n\r\n \r\n
\r\n
\r\n\r\n \r\n
\r\n\r\n
\r\n Rua da da Cooperativa S. Romão 214-017 Leiria\r\n
\r\n\r\n \r\n
\r\n\r\nae.islaleiria@gmail.com \r\n
\r\n\r\n \r\n
\r\n\r\n \r\n
\r\n\r\n', 4, 1, 1),
(12, 'Área Pedagógica', '\r\n \r\n
\r\n\r\nÉ um dos organismos mais importante na vida académica, veio proporcionar ao estudante, através dos delegados de turma representantes de cada ano e curso, um partilhar de ideias, iniciativas, debate de situações do quotidiano escolar; de modo garantir o bem estar social e académico dentro da instituição do Isla Leiria.\r\n
\r\n', 7, 1, 1),
(10, 'Área Desportiva', 'Mais um Contacto\r\n', 6, 1, 1),
(11, 'Tuna Académica', '\r\noiuutr \r\n
\r\n', 9, 1, 1),
(13, 'Área Sócio Cultural', '\r\nBrevemente disponível\r\n
\r\n', 8, 1, 1),
(16, 'Teste', 'sy<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|\r\n\r\nSerialized Array:\r\n[type] => text | checkbox | select | textarea | label\r\n[name] => \r\n[options] => \r\n[selects] => ', 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`
--