diff options
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; + |