function createTable($tablename, $datadef, $info)
 {
     if (!is_array($info)) {
         $info = array();
     }
     // Initialize for later use.
     $sql = "CREATE TABLE `" . $this->prefix . "{$tablename}` (";
     $primary = array();
     $unique = array();
     $index = array();
     foreach ($datadef as $name => $def) {
         if ($def != null) {
             $sql .= $this->fieldSQL($name, $def) . ",";
             if (isset($def[DB_PRIMARY]) && $def[DB_PRIMARY] == true) {
                 $primary[] = $name;
             }
             if (isset($def[DB_INDEX]) && $def[DB_INDEX] > 0) {
                 if ($def[DB_FIELD_TYPE] == DB_DEF_STRING) {
                     $index[$name] = $def[DB_INDEX];
                 } else {
                     $index[$name] = 0;
                 }
             }
             if (isset($def[DB_UNIQUE])) {
                 if (!isset($unique[$def[DB_UNIQUE]])) {
                     $unique[$def[DB_UNIQUE]] = array();
                 }
                 $unique[$def[DB_UNIQUE]][] = $name;
             }
         }
     }
     $sql = substr($sql, 0, -1);
     if (count($primary)) {
         $sql .= ", PRIMARY KEY(`" . implode("`,`", $primary) . "`)";
     }
     foreach ($unique as $key => $value) {
         $sql .= ", UNIQUE `" . $key . "` ( `" . implode("`,`", $value) . "`)";
     }
     foreach ($index as $key => $value) {
         $sql .= ", INDEX (`" . $key . "`" . ($value > 0 ? "(" . $value . ")" : "") . ")";
     }
     $sql .= ")";
     if (isset($info[DB_TABLE_COMMENT])) {
         $sql .= " COMMENT = '" . $info[DB_TABLE_COMMENT] . "'";
     }
     @mysql_query($sql, $this->connection);
     $return = array($tablename => $this->tableExists($tablename) ? DATABASE_TABLE_INSTALLED : DATABASE_TABLE_FAILED);
     if (isset($info[DB_TABLE_WORKFLOW]) && $info[DB_TABLE_WORKFLOW]) {
         // Initialize workflow tables:
         if (!defined("SYS_WORKFLOW")) {
             require_once BASE . "subsystems/workflow.php";
         }
         $wf = exponent_workflow_installWorkflowTables($tablename, $datadef);
         foreach ($wf as $key => $status) {
             $return[$key] = $status;
         }
     }
     return $return;
 }
 function createTable($tablename, $datadef, $info)
 {
     $sql = "CREATE TABLE \"" . $this->prefix . "{$tablename}\" (";
     $alter_sql = array();
     foreach ($datadef as $name => $def) {
         $sql .= $this->fieldSQL($name, $def) . ",";
         // PostGres is stupid, you cant specify NOT NULL in the Create Table
         if (!isset($def[DB_INCREMENT]) || !$def[DB_INCREMENT]) {
             $alter_sql[] = 'ALTER TABLE "' . $this->prefix . $tablename . '" ALTER COLUMN "' . $name . '" SET NOT NULL';
             $default = null;
             if (isset($def[DB_DEFAULT])) {
                 $default = $def[DB_DEFAULT];
             } else {
                 switch ($def[DB_FIELD_TYPE]) {
                     case DB_DEF_ID:
                     case DB_DEF_INTEGER:
                     case DB_DEF_TIMESTAMP:
                     case DB_DEF_DECIMAL:
                     case DB_DEF_BOOLEAN:
                         $default = 0;
                         break;
                     default:
                         $default = '';
                         break;
                 }
             }
             $alter_sql[] = 'ALTER TABLE "' . $this->prefix . $tablename . '" ALTER COLUMN "' . $name . '" SET DEFAULT ' . "'" . $default . "'";
         }
     }
     $sql = substr($sql, 0, -1) . ")";
     pg_query($this->connection, $sql);
     foreach ($alter_sql as $sql) {
         #echo '//'.$sql.'<br />';
         pg_query($this->connection, $sql);
     }
     if (isset($info[DB_TABLE_WORKFLOW]) && $info[DB_TABLE_WORKFLOW]) {
         // Initialize workflow tables:
         if (!defined("SYS_WORKFLOW")) {
             require_once BASE . "subsystems/workflow.php";
         }
         exponent_workflow_installWorkflowTables($tablename, $datadef);
     }
 }