-- http://www.phpmyadmin.net
-- 
-- Servidor: localhost
-- Tiempo de generación: 16-01-2009 a las 11:57:42
-- Versión del servidor: 4.1.20
-- Versión de PHP: 5.0.4
-- 
-- 

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

-- 
-- Estructura de tabla para la tabla `phi_audit`
-- 

CREATE TABLE `phi_audit` (
  `id` int(11) NOT NULL default '0',
  `timestamp` int(11) NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `type` varchar(12) NOT NULL default '',
  `target` int(11) NOT NULL default '0',
  `action` varchar(64) NOT NULL default '',
  `arguments` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_audit_seq`
-- 

CREATE TABLE `phi_audit_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=392 ;

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

-- 
-- Estructura de tabla para la tabla `phi_comments`
-- 

CREATE TABLE `phi_comments` (
  `id` int(11) NOT NULL default '0',
  `type` varchar(64) NOT NULL default '',
  `element` int(11) NOT NULL default '0',
  `timestamp` int(11) NOT NULL default '0',
  `author` varchar(128) NOT NULL default '0',
  `text` text NOT NULL,
  `url` varchar(255) NOT NULL default '',
  `language` varchar(2) NOT NULL default '',
  `spam` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_contact`
-- 

CREATE TABLE `phi_contact` (
  `id` int(11) NOT NULL default '0',
  `instance` int(11) NOT NULL default '0',
  `department` varchar(128) NOT NULL default '',
  `email` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_field_arguments`
-- 

CREATE TABLE `phi_field_arguments` (
  `id` int(11) NOT NULL default '0',
  `field` int(11) NOT NULL default '0',
  `name` varchar(250) default NULL,
  `value` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- Estructura de tabla para la tabla `phi_field_arguments_seq`
-- 

CREATE TABLE `phi_field_arguments_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

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

-- 
-- Estructura de tabla para la tabla `phi_field_values`
-- 

CREATE TABLE `phi_field_values` (
  `id` int(11) NOT NULL default '0',
  `class` varchar(150) default NULL,
  `field` int(11) NOT NULL default '0',
  `element` int(11) NOT NULL default '0',
  `value` varchar(250) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- Estructura de tabla para la tabla `phi_field_values_seq`
-- 

CREATE TABLE `phi_field_values_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

-- 
-- Estructura de tabla para la tabla `phi_fields`
-- 

CREATE TABLE `phi_fields` (
  `id` int(11) NOT NULL default '0',
  `class` varchar(150) default NULL,
  `type` varchar(150) default NULL,
  `name` varchar(150) default NULL,
  `label` varchar(150) default NULL,
  `required` int(11) default NULL,
  `regex` varchar(250) default NULL,
  `errmsg` varchar(250) default NULL,
  `iorder` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- Estructura de tabla para la tabla `phi_fields_seq`
-- 

CREATE TABLE `phi_fields_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

-- 
-- Estructura de tabla para la tabla `phi_groups`
-- 

CREATE TABLE `phi_groups` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(64) default NULL,
  `description` varchar(255) default NULL,
  `homeurl` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_groups_seq`
-- 

CREATE TABLE `phi_groups_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

-- 
-- Estructura de tabla para la tabla `phi_instances`
-- 

CREATE TABLE `phi_instances` (
  `id` int(11) NOT NULL default '0',
  `module` varchar(255) default NULL,
  `parent` int(11) default NULL,
  `arguments` varchar(255) default NULL,
  `title` varchar(255) NOT NULL default '',
  `language` varchar(2) default '0',
  `hidden_title` int(1) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_instances_seq`
-- 

CREATE TABLE `phi_instances_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=47 ;

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

-- 
-- Estructura de tabla para la tabla `phi_layout`
-- 

CREATE TABLE `phi_layout` (
  `instance` int(11) NOT NULL default '0',
  `page` int(11) NOT NULL default '0',
  `container` tinyint(4) NOT NULL default '0',
  `iorder` tinyint(4) NOT NULL default '0',
  `classname` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`instance`,`page`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_membership`
-- 

CREATE TABLE `phi_membership` (
  `user` int(11) NOT NULL default '0',
  `group` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user`,`group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_page_parameters`
-- 

CREATE TABLE `phi_page_parameters` (
  `page` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`page`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_pages`
-- 

CREATE TABLE `phi_pages` (
  `id` int(11) NOT NULL default '0',
  `parent` int(11) default NULL,
  `name` varchar(255) default NULL,
  `description` text default NULL,
  `template` varchar(255) default NULL,
  `iorder` tinyint(4) NOT NULL default '0',
  `language` varchar(2) NOT NULL default '0',
  `wraps` int(11) NOT NULL default '0',
  `uriname` varchar(255) NOT NULL default '',
  `hidden` int(1) NOT NULL default '0',
  `default` int(1) NOT NULL default '0',
  `deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `uriname` (`uriname`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_pages_seq`
-- 

CREATE TABLE `phi_pages_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;

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

-- 
-- Estructura de tabla para la tabla `phi_privileges`
-- 

CREATE TABLE `phi_privileges` (
  `group` int(11) NOT NULL default '0',
  `type` varchar(24) NOT NULL default '',
  `element` varchar(24) NOT NULL default '0',
  `privilege` int(11) NOT NULL default '0',
  PRIMARY KEY  (`group`,`type`,`element`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_tags`
-- 

CREATE TABLE `phi_tags` (
  `type` varchar(64) character set utf8 NOT NULL default '',
  `element` int(11) NOT NULL default '0',
  `tag` varchar(64) character set utf8 NOT NULL default '',
  PRIMARY KEY  (`type`,`element`,`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

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

-- 
-- Estructura de tabla para la tabla `phi_texts`
-- 

CREATE TABLE `phi_texts` (
  `id` int(11) NOT NULL default '0',
  `author` int(11) NOT NULL default '0',
  `timestamp` int(11) NOT NULL default '0',
  `text` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_user_field_values`
-- 

CREATE TABLE `phi_user_field_values` (
  `id` int(11) NOT NULL default '0',
  `field` int(11) NOT NULL default '0',
  `user` int(11) NOT NULL default '0',
  `value` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_user_fields`
-- 

CREATE TABLE `phi_user_fields` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(64) NOT NULL default '',
  `type` varchar(16) NOT NULL default '',
  `label` varchar(64) NOT NULL default '',
  `iorder` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_users`
-- 

CREATE TABLE `phi_users` (
  `id` int(11) NOT NULL default '0',
  `username` varchar(64) default NULL,
  `password` varchar(64) default NULL,
  `lastname` varchar(64) default NULL,
  `firstname` varchar(64) default NULL,
  `email` varchar(64) NOT NULL default '',
  `created` int(11) NOT NULL default '0',
  `laststamp` int(11) NOT NULL default '0',
  `active` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- 
-- Estructura de tabla para la tabla `phi_users_seq`
-- 

CREATE TABLE `phi_users_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
