-- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Servidor: 127.0.0.1 -- Tiempo de generación: 02-12-2017 a las 19:04:12 -- Versión del servidor: 10.1.9-MariaDB -- Versión de PHP: 5.6.15 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 utf8mb4 */; -- -- Base de datos: `fileshare` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `comment` -- CREATE TABLE `comment` ( `id` int(11) NOT NULL, `comment` text, `user_id` int(11) NOT NULL, `file_id` int(11) NOT NULL, `comment_id` int(11) DEFAULT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `configuration` -- CREATE TABLE `configuration` ( `id` int(11) NOT NULL, `url_base` varchar(250) NOT NULL, `email_admin` varchar(250) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Volcado de datos para la tabla `configuration` -- INSERT INTO `configuration` (`id`, `url_base`, `email_admin`) VALUES (1, 'http://localhost/project/odi_pc/fileshare/', ''); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `file` -- CREATE TABLE `file` ( `id` int(11) NOT NULL, `code` varchar(12) NOT NULL, `filename` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `download` int(11) NOT NULL, `is_public` tinyint(1) NOT NULL DEFAULT '0', `is_folder` tinyint(1) NOT NULL DEFAULT '0', `is_deleted` tinyint(1) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL, `status` int(11) DEFAULT '1', `folder_id` int(11) DEFAULT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `notification` -- CREATE TABLE `notification` ( `id` int(11) NOT NULL, `from_id` int(11) NOT NULL, `to_id` int(11) NOT NULL, `file_id` int(11) NOT NULL, `kind` int(11) NOT NULL, `created_at` datetime DEFAULT NULL, `is_readed` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `permision` -- CREATE TABLE `permision` ( `id` int(11) NOT NULL, `p_id` int(11) DEFAULT NULL, `user_id` int(11) NOT NULL, `file_id` int(11) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `fullname` varchar(100) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(60) NOT NULL, `image` varchar(255) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_admin` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Volcado de datos para la tabla `user` -- INSERT INTO `user` (`id`, `fullname`, `email`, `password`, `image`, `is_active`, `is_admin`, `created_at`) VALUES (1, 'Abisoft GT', 'admin@admin.com', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', 'default.png', 1, 1, '2017-12-01 09:55:12'); -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `comment` -- ALTER TABLE `comment` ADD PRIMARY KEY (`id`), ADD KEY `comment_id` (`comment_id`), ADD KEY `file_id` (`file_id`), ADD KEY `user_id` (`user_id`); -- -- Indices de la tabla `configuration` -- ALTER TABLE `configuration` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `file` -- ALTER TABLE `file` ADD PRIMARY KEY (`id`), ADD KEY `folder_id` (`folder_id`), ADD KEY `user_id` (`user_id`); -- -- Indices de la tabla `notification` -- ALTER TABLE `notification` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `permision` -- ALTER TABLE `permision` ADD PRIMARY KEY (`id`), ADD KEY `file_id` (`file_id`), ADD KEY `user_id` (`user_id`); -- -- Indices de la tabla `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`); -- -- AUTO_INCREMENT de las tablas volcadas -- -- -- AUTO_INCREMENT de la tabla `comment` -- ALTER TABLE `comment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `configuration` -- ALTER TABLE `configuration` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT de la tabla `file` -- ALTER TABLE `file` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `notification` -- ALTER TABLE `notification` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `permision` -- ALTER TABLE `permision` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Restricciones para tablas volcadas -- -- -- Filtros para la tabla `comment` -- ALTER TABLE `comment` ADD CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `comment` (`id`), ADD CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`), ADD CONSTRAINT `comment_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`); -- -- Filtros para la tabla `file` -- ALTER TABLE `file` ADD CONSTRAINT `file_ibfk_1` FOREIGN KEY (`folder_id`) REFERENCES `file` (`id`), ADD CONSTRAINT `file_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`); -- -- Filtros para la tabla `permision` -- ALTER TABLE `permision` ADD CONSTRAINT `permision_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `file` (`id`), ADD CONSTRAINT `permision_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`); /*!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 */;