Location: PHPKode > projects > SQL Buddy > sqlbuddy/includes/types.php
<?php
/*

SQL Buddy - Web based MySQL administration
http://www.sqlbuddy.com/

types.php
- list of data types

MIT-style license

Copyright (c) 2008 Calvin Lough, <http://calv.in>

*/

$typeList[] = "varchar";
$typeList[] = "char";
$typeList[] = "text";
$typeList[] = "tinytext";
$typeList[] = "mediumtext";
$typeList[] = "longtext";
$typeList[] = "tinyint";
$typeList[] = "smallint";
$typeList[] = "mediumint";
$typeList[] = "int";
$typeList[] = "bigint";
$typeList[] = "real";
$typeList[] = "double";
$typeList[] = "float";
$typeList[] = "decimal";
$typeList[] = "numeric";
$typeList[] = "date";
$typeList[] = "time";
$typeList[] = "datetime";
$typeList[] = "timestamp";
$typeList[] = "tinyblob";
$typeList[] = "blob";
$typeList[] = "mediumblob";
$typeList[] = "longblob";
$typeList[] = "binary";
$typeList[] = "varbinary";
$typeList[] = "bit";
$typeList[] = "enum";
$typeList[] = "set";

$textDTs[] = "text";
$textDTs[] = "mediumtext";
$textDTs[] = "longtext";

$numericDTs[] = "tinyint";
$numericDTs[] = "smallint";
$numericDTs[] = "mediumint";
$numericDTs[] = "int";
$numericDTs[] = "bigint";
$numericDTs[] = "real";
$numericDTs[] = "double";
$numericDTs[] = "float";
$numericDTs[] = "decimal";
$numericDTs[] = "numeric";

$binaryDTs[] = "tinyblob";
$binaryDTs[] = "blob";
$binaryDTs[] = "mediumblob";
$binaryDTs[] = "longblob";
$binaryDTs[] = "binary";
$binaryDTs[] = "varbinary";

$sqliteTypeList[] = "varchar";
$sqliteTypeList[] = "integer";
$sqliteTypeList[] = "float";
$sqliteTypeList[] = "varchar";
$sqliteTypeList[] = "nvarchar";
$sqliteTypeList[] = "text";
$sqliteTypeList[] = "boolean";
$sqliteTypeList[] = "clob";
$sqliteTypeList[] = "blob";
$sqliteTypeList[] = "timestamp";
$sqliteTypeList[] = "numeric";

?>
Return current item: SQL Buddy