[Hejes-devel] [1699] Rebuilt database
hejes-devel at nytud.hu
hejes-devel at nytud.hu
Thu Feb 2 16:17:22 CET 2017
Revision: 1699
Author: mittelholcz
Date: 2017-02-02 16:17:21 +0100 (Thu, 02 Feb 2017)
Log Message:
-----------
Rebuilt database
Modified Paths:
--------------
trunk/misc/dbdict/dbdict_create_tables.sql
trunk/misc/dbdict/dump_dbdict.sql.zip
trunk/misc/dbdict/fsv.info.txt
trunk/misc/dbdict/fsv.log
Modified: trunk/misc/dbdict/dbdict_create_tables.sql
===================================================================
--- trunk/misc/dbdict/dbdict_create_tables.sql 2017-02-02 14:54:22 UTC (rev 1698)
+++ trunk/misc/dbdict/dbdict_create_tables.sql 2017-02-02 15:17:21 UTC (rev 1699)
@@ -16,6 +16,48 @@
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
+-- Table structure for table `akh12_hsz_ige_import`
+--
+
+DROP TABLE IF EXISTS `akh12_hsz_ige_import`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `akh12_hsz_ige_import` (
+ `actual` varchar(64) COLLATE utf8_hungarian_ci NOT NULL,
+ `actual_tid` int(11) DEFAULT NULL,
+ KEY `actual_tid` (`actual_tid`),
+ KEY `actual` (`actual`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `akh12_mn_hatszo_import`
+--
+
+DROP TABLE IF EXISTS `akh12_mn_hatszo_import`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `akh12_mn_hatszo_import` (
+ `actual` varchar(64) COLLATE utf8_hungarian_ci NOT NULL,
+ `actual_tid` int(11) DEFAULT NULL,
+ KEY `actual_tid` (`actual_tid`),
+ KEY `actual` (`actual`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `akh12_mn_mn_egybe_import`
+--
+
+DROP TABLE IF EXISTS `akh12_mn_mn_egybe_import`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `akh12_mn_mn_egybe_import` (
+ `actual` varchar(64) COLLATE utf8_hungarian_ci NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `alt_types`
--
@@ -27,7 +69,7 @@
`actual` varchar(64) COLLATE utf8_hungarian_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `actual` (`actual`)
-) ENGINE=MyISAM AUTO_INCREMENT=350949 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=350950 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -44,7 +86,7 @@
PRIMARY KEY (`id`),
KEY `actual` (`actual`),
KEY `norm` (`norm`)
-) ENGINE=MyISAM AUTO_INCREMENT=350949 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=350950 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -159,7 +201,7 @@
KEY `tulnev_betuszo` (`tulnev_betuszo`),
KEY `morfologiai` (`morfologiai`),
KEY `tagadoszo` (`tagadoszo`)
-) ENGINE=MyISAM AUTO_INCREMENT=350949 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=350950 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -436,7 +478,7 @@
PRIMARY KEY (`id`),
KEY `actual` (`actual`),
KEY `norm` (`norm`)
-) ENGINE=MyISAM AUTO_INCREMENT=125397 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+) ENGINE=MyISAM AUTO_INCREMENT=125404 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -494,4 +536,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2016-11-30 15:00:41
+-- Dump completed on 2017-02-02 16:03:02
Modified: trunk/misc/dbdict/dump_dbdict.sql.zip
===================================================================
(Binary files differ)
Modified: trunk/misc/dbdict/fsv.info.txt
===================================================================
--- trunk/misc/dbdict/fsv.info.txt 2017-02-02 14:54:22 UTC (rev 1698)
+++ trunk/misc/dbdict/fsv.info.txt 2017-02-02 15:17:21 UTC (rev 1699)
@@ -79,7 +79,7 @@
Ivan_Zsofi toismetles_egybe 3 DatasetList
Ivan_Zsofi toismetles_kotojel 14 DatasetList
Ivan_Zsofi jelentessurito 212 DatasetList
-Ivan_Zsofi fekete_feher_kis_nagy_egybe 497 DatasetList
+Ivan_Zsofi fekete_feher_kis_nagy_egybe 498 DatasetList
Ivan_Zsofi fekete_feher_kis_nagy_kulon 330 DatasetList
Ivan_Zsofi minosegjelzos_hagyomany 77 DatasetList
Ivan_Zsofi befejezett_melleknevi_igenev 6 DatasetList
@@ -102,12 +102,12 @@
Ivan_Zsofi egyhazi_foglalkozas 18 DatasetList
Ivan_Zsofi egyhazi_foglalkozas_kivetel 3 DatasetList
Ivan_Zsofi allatok 272 DatasetList
-Ivan_Zsofi ketertelmu 955 DatasetTSV
+Ivan_Zsofi ketertelmu 958 DatasetTSV
Ivan_Zsofi 6_3_kivetel 11 DatasetList
Ivan_Zsofi tulnev_betuszo 261 DatasetList
Ivan_Zsofi uralkodohazak 158 DatasetList
-akh12 akh12_mn_fn_egybe 11 DatasetList
-akh12 akh12_mn_fn_kulon 3 DatasetList
+akh12 akh12_mn_fn_egybe 12 DatasetList
+akh12 akh12_mn_fn_kulon 4 DatasetList
akh12 akh12_folyamatosmnszerk 4 DatasetList
akh12 akh12_mn_u_kepzo_kulon 8 DatasetList
akh12 akh12_mn_u_kepzo_egybe 2 DatasetList
@@ -118,3 +118,6 @@
akh12 akh12_aseskepzo_egybe 1 DatasetList
akh12 akh12_6_3_egybe_1 2 DatasetList
akh12 akh12_6_3_egybe_2 1 DatasetList
+akh12 akh12_mn_hatszo 1 DatasetList
+akh12 akh12_hsz_ige 3 DatasetList
+akh12 akh12_mn_mn_egybe 3 DatasetList
Modified: trunk/misc/dbdict/fsv.log
===================================================================
--- trunk/misc/dbdict/fsv.log 2017-02-02 14:54:22 UTC (rev 1698)
+++ trunk/misc/dbdict/fsv.log 2017-02-02 15:17:21 UTC (rev 1699)
@@ -1243,3 +1243,28 @@
Running sql UPDATE `akh12_6_3_egybe_2_import` i INNER JOIN `alt_types` t ON...
Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_6_3_egybe_2`) ...
Running sql DROP TABLE IF EXISTS `akh12_6_3_egybe_2_import`;...
+akh12/akh12_mn_hatszo
+Running sql DROP TABLE IF EXISTS `akh12_mn_hatszo_import`;...
+Running sql CREATE TABLE `akh12_mn_hatszo_import` ( `actual` varchar(64) col...
+Running sql LOAD DATA INFILE '/home/projects/helyesiras/resource/dbdict/tmp/...
+Running sql ALTER TABLE `akh12_mn_hatszo_import` ADD `actual_tid` int(11) de...
+Running sql ALTER TABLE `akh12_mn_hatszo_import` ADD INDEX (`actual_tid`);...
+Running sql ALTER TABLE `akh12_mn_hatszo_import` ADD INDEX (`actual`);...
+Running sql UPDATE `akh12_mn_hatszo_import` i INNER JOIN `alt_types` t ON t...
+Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
+Running sql UPDATE `akh12_mn_hatszo_import` i INNER JOIN `alt_types` t ON t...
+Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_mn_hatszo`) SE...
+akh12/akh12_hsz_ige
+Running sql DROP TABLE IF EXISTS `akh12_hsz_ige_import`;...
+Running sql CREATE TABLE `akh12_hsz_ige_import` ( `actual` varchar(64) colla...
+Running sql LOAD DATA INFILE '/home/projects/helyesiras/resource/dbdict/tmp/...
+Running sql ALTER TABLE `akh12_hsz_ige_import` ADD `actual_tid` int(11) defa...
+Running sql ALTER TABLE `akh12_hsz_ige_import` ADD INDEX (`actual_tid`);...
+Running sql ALTER TABLE `akh12_hsz_ige_import` ADD INDEX (`actual`);...
+Running sql UPDATE `akh12_hsz_ige_import` i INNER JOIN `alt_types` t ON t.`...
+Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
+Running sql UPDATE `akh12_hsz_ige_import` i INNER JOIN `alt_types` t ON t.`...
+Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_hsz_ige`) SELE...
+akh12/akh12_mn_mn_egybe
+Running sql DROP TABLE IF EXISTS `akh12_mn_mn_egybe_import`;...
+Running sql CREATE TABLE `akh12_mn_mn_egybe_import` ( `actual` varchar(64) c...
More information about the Hejes-devel
mailing list