new file mode 100644

@@ -0,0 +1,52 @@

+<?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'"

+        ],

+    ]

+];