[Hejes-devel] [1518] Rebuilt database

[hejes-devel at nytud.hu]

Revision: 1518
Author:   kovacsr
Date:     2015-10-01 17:39:46 +0200 (Thu, 01 Oct 2015)
Log Message:
-----------
Rebuilt database

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

Modified: trunk/misc/dbdict/dbdict_create_tables.sql
===================================================================
--- trunk/misc/dbdict/dbdict_create_tables.sql	2015-10-01 15:24:45 UTC (rev 1517)
+++ trunk/misc/dbdict/dbdict_create_tables.sql	2015-10-01 15:39:46 UTC (rev 1518)
@@ -157,7 +157,7 @@
   KEY `tulnev_betuszo` (`tulnev_betuszo`),
   KEY `morfologiai` (`morfologiai`),
   KEY `tagadoszo` (`tagadoszo`)
-) ENGINE=MyISAM AUTO_INCREMENT=350824 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=350948 DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -492,4 +492,4 @@
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2015-10-01 17:23:57
+-- Dump completed on 2015-10-01 17:39:30

Modified: trunk/misc/dbdict/dbdict_reset_auto_increments.sql
===================================================================
--- trunk/misc/dbdict/dbdict_reset_auto_increments.sql	2015-10-01 15:24:45 UTC (rev 1517)
+++ trunk/misc/dbdict/dbdict_reset_auto_increments.sql	2015-10-01 15:39:46 UTC (rev 1518)
@@ -1,13 +1,3 @@
-ALTER TABLE `akh12_aseskepzo_egybe_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_aseskepzo_kulon_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_folyamatosmnszerk_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_mn_fn_egybe_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_mn_fn_kulon_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_mn_u_kepzo_egybe_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_mn_u_kepzo_kulon_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_mozgo_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_ragos_fn_ige_egybe_import` AUTO_INCREMENT = 1;
-ALTER TABLE `akh12_ragos_fn_ige_kulon_import` AUTO_INCREMENT = 1;
 ALTER TABLE `alt_types` AUTO_INCREMENT = 1;
 ALTER TABLE `alt_types__norm` AUTO_INCREMENT = 1;
 ALTER TABLE `alt_types_compound` AUTO_INCREMENT = 1;

Modified: trunk/misc/dbdict/dump_dbdict.sql.zip
===================================================================
(Binary files differ)

Modified: trunk/misc/dbdict/fsv.log
===================================================================
--- trunk/misc/dbdict/fsv.log	2015-10-01 15:24:45 UTC (rev 1517)
+++ trunk/misc/dbdict/fsv.log	2015-10-01 15:39:46 UTC (rev 1518)
@@ -1110,6 +1110,7 @@
 Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
 Running sql  UPDATE `akh12_mn_fn_egybe_import` i INNER JOIN `alt_types` t ON...
 Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_mn_fn_egybe`) ...
+Running sql DROP TABLE IF EXISTS `akh12_mn_fn_egybe_import`;...
 akh12/akh12_mn_fn_kulon
 Running sql DROP TABLE IF EXISTS `akh12_mn_fn_kulon_import`;...
 Running sql CREATE TABLE `akh12_mn_fn_kulon_import` ( `actual` varchar(64) c...
@@ -1121,6 +1122,7 @@
 Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
 Running sql  UPDATE `akh12_mn_fn_kulon_import` i INNER JOIN `alt_types` t ON...
 Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_mn_fn_kulon`) ...
+Running sql DROP TABLE IF EXISTS `akh12_mn_fn_kulon_import`;...
 akh12/akh12_folyamatosmnszerk
 Running sql DROP TABLE IF EXISTS `akh12_folyamatosmnszerk_import`;...
 Running sql CREATE TABLE `akh12_folyamatosmnszerk_import` ( `actual` varchar...
@@ -1132,6 +1134,7 @@
 Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
 Running sql  UPDATE `akh12_folyamatosmnszerk_import` i INNER JOIN `alt_types...
 Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_folyamatosmnsz...
+Running sql DROP TABLE IF EXISTS `akh12_folyamatosmnszerk_import`;...
 akh12/akh12_mn_u_kepzo_kulon
 Running sql DROP TABLE IF EXISTS `akh12_mn_u_kepzo_kulon_import`;...
 Running sql CREATE TABLE `akh12_mn_u_kepzo_kulon_import` ( `actual` varchar(...
@@ -1143,6 +1146,7 @@
 Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
 Running sql  UPDATE `akh12_mn_u_kepzo_kulon_import` i INNER JOIN `alt_types`...
 Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_mn_u_kepzo_kul...
+Running sql DROP TABLE IF EXISTS `akh12_mn_u_kepzo_kulon_import`;...
 akh12/akh12_mn_u_kepzo_egybe
 Running sql DROP TABLE IF EXISTS `akh12_mn_u_kepzo_egybe_import`;...
 Running sql CREATE TABLE `akh12_mn_u_kepzo_egybe_import` ( `actual` varchar(...
@@ -1154,6 +1158,7 @@
 Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
 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...
@@ -1165,6 +1170,7 @@
 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`;...
 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...
@@ -1176,6 +1182,7 @@
 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`;...
 akh12/akh12_mozgo
 Running sql DROP TABLE IF EXISTS `akh12_mozgo_import`;...
 Running sql CREATE TABLE `akh12_mozgo_import` ( `actual` varchar(64) collate...
@@ -1187,6 +1194,7 @@
 Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
 Running sql  UPDATE `akh12_mozgo_import` i INNER JOIN `alt_types` t ON t.`ac...
 Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_mozgo`) SELECT...
+Running sql DROP TABLE IF EXISTS `akh12_mozgo_import`;...
 akh12/akh12_aseskepzo_kulon
 Running sql DROP TABLE IF EXISTS `akh12_aseskepzo_kulon_import`;...
 Running sql CREATE TABLE `akh12_aseskepzo_kulon_import` ( `actual` varchar(6...
@@ -1198,6 +1206,7 @@
 Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
 Running sql  UPDATE `akh12_aseskepzo_kulon_import` i INNER JOIN `alt_types` ...
 Running sql INSERT INTO `alt_types_exceptions` (`tid`, `akh12_aseskepzo_kulo...
+Running sql DROP TABLE IF EXISTS `akh12_aseskepzo_kulon_import`;...
 akh12/akh12_aseskepzo_egybe
 Running sql DROP TABLE IF EXISTS `akh12_aseskepzo_egybe_import`;...
 Running sql CREATE TABLE `akh12_aseskepzo_egybe_import` ( `actual` varchar(6...
@@ -1209,3 +1218,4 @@
 Running sql INSERT INTO `alt_types` (`actual`) ( SELECT `actual` FROM `akh12...
 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`;...