#!/bin/sh


echo "LumedProject database"

echo "clear all groups from your @cunt"

sqlcmd -S ".\SQLEXPRESS" -U sa -P svp -d LumedProject -Q "
delete SEC_UserGroupUser 
    from SEC_UserGroupUser 
    join SEC_User on SEC_User.UserId = SEC_UserGroupUser.UserId 
    join SEC_UserGroup on SEC_UserGroup.UserGroupId = SEC_UserGroupUser.UserGroupId 
    where SEC_User.Login = 'mrobinson' 

"



echo "add Admin group to your @cunt"

sqlcmd -S ".\SQLEXPRESS" -U sa -P svp -d LumedProject -Q "
insert into SEC_UserGroupUser (UserId, UserGroupId, CreationDate, CreationUser)
    select SEC_User.UserId, SEC_UserGroup.UserGroupId, CURRENT_TIMESTAMP, 'script' 
    from SEC_User, SEC_UserGroup 
    where SEC_User.Login = 'mrobinson'
    and SEC_UserGroup.Name = 'Admin'
"

echo "your @cunt is now member of ZincBase"