01-11-24, 09:42 PM
Csv File
size: 92.7 kB
![[Image: p_3227noff61.png]](https://l.top4top.io/p_3227noff61.png)
![[Image: p_32277duu71.png]](https://g.top4top.io/p_32277duu71.png)
![[Image: p_32272jjj91.png]](https://e.top4top.io/p_32272jjj91.png)
size: 92.7 kB
PHP Code:
db body name type created modified sql_mode comment definer returns body_utf8 language param_list aggregate db_collation security_type specific_name sql_data_access is_deterministic character_set_client collation_connection
mysql begin\n set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end AddGeometryColumn PROCEDURE 2023-09-17 17:33:49 2023-09-17 17:33:49 <blank> <blank> mariadb.sys@localhost <blank> begin\n set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end SQL catalog varchar(64), t_schema varchar(64),\n t_name varchar(64), geometry_column varchar(64), t_srid int NONE utf8mb4_general_ci INVOKER AddGeometryColumn CONTAINS_SQL NO utf8mb3 utf8mb3_general_ci
mysql begin\n set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end DropGeometryColumn PROCEDURE 2023-09-17 17:33:49 2023-09-17 17:33:49 <blank> <blank> mariadb.sys@localhost <blank> begin\n set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' DROP ', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end SQL catalog varchar(64), t_schema varchar(64),\n t_name varchar(64), geometry_column varchar(64) NONE utf8mb4_general_ci INVOKER DropGeometryColumn CONTAINS_SQL NO utf8mb3 utf8mb3_general_ci
sys BEGIN\n DECLARE v_done bool DEFAULT FALSE;\n DECLARE v_db_name_check VARCHAR(64);\n DECLARE v_db_err_msg TEXT;\n DECLARE v_table VARCHAR(64);\n DECLARE v_views_created INT DEFAULT 0;\n DECLARE v_table_exists ENUM('', 'BASE TABLE', 'VIEW', 'TEMPORARY') DEFAULT '';\n DECLARE v_temp_table TEXT;\n DECLARE c_table_names CURSOR FOR\n SELECT TABLE_NAME\n FROM INFORMATION_SCHEMA.TABLES\n WHERE TABLE_SCHEMA = in_db_name;\n DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_done = TRUE;\n SELECT SCHEMA_NAME INTO v_db_name_check\n FROM INFORMATION_SCHEMA.SCHEMATA\n WHERE SCHEMA_NAME = in_db_name;\n IF v_db_name_check IS NULL THEN\n SET v_db_err_msg = CONCAT('Unknown database ', in_db_name);\n SIGNAL SQLSTATE 'HY000'\n SET MESSAGE_TEXT = v_db_err_msg;\n END IF;\n SELECT SCHEMA_NAME INTO v_db_name_check\n FROM INFORMATION_SCHEMA.SCHEMATA\n WHERE SCHEMA_NAME = in_synonym;\n IF v_db_name_check = in_synonym THEN\n SET v_db_err_msg = CONCAT('Can\\'t create database ', in_synonym, '; database exists');\n SIGNAL SQLSTATE 'HY000'\n SET MESSAGE_TEXT = v_db_err_msg;\n END IF;\n SET @create_db_stmt := CONCAT('CREATE DATABASE ', sys.quote_identifier(in_synonym));\n PREPARE create_db_stmt FROM @create_db_stmt;\n EXECUTE create_db_stmt;\n DEALLOCATE PREPARE create_db_stmt;\n SET v_done = FALSE;\n OPEN c_table_names;\n c_table_names: LOOP\n FETCH c_table_names INTO v_table;\n IF v_done THEN\n LEAVE c_table_names;\n END IF;\n CALL sys.table_exists(in_db_name, v_table, v_table_exists);\n IF (v_table_exists = 'TEMPORARY') THEN\n SET v_temp_table =\n CONCAT(\n 'Table',\n sys.quote_identifier(in_db_name),\n '.',\n sys.quote_identifier(v_table),\n 'shadows base table. View cannot be created! Terminating!');\n SIGNAL SQLSTATE 'HY000'\n SET MESSAGE_TEXT = v_temp_table;\n LEAVE c_table_names;\n END IF;\n SET @create_view_stmt = CONCAT(\n 'CREATE SQL SECURITY INVOKER VIEW ',\n sys.quote_identifier(in_synonym),\n '.',\n sys.quote_identifier(v_table),\n ' AS SELECT * FROM ',\n sys.quote_identifier(in_db_name),\n '.',\n sys.quote_identifier(v_table)\n );\n PREPARE create_view_stmt FROM @create_view_stmt;\n EXECUTE create_view_stmt;\n DEALLOCATE PREPARE create_view_stmt;\n SET v_views_created = v_views_created + 1;\n END LOOP;\n CLOSE c_table_names;\n SELECT CONCAT(\n 'Created ', v_views_created, ' view',\n IF(v_views_created != 1, 's', ''), ' in the ',\n sys.quote_identifier(in_synonym), ' database'\n ) AS summary;\nEND create_synonym_db PROCEDURE 2023-09-17 17:34:14 2023-09-17 17:34:14 <blank> \n Description\n Takes a source database name and synonym name, and then creates the\n synonym database with views that point to all of the tables within\n the source database.\n Useful for creating a "ps" synonym for "performance_schema",\n or "is" instead of "information_schema", for example.\n Parameters\n in_db_name (VARCHAR(64)):\n The database name that you would like to create a synonym for.\n in_synonym (VARCHAR(64)):\n The database synonym name.\n Example\n mysql> SHOW DATABASES;\n +--------------------+\n | Database |\n +--------------------+\n | information_schema |\n | mysql |\n | performance_schema |\n | sys |\n | test |\n +--------------------+\n 5 rows in set (0.00 sec)\n mysql> CALL sys.create_synonym_db('performance_schema', 'ps');\n +---------------------------------------+\n | summary |\n +---------------------------------------+\n | Created 74 views in the `ps` database |\n +---------------------------------------+\n 1 row in set (8.57 sec)\n Query OK, 0 rows affected (8.57 sec)\n mysql> SHOW DATABASES;\n +--------------------+\n | Database |\n +--------------------+\n | information_schema |\n | mysql |\n | performance_schema |\n | ps |\n | sys |\n | test |\n +--------------------+\n 6 rows in set (0.00 sec)\n mysql> SHOW FULL TABLES FROM ps;\n +------------------------------------------------------+------------+\n | Tables_in_ps | Table_type |\n +------------------------------------------------------+------------+\n | accounts | VIEW |\n | cond_instances | VIEW |\n | events_stages_current | VIEW |\n | events_stages_history | VIEW |\n ...\n mariadb.sys@localhost <blank> BEGIN\n DECLARE v_done bool DEFAULT FALSE;\n DECLARE v_db_name_check VARCHAR(64);\n DECLARE v_db_err_msg TEXT;\n DECLARE v_table VARCHAR(64);\n DECLARE v_views_created INT DEFAULT 0;\n DECLARE v_table_exists ENUM('', 'BASE TABLE', 'VIEW', 'TEMPORARY') DEFAULT '';\n DECLARE v_temp_table TEXT;\n DECLARE c_table_names CURSOR FOR\n SELECT TABLE_NAME\n FROM INFORMATION_SCHEMA.TABLES\n WHERE TABLE_SCHEMA = in_db_name;\n DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_done = TRUE;\n SELECT SCHEMA_NAME INTO v_db_name_check\n FROM INFORMATION_SCHEMA.SCHEMATA\n WHERE SCHEMA_NAME = in_db_name;\n IF v_db_name_check IS NULL THEN\n SET v_db_err_msg = CONCAT('Unknown database ', in_db_name);\n SIGNAL SQLSTATE 'HY000'\n SET MESSAGE_TEXT = v_db_err_msg;\n END IF;\n SELECT SCHEMA_NAME INTO v_db_name_check\n FROM INFORMATION_SCHEMA.SCHEMATA\n WHERE SCHEMA_NAME = in_synonym;\n IF v_db_name_check = in_synonym THEN\n SET v_db_err_msg = CONCAT('Can''t create database ', in_synonym, '; database exists');\n SIGNAL SQLSTATE 'HY000'\n SET MESSAGE_TEXT = v_db_err_msg;\n END IF;\n SET @create_db_stmt := CONCAT('CREATE DATABASE ', sys.quote_identifier(in_synonym));\n PREPARE create_db_stmt FROM @create_db_stmt;\n EXECUTE create_db_stmt;\n DEALLOCATE PREPARE create_db_stmt;\n SET v_done = FALSE;\n OPEN c_table_names;\n c_table_names: LOOP\n FETCH c_table_names INTO v_table;\n IF v_done THEN\n LEAVE c_table_names;\n END IF;\n CALL sys.table_exists(in_db_name, v_table, v_table_exists);\n IF (v_table_exists = 'TEMPORARY') THEN\n SET v_temp_table =\n CONCAT(\n 'Table',\n sys.quote_identifier(in_db_name),\n '.',\n sys.quote_identifier(v_table),\n 'shadows base table. View cannot be created! Terminating!');\n SIGNAL SQLSTATE 'HY000'\n SET MESSAGE_TEXT = v_temp_table;\n LEAVE c_table_names;\n END IF;\n SET @create_view_stmt = CONCAT(\n 'CREATE SQL SECURITY INVOKER VIEW ',\n sys.quote_identifier(in_synonym),\n '.',\n sys.quote_identifier(v_table),\n ' AS SELECT * FROM ',\n sys.quote_identifier(in_db_name),\n '.',\n sys.quote_identifier(v_table)\n );\n PREPARE create_view_stmt FROM @create_view_stmt;\n EXECUTE create_view_stmt;\n DEALLOCATE PREPARE create_view_stmt;\n SET v_views_created = v_views_created + 1;\n END LOOP;\n CLOSE c_table_names;\n SELECT CONCAT(\n 'Created ', v_views_created, ' view',\n IF(v_views_created != 1, 's', ''), ' in the ',\n sys.quote_identifier(in_synonym), ' database'\n ) AS summary;\nEND SQL \n IN in_db_name VARCHAR(64),\n IN in_synonym VARCHAR(64)\n NONE utf8mb3_general_ci INVOKER create_synonym_db MODIFIES_SQL_DATA NO utf8mb3 utf8mb3_general_ci
PHP Code:
+-----------------------------+-----------------------+---------------------+----------------+----------------------------------------------+
| email | fullname | laston | nickname | password |
+-----------------------------+-----------------------+---------------------+----------------+----------------------------------------------+
| <blank> | Domyślny użytkownik | 0000-00-00 00:00:00 | <blank> | <blank> |
| <blank> | Mariusz Makowski | 0000-00-00 00:00:00 | Makus | <blank> |
| <blank> | Małgorzata Jakubowska | 2004-04-01 13:23:34 | <blank> | de8313e6cef29b2ba317c1565eb3b632 |
| <blank> | Małgorzata Jakubowska | 2004-04-01 13:23:34 | <blank> | de8313e6cef29b2ba317c1565eb3b632 |
| <blank> | Małgorzata Jakubowska | 2004-04-01 13:23:34 | <blank> | de8313e6cef29b2ba317c1565eb3b632 |
| <blank> | Ewa Wojciechowska | 0000-00-00 00:00:00 | <blank> | 6368b428fa30fde28457a5c9c08db7c4 |
| <blank> | Ewa Wojciechowska | 0000-00-00 00:00:00 | <blank> | 6368b428fa30fde28457a5c9c08db7c4 |
| b0n07d@poczta.onet.pl | Piotr Zelga | 0000-00-00 00:00:00 | <blank> | <blank> |
| bartosz@retsat1.com.pl | Bartek Kasielski | 2004-04-01 17:09:38 | Bartek | 2fe04e524ba40505a82e03a2819429cc (ola) |
| cienias@magres.net | Piotr M. Cie?ski | 2009-10-10 19:07:11 | Cienias | 5ddf30ab82d65289c0445a6bf2210520 |
| filippo@o2.pl | Filip Gusta | 2004-04-03 16:04:23 | Gustlik | 9bce8b9c80f4fb897d930c18e99d1002 (100184) |
| graczyq@magres.net | Michał Graczykowski | 2013-08-14 20:08:16 | Graczyk | 87df2cd1570fd297de238aeee667fe0a (satan) |
| imka13@poczta.onet.pl | Zosia Szajdzińska | 2005-07-12 17:14:39 | Imka | fbf948ed25042c3ceec8ae63819051d6 |
| jarpiekar@wp.pl | Jarek Piekarski | 2004-11-04 21:05:03 | Jaro | 7dfd69275b7272fc452b5e949ce5939c |
| kotyn@poczta.onet.pl | Łukasz Kotynia | 2004-12-28 13:25:42 | Kotyń | be87549e2c11f93ef83d42a60ba8cd93 |
| m.grabowska@arcadis.pl | Matylda Grabowska | 2014-10-08 22:46:15 | Mati; Skrzacik | ae5de31fe99f0d149a76b839f57a7e25 |
| marc.o_at_wp.pl | Marcin Osiniak | 2007-02-28 04:41:08 | Marcin Osiniak | 733fa256da0656a4bf48fdb5d91a3b4a |
| marcin_box@poczta.onet.pl | Marcin Pude?ek | 2019-04-04 20:19:16 | Pude? | 5820d207325bcd378bcd69fdf0af3591 |
| mariuszsokol@poczta.onet.pl | Mariusz Sokół | 2006-07-09 15:43:46 | <blank> | 6b5b602242c60d5bcb54f0cf32383b6f (zaria) |
| michal@amicus.lodz.pl | Michał Lange | 2003-07-19 18:35:20 | <blank> | a8f64d3dcd752fa18cd420569e505072 |
| orca@retsat1.net | Ewa Gałecka | 2006-11-04 21:43:22 | Ewa | c3a6142a2cf5f758f4e91f45ec0852a0 (ahimsa8) |
| ortie@wp.pl | Marcin Pokrzewiński | 2004-11-02 22:39:18 | POKRZEW | 3047c9424099b65eb6671874782a4635 |
| pyro@magres.net | Michał Głowacki | 2006-08-23 10:41:10 | Pyro | d159414650f6763682ea5205a4b95ddd |
| qbek_2000@wp.pl | Kuba Pilarski | 2007-07-16 18:08:07 | Kubuś | b2ca678b4c936f905fb82f2733f5297f (qqq) |
| scajaczek@tlen.pl | Sylwia Zając | 2003-10-20 00:53:11 | Sylwia | e8dd7f903f26c504f9d8afcbb0edf5b9 |
| skuszka@poczta.onet.pl | Kasia Skucha | 0000-00-00 00:00:00 | Kasia | <blank> |
| szczepan@magres.net | Piotr Szczepaniec | 2016-02-11 10:33:56 | Szczepan | e11c55f555b3aeafa73ab6a80578a8e6 |
| szyman@halflife.pl | Piotr Szyma?ski | 2012-03-05 19:26:55 | Szyman | dd96e85a9598ab143c5397483ae36521 |
| szyman@magres.net | Administrator systemu | 2019-04-04 13:32:11 | Szyman | dd96e85a9598ab143c5397483ae36521 |
| szymor_magres.net | Piotr Szymor | 2014-08-21 02:02:31 | szymoire | a10b0f21df19fc2a1b46690a9b24372c |
| tomcio-13@wp.pl | Tomek Liszewski | 2009-07-25 08:31:09 | <blank> | 25f9e794323b453885f5181f1b624d0b (123456789) |
| vardzio@magres.net | Piotr Wardaszko | 2014-08-26 19:03:11 | Vardzio | 483053b74793b5255e0efc4e216304ae |
| vlk@bmp.net.pl | Valique | 2004-07-05 13:09:17 | Valique | 5419d410a42987cd44a17bf74be339f6 |
| wizard@klub.chip.pl | Marcin Balcerzak | 2004-05-15 02:09:02 | Balcer | 22c2ffd621fb6a4831c3971cf6679676 |
| y-namiot@wp.pl | Piotr Namieciński | 2003-04-28 16:25:13 | Namiot | 13b328e6632ee164de815ca113d8c9ad |
| yaceq@toya.net.pl | Jacek Dziworski | 2005-02-02 03:23:14 | YaCeQ | 2d58b0ac72f929ca9ad3238ade9eab69 (pantera) |
+-----------------------------+-----------------------+---------------------+----------------+----------------------------------------------+