INSERT INTO users (id,username,userpassword) VALUES (1,'admin','edf123');
INSERT INTO group_ (id,groupname) VALUES (1,'admins');
INSERT into usergroup(id,groupid,userid) VALUES (2,1,1);
-INSERT INTO grouppermissions (id,groupid,servicename,methodname) VALUES (3, 1, 'UserService',1); -- Create user
-INSERT INTO grouppermissions (id,groupid,servicename,methodname) VALUES (3, 1, 'UserService',2); -- Delete user
-INSERT INTO grouppermissions (id,groupid,servicename,methodname) VALUES (3, 1, 'UserService',3); -- Add to group
-INSERT INTO grouppermissions (id,groupid,servicename,methodname) VALUES (3, 1, 'UserService',4); -- Remove from group
-INSERT INTO grouppermissions (id,groupid,servicename,methodname) VALUES (3, 1, 'UserService',5); -- Create group
-INSERT INTO grouppermissions (id,groupid,servicename,methodname) VALUES (3, 1, 'UserService',6); -- Delete group
-INSERT INTO grouppermissions (id,groupid,servicename,methodname) VALUES (3, 1, 'UserService',7); -- Find user
-INSERT INTO grouppermissions (id,groupid,servicename,methodname) VALUES (3, 1, 'UserService',8); -- Find group
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',1); -- Create user
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',2); -- Delete user
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',3); -- Add to group
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',4); -- Remove from group
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',5); -- Create group
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',6); -- Delete group
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',7); -- Find user
+INSERT INTO GROUPPERMISSIONS (id,groupid,servicename,methodindex) VALUES (3, 1, 'UserService',8); -- Find group
