 PMA_token |s:32:"503b60222c32743b2729626a2c444f73"; HMAC_secret |s:16:"_5[6pA3$>TxPPs*O";auth_type|s:3:"env";browser_access_time|a:5:{s:7:"default";i:1736443879;s:36:"03309dc2-c74c-5865-b24c-3e3e6eb690ef";i:1736448062;s:36:"a989e94d-4518-76cc-e6ae-99d285e75a1f";i:1736437981;s:36:"29a80b41-3cae-e801-85e3-16f105f752f8";i:1736442714;s:36:"429904a5-9c35-9dde-722b-3955ecf9a411";i:1736447843;}encryption_key|s:32:"¥"YP×g ¿EB<LËJ‡³.šÞ¯aÂ¹méŽÅü~";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.1";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:2:{s:4:"lang";s:2:"es";s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1736436620;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1736436620;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1698023484;s:9:"userprefs";a:2:{s:4:"lang";s:2:"es";s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:13:"server_1_yala";a:19:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:1:{i:0;s:8:"yala\_bd";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:14:"Bases de datos";s:3:"sql";s:3:"SQL";s:6:"status";s:13:"Estado actual";s:6:"rights";s:8:"Usuarios";s:6:"export";s:8:"Exportar";s:6:"import";s:8:"Importar";s:8:"settings";s:14:"ConfiguraciÃ³n";s:6:"binlog";s:16:"Registro binario";s:11:"replication";s:12:"ReplicaciÃ³n";s:4:"vars";s:9:"Variables";s:7:"charset";s:20:"Juegos de caracteres";s:7:"plugins";s:12:"Complementos";s:6:"engine";s:7:"Motores";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:10:"Estructura";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Buscar";s:5:"query";s:20:"Generar una consulta";s:6:"export";s:8:"Exportar";s:6:"import";s:8:"Importar";s:9:"operation";s:11:"Operaciones";s:10:"privileges";s:11:"Privilegios";s:8:"routines";s:7:"Rutinas";s:6:"events";s:7:"Eventos";s:8:"triggers";s:12:"Disparadores";s:8:"tracking";s:11:"Seguimiento";s:8:"designer";s:10:"DiseÃ±ador";s:15:"central_columns";s:18:"Columnas centrales";}s:19:"profiling_supported";b:1;s:17:"menu-levels-table";a:11:{s:6:"browse";s:8:"Examinar";s:9:"structure";s:10:"Estructura";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Buscar";s:6:"insert";s:8:"Insertar";s:6:"export";s:8:"Exportar";s:6:"import";s:8:"Importar";s:10:"privileges";s:11:"Privilegios";s:9:"operation";s:11:"Operaciones";s:8:"tracking";s:11:"Seguimiento";s:8:"triggers";s:12:"Disparadores";}s:24:"disabled_storage_engines";s:0:"";s:12:"is_superuser";b:0;s:14:"mysql_cur_user";s:14:"yala@localhost";s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:16:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:2:{i:0;a:2:{s:2:"db";s:7:"yala_bd";s:5:"table";s:10:"tbl_compra";}i:1;a:2:{s:2:"db";s:7:"yala_bd";s:5:"table";s:19:"tbl_detalles_compra";}}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:7:"yala_bd";s:5:"query";a:10:{s:32:"699fff63b6d6d61f5e48ea5f608f4920";a:8:{s:3:"sql";s:84:"SELECT COUNT(*) AS cantidad FROM tbl_compra WHERE id_evento = 11 AND id_usuario = 1;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"eefb945e4f233278329a7d71e1df98e9";a:8:{s:3:"sql";s:88:"DELETE FROM `tbl_detalles_compra` WHERE `tbl_detalles_compra`.`id_detalles` = 0000000012";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"75d9a1b6660c3eb0d83a12cd8a56bc92";a:8:{s:3:"sql";s:68:"DELETE FROM `tbl_compra` WHERE `tbl_compra`.`id_compra` = 0000000017";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"c99139d1af1577da95a686bd4b124393";a:8:{s:3:"sql";s:35:"SELECT * FROM `tbl_detalles_compra`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"271d07e3a4072c2d8928f6bb5c329e2b";a:8:{s:3:"sql";s:88:"DELETE FROM `tbl_detalles_compra` WHERE `tbl_detalles_compra`.`id_detalles` = 0000000015";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"1482669ccac6fa269693b4140c543294";a:8:{s:3:"sql";s:88:"DELETE FROM `tbl_detalles_compra` WHERE `tbl_detalles_compra`.`id_detalles` = 0000000014";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"fb5eec949854d18acf47285a5bf32e88";a:8:{s:3:"sql";s:88:"DELETE FROM `tbl_detalles_compra` WHERE `tbl_detalles_compra`.`id_detalles` = 0000000013";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"f0300c9447176170ca868cc2c541cc85";a:8:{s:3:"sql";s:26:"SELECT * FROM `tbl_compra`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"153ca2ba646a05a8b5d53de35c8805f0";a:8:{s:3:"sql";s:68:"DELETE FROM `tbl_compra` WHERE `tbl_compra`.`id_compra` = 0000000018";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"92d7ebc933b0b4e5b4a30f9434efcae6";a:8:{s:3:"sql";s:48:"SELECT * FROM `tbl_compra` WHERE id_compra = 19;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:20:"possible_as_geometry";b:1;s:13:"table_uiprefs";a:1:{i:1;a:1:{s:7:"yala_bd";a:4:{s:1:"e";a:0:{}s:2:"dc";a:0:{}s:10:"tbl_compra";a:0:{}s:19:"tbl_detalles_compra";a:0:{}}}}}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}flashMessages|a:0:{}Import_message|a:2:{s:7:"message";N;s:11:"go_back_url";s:60:"index.php?route=/table/structure&db=yala_bd&table=tbl_compra";}is_multi_query|b:0;sql_history|a:20:{i:0;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:286:"SELECT e.*, c.nombre AS categoria, u.usuario AS organizador, u.ruc AS organizador_ruc
        FROM tbl_evento e 
        INNER JOIN tbl_categoria c ON e.id_categoria = c.id_categoria
        INNER JOIN tbl_usuario u ON e.id_organizador = u.id_usuario
        WHERE e.id_evento = 11;";}i:1;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:299:"SELECT e.nombre, e.imagen, e.banner, e.portada, u.usuario AS organizador, u.ruc AS organizador_ruc
        FROM tbl_evento e 
        INNER JOIN tbl_categoria c ON e.id_categoria = c.id_categoria
        INNER JOIN tbl_usuario u ON e.id_organizador = u.id_usuario
        WHERE e.id_evento = 11;";}i:2;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:228:"SELECT e.nombre, e.imagen, e.banner, e.portada, u.usuario AS organizador, u.ruc AS organizador_ruc
        FROM tbl_evento e 
        INNER JOIN tbl_usuario u ON e.id_organizador = u.id_usuario
        WHERE e.id_evento = 11;";}i:3;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:138:"SELECT dc.id_entrada, e.nombre, dc.cantidad FROM tbl_detalles_compra dc
        INNER JOIN tbl_entrada e ON dc.id_entrada = e.id_entrada;";}i:4;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:156:"SELECT dc.id_entrada, e.nombre, dc.cantidad, e.precio_regular FROM tbl_detalles_compra dc
        INNER JOIN tbl_entrada e ON dc.id_entrada = e.id_entrada;";}i:5;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:258:"SELECT e.nombre, e.imagen, e.banner, e.portada, e.direccion, e.fecha, e.hora, u.usuario AS organizador, u.ruc AS organizador_ruc
        FROM tbl_evento e 
        INNER JOIN tbl_usuario u ON e.id_organizador = u.id_usuario
        WHERE e.id_evento = 11;";}i:6;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:10:"tbl_compra";s:8:"sqlquery";s:26:"SELECT * FROM `tbl_compra`";}i:7;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:19:"tbl_detalles_compra";s:8:"sqlquery";s:35:"SELECT * FROM `tbl_detalles_compra`";}i:8;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:19:"tbl_detalles_compra";s:8:"sqlquery";s:35:"SELECT * FROM `tbl_detalles_compra`";}i:9;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:172:"SELECT dc.id_detalles, dc.id_entrada, e.nombre, dc.cantidad, e.precio_regular FROM tbl_detalles_compra dc
        INNER JOIN tbl_entrada e ON dc.id_entrada = e.id_entrada;";}i:10;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:204:"SELECT dc.id_detalles, dc.id_entrada, e.nombre, dc.cantidad, e.precio_regular FROM tbl_detalles_compra dc
        INNER JOIN tbl_entrada e ON dc.id_entrada = e.id_entrada WHERE dc.id_compra = 0000000003;";}i:11;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:0:"";s:8:"sqlquery";s:258:"SELECT e.nombre, e.imagen, e.banner, e.portada, e.direccion, e.fecha, e.hora, u.usuario AS organizador, u.ruc AS organizador_ruc
        FROM tbl_evento e 
        INNER JOIN tbl_usuario u ON e.id_organizador = u.id_usuario
        WHERE e.id_evento = 11;";}i:12;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:19:"tbl_detalles_compra";s:8:"sqlquery";s:35:"SELECT * FROM `tbl_detalles_compra`";}i:13;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:10:"tbl_compra";s:8:"sqlquery";s:84:"SELECT COUNT(*) AS cantidad FROM tbl_compra WHERE id_evento = 11 AND id_usuario = 1;";}i:14;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:10:"tbl_compra";s:8:"sqlquery";s:26:"SELECT * FROM `tbl_compra`";}i:15;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:19:"tbl_detalles_compra";s:8:"sqlquery";s:35:"SELECT * FROM `tbl_detalles_compra`";}i:16;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:10:"tbl_compra";s:8:"sqlquery";s:26:"SELECT * FROM `tbl_compra`";}i:17;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:19:"tbl_detalles_compra";s:8:"sqlquery";s:35:"SELECT * FROM `tbl_detalles_compra`";}i:18;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:10:"tbl_compra";s:8:"sqlquery";s:26:"SELECT * FROM `tbl_compra`";}i:19;a:3:{s:2:"db";s:7:"yala_bd";s:5:"table";s:10:"tbl_compra";s:8:"sqlquery";s:48:"SELECT * FROM `tbl_compra` WHERE id_compra = 19;";}}errors|a:0:{}