[adminer-svn] SF.net SVN: adminer:[1448] branches/sqlite
Database management in a single PHP file
Brought to you by:
jakubvrana
From: <jak...@us...> - 2010-04-16 12:52:17
|
Revision: 1448 http://adminer.svn.sourceforge.net/adminer/?rev=1448&view=rev Author: jakubvrana Date: 2010-04-16 12:52:11 +0000 (Fri, 16 Apr 2010) Log Message: ----------- Comments Modified Paths: -------------- branches/sqlite/adminer/include/adminer.inc.php branches/sqlite/adminer/include/auth.inc.php branches/sqlite/todo.txt Modified: branches/sqlite/adminer/include/adminer.inc.php =================================================================== --- branches/sqlite/adminer/include/adminer.inc.php 2010-04-16 12:51:37 UTC (rev 1447) +++ branches/sqlite/adminer/include/adminer.inc.php 2010-04-16 12:52:11 UTC (rev 1448) @@ -340,7 +340,7 @@ function selectOrderProcess($fields, $indexes) { $return = array(); foreach ((array) $_GET["order"] as $key => $val) { - if (isset($fields[$val]) || preg_match('~^((COUNT\\(DISTINCT |[A-Z0-9_]+\\()(`(?:[^`]|``)+`|"(?:[^"]|"")+")\\)|COUNT\\(\\*\\))$~', $val)) { + if (isset($fields[$val]) || preg_match('~^((COUNT\\(DISTINCT |[A-Z0-9_]+\\()(`(?:[^`]|``)+`|"(?:[^"]|"")+")\\)|COUNT\\(\\*\\))$~', $val)) { //! MS SQL uses [] $return[] = (isset($fields[$val]) ? idf_escape($val) : $val) . (isset($_GET["desc"][$key]) ? " DESC" : ""); } } Modified: branches/sqlite/adminer/include/auth.inc.php =================================================================== --- branches/sqlite/adminer/include/auth.inc.php 2010-04-16 12:51:37 UTC (rev 1447) +++ branches/sqlite/adminer/include/auth.inc.php 2010-04-16 12:52:11 UTC (rev 1448) @@ -54,6 +54,7 @@ session_regenerate_id(); // defense against session fixation set_session("passwords", decrypt_string($cipher, $adminer->permanentLogin())); } + //! redirect ?select=tab } function auth_error($exception = null) { Modified: branches/sqlite/todo.txt =================================================================== --- branches/sqlite/todo.txt 2010-04-16 12:51:37 UTC (rev 1447) +++ branches/sqlite/todo.txt 2010-04-16 12:52:11 UTC (rev 1448) @@ -11,6 +11,7 @@ Add title to Logout, edit (in select) and select (in menu) in style "hever" Shift-click in checkboxes to select range Export by GET parameters +Only first part of big BZ2 export is readable ? LIKE %% operator ? Column and table names auto-completition in SQL textarea ? Aliasing of built-in functions can save 7 KB, function minification can save 7 KB, substitution of repetitive $a["a"] can save 4 KB, substitution of $_GET and friends can save 2 KB, aliasing of $connection->query, $connection->result and $connection->quote can save ~ 3 KB, JS packer can save 1 KB, not enclosing HTML attribute values can save 1.2 KB, replacing \\n by \n can save .3 KB @@ -26,12 +27,12 @@ Add whisperer to fields with foreign key to big table SQLite: -Editing functions CREATE DATABASE - PRAGMA encoding = "UTF-8" Detecion of non-existing database DROP DATABASE by file operations CSV import - ON DUPLICATE KEY UPDATE -Export +Export - views, triggers +Delimiter in export and SQL command PostgreSQL: Users - SELECT * FROM pg_user @@ -42,3 +43,8 @@ Column rights - http://www.postgresql.org/docs/8.4/static/functions-info.html Move table - ALTER TABLE SET SCHEMA bool in Editor + +MS SQL: +Rename by sp_rename +Detection of table collation +PDO driver This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |