From c0f79397dd75e03a7a40303f82926e8187697d07 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Fri, 8 Mar 2019 23:32:47 +0100
Subject: Rev: 4455

---
 .../install/module-fenntarto/mysql/base.sql              | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 mayor-orig/mayor-fenntarto/install/module-fenntarto/mysql/base.sql

(limited to 'mayor-orig/mayor-fenntarto/install/module-fenntarto/mysql')

diff --git a/mayor-orig/mayor-fenntarto/install/module-fenntarto/mysql/base.sql b/mayor-orig/mayor-fenntarto/install/module-fenntarto/mysql/base.sql
new file mode 100644
index 00000000..a515439f
--- /dev/null
+++ b/mayor-orig/mayor-fenntarto/install/module-fenntarto/mysql/base.sql
@@ -0,0 +1,16 @@
+
+
+CREATE DATABASE `%MYSQL_FENNTARTO_DB%` CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
+GRANT ALL ON `%MYSQL_FENNTARTO_DB%`.* TO '%MYSQL_FENNTARTO_USER%'@'localhost' IDENTIFIED BY '%MYSQL_FENNTARTO_PW%';
+
+USE `%MYSQL_FENNTARTO_DB%`;
+
+CREATE TABLE `rpcKerelem` (
+  `userAccount` varchar(50) NOT NULL default '',
+  `nodeId` mediumint(8) unsigned zerofill NOT NULL DEFAULT '00000000',
+  `OMKod` mediumint(8) unsigned zerofill NOT NULL DEFAULT '00000000',
+  `requ` set('OMKod','Jogosultság','Tantárgyfelosztás') COLLATE utf8_hungarian_ci DEFAULT 'OMKod,Jogosultság',
+  PRIMARY KEY (`nodeId`, `userAccount`,`OMKod`),
+  CONSTRAINT `nodeId_login` FOREIGN KEY (`nodeId`) REFERENCES `mayor_login`.`mayorKeychain` (`nodeId`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
-- 
cgit v1.2.3