[Hejes-devel] [1517] DB schema for 10 new columns

[hejes-devel at nytud.hu]

Revision: 1517
Author:   kovacsr
Date:     2015-10-01 17:24:45 +0200 (Thu, 01 Oct 2015)
Log Message:
-----------
DB schema for 10 new columns

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

Modified: trunk/misc/dbdict/dbdict_create_tables.sql
===================================================================
--- trunk/misc/dbdict/dbdict_create_tables.sql	2015-10-01 14:50:39 UTC (rev 1516)
+++ trunk/misc/dbdict/dbdict_create_tables.sql	2015-10-01 15:24:45 UTC (rev 1517)
@@ -16,156 +16,6 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
 --
--- Table structure for table `akh12_aseskepzo_egybe_import`
---
-
-DROP TABLE IF EXISTS `akh12_aseskepzo_egybe_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_aseskepzo_egybe_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_aseskepzo_kulon_import`
---
-
-DROP TABLE IF EXISTS `akh12_aseskepzo_kulon_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_aseskepzo_kulon_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_folyamatosmnszerk_import`
---
-
-DROP TABLE IF EXISTS `akh12_folyamatosmnszerk_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_folyamatosmnszerk_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_mn_fn_egybe_import`
---
-
-DROP TABLE IF EXISTS `akh12_mn_fn_egybe_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_mn_fn_egybe_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_mn_fn_kulon_import`
---
-
-DROP TABLE IF EXISTS `akh12_mn_fn_kulon_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_mn_fn_kulon_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_mn_u_kepzo_egybe_import`
---
-
-DROP TABLE IF EXISTS `akh12_mn_u_kepzo_egybe_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_mn_u_kepzo_egybe_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_mn_u_kepzo_kulon_import`
---
-
-DROP TABLE IF EXISTS `akh12_mn_u_kepzo_kulon_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_mn_u_kepzo_kulon_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_mozgo_import`
---
-
-DROP TABLE IF EXISTS `akh12_mozgo_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_mozgo_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_ragos_fn_ige_egybe_import`
---
-
-DROP TABLE IF EXISTS `akh12_ragos_fn_ige_egybe_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_ragos_fn_ige_egybe_import` (
-  `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 */;
-
---
--- Table structure for table `akh12_ragos_fn_ige_kulon_import`
---
-
-DROP TABLE IF EXISTS `akh12_ragos_fn_ige_kulon_import`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `akh12_ragos_fn_ige_kulon_import` (
-  `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 */;
-
---
 -- Table structure for table `alt_types`
 --
 
@@ -264,6 +114,16 @@
   `6_3_kivetel` tinyint(1) DEFAULT NULL,
   `morfologiai` tinyint(1) DEFAULT NULL,
   `tagadoszo` tinyint(1) DEFAULT NULL,
+  `akh12_mn_fn_egybe` tinyint(1) DEFAULT NULL,
+  `akh12_mn_fn_kulon` tinyint(1) DEFAULT NULL,
+  `akh12_folyamatosmnszerk` tinyint(1) DEFAULT NULL,
+  `akh12_mn_u_kepzo_kulon` tinyint(1) DEFAULT NULL,
+  `akh12_mn_u_kepzo_egybe` tinyint(1) DEFAULT NULL,
+  `akh12_ragos_fn_ige_kulon` tinyint(1) DEFAULT NULL,
+  `akh12_ragos_fn_ige_egybe` tinyint(1) DEFAULT NULL,
+  `akh12_mozgo` tinyint(1) DEFAULT NULL,
+  `akh12_aseskepzo_kulon` tinyint(1) DEFAULT NULL,
+  `akh12_aseskepzo_egybe` tinyint(1) DEFAULT NULL,
   PRIMARY KEY (`tid`),
   KEY `fonevi_jelzos_szerk` (`fonevi_jelzos_szerk`),
   KEY `allandosult_szokapcs_kepzett_osszetetel` (`allandosult_szokapcs_kepzett_osszetetel`),
@@ -632,4 +492,4 @@
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2015-10-01 16:50:06
+-- Dump completed on 2015-10-01 17:23:57