[Hejes-devel] [1705] Rebuilt database (rev.

[hejes-devel at nytud.hu]

Revision: 1705
Author:   mittelholcz
Date:     2017-02-02 18:06:36 +0100 (Thu, 02 Feb 2017)
Log Message:
-----------
Rebuilt database (rev. 27, not correct)

Modified Paths:
--------------
    trunk/misc/dbdict/dbdict_create_tables.sql
    trunk/misc/dbdict/fsv.log

Modified: trunk/misc/dbdict/dbdict_create_tables.sql
===================================================================
--- trunk/misc/dbdict/dbdict_create_tables.sql	2017-02-02 16:50:44 UTC (rev 1704)
+++ trunk/misc/dbdict/dbdict_create_tables.sql	2017-02-02 17:06:36 UTC (rev 1705)
@@ -23,10 +23,7 @@
 /*!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`)
+  `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 */;
 
@@ -69,7 +66,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 */;
 
 --
@@ -86,7 +83,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 */;
 
 --
@@ -201,7 +198,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 */;
 
 --
@@ -536,4 +533,4 @@
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2017-02-02 17:49:28
+-- Dump completed on 2017-02-02 18:05:44

Modified: trunk/misc/dbdict/fsv.log
===================================================================
--- trunk/misc/dbdict/fsv.log	2017-02-02 16:50:44 UTC (rev 1704)
+++ trunk/misc/dbdict/fsv.log	2017-02-02 17:06:36 UTC (rev 1705)
@@ -1257,14 +1257,6 @@
 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...