diff options
| author | M.Gergo | 2019-03-08 23:32:47 +0100 |
|---|---|---|
| committer | M.Gergo | 2019-03-08 23:32:47 +0100 |
| commit | c0f79397dd75e03a7a40303f82926e8187697d07 (patch) | |
| tree | e945a10ef6479e0f8720ad9cd4947b6a85b78d6e /mayor-orig/mayor-jatek/install | |
| parent | f51c9ed2abe5c68211bb3736be5f70b1fe2c9ec0 (diff) | |
| download | mayor-c0f79397dd75e03a7a40303f82926e8187697d07.tar.gz mayor-c0f79397dd75e03a7a40303f82926e8187697d07.zip | |
Rev: 4455
Diffstat (limited to 'mayor-orig/mayor-jatek/install')
| -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; + |