root/scaffolding.php

<?php

class Scaffolder {
        protected $dir;

        public function __construct($dir) {
                $this->dir = $dir;
        }
        
        public function run() {
                $this->parseSQL($this->dir.'install.sql');
        }
        
        /**
         * Deletes the comments from an sql file. 
         *
         * @param       string  $queries
         * @return      string  $queries
         */
        public function deleteComments($queries) {
//              $queries = preg_replace("~('[^'\\\\]*(?:\\\\.[^'\\\\]*)*')|(?:(?:--|#).*|/\*(?:.|[\r\n])*?\*/)~", '$1', $queries);
                $queries = preg_replace("~('[^'\\\\]*(?:\\\\.[^'\\\\]*)*')|(?:(?:--|#)[^\n]*|/\*.*?\*/)~s", '$1', $queries);

                // strip whitespace
                return trim($queries);
        }
        
        /**
         * This function reads the logable data out of the statement and 
         * calls the log function if so.  
         * 
         * @param       string          $filename
         */
        protected function parseSQL($filename) {
                $queries = file_get_contents($filename);
        
                $alterStatement = $columnName = $columns = array();

                $queries = $this->deleteComments($queries);
                // Put all queries in the $queries array. 
                $queryArray = array();
                $char = '';
                $lastChar = '';
                $inString = false;
                $stringOpen = '';
                for ($i = 0; $i < strlen($queries); $i++) {
                        $char = $queries[$i];

                        // if delimiter found, add the parsed part to the returned array
                        if ($char == ';' && !$inString) {
                                $queryArray[] = substr($queries, 0, $i);
                                $queries = substr($queries, $i + 1);
                                $i = 0;
                                $lastChar = '';
                        }
                        
                        else if (!$inString) {
                                if ($char == "'" || $char == '"') {
                                        $inString = true;
                                        $stringOpen = $char;
                                }
                        }
                        else if ($inString) {
                                if ($lastChar != '\\' && $char == $stringOpen) {
                                        $inString = false;      
                                } 
                        }
                        $lastChar = $char;
                }
                if ($queries != '') {
                        $queryArray[] = $queries;
                }
                unset($queries);

                // array for setup log data.
                $tableLogData = array();
                
                // loop through the queries and handle them one by one
                $c = count($queryArray);
                for ($i = 0; $i < $c; $i++) {

                        // ignore errors syntax?
                        if (substr($queryArray[$i], 0, 1) == '@') {
                                $queryArray[$i] = substr($queryArray[$i], 1);
                        }
                        
                        // query for CREATE TABLE
                        $this->parseSingleSQL($queryArray[$i]);
                }
        }
        
        protected function parseSingleSQL($sql) {
                // query for CREATE TABLE
                if(preg_match("%CREATE(?:\s+TEMPORARY)?\s+TABLE(?:\s+IF\s+NOT\s+EXISTS)?\s+`?(\w+)`?(.*)%i", $sql, $matches)) {
                        $this->parseCreateTable($matches[1], $sql);
                }
        }
        
        protected function parseCreateTable($table, $sql) {
                var_dump($table, $sql);
        }
}

$scaff = new Scaffolder('/var/www/admanager/');
$scaff->run();