beenull/adminerevo
1
0
Fork 0
Code Issues Pull requests Actions Packages Projects Releases Wiki Activity
3909 commits 7 branches 55 tags 9.6 MiB
Commit graph

560 commits

Author SHA1 Message Date
Jakub Vrana 67b84d1167 MySQL: Speed up displaying tables in large databases (bug #700) 2019-08-19 18:29:05 +02:00
Malte Riesch 00d36efcf1 MySQL: Skip editing generated columns 2019-08-19 16:51:28 +02:00
Jakub Vrana d5bf51b2a7 MySQL: Fix getting foreign keys 2019-07-18 08:50:52 +02:00
Jakub Vrana b7b4157bcb Fix table status in PostgreSQL 12 (bug #683) 2019-07-15 13:37:10 +02:00
Jakub Vrana 45caae1660 PostgreSQL: Display definitions of materialized views (bug #682) 2019-07-15 13:03:57 +02:00
Michal Adamec 36e9a4d6e1 Support for viewing and editing of column comments in mssql driver 2019-07-15 12:45:39 +02:00
Jakub Vrana 9b58ecf925 PostgreSQL: Fix setting column comments on new table 2019-07-15 12:21:17 +02:00
Jakub Vrana 36ade4e197 MySQL: Fix displaying multi-columns foreign keys (bug #675) 2019-07-14 19:53:41 +02:00
grass@dionera.com 6a5b0abbb4 Check if PDO SSL Attributes are set within config, and only set them in PDO Options. otherwise Mysql PDO throws errors if attribute is set and empty 2019-07-14 19:20:13 +02:00
Bohuslav Simek 33234fef19 Elasticsearch: Show executed query as a json 2019-07-14 19:11:17 +02:00
Bohuslav Simek 4b6833ba65 MongoDB: number of records should be count on provide rows 2019-07-14 19:10:16 +02:00
Dennis Stolmeijer 327041874e Always pass the SRID part of a geometry property with the GeomFromText function 2019-05-18 17:24:35 +02:00
Jakub Vrana deea21dd2d Allow overwriting tables when copying them 2019-05-14 09:56:29 +02:00
Tim Düsterhus a2fbcbe28e Fix PHP 7.3 compatibility (#318) 2018-12-18 16:17:21 +01:00
helix84 da76e6b9b8 php <5.4 compat: array syntax (#313) 2018-12-18 14:21:23 +01:00
Jakub Vrana e148db4b0f Fix whitespace 2018-11-24 12:16:12 +01:00
Jakub Vrana e546b483a1 Delete copy/pasted code 2018-10-29 11:43:45 +01:00
Jakub Vrana 5bebb439a1 MySQL: Descending indexes in MySQL 8 (bug #643) 2018-10-27 20:05:04 +02:00
sartor 9f0ee9cf41 PostgreSQL: Support for GENERATED BY DEFAULT AS IDENTITY 2018-10-27 19:42:01 +02:00
Jakub Vrana c002009bfe Fix style 2018-10-27 19:38:43 +02:00
sartor a592ad52f1 ClickHouse: support for decimal types, SQL operator 2018-10-27 19:32:52 +02:00
sartor 3127c0d95e ClickHouse: Fix for drop multiple tables and views 2018-10-27 19:32:10 +02:00
sartor 9447d97a6a ClickHouse ALTER DELETE and ALTER UPDATE support 2018-10-27 19:31:35 +02:00
sartor c8e41ee649 ClickHouse fix select-like queries format postfix 2018-10-27 19:30:33 +02:00
Jakub Vrana b327a76fc0 Avoid overwriting existing tables when copying tables (bug #642) 2018-10-27 18:50:50 +02:00
Jakub Vrana 7f2dd73670 PostgreSQL: Export DESC indexes (bug #639) 2018-10-27 18:14:00 +02:00
Jakub Vrana a426fefd40 Remove unused code 2018-09-19 11:16:21 +02:00
Jakub Vrana 0234fe4a66 ClickHouse: Fix escaping 2018-09-18 13:13:34 +02:00
Sartor 1883e250ff ClickHouse support alpha version 2018-09-18 13:09:46 +02:00
harryxu 94f6a45a2a Set default db to sqlsrv connection 2018-09-18 11:44:02 +02:00
Jared Brandt e959e46fa5 Fixes foreign key pattern in MySQL 
Foreign keys are not displaying in MySQL when ANSI_QUOTES is enabled because the preg_match_all() is looking specifically for backticks. This fix allows for double quotes as well, so foreign keys are recognized even when ANSI_QUOTES is enabled.
 2018-07-15 20:51:09 +02:00
Jakub Vrana 26a39ac243 Revert "PgSQL search operator "SQL" added" 
This reverts commit af7ac6f06a.
 2018-06-27 22:23:56 +02:00
Jakub Vrana c564a8ef50 MySQL: Disallow LOAD DATA LOCAL INFILE 2018-06-26 08:53:12 +02:00
Gintautas Miselis b98d0bcc55 mssql: ignore serverproperty error 
This change allows connection to Sybase ASE 15
 2018-06-09 12:25:24 +02:00
Jakub Vrana e856e28892 Add spaces 2018-06-09 12:24:18 +02:00
Jakub Vrana 11f24a52e4 Order database names in MySQL 8(bug #613) 2018-05-06 18:11:03 +02:00
Jakub Vrana 7b60b03e6a Copy triggers when copying table 2018-05-06 17:36:52 +02:00
Jakub Vrana 84c65fcca6 MS SQL: Support port with sqlsrc 2018-05-06 11:46:36 +02:00
Jakub Vrana 733fe9e430 PostgreSQL: Do not cast uuid searches to text (bug #608) 2018-05-06 11:41:59 +02:00
Jakub Vrana 60d1b7b3b4 Disallow using password-less databases 2018-05-04 16:52:41 +02:00
Jakub Vrana db11fa4c1a MongoDB: Consolidate code 2018-05-04 16:39:21 +02:00
Jakub Vrana c3cfc0e69b MongoDB: Consolidate code 2018-05-04 16:38:24 +02:00
Jakub Vrana 5f4d407f2e MongoDB: Consolidate code 2018-05-04 16:37:36 +02:00
Jakub Vrana 70afe70b72 MongoDB: Report version 2018-05-04 15:37:29 +02:00
Jakub Vrana 75f43a4454 Document that Elasticsearch requires allow_url_fopen 2018-05-04 15:26:57 +02:00
Matěj Humpál 78f4513d9d PostgreSQL: Do not cast boolean to text on search (#264) 2018-03-18 14:34:54 +01:00
Jakub Vrana 89c66ccabe PostgreSQL: Do not cast number searches to text 2018-03-13 14:09:53 +01:00
Jakub Vrana 6ba77b7899 PostgreSQL: Fix editing data in views (bug #605) 2018-03-11 16:41:04 +01:00
Jakub Vrana d271d0b481 Elasticsearch: Fix PHP warning 2018-03-11 16:07:54 +01:00
Sartor af7ac6f06a PgSQL search operator "SQL" added 2018-03-11 15:48:42 +01:00
Jakub Vrana 19034c35fe PostgreSQL: Fix slow query 2018-03-10 17:16:07 +01:00
Jakub Vrana 665fafb297 Simplify running slow queries 2018-03-09 18:19:14 +01:00
Jakub Vrana 67c2a91c67 Remove unused argument 2018-03-09 18:19:14 +01:00
David Sinquin cf9cad66e2 MongoDB driver: Add create_database methods. 
MongoDB databases are created on the fly when some data is written in
the database, so this method does not need to do anything.
 2018-03-01 11:48:02 +01:00
Jakub Vrana 26a3967cf9 Fix comment 2018-03-01 11:46:23 +01:00
Jakub Vrana 36b75b4203 Use $adminer->operators 2018-03-01 11:29:04 +01:00
Jakub Vrana 4a24ee7672 PostgreSQL: Do not cast time search 2018-03-01 11:23:01 +01:00
Matěj Humpál e21ddd9767 Do not cast date/timestamp exact searches in PostgreSQL to text 2018-03-01 11:21:50 +01:00
Matěj Humpál f844fc499e Do not cast date/timestamp exact searches in PostgreSQL to text 2018-03-01 11:06:12 +01:00
Jakub Vrana 52d7c38ef1 MySQL: Use CONVERT() only when searching for non-ASCII (bug #603) 2018-03-01 11:01:35 +01:00
Jakub Vrana b1cdc7902b Comment 2018-02-21 00:28:59 +01:00
Jakub Vrana 7b35ebd82e PDO: Support binary fields download 2018-02-20 22:40:20 +01:00
Jakub Vrana b4392b3f91 Use single \ in ' strings 2018-02-20 16:27:40 +01:00
Jakub Vrana d18c7b3587 Promote MongoDB, demote Oracle and MS SQL 2018-02-10 00:09:07 +01:00
Jakub Vrana 879963dec1 PostgreSQL: Add IF EXISTS to DROP SEQUENCE in export (bug #595) 2018-02-09 22:11:27 +01:00
Jakub Vrana eeb7ce1939 PostgreSQL: Fix exporting string default values (thanks to PotatoPangolin) 2018-02-09 15:29:54 +01:00
Jakub Vrana 3906231dc5 Fix exporting sequences in PostgreSQL 10 2018-02-09 14:43:25 +01:00
Jakub Vrana 76d7560d27 MariaDB: Links to documentation 2018-02-08 13:56:22 +01:00
Jakub Vrana cddd61c214 Add more system tables help links 2018-02-08 11:21:33 +01:00
Jakub Vrana 718f9d3791 SQLite: Support ` in PRIMARY KEY 2018-02-07 16:43:21 +01:00
Jakub Vrana 66e7ec56bb SQLite: Allow deleting PRIMARY KEY from tables with auto increment 2018-02-07 14:47:29 +01:00
Jakub Vrana 42eec7d728 Support connecting to MySQL via SSL 2018-02-07 12:13:58 +01:00
Jakub Vrana 02cd416093 Delete unused functions 2018-02-06 16:33:47 +01:00
Jakub Vrana b500a46f9a Add truncate_sql to PostgreSQL 2018-02-06 16:24:12 +01:00
Jakub Vrana 19653de764 PostgreSQL: Unescape bytea fields 2018-02-06 16:05:50 +01:00
Jakub Vrana 17b110f0d5 PostgreSQL: Upload binary files to bytea fields 2018-02-06 15:42:14 +01:00
Jakub Vrana d7f9b6b5de PostgreSQL: Cast to string when searching using LIKE (bug #325) 2018-02-06 13:51:53 +01:00
Jakub Vrana 197abdcb70 MySQL: Support non-utf8 charset in search in column 2018-02-06 13:51:23 +01:00
Jakub Vrana c2de3b8ec1 Use ST_GeomFromText in MySQL 8 (bug #574) 2018-02-06 13:50:40 +01:00
Jakub Vrana a7632fd9fd Fix whitespace 2018-02-06 12:50:44 +01:00
Jakub Vrana 6cfb3676a7 PostgreSQL: Don't treat interval type as number (bug #474) 2018-02-06 12:17:01 +01:00
Jakub Vrana 89ceb06208 Use primary key instead of LIMIT 1 if available 2018-02-05 11:21:19 +01:00
Jakub Vrana 7b0c58af32 Fix affected rows after getting warnings 2018-02-05 09:23:07 +01:00
Jakub Vrana d3cdfc17de Fix number of affected rows after getting warnings 2018-02-05 09:09:41 +01:00
Jakub Vrana 685bf29abc Use separator in limit1 2018-02-01 18:53:53 +01:00
Jakub Vrana 0866c79afb SQLite: Limit rows in data manipulation without unique key 2018-02-01 18:47:57 +01:00
Jakub Vrana 52d98e16fa PostgreSQL: Limit rows in data manipulation without unique key 2018-02-01 16:58:01 +01:00
Jakub Vrana 763e66a148 Don't use ctid as it's not stable 2018-02-01 16:45:31 +01:00
Jakub Vrana f4625da53d Use Oid as the name of the column 2018-02-01 16:15:36 +01:00
Jakub Vrana dc94b2ec38 Save bytes 2018-02-01 16:00:40 +01:00
Jakub Vrana e55f0d7cb2 MySQL: Add FIND_IN_SET search operator 2018-02-01 15:25:38 +01:00
Jakub Vrana 6d55395d9e MySQL: Add floor and ceil functions 2018-02-01 14:32:01 +01:00
Jakub Vrana ae91088cb3 Don't display warnings for failed queries 2018-02-01 13:16:37 +01:00
Jakub Vrana 6b9c0dee14 Use pg_last_notice only with pgsql 2018-02-01 12:03:11 +01:00
Jakub Vrana d667f585e0 Pass start time to selectQuery 2018-02-01 11:54:56 +01:00
Jakub Vrana ebb23a7a88 PostgreSQL: Display warnings 2018-02-01 11:50:15 +01:00
Jakub Vrana e9add6d985 Return string from warnings() 2018-02-01 11:43:44 +01:00
Jakub Vrana 2adc174541 MySQL: Display warnings in SQL command 2018-01-31 17:28:12 +01:00
Jakub Vrana d542843fdd Fix min_version use 2018-01-30 16:42:13 +01:00
Jakub Vrana 78f0a1152e PostgreSQL: Allow editing views with uppercase letters (bug #467) 2018-01-30 16:03:13 +01:00
Jakub Vrana e81334ef87 PostgreSQL: Support functions 2018-01-30 15:18:26 +01:00
Jakub Vrana 92739f48ce SimpleDB: Document that allow_url_fopen is required (bug #340) 2018-01-30 13:19:21 +01:00
Jakub Vrana 75450548b3 Support JSON since MariaDB 10.2 (bug #590) 2018-01-29 21:08:38 +01:00
Jakub Vrana c3b4208853 Use min_version 2018-01-29 20:54:24 +01:00
Jakub Vrana 93686eab65 Save bytes 2018-01-29 18:33:26 +01:00
Jakub Vrana 0d90f1f1dd Fix elastic after ef5a7639 2018-01-27 11:08:56 +01:00
helix84 ef5a76392d fix elastic.inc.php to work on PHP 5.2 
Without this change, I get the following syntax error on PHP 5.2.6:
PHP Parse error:  syntax error, unexpected ':' in /var/www/adminer/adminer/drivers/elastic.inc.php on line 415

I haven't actually tested the alter_table() method.
 2018-01-26 16:48:34 +01:00
Jakub Vrana 34f25afe90 MySQL: Support routines with comments in parameters (bug #460) 2018-01-24 16:37:38 +01:00
Jakub Vrana fb18e814de PostgreSQL: Display foreign tables (bug #576) 2018-01-23 15:03:53 +01:00
Jakub Vrana c789c147b7 MySQL: Support geometry in MySQL 8 (bug #574) 2018-01-22 20:56:35 +01:00
Uherkovich Péter a2adb67d2f MSSQL driver fixed for freetds drivers. See bug #167, #291 2018-01-22 18:35:08 +01:00
Jakub Vrana 0d2b232bd7 Compatibility with PHP < 5.3 2018-01-22 17:30:12 +01:00
Jakub Vrana 83e16e059f Add mongodb as a possible driver 2018-01-22 17:12:48 +01:00
Jakub Vrana 6e4dc3911f Save bytes 2018-01-22 17:05:49 +01:00
Vladimir Goncharov 2a08a11e89 php7 support with minimal changes of original code 2018-01-22 16:59:55 +01:00
Jakub Vrana 993dce398d PostgreSQL: Export DROP SEQUENCE if dropping table 2018-01-22 14:33:21 +01:00
Jakub Vrana eee9a62c8f PostgreSQL: Do not export triggers if not requested 2018-01-22 14:25:27 +01:00
Jakub Vrana ce17b6cf46 Ignore removed CREATE+ALTER mode in trigger_sql() 2018-01-22 14:14:42 +01:00
Jakub Vrana 923c0ffc87 Fix whitespace 2018-01-22 13:51:47 +01:00
Jáchym Toušek 019ada8da5 Fix NULL value in edit form with Postgres 2018-01-22 12:06:15 +01:00
Fabio Montefuscolo d2c82fdeca Enhance ElasticSearch integration 2018-01-19 18:32:41 +01:00
Jakub Vrana 34b03ef835 SQLite: Enable foreign key checks 2018-01-19 14:57:58 +01:00
Jakub Vrana 72b199378a Prevent PHP 7.1 warning about non-numeric values 2018-01-11 16:22:29 +01:00
Jakub Vrana 70aef8a55a MySQL: Remove dedicated view for replication status 2017-05-19 11:11:44 +02:00
Jakub Vrana 0b824dad29 Sort table names (bug #552) 2017-05-19 10:57:20 +02:00
Jakub Vrana fb71941daa PostgreSQL: Fix JSONB version support 2017-04-08 20:17:08 +02:00
Jakub Vrana 504c56216c PostgreSQL: Support JSON and JSONB data types (bug #542) 2017-04-08 19:59:13 +02:00
Deni f4817e8568 Fix table dependency on export 2017-04-08 19:38:03 +02:00
Deni 105aca9b04 Fix PostgreSQL nullable fields in export 2017-04-08 19:37:56 +02:00
Jakub Vrana f556f6acb1 PostgreSQL: Fix index size computation in PostgreSQL < 9.0 (reverts 4c78976c) 2017-04-08 19:33:46 +02:00
Jakub Vrana b616c57352 MySQL: Support JSON data type 2017-03-10 08:15:52 +01:00
Jakub Vrana 50390ea38c Support MySQL 8 2017-03-09 18:52:00 +01:00
Jakub Vrana 8a9df8ede1 Elasticsearch: allow empty server name 2017-02-21 12:07:13 +01:00
Jakub Vrana e4d35f9591 Hide materialized views in MySQL 2017-02-20 19:28:16 +01:00
Jakub Vrana 9df33e82e6 Elasticsearch: Support HTTPS by inputting https://server (bug #446) 2017-02-20 18:06:14 +01:00
Jakub Vrana fa09eba15e Save bytes 2017-02-20 17:25:59 +01:00
Jakub Vrana d5b329a1a4 MySQL: Support spatial indexes (bug #455) 2017-02-20 17:25:34 +01:00
Matthew Gamble 2a534798fa Add basic support for MySQL replication 2017-02-20 12:54:40 +01:00
Jakub Vrana a01ca3ade4 PostgreSQL: Allow changing materialized views 2017-02-20 12:13:09 +01:00
Jakub Vrana 6ee4692afd PostgreSQL: Fix index size computation 2017-02-20 12:06:41 +01:00
Loren Klingman 12aaf506b8 Fix MS SQL Driver to not show warnings for version fetching on connection and to retrieve the next set of results properly 2017-02-19 11:35:24 +01:00
Felix Geyer b8bea7fc56 Hide databases the user can't connect to 
pg_database lists all databases including the ones the user can't connect to.
There is little point in showing them when we know connecting will fail.
 2017-02-19 10:33:22 +01:00
Lubor Bilek 32334f1106 PostgreSQL export: table structure, columns, sequences, indexes, foreign keys, comments, trigger definition 2017-02-19 09:26:47 +01:00
Ion Bazan cf10398104 fixed Elastic table_status() 2017-02-18 18:45:23 +01:00
PiR-B- 4c78976cba Fix index length with Postgresql 2017-02-18 17:42:34 +01:00
Charles Wu 73690164b7 Added pdo_dblib as a driver for MSSQL (as native MSSQL driver does not exist for PHP7) 2017-02-18 17:35:36 +01:00
Massimiliano Torromeo d0268c69da Fixed mssql driver for usage with microsoft's php7 sqlsrv extension 2017-02-18 17:32:40 +01:00
soleuu 86e26846a8 postgresql : ERROR: function connection_id() does not exist 2017-02-18 17:32:40 +01:00
soleuu 6860478950 postgresql : unique partial index musn't be considered as unique. can cause problems on row edition 2017-02-18 17:32:40 +01:00
Jakub Vrana 63f2a041ed Remove global variable 2016-02-28 12:30:52 -08:00