[Hejes-devel] [1592] Rebuilt database
hejes-devel at nytud.hu
hejes-devel at nytud.hu
Thu Mar 24 15:52:01 CET 2016
Revision: 1592
Author: mittelholcz
Date: 2016-03-24 15:52:01 +0100 (Thu, 24 Mar 2016)
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 2016-03-24 14:41:04 UTC (rev 1591)
+++ trunk/misc/dbdict/dbdict_create_tables.sql 2016-03-24 14:52:01 UTC (rev 1592)
@@ -436,7 +436,7 @@
PRIMARY KEY (`id`),
KEY `actual` (`actual`),
KEY `norm` (`norm`)
-) ENGINE=MyISAM AUTO_INCREMENT=125385 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+) ENGINE=MyISAM AUTO_INCREMENT=125387 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -494,4 +494,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2015-10-05 15:15:52
+-- Dump completed on 2016-03-24 15:51: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 2016-03-24 14:41:04 UTC (rev 1591)
+++ trunk/misc/dbdict/fsv.info.txt 2016-03-24 14:52:01 UTC (rev 1592)
@@ -32,7 +32,7 @@
listak szinarnyalatok 80 DatasetList
listak szinnevek 989 DatasetList
listak szinnevek_multiword 988 Dataset_NOT_IMPLEMENTED_MULTIWORD
-listak tarolok 26 DatasetList
+listak tarolok 28 DatasetList
listak foglalkozasok 1405 DatasetList
listak rang 136 DatasetList
listak pron_idegen_csv 4748 Dataset_NOT_IMPLEMENTED_MULTIWORD
@@ -111,8 +111,10 @@
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_egybe 1 DatasetList
+akh12 akh12_6_3_egybe_1 2 DatasetList
+akh12 akh12_6_3_egybe_2 1 DatasetList
Modified: trunk/misc/dbdict/fsv.log
===================================================================
--- trunk/misc/dbdict/fsv.log 2016-03-24 14:41:04 UTC (rev 1591)
+++ trunk/misc/dbdict/fsv.log 2016-03-24 14:52:01 UTC (rev 1592)
@@ -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_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...
+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...
Running sql LOAD DATA INFILE '/home/projects/helyesiras/resource/dbdict/tmp/...
-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 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 INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
-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`;...
+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`;...
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...
@@ -1219,3 +1219,27 @@
Running sql UPDATE `akh12_aseskepzo_egybe_import` i INNER JOIN `alt_types` ...
Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_aseskepzo_egyb...
Running sql DROP TABLE IF EXISTS `akh12_aseskepzo_egybe_import`;...
+akh12/akh12_6_3_egybe_1
+Running sql DROP TABLE IF EXISTS `akh12_6_3_egybe_1_import`;...
+Running sql CREATE TABLE `akh12_6_3_egybe_1_import` ( `actual` varchar(64) c...
+Running sql LOAD DATA INFILE '/home/projects/helyesiras/resource/dbdict/tmp/...
+Running sql ALTER TABLE `akh12_6_3_egybe_1_import` ADD `actual_tid` int(11) ...
+Running sql ALTER TABLE `akh12_6_3_egybe_1_import` ADD INDEX (`actual_tid`);...
+Running sql ALTER TABLE `akh12_6_3_egybe_1_import` ADD INDEX (`actual`);...
+Running sql UPDATE `akh12_6_3_egybe_1_import` i INNER JOIN `alt_types` t ON...
+Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
+Running sql UPDATE `akh12_6_3_egybe_1_import` i INNER JOIN `alt_types` t ON...
+Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_6_3_egybe_1`) ...
+Running sql DROP TABLE IF EXISTS `akh12_6_3_egybe_1_import`;...
+akh12/akh12_6_3_egybe_2
+Running sql DROP TABLE IF EXISTS `akh12_6_3_egybe_2_import`;...
+Running sql CREATE TABLE `akh12_6_3_egybe_2_import` ( `actual` varchar(64) c...
+Running sql LOAD DATA INFILE '/home/projects/helyesiras/resource/dbdict/tmp/...
+Running sql ALTER TABLE `akh12_6_3_egybe_2_import` ADD `actual_tid` int(11) ...
+Running sql ALTER TABLE `akh12_6_3_egybe_2_import` ADD INDEX (`actual_tid`);...
+Running sql ALTER TABLE `akh12_6_3_egybe_2_import` ADD INDEX (`actual`);...
+Running sql UPDATE `akh12_6_3_egybe_2_import` i INNER JOIN `alt_types` t ON...
+Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
+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`;...
More information about the Hejes-devel
mailing list