if not exists (select *	from aspnet_Users where username = 'ondot.et')
begin
	begin transaction

	declare @SupportUserID uniqueidentifier

	select @SupportUserID = UserId
	from aspnet_Users
	where UserName = 'ondot.dev'

	declare @t table (UserID uniqueidentifier, Initials nvarchar(10), Gender char(1), Firstname nvarchar(100), Lastname nvarchar(100), [Password] nvarchar(128), PasswordSalt nvarchar(128))

	insert into @t
	values ('B10B3A17-8CD2-4DB0-ABD8-3CBF7B7D6B9C', 'et', 'f', 'Elisabeth', 'Tudorescu', 'l3ngGnFLtoUoqfE7/VuJ+UnhO98=', 'UKQLK7Xvc22sPwACCQERGQ==')

	insert into aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)
	select '82F962AB-1BEE-4064-BB45-AA0B3197CC99', UserID, 'ondot.' + Initials, lower('ondot.' + Initials), 0, GETUTCDATE()
	from @t

	insert into aspnet_UserProperties (UserID, Email, Firstname, Lastname, Phone, WindowsUsername, LanguageID, Homepage, Gender, IsUser, SysDateCreated, SysUserCreatedID, SysProcessCreatedID)
	select UserID, 'support@ondot.at', Firstname, Lastname, '+43 676 845246999', 'ondot\' + Initials, 'de', 'https://www.ondot.at/', Gender, 1, getutcdate(), 'ffffffff-ffff-ffff-ffff-ffffffffffff', 'ffffffff-ffff-ffff-ffff-ffffffffffff'
	from @t

	insert into aspnet_Membership (ApplicationId, UserId, [Password], PasswordFormat, PasswordSalt, Email, LoweredEmail, IsApproved, IsLockedOut, CreateDate, LastLoginDate, LastPasswordChangedDate, LastLockoutDate, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart)
	select '82F962AB-1BEE-4064-BB45-AA0B3197CC99', UserID, [Password], 1, PasswordSalt, 'ondot.' + Initials + '@' + 'ondot.' + Initials, lower('ondot.' + Initials + '@' + 'ondot.' + Initials), 1, 0, GETUTCDATE(), GETUTCDATE(), GETUTCDATE(), GETUTCDATE(), 0, GETUTCDATE(), 0, GETUTCDATE()
	from @t

	insert into aspnet_UsersInRoles (UserId, RoleId, OUID, IsDefault, IsSubstitutionActive)
	select T.UserID, UIR.RoleId, UIR.OUID, UIR.IsDefault, 0
	from 
		aspnet_UsersInRoles UIR
		cross join @t T
	where 
		UIR.UserId = @SupportUserID

	commit transaction
end