👁 View: datatypes.php
Path: /home/thiqat5/admincrud.thiqatech.com/sql/modules/views/pgsql/templates/datatypes.php
Size: 1.76 KB · Modified: 2023-08-20 10:31:19 · Perm: 0644 · Writable
<?php
/**
 * This file is a part of MyWebSQL package
 *
 * @file:      modules/views/pgsql/templates/datatypes.php
 * @author     Samnan ur Rehman
 * @copyright  (c) 2008-2014 Samnan ur Rehman
 * @web        http://mywebsql.net
 * @license    http://mywebsql.net/license
 */

	// @@TODO: add support for lots of other pgsql data types
	$dataTypes = array(
		'bigint' => array('type' => 'numeric'),
		'bigserial' => array('type' => 'numeric'),
		'bit' => array('type' => 'special'),
		'bytea' => array('type' => 'binary'),
		'boolean' => array('type' => 'special'),
		'character' => array('type' => 'char'),
		'character varying' => array('type' => 'char'),
		'date' => array('type' => 'date'),
		'datetime' => array('type' => 'date'),
		'decimal' => array('type' => 'numeric'),
		'double' => array('type' => 'numeric'),
		'enum' => array('type' => 'char'),
		'float' => array('type' => 'numeric'),
		'integer' => array('type' => 'numeric'),
		'interval' => array('type' => 'date'),
		'longblob'=> array('type' => 'binary'),
		'longtext'=> array('type' => 'text'),
		'mediumblob'=> array('type' => 'binary'),
		'mediumint' => array('type' => 'numeric'),
		'mediumtext'=> array('type' => 'text'),
		'numeric' => array('type' => 'numeric'),
		'real' => array('type' => 'numeric'),
		'serial' => array('type' => 'numeric'),
		'set'=> array('type' => 'char'),
		'smallint' => array('type' => 'numeric'),
		'text'=> array('type' => 'text'),
		'time' => array('type' => 'date'),
		'timestamp' => array('type' => 'date'),
		'tinyblob'=> array('type' => 'binary'),
		'tinyint' => array('type' => 'numeric'),
		'tinytext'=> array('type' => 'text'),
		'uuid' => array('type' => 'special'),
		'varbinary'=> array('type' => 'binary'),
		'varchar'=> array('type' => 'char'),
		'year' => array('type' => 'date'),
	);

?>