diff options
| author | Denis <d.v.kobozev@gmail.com> | 2010-04-05 09:41:30 -0400 |
|---|---|---|
| committer | Loui Chang <louipc.ist@gmail.com> | 2010-04-17 16:50:24 -0400 |
| commit | 290c436046327d9f04b7d12b5fda19f4dc14f574 (patch) | |
| tree | 93c9ca0485e5ffb7d87460fbb78218c5f03e830f /support/schema | |
| parent | 5b8b0757f4f938f86bed86ae56fa3511704e006f (diff) | |
| download | aurweb-290c436046327d9f04b7d12b5fda19f4dc14f574.tar.xz | |
Support for storing salted passwords
To upgrade existing databases:
ALTER TABLE Users ADD Salt CHAR(32) NOT NULL DEFAULT '';
Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Diffstat (limited to 'support/schema')
| -rw-r--r-- | support/schema/aur-schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 67e20a7..250d405 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -26,6 +26,7 @@ CREATE TABLE Users ( Username CHAR(32) NOT NULL, Email CHAR(64) NOT NULL, Passwd CHAR(32) NOT NULL, + Salt CHAR(32) NOT NULL DEFAULT '', ResetKey CHAR(32) NOT NULL DEFAULT '', RealName CHAR(64) NOT NULL DEFAULT '', LangPreference CHAR(5) NOT NULL DEFAULT 'en', |