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

---
 .../mayor-jatek/install/module-jatek/mysql/egyszam.sql     | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 mayor-orig/mayor-jatek/install/module-jatek/mysql/egyszam.sql

(limited to 'mayor-orig/mayor-jatek/install')

diff --git a/mayor-orig/mayor-jatek/install/module-jatek/mysql/egyszam.sql b/mayor-orig/mayor-jatek/install/module-jatek/mysql/egyszam.sql
new file mode 100644
index 00000000..1f4c9271
--- /dev/null
+++ b/mayor-orig/mayor-jatek/install/module-jatek/mysql/egyszam.sql
@@ -0,0 +1,14 @@
+DROP DATABASE IF EXISTS mayor_jatek;
+CREATE DATABASE mayor_jatek CHARACTER SET utf8;
+GRANT ALL ON mayor_jatek.* TO 'mayor_jatek'@'localhost' IDENTIFIED BY '1212';
+GRANT SELECT ON mayor_jatek.* TO 'mayor_jatek_read'@'localhost' IDENTIFIED BY '1234';
+USE mayor_jatek;
+
+CREATE TABLE egyszam (
+  userAccount VARCHAR(32) NULL,
+  ev YEAR NULL,
+  het TINYINT UNSIGNED NULL,
+  szam TINYINT UNSIGNED NULL,
+  PRIMARY KEY(userAccount,ev,het,szam)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
-- 
cgit v1.2.3