SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE createAccount

	@username char(20),
	@email char(50),
	@password char(20),
	@verified BIT,
	@enabled BIT,
	@verificationCode char(8),

	@class TINYINT,
	@gender char (6),
	@charName char (20),
	@strength tinyint,
	@agility tinyint,
	@magicalPower tinyint,
	@hp integer,
	@mana integer

AS

BEGIN TRY

BEGIN TRANSACTION



INSERT INTO Accounts ([username], [email], [password], [verified?], [enabled?], [verificationCode])
VALUES (@username, @email, @password, @verified, @enabled, @verificationCode)

INSERT INTO Characters([charId], [charName], [strength], [agility], [magicalPower], [hp], [mana], [doingSomething?], [class], [gender])
VALUES (SCOPE_IDENTITY(), @charName, @strength, @agility, @magicalPower, @hp, @mana, 0, @class, @gender)

COMMIT

END TRY
BEGIN CATCH

IF @@TRANCOUNT>0
	ROLLBACK

END CATCH
GO