$TRUSTED_CONNECTION_STRING = "Server = {0}; Database = {1}; Integrated Security=SSPI;"
$TRUSTED_CONNECTION_STRING_master = "Server = {0}; Database = master; Integrated Security=SSPI;"
$CREATE_SQL_USER_Windows = "CREATE LOGIN [{0}] FROM WINDOWS;"
$CREATE_SQL_USER =  "LOGIN {0} WITH PASSWORD = '{1}';"
$ADD_SQLUSER = "CREATE USER [{0}] FOR LOGIN [{0}]; "
$REMOVE_USER_FROM_DB = "DROP USER {0};"
$REMOVE_USER_FROM_DB_Windows = "DROP USER [{0}];"
$REMOVE_LOGIN= "DROP LOGIN [{0}];"
$CREATE_DATABASE = "CREATE DATABASE {0} CHARACTER SET utf8 COLLATE utf8_general_ci;"
$REMOVE_DATABASE = "DROP DATABASE {0}"
$CHANGE_DBOWNER ="EXEC sp_addrolemember 'db_owner', [{0}]"


#------MySQL-----
$MYSQL_CREATEUSER = "CREATE USER '{0}'@'%' IDENTIFIED BY '{1}';"
$MYSQL_CHANGEPASSWORD = "SET PASSWORD FOR '{0}'@'%' = PASSWORD('{1}');"
$MYSQL_GRANTALL = "GRANT select, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON {0}.* TO '{1}'@'%';"
$MYSQL_REVOKE_ALL = "REVOKE select, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON {0}.* TO '{1}'@'%';"

$MYSQL_SIZE_QUOTA_PERMISSION_SET = "INSERT, CREATE";
$MYSQL_REVOKE = "REVOKE {0} ON {1}.* FROM '{2}'@'%';"
$MYSQL_GRANT = "GRANT {0} ON {1}.* TO '{2}'@'%';"

$MYSQL_REVOKE_ALL = "REVOKE ALL PRIVILEGES, GRANT OPTION FROM '{0}'@'%'"
$MYSQL_QUERY_ALL_TABLES = "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '{0}'"
