<?php

declare(strict_types=1);

/*
 * This file is part of alox bundle for Contao.
 *
 * (c) Benjamin Roth
 *
 * @license commercial
 */

$GLOBALS['TL_DCA']['tl_ab_geodb'] = [
    'config' => [
        'sql' => [
            'keys' => [
                'id' => 'primary',
                'name,postal' => 'index',
                'name,postal,type' => 'index'
            ]
        ]
    ],
    'fields' => [
        'id' => [
            'sql' => "int(10) unsigned NOT NULL auto_increment"
        ],
        'tmp' => [
            'sql' => "varchar(10) unsigned NOT NULL 0"
        ],
        'pid' => [
            'sql' => "int(10) unsigned NOT NULL 0"
        ],
        'name' => [
            'sql' => "varchar(64) NOT NULL default ''"
        ],
        'type' => [
            'sql' => "varchar(32) NOT NULL default ''"
        ],
        'postal' => [
            'sql' => "varchar(512) NOT NULL default ''"
        ],
        'lat' => [
            'sql' => "float(9,6) NOT NULL default 0"
        ],
        'lon' => [
            'sql' => "float(9,6) NOT NULL default 0"
        ],
        'invalid' => [
            'sql' => "char(1) unsigned NOT NULL '0'"
        ],
    ]
];