aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/mayor-jatek/install
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/mayor-jatek/install')
-rw-r--r--mayor-orig/mayor-jatek/install/module-jatek/mysql/egyszam.sql14
1 files changed, 14 insertions, 0 deletions
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;
+