-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 25-11-2014 a las 11:06:55
-- Versión del servidor: 5.5.40-0ubuntu0.14.04.1
-- Versión de PHP: 5.5.9-1ubuntu4.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Base de datos: `certifica`
--

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

--
-- Estructura de tabla para la tabla `grupos`
--

CREATE TABLE IF NOT EXISTS `grupos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `grupos`
--

INSERT INTO `grupos` (`id`, `nombre`) VALUES
(1, 'Administrador');

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

--
-- Estructura de tabla para la tabla `lenguaje`
--

CREATE TABLE IF NOT EXISTS `lenguaje` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` char(20) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Volcado de datos para la tabla `lenguaje`
--

INSERT INTO `lenguaje` (`id`, `nombre`, `last_update`) VALUES
(1, 'Portugues', '2006-02-15 03:02:19'),
(2, 'Español', '2006-02-15 03:02:19'),
(3, 'Ingles', '2006-02-15 03:02:19');

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

--
-- Estructura de tabla para la tabla `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `texto` varchar(45) NOT NULL,
  `iconCls` varchar(15) DEFAULT NULL,
  `padre_id` int(11) DEFAULT NULL,
  `className` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_menu_menu` (`padre_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Volcado de datos para la tabla `menu`
--

INSERT INTO `menu` (`id`, `texto`, `iconCls`, `padre_id`, `className`) VALUES
(1, 'menu1', 'menu_admin', NULL, NULL),
(2, 'menu11', 'menu_groups', 1, 'panel'),
(3, 'menu12', 'menu_users', 1, 'users'),
(4, 'staticData', 'menu_staticdata', NULL, NULL),
(5, 'actors', 'menu_actor', 4, 'actorsgrid'),
(6, 'categories', 'menu_category', 4, 'categoriesgrid'),
(7, 'languages', 'menu_language', 4, 'languagesgrid'),
(8, 'cities', 'menu_city', 4, 'citiesgrid'),
(9, 'countries', 'menu_country', 4, 'countriesgrid'),
(11, 'cms', 'menu_films', NULL, NULL),
(12, 'films', 'menu_films', 11, 'filmsgrid'),
(13, 'reports', 'menu_films', 11, 'salesfilmcategory'),
(14, 'salesfilmcategory', 'menu_films', NULL, NULL),
(15, 'salesfilmcategory', 'menu_films', 14, 'salesfilmcategory');

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

--
-- Estructura de tabla para la tabla `pais`
--

CREATE TABLE IF NOT EXISTS `pais` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `pais` varchar(50) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=110 ;

--
-- Volcado de datos para la tabla `pais`
--

INSERT INTO `pais` (`id`, `pais`, `last_update`) VALUES
(1, 'Afghanistan', '2006-02-15 02:44:00'),
(2, 'Algeria', '2006-02-15 02:44:00'),
(3, 'American Samoa', '2006-02-15 02:44:00'),
(4, 'Angola', '2006-02-15 02:44:00'),
(5, 'Anguilla', '2006-02-15 02:44:00'),
(6, 'Argentina', '2006-02-15 02:44:00'),
(7, 'Armenia', '2006-02-15 02:44:00'),
(8, 'Australia', '2006-02-15 02:44:00'),
(9, 'Austria', '2006-02-15 02:44:00'),
(10, 'Azerbaijan', '2006-02-15 02:44:00'),
(11, 'Bahrain', '2006-02-15 02:44:00'),
(12, 'Bangladesh', '2006-02-15 02:44:00'),
(13, 'Belarus', '2006-02-15 02:44:00'),
(14, 'Bolivia', '2006-02-15 02:44:00'),
(15, 'Brazil', '2006-02-15 02:44:00'),
(16, 'Brunei', '2006-02-15 02:44:00'),
(17, 'Bulgaria', '2006-02-15 02:44:00'),
(18, 'Cambodia', '2006-02-15 02:44:00'),
(19, 'Cameroon', '2006-02-15 02:44:00'),
(20, 'Canada', '2006-02-15 02:44:00'),
(21, 'Chad', '2006-02-15 02:44:00'),
(22, 'Chile', '2006-02-15 02:44:00'),
(23, 'China', '2006-02-15 02:44:00'),
(24, 'Colombia', '2006-02-15 02:44:00'),
(25, 'Congo, The Democratic Republic of the', '2006-02-15 02:44:00'),
(26, 'Czech Republic', '2006-02-15 02:44:00'),
(27, 'Dominican Republic', '2006-02-15 02:44:00'),
(28, 'Ecuador', '2006-02-15 02:44:00'),
(29, 'Egypt', '2006-02-15 02:44:00'),
(30, 'Estonia', '2006-02-15 02:44:00'),
(31, 'Ethiopia', '2006-02-15 02:44:00'),
(32, 'Faroe Islands', '2006-02-15 02:44:00'),
(33, 'Finland', '2006-02-15 02:44:00'),
(34, 'France', '2006-02-15 02:44:00'),
(35, 'French Guiana', '2006-02-15 02:44:00'),
(36, 'French Polynesia', '2006-02-15 02:44:00'),
(37, 'Gambia', '2006-02-15 02:44:00'),
(38, 'Germany', '2006-02-15 02:44:00'),
(39, 'Greece', '2006-02-15 02:44:00'),
(40, 'Greenland', '2006-02-15 02:44:00'),
(41, 'Holy See (Vatican City State)', '2006-02-15 02:44:00'),
(42, 'Hong Kong', '2006-02-15 02:44:00'),
(43, 'Hungary', '2006-02-15 02:44:00'),
(44, 'India', '2006-02-15 02:44:00'),
(45, 'Indonesia', '2006-02-15 02:44:00'),
(46, 'Iran', '2006-02-15 02:44:00'),
(47, 'Iraq', '2006-02-15 02:44:00'),
(48, 'Israel', '2006-02-15 02:44:00'),
(49, 'Italy', '2006-02-15 02:44:00'),
(50, 'Japan', '2006-02-15 02:44:00'),
(51, 'Kazakstan', '2006-02-15 02:44:00'),
(52, 'Kenya', '2006-02-15 02:44:00'),
(53, 'Kuwait', '2006-02-15 02:44:00'),
(54, 'Latvia', '2006-02-15 02:44:00'),
(55, 'Liechtenstein', '2006-02-15 02:44:00'),
(56, 'Lithuania', '2006-02-15 02:44:00'),
(57, 'Madagascar', '2006-02-15 02:44:00'),
(58, 'Malawi', '2006-02-15 02:44:00'),
(59, 'Malaysia', '2006-02-15 02:44:00'),
(60, 'Mexico', '2006-02-15 02:44:00'),
(61, 'Moldova', '2006-02-15 02:44:00'),
(62, 'Morocco', '2006-02-15 02:44:00'),
(63, 'Mozambique', '2006-02-15 02:44:00'),
(64, 'Myanmar', '2006-02-15 02:44:00'),
(65, 'Nauru', '2006-02-15 02:44:00'),
(66, 'Nepal', '2006-02-15 02:44:00'),
(67, 'Netherlands', '2006-02-15 02:44:00'),
(68, 'New Zealand', '2006-02-15 02:44:00'),
(69, 'Nigeria', '2006-02-15 02:44:00'),
(70, 'North Korea', '2006-02-15 02:44:00'),
(71, 'Oman', '2006-02-15 02:44:00'),
(72, 'Pakistan', '2006-02-15 02:44:00'),
(73, 'Paraguay', '2006-02-15 02:44:00'),
(74, 'Peru', '2006-02-15 02:44:00'),
(75, 'Philippines', '2006-02-15 02:44:00'),
(76, 'Poland', '2006-02-15 02:44:00'),
(77, 'Puerto Rico', '2006-02-15 02:44:00'),
(78, 'Romania', '2006-02-15 02:44:00'),
(79, 'Runion', '2006-02-15 02:44:00'),
(80, 'Russian Federation', '2006-02-15 02:44:00'),
(81, 'Saint Vincent and the Grenadines', '2006-02-15 02:44:00'),
(82, 'Saudi Arabia', '2006-02-15 02:44:00'),
(83, 'Senegal', '2006-02-15 02:44:00'),
(84, 'Slovakia', '2006-02-15 02:44:00'),
(85, 'South Africa', '2006-02-15 02:44:00'),
(86, 'South Korea', '2006-02-15 02:44:00'),
(87, 'Spain', '2006-02-15 02:44:00'),
(88, 'Sri Lanka', '2006-02-15 02:44:00'),
(89, 'Sudan', '2006-02-15 02:44:00'),
(90, 'Sweden', '2006-02-15 02:44:00'),
(91, 'Switzerland', '2006-02-15 02:44:00'),
(92, 'Taiwan', '2006-02-15 02:44:00'),
(93, 'Tanzania', '2006-02-15 02:44:00'),
(94, 'Thailand', '2006-02-15 02:44:00'),
(95, 'Tonga', '2006-02-15 02:44:00'),
(96, 'Tunisia', '2006-02-15 02:44:00'),
(97, 'Turkey', '2006-02-15 02:44:00'),
(98, 'Turkmenistan', '2006-02-15 02:44:00'),
(99, 'Tuvalu', '2006-02-15 02:44:00'),
(100, 'Ukraine', '2006-02-15 02:44:00'),
(101, 'United Arab Emirates', '2006-02-15 02:44:00'),
(102, 'United Kingdom', '2006-02-15 02:44:00'),
(103, 'United States', '2006-02-15 02:44:00'),
(104, 'Venezuela', '2006-02-15 02:44:00'),
(105, 'Vietnam', '2006-02-15 02:44:00'),
(106, 'Virgin Islands, U.S.', '2006-02-15 02:44:00'),
(107, 'Yemen', '2006-02-15 02:44:00'),
(108, 'Yugoslavia', '2006-02-15 02:44:00'),
(109, 'Zambia', '2006-02-15 02:44:00');

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

--
-- Estructura de tabla para la tabla `permisos`
--

CREATE TABLE IF NOT EXISTS `permisos` (
  `menu_id` int(11) NOT NULL,
  `grupo_id` int(11) NOT NULL,
  PRIMARY KEY (`menu_id`,`grupo_id`),
  KEY `fk_Menu_has_Group_Group1` (`grupo_id`),
  KEY `fk_Menu_has_Group_Menu1` (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `permisos`
--

INSERT INTO `permisos` (`menu_id`, `grupo_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1);

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

