-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 05-03-2015 a las 03:39:58
-- Versión del servidor: 5.5.27
-- Versión de PHP: 5.4.7

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: `minuta`
--

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

--
-- Estructura de tabla para la tabla `acuerdo`
--

CREATE TABLE IF NOT EXISTS `acuerdo` (
  `acu_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `acu_titulo` varchar(500) COLLATE latin1_general_cs NOT NULL,
  `acu_fecha` date DEFAULT NULL,
  `min_codigo` int(11) DEFAULT NULL,
  PRIMARY KEY (`acu_codigo`),
  KEY `min_codigo` (`min_codigo`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=43 ;

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

INSERT INTO `acuerdo` (`acu_codigo`, `acu_titulo`, `acu_fecha`, `min_codigo`) VALUES
(32, 'Acuerdo 1', '2014-12-20', 99),
(33, 'Acuerdo2', '2014-12-20', 99),
(34, 'acu', '2014-12-21', 2),
(35, 'asdfsdfsdfsdfdsf', '2014-12-22', 3),
(36, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 4),
(37, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 4),
(38, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 4),
(39, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 5),
(40, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 5),
(41, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 6),
(42, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 6);

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

--
-- Estructura de tabla para la tabla `agenda`
--

CREATE TABLE IF NOT EXISTS `agenda` (
  `agen_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `agen_detalle` varchar(2000) COLLATE latin1_general_cs DEFAULT NULL,
  `agen_fecha` date DEFAULT NULL,
  `min_codigo` int(11) DEFAULT NULL,
  `fun_rut` varchar(12) COLLATE latin1_general_cs DEFAULT NULL,
  PRIMARY KEY (`agen_codigo`),
  KEY `min_codigo` (`min_codigo`),
  KEY `fun_rut` (`fun_rut`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=112 ;

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

INSERT INTO `agenda` (`agen_codigo`, `agen_detalle`, `agen_fecha`, `min_codigo`, `fun_rut`) VALUES
(102, 'Agenda1', '2014-12-20', 99, '173429118'),
(103, 'Agenda2', '2014-12-20', 99, '173429118'),
(104, 'agenda 1', '2014-12-21', 2, '173429118'),
(105, 'agenda 2', '2014-12-21', 2, '173429118'),
(106, 'agenda 3', '2014-12-21', 2, '173429118'),
(107, 'asdfffasdf', '2014-12-22', 3, '173429118'),
(108, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 4, '173429118'),
(109, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 4, '173429118'),
(110, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2014-12-22', 5, '173429118'),
(111, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '2015-01-04', 6, '173429118');

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

--
-- Estructura de tabla para la tabla `asistente`
--

CREATE TABLE IF NOT EXISTS `asistente` (
  `asis_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `min_codigo` int(11) DEFAULT NULL,
  `fun_rut` varchar(12) COLLATE latin1_general_cs DEFAULT NULL,
  PRIMARY KEY (`asis_codigo`),
  KEY `min_codigo` (`min_codigo`),
  KEY `fun_rut` (`fun_rut`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=12 ;

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

INSERT INTO `asistente` (`asis_codigo`, `min_codigo`, `fun_rut`) VALUES
(1, 1, '131033575'),
(2, 1, '173429118'),
(3, 2, '173429118'),
(4, 2, '125580335'),
(5, 3, '173429118'),
(6, 3, '125580335'),
(7, 4, '173429118'),
(8, 4, '125580335'),
(9, 4, '131033575'),
(10, 6, '173429118'),
(11, 6, '125580335');

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

--
-- Estructura de tabla para la tabla `asis_grupo`
--

CREATE TABLE IF NOT EXISTS `asis_grupo` (
  `ag_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `grupo_codigo` int(11) DEFAULT NULL,
  `fun_rut` varchar(12) COLLATE latin1_general_cs DEFAULT NULL,
  PRIMARY KEY (`ag_codigo`),
  KEY `grupo_codigo` (`grupo_codigo`),
  KEY `fun_rut` (`fun_rut`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=2 ;

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

INSERT INTO `asis_grupo` (`ag_codigo`, `grupo_codigo`, `fun_rut`) VALUES
(1, 1, '173429118');

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

--
-- Estructura de tabla para la tabla `compromiso`
--

CREATE TABLE IF NOT EXISTS `compromiso` (
  `com_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `com_detalle` varchar(1000) COLLATE latin1_general_cs DEFAULT NULL,
  `com_estado` varchar(500) COLLATE latin1_general_cs DEFAULT NULL,
  `com_fecha_registro` date DEFAULT NULL,
  `com_fecha_plazo` date DEFAULT NULL,
  `com_fecha_termino` date DEFAULT NULL,
  `min_codigo` int(11) DEFAULT NULL,
  `fun_rut` varchar(12) COLLATE latin1_general_cs DEFAULT NULL,
  PRIMARY KEY (`com_codigo`),
  KEY `min_codigo` (`min_codigo`),
  KEY `fun_rut` (`fun_rut`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=87 ;

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

INSERT INTO `compromiso` (`com_codigo`, `com_detalle`, `com_estado`, `com_fecha_registro`, `com_fecha_plazo`, `com_fecha_termino`, `min_codigo`, `fun_rut`) VALUES
(81, 'Compromiso 1', 'Por Publicar', '2014-12-20', '2014-12-20', NULL, 99, '173429118'),
(82, 'Compromiso2', 'Por Publicar', '2014-12-20', '2014-12-20', NULL, 99, '173429118'),
(83, 'com1', 'Por Publicar', '2014-12-21', '2014-12-21', NULL, 2, '173429118'),
(84, 'com2', 'Por Publicar', '2014-12-21', '2014-12-21', NULL, 2, '173429118'),
(85, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', 'Por Publicar', '2014-12-22', '2014-12-22', NULL, 4, '173429118'),
(86, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', 'Por Publicar', '2014-12-22', '2014-12-25', NULL, 4, '173429118');

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

--
-- Estructura de tabla para la tabla `grupo`
--

CREATE TABLE IF NOT EXISTS `grupo` (
  `grupo_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `grupo_nombre` varchar(100) COLLATE latin1_general_cs NOT NULL,
  PRIMARY KEY (`grupo_codigo`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=4 ;

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

INSERT INTO `grupo` (`grupo_codigo`, `grupo_nombre`) VALUES
(1, 'Fiscalía Regional'),
(2, 'UGI'),
(3, 'Informática');

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

--
-- Estructura de tabla para la tabla `invitado`
--

CREATE TABLE IF NOT EXISTS `invitado` (
  `inv_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `min_codigo` int(11) DEFAULT NULL,
  `fun_rut` varchar(12) COLLATE latin1_general_cs DEFAULT NULL,
  PRIMARY KEY (`inv_codigo`),
  KEY `min_codigo` (`min_codigo`),
  KEY `fun_rut` (`fun_rut`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=1 ;

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

--
-- Estructura de tabla para la tabla `minuta`
--

CREATE TABLE IF NOT EXISTS `minuta` (
  `min_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `min_numero` int(11) DEFAULT NULL,
  `min_descripcion` varchar(1000) COLLATE latin1_spanish_ci DEFAULT NULL,
  `min_fecha` date DEFAULT NULL,
  `min_fecha_registro` date DEFAULT NULL,
  `min_fecha_cierra` date DEFAULT NULL,
  `min_hora_inicio` time DEFAULT NULL,
  `min_hora_fin` time DEFAULT NULL,
  `min_lugar` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
  `min_estado` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
  `min_privacidad` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
  `fis_codigo` int(11) DEFAULT NULL,
  `uni_codigo` int(11) DEFAULT NULL,
  `prc_codigo` int(11) DEFAULT NULL,
  `fun_rut` varchar(12) COLLATE latin1_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`min_codigo`),
  KEY `fis_codigo` (`fis_codigo`),
  KEY `uni_codigo` (`uni_codigo`),
  KEY `prc_codigo` (`prc_codigo`),
  KEY `fun_rut` (`fun_rut`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci AUTO_INCREMENT=7 ;

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

INSERT INTO `minuta` (`min_codigo`, `min_numero`, `min_descripcion`, `min_fecha`, `min_fecha_registro`, `min_fecha_cierra`, `min_hora_inicio`, `min_hora_fin`, `min_lugar`, `min_estado`, `min_privacidad`, `fis_codigo`, `uni_codigo`, `prc_codigo`, `fun_rut`) VALUES
(1, NULL, ' FR-:2014', '0000-00-00', '2014-12-21', NULL, '00:00:00', '00:00:00', '', 'Publicado', 'Público', 8, NULL, NULL, '173429118'),
(2, NULL, ' FR-UGI:2014', '2014-12-21', '2014-12-21', NULL, '19:39:00', '20:00:00', 'Dpto', 'Publicado', 'Público', 8, 1, NULL, '173429118'),
(3, NULL, ' FR-UGI:2014', '2015-01-02', '2014-12-22', NULL, '11:11:11', '11:11:11', 'asdf', 'Publicado', 'Público', 8, 1, NULL, '173429118'),
(4, NULL, ' FR-UGI:2014', '2014-12-27', '2014-12-22', NULL, '19:19:00', '20:00:00', 'Departamento Orompello 657', 'Publicado', 'Público', 8, 1, NULL, '173429118'),
(5, NULL, ' FR-UGI:2014', '2015-01-01', '2014-12-22', NULL, '10:00:00', '01:00:10', 'Dptoo', 'Por Publicar', 'Público', 8, 1, NULL, '173429118'),
(6, NULL, ' FR-UGI:2014', '2014-12-26', '2014-12-22', NULL, '11:11:11', '11:11:11', 'asd', 'Por Publicar', 'Público', 8, 1, NULL, '173429118');

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

--
-- Estructura de tabla para la tabla `revision`
--

CREATE TABLE IF NOT EXISTS `revision` (
  `rev_codigo` int(11) NOT NULL AUTO_INCREMENT,
  `rev_titulo` varchar(100) COLLATE latin1_general_cs DEFAULT NULL,
  `rev_ruc` varchar(100) COLLATE latin1_general_cs DEFAULT NULL,
  `rev_detalle` varchar(500) COLLATE latin1_general_cs DEFAULT NULL,
  `rev_estado` varchar(100) COLLATE latin1_general_cs DEFAULT NULL,
  `rev_fecha_registro` date DEFAULT NULL,
  `rev_fecha_plazo` date DEFAULT NULL,
  `rev_fecha_termino` date DEFAULT NULL,
  `min_codigo` int(11) DEFAULT NULL,
  `fun_rut` varchar(12) COLLATE latin1_general_cs DEFAULT NULL,
  PRIMARY KEY (`rev_codigo`),
  KEY `min_codigo` (`min_codigo`),
  KEY `fun_rut` (`fun_rut`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=3 ;

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

INSERT INTO `revision` (`rev_codigo`, `rev_titulo`, `rev_ruc`, `rev_detalle`, `rev_estado`, `rev_fecha_registro`, `rev_fecha_plazo`, `rev_fecha_termino`, `min_codigo`, `fun_rut`) VALUES
(1, NULL, NULL, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', 'Por Publicar', '2014-12-22', '2014-12-25', NULL, 4, '173429118'),
(2, NULL, NULL, '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', 'Por Publicar', '2014-12-22', '2014-12-25', NULL, 4, '173429118');

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