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-fenntarto/install/module-fenntarto/mysql | |
| parent | f51c9ed2abe5c68211bb3736be5f70b1fe2c9ec0 (diff) | |
| download | mayor-c0f79397dd75e03a7a40303f82926e8187697d07.tar.gz mayor-c0f79397dd75e03a7a40303f82926e8187697d07.zip | |
Rev: 4455
Diffstat (limited to 'mayor-orig/mayor-fenntarto/install/module-fenntarto/mysql')
| -rw-r--r-- | mayor-orig/mayor-fenntarto/install/module-fenntarto/mysql/base.sql | 16 |
1 files changed, 16 insertions, 0 deletions
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; + |