Added query utilities.

Included basic support for ANALYZE, BACKUP, CHECK, CHECKSUM, OPTIMIZE, REPAIR and RESTORE statements.
Better parsing for fields, SELECT statement, INTO keyword.
Improved contexts (included functions).
Improved documentation.
Refactoring and coding style fixes.

1 files changed, 76 insertions, 0 deletions

diff --git a/src/Statements/ShowStatement.php b/src/Statements/ShowStatement.php
new file mode 100644
index 0000000..962a7a3
--- /dev/null
+++ b/src/Statements/ShowStatement.php
@@ -0,0 +1,76 @@
+<?php
+
+namespace SqlParser\Statements;
+
+use SqlParser\Statement;
+
+/**
+ * `SHOW` statement.
+ *
+ * @category   Statements
+ * @package    SqlParser
+ * @subpackage Statements
+ * @author     Dan Ungureanu <udan1107@gmail.com>
+ * @license    http://opensource.org/licenses/GPL-2.0 GNU Public License
+ */
+class ShowStatement extends Statement
+{
+
+    /**
+     * Options of this statement.
+     *
+     * @var array
+     */
+    public static $OPTIONS = array(
+        'CREATE'                        => 1,
+        'AUTHORS'                       => 2,
+        'BINARY'                        => 2,
+        'BINLOG'                        => 2,
+        'CHARACTER'                     => 2,
+        'CODE'                          => 2,
+        'COLLATION'                     => 2,
+        'COLUMNS'                       => 2,
+        'CONTRIBUTORS'                  => 2,
+        'DATABASE'                      => 2,
+        'DATABASES'                     => 2,
+        'ENGINE'                        => 2,
+        'ENGINES'                       => 2,
+        'ERRORS'                        => 2,
+        'EVENT'                         => 2,
+        'EVENTS'                        => 2,
+        'FUNCTION'                      => 2,
+        'GRANTS'                        => 2,
+        'HOSTS'                         => 2,
+        'INDEX'                         => 2,
+        'INNODB'                        => 2,
+        'LOGS'                          => 2,
+        'MASTER'                        => 2,
+        'OPEN'                          => 2,
+        'PLUGINS'                       => 2,
+        'PRIVILEGES'                    => 2,
+        'PROCEDURE'                     => 2,
+        'PROCESSLIST'                   => 2,
+        'PROFILE'                       => 2,
+        'PROFILES'                      => 2,
+        'SCHEDULER'                     => 2,
+        'SET'                           => 2,
+        'SLAVE'                         => 2,
+        'STATUS'                        => 2,
+        'TABLE'                         => 2,
+        'TABLES'                        => 2,
+        'TRIGGER'                       => 2,
+        'TRIGGERS'                      => 2,
+        'VARIABLES'                     => 2,
+        'VIEW'                          => 2,
+        'WARNINGS'                      => 2,
+    );
+
+    /**
+     * The options of this query.
+     *
+     * @var OptionsFragment
+     *
+     * @see static::$OPTIONS
+     */
+    public $options;
+}