[Hejes-devel] [1706] Rebuilt database
hejes-devel at nytud.hu
hejes-devel at nytud.hu
Sun Feb 5 15:25:37 CET 2017
Revision: 1706
Author: mittelholcz
Date: 2017-02-05 15:25:37 +0100 (Sun, 05 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 17:06:36 UTC (rev 1705)
+++ trunk/misc/dbdict/dbdict_create_tables.sql 2017-02-05 14:25:37 UTC (rev 1706)
@@ -66,7 +66,7 @@
`actual` varchar(64) COLLATE utf8_hungarian_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `actual` (`actual`)
-) ENGINE=MyISAM AUTO_INCREMENT=350950 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=350949 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -83,7 +83,7 @@
PRIMARY KEY (`id`),
KEY `actual` (`actual`),
KEY `norm` (`norm`)
-) ENGINE=MyISAM AUTO_INCREMENT=350950 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=350949 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -198,7 +198,7 @@
KEY `tulnev_betuszo` (`tulnev_betuszo`),
KEY `morfologiai` (`morfologiai`),
KEY `tagadoszo` (`tagadoszo`)
-) ENGINE=MyISAM AUTO_INCREMENT=350950 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=350949 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -533,4 +533,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2017-02-02 18:05:44
+-- Dump completed on 2017-02-05 15:25:18
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 17:06:36 UTC (rev 1705)
+++ trunk/misc/dbdict/fsv.info.txt 2017-02-05 14:25:37 UTC (rev 1706)
@@ -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 498 DatasetList
+Ivan_Zsofi fekete_feher_kis_nagy_egybe 497 DatasetList
Ivan_Zsofi fekete_feher_kis_nagy_kulon 330 DatasetList
Ivan_Zsofi minosegjelzos_hagyomany 77 DatasetList
Ivan_Zsofi befejezett_melleknevi_igenev 6 DatasetList
@@ -106,8 +106,8 @@
Ivan_Zsofi 6_3_kivetel 11 DatasetList
Ivan_Zsofi tulnev_betuszo 261 DatasetList
Ivan_Zsofi uralkodohazak 158 DatasetList
-akh12 akh12_mn_fn_egybe 12 DatasetList
-akh12 akh12_mn_fn_kulon 4 DatasetList
+akh12 akh12_mn_fn_egybe 11 DatasetList
+akh12 akh12_mn_fn_kulon 3 DatasetList
akh12 akh12_folyamatosmnszerk 4 DatasetList
akh12 akh12_mn_u_kepzo_kulon 8 DatasetList
akh12 akh12_mn_u_kepzo_egybe 2 DatasetList
@@ -118,6 +118,4 @@
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
+akh12 mn_hatszo.txt 0 DatasetList
Modified: trunk/misc/dbdict/fsv.log
===================================================================
--- trunk/misc/dbdict/fsv.log 2017-02-02 17:06:36 UTC (rev 1705)
+++ trunk/misc/dbdict/fsv.log 2017-02-05 14:25:37 UTC (rev 1706)
@@ -1243,20 +1243,14 @@
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...
+akh12/mn_hatszo.txt
+Running sql DROP TABLE IF EXISTS `mn_hatszo.txt_import`;...
+Running sql CREATE TABLE `mn_hatszo.txt_import` ( `actual` varchar(64) colla...
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...
-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...
+Running sql ALTER TABLE `mn_hatszo.txt_import` ADD `actual_tid` int(11) defa...
+Running sql ALTER TABLE `mn_hatszo.txt_import` ADD INDEX (`actual_tid`);...
+Running sql ALTER TABLE `mn_hatszo.txt_import` ADD INDEX (`actual`);...
+Running sql UPDATE `mn_hatszo.txt_import` i INNER JOIN `alt_types` t ON t.`...
+Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `mn_ha...
+Running sql UPDATE `mn_hatszo.txt_import` i INNER JOIN `alt_types` t ON t.`...
+Running sql DROP TABLE IF EXISTS `mn_hatszo.txt_import`;...
More information about the Hejes-devel
mailing list