2.0.1_password_hash.sql

main 11 lines · 511 bytes Raw

Alex Commit Initial commit 01/10/2026 09:20

1-- Website-only password modernization: accounts.password (SHA1, read by the

2-- game server) is never touched. This column holds a modern password_hash()

3-- value used only to verify website logins; it is filled in lazily as each

4-- account logs in or changes its password.

5--

6-- Only needed for databases created BEFORE 2.0.1. A fresh import of

7-- SQL/znote_schema.sql already contains this column.

9ALTER TABLE `znote_accounts`

10 ADD COLUMN `password_hash` varchar(255) DEFAULT NULL AFTER `secret`;