[Security] User's password

All passwords are encrypted to SHA512 on our database.

The hash is stored as uppercase, contains an fixed salt and their user's ID. You can't copy an user's password to another for re-usage (for example, to reset an password).

Use following MySQL query to generate an password:

SELECT
	1			AS `id`,	-- Change the ID
	'YourPassword123'	AS `password`,	-- Change the Password
	(SELECT
		UPPER(SHA2(CONCAT(`id`, '%PineApple$', `password`), 512)) AS `crypted`
	) AS `crypted`

You get following sample result:

id	password	crypted
1	YourPassword123	E8BC1E54BC5776E5223E94EACB3C3B3BE3F7F09A1A8F43ADE0FE7BD1F7879CE047FDAFDF9968BB884AC9F3FBCFDFDD828680056AA07712FD25581FFBF61FAFF5