/**
  * Returns array of all column types available.
  *
  * @return string[]
  *
  */
 public function getColumns()
 {
     $types_num = array('INTEGER', 'BIGINT', '-', 'DECIMAL', 'DOUBLE', '-', 'BOOLEAN', 'SERIAL', 'UUID');
     $types_date = array('DATE', 'DATETIME', 'TIMESTAMP', 'TIME');
     $types_string = array('VARCHAR', 'TEXT', '-', 'VARBINARY', 'BLOB', '-', 'ENUM');
     if (PMA_MYSQL_INT_VERSION >= 70132) {
         $types_string[] = '-';
         $types_string[] = 'IPV6';
     }
     $ret = parent::getColumns();
     // numeric
     $ret[_pgettext('numeric types', 'Numeric')] = $types_num;
     // Date/Time
     $ret[_pgettext('date and time types', 'Date and time')] = $types_date;
     // Text
     $ret[_pgettext('string types', 'String')] = $types_string;
     return $ret;
 }
Beispiel #2
0
 /**
  * Returns array of all column types available.
  *
  * VARCHAR, TINYINT, TEXT and DATE are listed first, based on
  * estimated popularity.
  *
  * @return string[]
  *
  */
 public function getColumns()
 {
     $ret = parent::getColumns();
     // numeric
     $ret[_pgettext('numeric types', 'Numeric')] = array('TINYINT', 'SMALLINT', 'MEDIUMINT', 'INT', 'BIGINT', '-', 'DECIMAL', 'FLOAT', 'DOUBLE', 'REAL', '-', 'BIT', 'BOOLEAN', 'SERIAL');
     // Date/Time
     $ret[_pgettext('date and time types', 'Date and time')] = array('DATE', 'DATETIME', 'TIMESTAMP', 'TIME', 'YEAR');
     // Text
     $ret[_pgettext('string types', 'String')] = array('CHAR', 'VARCHAR', '-', 'TINYTEXT', 'TEXT', 'MEDIUMTEXT', 'LONGTEXT', '-', 'BINARY', 'VARBINARY', '-', 'TINYBLOB', 'MEDIUMBLOB', 'BLOB', 'LONGBLOB', '-', 'ENUM', 'SET');
     $ret[_pgettext('spatial types', 'Spatial')] = array('GEOMETRY', 'POINT', 'LINESTRING', 'POLYGON', 'MULTIPOINT', 'MULTILINESTRING', 'MULTIPOLYGON', 'GEOMETRYCOLLECTION');
     $ret['JSON'] = array('JSON');
     return $ret;
 }