[Hejes-devel] [1708] Rebuilt database
hejes-devel at nytud.hu
hejes-devel at nytud.hu
Tue Feb 7 12:30:30 CET 2017
Revision: 1708
Author: mittelholcz
Date: 2017-02-07 12:30:29 +0100 (Tue, 07 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-06 14:55:33 UTC (rev 1707)
+++ trunk/misc/dbdict/dbdict_create_tables.sql 2017-02-07 11:30:29 UTC (rev 1708)
@@ -23,7 +23,10 @@
/*!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` 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 */;
@@ -66,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 */;
--
@@ -83,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 */;
--
@@ -198,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 */;
--
@@ -533,4 +536,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2017-02-06 15:54:22
+-- Dump completed on 2017-02-07 12:28:24
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-06 14:55:33 UTC (rev 1707)
+++ trunk/misc/dbdict/fsv.info.txt 2017-02-07 11:30:29 UTC (rev 1708)
@@ -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,19 +102,20 @@
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
+akh12 akh12_ragos_fn_ige_kulon 3 DatasetList
akh12 akh12_ragos_fn_ige_egybe 2 DatasetList
-akh12 akh12_ragos_fn_ige_egybe 2 DatasetList
akh12 akh12_mozgo 2 DatasetList
-akh12 akh12_aseskepzo_kulon 12 DatasetList
+akh12 akh12_aseskepzo_kulon 13 DatasetList
akh12 akh12_aseskepzo_egybe 1 DatasetList
akh12 akh12_6_3_egybe_1 2 DatasetList
akh12 akh12_6_3_egybe_2 1 DatasetList
+akh12 akh12_hsz_ige 3 DatasetList
Modified: trunk/misc/dbdict/fsv.log
===================================================================
--- trunk/misc/dbdict/fsv.log 2017-02-06 14:55:33 UTC (rev 1707)
+++ trunk/misc/dbdict/fsv.log 2017-02-07 11:30:29 UTC (rev 1708)
@@ -1159,18 +1159,18 @@
Running sql UPDATE `akh12_mn_u_kepzo_egybe_import` i INNER JOIN `alt_types`...
Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_mn_u_kepzo_egy...
Running sql DROP TABLE IF EXISTS `akh12_mn_u_kepzo_egybe_import`;...
-akh12/akh12_ragos_fn_ige_egybe
-Running sql DROP TABLE IF EXISTS `akh12_ragos_fn_ige_egybe_import`;...
-Running sql CREATE TABLE `akh12_ragos_fn_ige_egybe_import` ( `actual` varcha...
+akh12/akh12_ragos_fn_ige_kulon
+Running sql DROP TABLE IF EXISTS `akh12_ragos_fn_ige_kulon_import`;...
+Running sql CREATE TABLE `akh12_ragos_fn_ige_kulon_import` ( `actual` varcha...
Running sql LOAD DATA INFILE '/home/projects/helyesiras/resource/dbdict/tmp/...
-Running sql ALTER TABLE `akh12_ragos_fn_ige_egybe_import` ADD `actual_tid` i...
-Running sql ALTER TABLE `akh12_ragos_fn_ige_egybe_import` ADD INDEX (`actual...
-Running sql ALTER TABLE `akh12_ragos_fn_ige_egybe_import` ADD INDEX (`actual...
-Running sql UPDATE `akh12_ragos_fn_ige_egybe_import` i INNER JOIN `alt_type...
+Running sql ALTER TABLE `akh12_ragos_fn_ige_kulon_import` ADD `actual_tid` i...
+Running sql ALTER TABLE `akh12_ragos_fn_ige_kulon_import` ADD INDEX (`actual...
+Running sql ALTER TABLE `akh12_ragos_fn_ige_kulon_import` ADD INDEX (`actual...
+Running sql UPDATE `akh12_ragos_fn_ige_kulon_import` i INNER JOIN `alt_type...
Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
-Running sql UPDATE `akh12_ragos_fn_ige_egybe_import` i INNER JOIN `alt_type...
-Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_ragos_fn_ige_e...
-Running sql DROP TABLE IF EXISTS `akh12_ragos_fn_ige_egybe_import`;...
+Running sql UPDATE `akh12_ragos_fn_ige_kulon_import` i INNER JOIN `alt_type...
+Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_ragos_fn_ige_k...
+Running sql DROP TABLE IF EXISTS `akh12_ragos_fn_ige_kulon_import`;...
akh12/akh12_ragos_fn_ige_egybe
Running sql DROP TABLE IF EXISTS `akh12_ragos_fn_ige_egybe_import`;...
Running sql CREATE TABLE `akh12_ragos_fn_ige_egybe_import` ( `actual` varcha...
@@ -1243,3 +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_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...
More information about the Hejes-devel
mailing list