diff options
Diffstat (limited to 'mayor-orig/mayor-jatek/install/module-jatek/mysql')
| -rw-r--r-- | mayor-orig/mayor-jatek/install/module-jatek/mysql/egyszam.sql | 14 |
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; + |