aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/install/module-naplo/mysql/naplo-users.sql
blob: 309abb23021e187b379764d11cfa9fe1ff701484 (plain)
1
2
3
4
5
6
7
8
USE %MYSQL_PRIVATE_DB%;

INSERT INTO groups (groupCn,groupDesc,policy) VALUES
('naploadmin','Napló adminisztrátorok','private'),('vezetoseg','Vezetőség','private'),
                ('diakadmin','Diák adminisztrátorok','private'),('uzenoadmin','Üzenő adminisztrátorok','private');
SET @uid = (SELECT uid FROM accounts WHERE userAccount='mayoradmin');
SET @gid = (SELECT gid FROM groups WHERE groupCn='naploadmin');
INSERT INTO members (uid,gid) VALUES (@uid,@gid);