-- LosaDev 2019 (optional): test accounts and seed rows (run after the schema scripts).
-- The Indonesia build only accepts IDs of 6-12 letters/digits/-/_, so "test1" is too short: the IDs are tester1 / gmtest1.
-- Passwords are stored for reference only: with TestMode=1 the billing server does not check them.
-- gmtest1's nickname GMTest1 is listed in ls_gamesvr\config\sp2_developerID.ini (developer = GM rights).
-- Any other 6-12 character ID also works: the first login creates the account (game_member_add).
USE [LosaGame]
GO
SET NOCOUNT ON
DECLARE @ret int
IF NOT EXISTS (SELECT 1 FROM dbo.userMemberDB WHERE userID = 'tester1')
	EXEC dbo.web_member_add 'tester1', 'Tester1', 'test1234', '', 0, 0, 0, 0, '127.0.0.1', @ret OUTPUT
IF NOT EXISTS (SELECT 1 FROM dbo.userMemberDB WHERE userID = 'gmtest1')
	EXEC dbo.web_member_add 'gmtest1', 'GMTest1', 'test1234', '', 0, 0, 0, 0, '127.0.0.1', @ret OUTPUT
SELECT accountIDX, userID, nickName FROM dbo.userMemberDB WHERE userID IN ('tester1', 'gmtest1')
GO