text: 
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `cliente`
  --
  
  CREATE TABLE `cliente` (
    `id` int(11) NOT NULL,
    `cedula` varchar(11) COLLATE utf8_spanish_ci NOT NULL,
    `correo` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
    `nit` varchar(16) COLLATE utf8_spanish_ci DEFAULT NULL,
    `nombres` varchar(64) COLLATE utf8_spanish_ci NOT NULL,
    `apellidos` varchar(64) COLLATE utf8_spanish_ci NOT NULL,
    `tipo_usuario` tinyint(4) NOT NULL,
    `telefono` varchar(11) COLLATE utf8_spanish_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
  
  --
  -- Volcado de datos para la tabla `cliente`
  --
  
  INSERT INTO `cliente` (`id`, `cedula`, `correo`, `nit`, `nombres`, `apellidos`, `tipo_usuario`, `telefono`) VALUES
  (5, '213433', 'andresf@gmail.co33', '87123', 'Andres F', 'largo', 0, 'cll 678 b '),
  (6, '2134334', 'andresf@gmail.co335', '871234', 'Andres F', 'largo', 0, 'cll 678 b '),
  (7, '21343343', 'andresf@gmail.co3354', '8712344', 'Andres F', 'largo', 0, 'cll 678 b '),
  (8, '2134842', 'andresf@gmail.com33', '123-32', 'Andres F', 'largo', 1, 'cll 678 b '),
  (9, '21348424', 'steben.vera@gmail.com', '123-324', 'Steben ', 'Vera', 1, 'cll 678 b '),
  (10, '12222912', 'felipe@gmail.com', '1232229-1', 'andres', 'largo', 0, '123\r\n↵'),
  (11, '19222224', 'felipe@gmail.coma', '1239-11', 'andres', 'largo', 0, '322840\r\n'),
  (12, '1932222234', 'felipe@gmail.coma3', '1239-311', 'andres', 'largo', 0, '322840\r\n'),
  (13, '1234564', 'andresf@gaeeeaee.com1', '21312-95', 'Andres F', 'largo', 0, 'cll 678 b '),
  (14, '12345644', 'andresf@gaeeeaee.com11', '21312-951', 'Andres F', 'largo', 0, 'cll 678 b '),
  (15, '1822353762', 'aassadas@gmail.com', '211s2', 'kakasama', 'dasdasdsa', 1, '2134121'),
  (16, '1233213213', 'stebe2nvera@gmail.com', '213123', 'asdasd', 'asdd', 2, 'sdvsd'),
  (17, '10223862572', 'dansiel@gmail.com', '122', 'sadasdasdas', 'asdasdas', 1, 'asdsad'),
  (18, '10213123', 'stebenverass@gmail.com', '1123', 'steben', 'sadasdas', 1, '2002123'),
  (19, '1033324324', 'sga2hs@gmail.com', '112322', 'camilo', 'daksdjas', 1, '2929312'),
  (20, '192321312', 'stebenvsadera@gmail.com', '1123222', 'daniela', 'sdasd', 2, '290313'),
  (21, '1922873652', 'sadasd@gmail.com', '1231244', 'julian', 'vera', 2, '20340412'),
  (22, '1023321321', 'asdasd@gmail.comadsad', '213124124', 'Andres', 'asdasdasd', 2, '231412421');
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `cliente`
  --
  ALTER TABLE `cliente`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `cc` (`cedula`),
    ADD UNIQUE KEY `email` (`correo`),
    ADD UNIQUE KEY `nit` (`nit`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `cliente`
  --
  ALTER TABLE `cliente`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
  --
  -- Base de datos: `mydb`
  --
  CREATE DATABASE IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  USE `mydb`;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `modulo`
  --
  
  CREATE TABLE `modulo` (
    `id` int(11) NOT NULL,
    `nombre` varchar(45) NOT NULL,
    `icono` varchar(45) NOT NULL,
    `opciones` varchar(45) NOT NULL,
    `estado` varchar(45) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `modulo`
  --
  
  INSERT INTO `modulo` (`id`, `nombre`, `icono`, `opciones`, `estado`) VALUES
  (2, 'andres', 'asd/img', 'act', '0');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `permiso`
  --
  
  CREATE TABLE `permiso` (
    `id` int(11) NOT NULL,
    `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `leer` varchar(45) NOT NULL,
    `escribir` varchar(45) NOT NULL,
    `eliminar` varchar(45) NOT NULL,
    `modulo_id` int(11) NOT NULL,
    `rol_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `permiso`
  --
  
  INSERT INTO `permiso` (`id`, `fecha`, `leer`, `escribir`, `eliminar`, `modulo_id`, `rol_id`) VALUES
  (1, '2019-01-23 21:32:51', '1', '1', '0', 2, 1),
  (2, '2019-01-23 21:32:51', '1', '1', '0', 2, 1),
  (3, '2019-01-23 21:33:42', '1', '1', '0', 2, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `rol`
  --
  
  CREATE TABLE `rol` (
    `id` int(11) NOT NULL,
    `nombre` varchar(45) NOT NULL,
    `nivel` varchar(45) NOT NULL,
    `estado` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `rol`
  --
  
  INSERT INTO `rol` (`id`, `nombre`, `nivel`, `estado`) VALUES
  (1, 'AdministreidoRrr', '3', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `usuario`
  --
  
  CREATE TABLE `usuario` (
    `id` int(11) NOT NULL,
    `nombres` varchar(45) NOT NULL,
    `apellidos` varchar(45) NOT NULL,
    `tipo_doc` varchar(45) NOT NULL,
    `nro_doc` varchar(45) NOT NULL,
    `email` varchar(45) NOT NULL,
    `telefono` varchar(45) NOT NULL,
    `direccion` varchar(45) NOT NULL,
    `usuario` varchar(45) NOT NULL,
    `clave` varchar(45) NOT NULL,
    `estado` varchar(45) NOT NULL,
    `rol_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `modulo`
  --
  ALTER TABLE `modulo`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `permiso`
  --
  ALTER TABLE `permiso`
    ADD PRIMARY KEY (`id`),
    ADD KEY `fk_permiso_modulo_idx` (`modulo_id`),
    ADD KEY `fk_permiso_rol1_idx` (`rol_id`);
  
  --
  -- Indices de la tabla `rol`
  --
  ALTER TABLE `rol`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `usuario`
  --
  ALTER TABLE `usuario`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `email_UNIQUE` (`email`),
    ADD UNIQUE KEY `nro_doc_UNIQUE` (`nro_doc`),
    ADD UNIQUE KEY `usuario_UNIQUE` (`usuario`),
    ADD KEY `fk_usuario_rol1_idx` (`rol_id`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `modulo`
  --
  ALTER TABLE `modulo`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `permiso`
  --
  ALTER TABLE `permiso`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT de la tabla `rol`
  --
  ALTER TABLE `rol`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de la tabla `usuario`
  --
  ALTER TABLE `usuario`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- Restricciones para tablas volcadas
  --
  
  --
  -- Filtros para la tabla `permiso`
  --
  ALTER TABLE `permiso`
    ADD CONSTRAINT `fk_permiso_modulo` FOREIGN KEY (`modulo_id`) REFERENCES `modulo` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `fk_permiso_rol1` FOREIGN KEY (`rol_id`) REFERENCES `rol` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `usuario`
  --
  ALTER TABLE `usuario`
    ADD CONSTRAINT `fk_usuario_rol1` FOREIGN KEY (`rol_id`) REFERENCES `rol` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  --
  -- Base de datos: `phpmyadmin`
  --
  CREATE DATABASE IF NOT EXISTS `phpmyadmin` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
  USE `phpmyadmin`;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__bookmark`
  --
  
  CREATE TABLE `pma__bookmark` (
    `id` int(11) NOT NULL,
    `dbase` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
    `user` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
    `label` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
    `query` text COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__central_columns`
  --
  
  CREATE TABLE `pma__central_columns` (
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `col_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `col_type` varchar(64) COLLATE utf8_bin NOT NULL,
    `col_length` text COLLATE utf8_bin,
    `col_collation` varchar(64) COLLATE utf8_bin NOT NULL,
    `col_isNull` tinyint(1) NOT NULL,
    `col_extra` varchar(255) COLLATE utf8_bin DEFAULT '',
    `col_default` text COLLATE utf8_bin
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Central list of columns';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__column_info`
  --
  
  CREATE TABLE `pma__column_info` (
    `id` int(5) UNSIGNED NOT NULL,
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `column_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `comment` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
    `mimetype` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
    `transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
    `transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
    `input_transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
    `input_transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column information for phpMyAdmin';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__designer_settings`
  --
  
  CREATE TABLE `pma__designer_settings` (
    `username` varchar(64) COLLATE utf8_bin NOT NULL,
    `settings_data` text COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Settings related to Designer';
  
  --
  -- Volcado de datos para la tabla `pma__designer_settings`
  --
  
  INSERT INTO `pma__designer_settings` (`username`, `settings_data`) VALUES
  ('root', '{\"relation_lines\":\"true\",\"angular_direct\":\"direct\",\"snap_to_grid\":\"off\"}');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__export_templates`
  --
  
  CREATE TABLE `pma__export_templates` (
    `id` int(5) UNSIGNED NOT NULL,
    `username` varchar(64) COLLATE utf8_bin NOT NULL,
    `export_type` varchar(10) COLLATE utf8_bin NOT NULL,
    `template_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `template_data` text COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved export templates';
  
  --
  -- Volcado de datos para la tabla `pma__export_templates`
  --
  
  INSERT INTO `pma__export_templates` (`id`, `username`, `export_type`, `template_name`, `template_data`) VALUES
  (1, 'root', 'server', 'apiUser', '{\"quick_or_custom\":\"quick\",\"what\":\"sql\",\"db_select[]\":[\"cliente\",\"mydb\",\"phpmyadmin\",\"test\",\"usuarios\"],\"aliases_new\":\"\",\"output_format\":\"sendit\",\"filename_template\":\"@SERVER@\",\"remember_template\":\"on\",\"charset\":\"utf-8\",\"compression\":\"none\",\"maxsize\":\"\",\"codegen_structure_or_data\":\"data\",\"codegen_format\":\"0\",\"csv_separator\":\",\",\"csv_enclosed\":\"\\\"\",\"csv_escaped\":\"\\\"\",\"csv_terminated\":\"AUTO\",\"csv_null\":\"NULL\",\"csv_structure_or_data\":\"data\",\"excel_null\":\"NULL\",\"excel_columns\":\"something\",\"excel_edition\":\"win\",\"excel_structure_or_data\":\"data\",\"json_structure_or_data\":\"data\",\"json_unicode\":\"something\",\"latex_caption\":\"something\",\"latex_structure_or_data\":\"structure_and_data\",\"latex_structure_caption\":\"Estructura de la tabla @TABLE@\",\"latex_structure_continued_caption\":\"Estructura de la tabla @TABLE@ (continÃºa)\",\"latex_structure_label\":\"tab:@TABLE@-structure\",\"latex_relation\":\"something\",\"latex_comments\":\"something\",\"latex_mime\":\"something\",\"latex_columns\":\"something\",\"latex_data_caption\":\"Contenido de la tabla @TABLE@\",\"latex_data_continued_caption\":\"Contenido de la tabla @TABLE@ (continÃºa)\",\"latex_data_label\":\"tab:@TABLE@-data\",\"latex_null\":\"\\\\textit{NULL}\",\"mediawiki_structure_or_data\":\"data\",\"mediawiki_caption\":\"something\",\"mediawiki_headers\":\"something\",\"htmlword_structure_or_data\":\"structure_and_data\",\"htmlword_null\":\"NULL\",\"ods_null\":\"NULL\",\"ods_structure_or_data\":\"data\",\"odt_structure_or_data\":\"structure_and_data\",\"odt_relation\":\"something\",\"odt_comments\":\"something\",\"odt_mime\":\"something\",\"odt_columns\":\"something\",\"odt_null\":\"NULL\",\"pdf_report_title\":\"\",\"pdf_structure_or_data\":\"data\",\"phparray_structure_or_data\":\"data\",\"sql_include_comments\":\"something\",\"sql_header_comment\":\"\",\"sql_use_transaction\":\"something\",\"sql_compatibility\":\"NONE\",\"sql_structure_or_data\":\"structure_and_data\",\"sql_create_table\":\"something\",\"sql_auto_increment\":\"something\",\"sql_create_view\":\"something\",\"sql_create_trigger\":\"something\",\"sql_backquotes\":\"something\",\"sql_type\":\"INSERT\",\"sql_insert_syntax\":\"both\",\"sql_max_query_size\":\"50000\",\"sql_hex_for_binary\":\"something\",\"sql_utc_time\":\"something\",\"texytext_structure_or_data\":\"structure_and_data\",\"texytext_null\":\"NULL\",\"yaml_structure_or_data\":\"data\",\"\":null,\"as_separate_files\":null,\"csv_removeCRLF\":null,\"csv_columns\":null,\"excel_removeCRLF\":null,\"json_pretty_print\":null,\"htmlword_columns\":null,\"ods_columns\":null,\"sql_dates\":null,\"sql_relation\":null,\"sql_mime\":null,\"sql_disable_fk\":null,\"sql_views_as_tables\":null,\"sql_metadata\":null,\"sql_drop_database\":null,\"sql_drop_table\":null,\"sql_if_not_exists\":null,\"sql_procedure_function\":null,\"sql_truncate\":null,\"sql_delayed\":null,\"sql_ignore\":null,\"texytext_columns\":null}');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__favorite`
  --
  
  CREATE TABLE `pma__favorite` (
    `username` varchar(64) COLLATE utf8_bin NOT NULL,
    `tables` text COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Favorite tables';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__history`
  --
  
  CREATE TABLE `pma__history` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `sqlquery` text COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history for phpMyAdmin';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__navigationhiding`
  --
  
  CREATE TABLE `pma__navigationhiding` (
    `username` varchar(64) COLLATE utf8_bin NOT NULL,
    `item_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `item_type` varchar(64) COLLATE utf8_bin NOT NULL,
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `table_name` varchar(64) COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Hidden items of navigation tree';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__pdf_pages`
  --
  
  CREATE TABLE `pma__pdf_pages` (
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `page_nr` int(10) UNSIGNED NOT NULL,
    `page_descr` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT ''
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF relation pages for phpMyAdmin';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__recent`
  --
  
  CREATE TABLE `pma__recent` (
    `username` varchar(64) COLLATE utf8_bin NOT NULL,
    `tables` text COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Recently accessed tables';
  
  --
  -- Volcado de datos para la tabla `pma__recent`
  --
  
  INSERT INTO `pma__recent` (`username`, `tables`) VALUES
  ('root', '[{\"db\":\"mydb\",\"table\":\"modulo\"},{\"db\":\"cliente\",\"table\":\"cliente\"},{\"db\":\"sfc\",\"table\":\"cliente\"}]');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__relation`
  --
  
  CREATE TABLE `pma__relation` (
    `master_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `master_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `master_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `foreign_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `foreign_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `foreign_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__savedsearches`
  --
  
  CREATE TABLE `pma__savedsearches` (
    `id` int(5) UNSIGNED NOT NULL,
    `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `search_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `search_data` text COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved searches';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__table_coords`
  --
  
  CREATE TABLE `pma__table_coords` (
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `pdf_page_number` int(11) NOT NULL DEFAULT '0',
    `x` float UNSIGNED NOT NULL DEFAULT '0',
    `y` float UNSIGNED NOT NULL DEFAULT '0'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin PDF output';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__table_info`
  --
  
  CREATE TABLE `pma__table_info` (
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
    `display_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT ''
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for phpMyAdmin';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__table_uiprefs`
  --
  
  CREATE TABLE `pma__table_uiprefs` (
    `username` varchar(64) COLLATE utf8_bin NOT NULL,
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `prefs` text COLLATE utf8_bin NOT NULL,
    `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables'' UI preferences';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__tracking`
  --
  
  CREATE TABLE `pma__tracking` (
    `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
    `version` int(10) UNSIGNED NOT NULL,
    `date_created` datetime NOT NULL,
    `date_updated` datetime NOT NULL,
    `schema_snapshot` text COLLATE utf8_bin NOT NULL,
    `schema_sql` text COLLATE utf8_bin,
    `data_sql` longtext COLLATE utf8_bin,
    `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') COLLATE utf8_bin DEFAULT NULL,
    `tracking_active` int(1) UNSIGNED NOT NULL DEFAULT '1'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database changes tracking for phpMyAdmin';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__userconfig`
  --
  
  CREATE TABLE `pma__userconfig` (
    `username` varchar(64) COLLATE utf8_bin NOT NULL,
    `timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `config_data` text COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User preferences storage for phpMyAdmin';
  
  --
  -- Volcado de datos para la tabla `pma__userconfig`
  --
  
  INSERT INTO `pma__userconfig` (`username`, `timevalue`, `config_data`) VALUES
  ('root', '2019-01-23 21:42:46', '{\"lang\":\"es\",\"Console\\/Mode\":\"collapse\"}');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__usergroups`
  --
  
  CREATE TABLE `pma__usergroups` (
    `usergroup` varchar(64) COLLATE utf8_bin NOT NULL,
    `tab` varchar(64) COLLATE utf8_bin NOT NULL,
    `allowed` enum('Y','N') COLLATE utf8_bin NOT NULL DEFAULT 'N'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User groups with configured menu items';
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `pma__users`
  --
  
  CREATE TABLE `pma__users` (
    `username` varchar(64) COLLATE utf8_bin NOT NULL,
    `usergroup` varchar(64) COLLATE utf8_bin NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and their assignments to user groups';
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `pma__bookmark`
  --
  ALTER TABLE `pma__bookmark`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indices de la tabla `pma__central_columns`
  --
  ALTER TABLE `pma__central_columns`
    ADD PRIMARY KEY (`db_name`,`col_name`);
  
  --
  -- Indices de la tabla `pma__column_info`
  --
  ALTER TABLE `pma__column_info`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`);
  
  --
  -- Indices de la tabla `pma__designer_settings`
  --
  ALTER TABLE `pma__designer_settings`
    ADD PRIMARY KEY (`username`);
  
  --
  -- Indices de la tabla `pma__export_templates`
  --
  ALTER TABLE `pma__export_templates`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`);
  
  --
  -- Indices de la tabla `pma__favorite`
  --
  ALTER TABLE `pma__favorite`
    ADD PRIMARY KEY (`username`);
  
  --
  -- Indices de la tabla `pma__history`
  --
  ALTER TABLE `pma__history`
    ADD PRIMARY KEY (`id`),
    ADD KEY `username` (`username`,`db`,`table`,`timevalue`);
  
  --
  -- Indices de la tabla `pma__navigationhiding`
  --
  ALTER TABLE `pma__navigationhiding`
    ADD PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`);
  
  --
  -- Indices de la tabla `pma__pdf_pages`
  --
  ALTER TABLE `pma__pdf_pages`
    ADD PRIMARY KEY (`page_nr`),
    ADD KEY `db_name` (`db_name`);
  
  --
  -- Indices de la tabla `pma__recent`
  --
  ALTER TABLE `pma__recent`
    ADD PRIMARY KEY (`username`);
  
  --
  -- Indices de la tabla `pma__relation`
  --
  ALTER TABLE `pma__relation`
    ADD PRIMARY KEY (`master_db`,`master_table`,`master_field`),
    ADD KEY `foreign_field` (`foreign_db`,`foreign_table`);
  
  --
  -- Indices de la tabla `pma__savedsearches`
  --
  ALTER TABLE `pma__savedsearches`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`);
  
  --
  -- Indices de la tabla `pma__table_coords`
  --
  ALTER TABLE `pma__table_coords`
    ADD PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`);
  
  --
  -- Indices de la tabla `pma__table_info`
  --
  ALTER TABLE `pma__table_info`
    ADD PRIMARY KEY (`db_name`,`table_name`);
  
  --
  -- Indices de la tabla `pma__table_uiprefs`
  --
  ALTER TABLE `pma__table_uiprefs`
    ADD PRIMARY KEY (`username`,`db_name`,`table_name`);
  
  --
  -- Indices de la tabla `pma__tracking`
  --
  ALTER TABLE `pma__tracking`
    ADD PRIMARY KEY (`db_name`,`table_name`,`version`);
  
  --
  -- Indices de la tabla `pma__userconfig`
  --
  ALTER TABLE `pma__userconfig`
    ADD PRIMARY KEY (`username`);
  
  --
  -- Indices de la tabla `pma__usergroups`
  --
  ALTER TABLE `pma__usergroups`
    ADD PRIMARY KEY (`usergroup`,`tab`,`allowed`);
  
  --
  -- Indices de la tabla `pma__users`
  --
  ALTER TABLE `pma__users`
    ADD PRIMARY KEY (`username`,`usergroup`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `pma__bookmark`
  --
  ALTER TABLE `pma__bookmark`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `pma__column_info`
  --
  ALTER TABLE `pma__column_info`
    MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `pma__export_templates`
  --
  ALTER TABLE `pma__export_templates`
    MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT de la tabla `pma__history`
  --
  ALTER TABLE `pma__history`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `pma__pdf_pages`
  --
  ALTER TABLE `pma__pdf_pages`
    MODIFY `page_nr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `pma__savedsearches`
  --
  ALTER TABLE `pma__savedsearches`
    MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
  --
  -- Base de datos: `test`
  --
  CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  USE `test`;
  --
  -- Base de datos: `usuarios`
  --
  CREATE DATABASE IF NOT EXISTS `usuarios` DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish_ci;
  USE `usuarios`;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `users`
  --
  
  CREATE TABLE `users` (
    `id` int(11) NOT NULL,
    `username` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
    `password` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
    `authKey` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
    `accessToken` varchar(250) COLLATE utf8_spanish_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  COMMIT;
  
  /*!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 */;
  