--
-- Estructura de tabla para la tabla `usuario`
--

CREATE TABLE IF NOT EXISTS `usuario` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) NOT NULL,
  `userName` varchar(20) NOT NULL,
  `password` varchar(35) NOT NULL,
  `email` varchar(100) NOT NULL,
  `imagen` varchar(100) DEFAULT NULL,
  `grupo_id` int(11) NOT NULL,
  PRIMARY KEY (`id`,`grupo_id`),
  UNIQUE KEY `userName_UNIQUE` (`userName`),
  KEY `fk_usuario_grupo1_idx` (`grupo_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `usuario`
--

INSERT INTO `usuario` (`id`, `nombre`, `userName`, `password`, `email`, `imagen`, `grupo_id`) VALUES
(1, 'diego', 'diego', 'e10adc3949ba59abbe56e057f20f883e', 'diego@ardinova.com', NULL, 1);

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `menu`
--
ALTER TABLE `menu`
  ADD CONSTRAINT `fk_menu_menu` FOREIGN KEY (`padre_id`) REFERENCES `menu` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Filtros para la tabla `permisos`
--
ALTER TABLE `permisos`
  ADD CONSTRAINT `fk_menu_has_grupo_grupo1` FOREIGN KEY (`grupo_id`) REFERENCES `grupos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_menu_has_grupo_menu1` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Filtros para la tabla `usuario`
--
ALTER TABLE `usuario`
  ADD CONSTRAINT `fk_usuario_grupo1` FOREIGN KEY (`grupo_id`) REFERENCES `grupos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;