SproutCMS

source of /sprout/config/sql_types.php

<?php
/*
 * kate: tab-width 4; indent-width 4; space-indent on; word-wrap off; word-wrap-column 120;
 * :tabSize=4:indentSize=4:noTabs=true:wrap=false:maxLineLen=120:mode=php:
 *
 * Copyright (C) 2016 Karmabunny Pty Ltd.
 *
 * This file is a part of SproutCMS.
 *
 * SproutCMS is free software: you can redistribute it and/or modify it under the terms
 * of the GNU General Public License as published by the Free Software Foundation, either
 * version 2 of the License, or (at your option) any later version.
 *
 * For more information, visit <http://getsproutcms.com>.
 */
 
/**
 * @package  Database
 *
 * SQL data types. If there are missing values, please report them:
 *
 * @link  http://trac.kohanaphp.com/newticket
 */
$config = array
(
    'tinyint'            => array('type' => 'int', 'max' => 127),
    'smallint'            => array('type' => 'int', 'max' => 32767),
    'mediumint'            => array('type' => 'int', 'max' => 8388607),
    'int'                => array('type' => 'int', 'max' => 2147483647),
    'integer'            => array('type' => 'int', 'max' => 2147483647),
    'bigint'            => array('type' => 'int', 'max' => 9223372036854775807),
    'float'                => array('type' => 'float'),
    'float unsigned'    => array('type' => 'float', 'min' => 0),
    'boolean'            => array('type' => 'boolean'),
    'time'                => array('type' => 'string', 'format' => '00:00:00'),
    'time with time zone' => array('type' => 'string'),
    'date'                => array('type' => 'string', 'format' => '0000-00-00'),
    'year'                => array('type' => 'string', 'format' => '0000'),
    'datetime'            => array('type' => 'string', 'format' => '0000-00-00 00:00:00'),
    'timestamp with time zone' => array('type' => 'string'),
    'char'                => array('type' => 'string', 'exact' => TRUE),
    'binary'            => array('type' => 'string', 'binary' => TRUE, 'exact' => TRUE),
    'varchar'            => array('type' => 'string'),
    'varbinary'            => array('type' => 'string', 'binary' => TRUE),
    'blob'                => array('type' => 'string', 'binary' => TRUE),
    'text'                => array('type' => 'string')
);
 
// DOUBLE
$config['double'] = $config['double precision'] = $config['decimal'] = $config['real'] = $config['numeric'] = $config['float'];
$config['double unsigned'] = $config['float unsigned'];
 
// BIT
$config['bit'] = $config['boolean'];
 
// TIMESTAMP
$config['timestamp'] = $config['timestamp without time zone'] = $config['datetime'];
 
// ENUM
$config['enum'] = $config['set'] = $config['varchar'];
 
// TEXT
$config['tinytext'] = $config['mediumtext'] = $config['longtext'] = $config['text'];
 
// BLOB
$config['tsvector'] = $config['tinyblob'] = $config['mediumblob'] = $config['longblob'] = $config['clob'] = $config['bytea'] = $config['blob'];
 
// CHARACTER
$config['character'] = $config['char'];
$config['character varying'] = $config['varchar'];
 
// TIME
$config['time without time zone'] = $config['time'];