function system_update_7016

Remove custom datatype *_unsigned in PostgreSQL.

Related topics

File

modules/system/system.install, line 2179

Code

function system_update_7016() {
    // Only run these queries if the driver used is pgsql.
    if (db_driver() == 'pgsql') {
        $result = db_query("SELECT c.relname AS table, a.attname AS field,\n                        pg_catalog.format_type(a.atttypid, a.atttypmod) AS type\n                        FROM pg_catalog.pg_attribute a\n                        LEFT JOIN pg_class c ON (c.oid =  a.attrelid)\n                        WHERE pg_catalog.pg_table_is_visible(c.oid) AND c.relkind = 'r'\n                        AND pg_catalog.format_type(a.atttypid, a.atttypmod) LIKE '%unsigned%'");
        foreach ($result as $row) {
            switch ($row->type) {
                case 'smallint_unsigned':
                    $datatype = 'int';
                    break;
                case 'int_unsigned':
                case 'bigint_unsigned':
                default:
                    $datatype = 'bigint';
                    break;
            }
            db_query('ALTER TABLE ' . $row->table . ' ALTER COLUMN "' . $row->field . '" TYPE ' . $datatype);
            db_query('ALTER TABLE ' . $row->table . ' ADD CHECK ("' . $row->field . '" >= 0)');
        }
        db_query('DROP DOMAIN IF EXISTS smallint_unsigned');
        db_query('DROP DOMAIN IF EXISTS int_unsigned');
        db_query('DROP DOMAIN IF EXISTS bigint_unsigned');
    }
}