V0.04.316

SQL Ausschnitt

Die Datei wird nie komplett geladen. Es werden hoechstens 200 Zeilen ab der Treffer- oder Startzeile gelesen.

Datei: /opt/hdb-tools/table-research/cxt/data/mysql/rda_all.sql

Wenn Suchbegriffe gesetzt sind, muss die erste gefundene Zeile alle Begriffe enthalten. Ohne Suchbegriffe wird direkt ab der Startzeile gelesen.

Ausschnitt 1-200 · Trefferzeile: 1 · gescannt bis Zeile 201 und weitere Zeilen vorhanden

Doppelklick auf eine Zeilennummer, um Start oder End zu setzen.
Zeile Inhalt
1/*M!999999\- enable the sandbox mode */
2-- MariaDB dump 10.19 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
3--
4-- Host: localhost Database: rda
5-- ------------------------------------------------------
6-- Server version 10.11.14-MariaDB-0ubuntu0.24.04.1
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8mb4 */;
12/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
13/*!40103 SET TIME_ZONE='+00:00' */;
14/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18
19--
20-- Current Database: `rda`
21--
22
23CREATE DATABASE /*!32312 IF NOT EXISTS*/ `rda` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
24
25USE `rda`;
26
27--
28-- Dumping routines for database 'rda'
29--
30
31--
32-- Current Database: `rdaadr`
33--
34
35CREATE DATABASE /*!32312 IF NOT EXISTS*/ `rdaadr` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
36
37USE `rdaadr`;
38
39--
40-- Table structure for table `domain_index`
41--
42
43DROP TABLE IF EXISTS `domain_index`;
44/*!40101 SET @saved_cs_client = @@character_set_client */;
45/*!40101 SET character_set_client = utf8mb4 */;
46CREATE TABLE `domain_index` (
47 `id` int(11) NOT NULL AUTO_INCREMENT,
48 `domain` varchar(255) NOT NULL,
49 `company_id` int(11) DEFAULT NULL,
50 PRIMARY KEY (`id`),
51 UNIQUE KEY `domain` (`domain`),
52 KEY `company_id` (`company_id`),
53 CONSTRAINT `domain_index_ibfk_1` FOREIGN KEY (`company_id`) REFERENCES `known_companies` (`id`)
54) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
55/*!40101 SET character_set_client = @saved_cs_client */;
56
57--
58-- Dumping data for table `domain_index`
59--
60
61LOCK TABLES `domain_index` WRITE;
62/*!40000 ALTER TABLE `domain_index` DISABLE KEYS */;
63/*!40000 ALTER TABLE `domain_index` ENABLE KEYS */;
64UNLOCK TABLES;
65
66--
67-- Table structure for table `known_companies`
68--
69
70DROP TABLE IF EXISTS `known_companies`;
71/*!40101 SET @saved_cs_client = @@character_set_client */;
72/*!40101 SET character_set_client = utf8mb4 */;
73CREATE TABLE `known_companies` (
74 `id` int(11) NOT NULL AUTO_INCREMENT,
75 `name` varchar(512) NOT NULL,
76 `plz` char(5) DEFAULT NULL,
77 `city` varchar(255) DEFAULT NULL,
78 `street` varchar(255) DEFAULT NULL,
79 `housenumber` varchar(20) DEFAULT NULL,
80 `is_mandant` tinyint(1) DEFAULT 0,
81 PRIMARY KEY (`id`)
82) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Dumping data for table `known_companies`
87--
88
89LOCK TABLES `known_companies` WRITE;
90/*!40000 ALTER TABLE `known_companies` DISABLE KEYS */;
91/*!40000 ALTER TABLE `known_companies` ENABLE KEYS */;
92UNLOCK TABLES;
93
94--
95-- Table structure for table `manual_review_queue`
96--
97
98DROP TABLE IF EXISTS `manual_review_queue`;
99/*!40101 SET @saved_cs_client = @@character_set_client */;
100/*!40101 SET character_set_client = utf8mb4 */;
101CREATE TABLE `manual_review_queue` (
102 `id` int(11) NOT NULL AUTO_INCREMENT,
103 `doc_id` bigint(20) unsigned DEFAULT NULL,
104 `candidate_type` enum('plz','city','street') NOT NULL,
105 `raw_token` varchar(255) DEFAULT NULL,
106 `corrected_value` varchar(255) DEFAULT NULL,
107 `context_tokens` text DEFAULT NULL,
108 `bbox_x1` int(11) DEFAULT NULL,
109 `bbox_y1` int(11) DEFAULT NULL,
110 `bbox_x2` int(11) DEFAULT NULL,
111 `bbox_y2` int(11) DEFAULT NULL,
112 `status` enum('pending','accepted','rejected') DEFAULT 'pending',
113 `created_at` timestamp NULL DEFAULT current_timestamp(),
114 `reviewed_at` timestamp NULL DEFAULT NULL,
115 PRIMARY KEY (`id`)
116) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
117/*!40101 SET character_set_client = @saved_cs_client */;
118
119--
120-- Dumping data for table `manual_review_queue`
121--
122
123LOCK TABLES `manual_review_queue` WRITE;
124/*!40000 ALTER TABLE `manual_review_queue` DISABLE KEYS */;
125/*!40000 ALTER TABLE `manual_review_queue` ENABLE KEYS */;
126UNLOCK TABLES;
127
128--
129-- Table structure for table `validated_addresses`
130--
131
132DROP TABLE IF EXISTS `validated_addresses`;
133/*!40101 SET @saved_cs_client = @@character_set_client */;
134/*!40101 SET character_set_client = utf8mb4 */;
135CREATE TABLE `validated_addresses` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `doc_id` bigint(20) unsigned DEFAULT NULL,
138 `role` enum('sender','recipient','other') DEFAULT 'other',
139 `role_guess` varchar(50) DEFAULT 'other',
140 `name` varchar(255) DEFAULT NULL,
141 `name_type` enum('person','company','other') DEFAULT 'other',
142 `address_type` enum('Person','Firma') DEFAULT NULL,
143 `plz` char(5) DEFAULT NULL,
144 `city` varchar(255) DEFAULT NULL,
145 `street` varchar(255) DEFAULT NULL,
146 `housenumber` varchar(20) DEFAULT NULL,
147 `is_postfach` tinyint(1) DEFAULT 0,
148 `full_text` text DEFAULT NULL,
149 `confidence` float DEFAULT NULL,
150 `validation_method` varchar(255) DEFAULT NULL,
151 `bbox_x1` int(11) DEFAULT NULL,
152 `bbox_y1` int(11) DEFAULT NULL,
153 `bbox_x2` int(11) DEFAULT NULL,
154 `bbox_y2` int(11) DEFAULT NULL,
155 `validated_at` timestamp NULL DEFAULT current_timestamp(),
156 PRIMARY KEY (`id`)
157) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
158/*!40101 SET character_set_client = @saved_cs_client */;
159
160--
161-- Dumping data for table `validated_addresses`
162--
163
164LOCK TABLES `validated_addresses` WRITE;
165/*!40000 ALTER TABLE `validated_addresses` DISABLE KEYS */;
166INSERT INTO `validated_addresses` VALUES
167(1,2,'other','recipient','Hans-Detlev Bombach','person','Person','40667','Meerbusch','Necklenbroicher Straße','47b',0,'Necklenbroicher Straße 47b, 40667 Meerbusch',0.99,'PLZ:exact | City:proximity | Street:regex | Addr:dictionary | Name:person',181,554,480,631,'2026-04-07 18:52:46');
168/*!40000 ALTER TABLE `validated_addresses` ENABLE KEYS */;
169UNLOCK TABLES;
170
171--
172-- Dumping routines for database 'rdaadr'
173--
174
175--
176-- Current Database: `rdac`
177--
178
179CREATE DATABASE /*!32312 IF NOT EXISTS*/ `rdac` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
180
181USE `rdac`;
182
183--
184-- Table structure for table `address_dictionary`
185--
186
187DROP TABLE IF EXISTS `address_dictionary`;
188/*!40101 SET @saved_cs_client = @@character_set_client */;
189/*!40101 SET character_set_client = utf8mb4 */;
190CREATE TABLE `address_dictionary` (
191 `id` int(11) NOT NULL AUTO_INCREMENT,
192 `plz` varchar(10) NOT NULL,
193 `city` varchar(100) NOT NULL,
194 `street` varchar(150) NOT NULL,
195 `street_normalized` varchar(150) NOT NULL,
196 `housenumber` varchar(20) NOT NULL,
197 `housenumber_normalized` varchar(20) NOT NULL,
198 `search_city` varchar(100) DEFAULT NULL,
199 `lon` decimal(11,8) DEFAULT NULL,
200 `lat` decimal(10,8) DEFAULT NULL,