diff options
| author | Andreas Habel <mail@exceptionfault.de> | 2009-08-17 19:18:36 +0200 |
|---|---|---|
| committer | Andreas Habel <mail@exceptionfault.de> | 2009-08-17 19:18:36 +0200 |
| commit | 04ebe945e98e397192272d1e3f5e6b91ebd3d795 (patch) | |
| tree | c250b188e8ca507736b619905edbc5b9049d983a /src/sql/sqlite/updates | |
| parent | e6471b3ffc2f4cc049184a979db7b02c41a8e475 (diff) | |
| download | manaserv-04ebe945e98e397192272d1e3f5e6b91ebd3d795.tar.gz manaserv-04ebe945e98e397192272d1e3f5e6b91ebd3d795.tar.xz manaserv-04ebe945e98e397192272d1e3f5e6b91ebd3d795.zip | |
Update table tmw_accounts. Added columns to store secret key and expiration
time for password recovery via tmwweb/email.
Diffstat (limited to 'src/sql/sqlite/updates')
| -rw-r--r-- | src/sql/sqlite/updates/update_3_to_4.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/src/sql/sqlite/updates/update_3_to_4.sql b/src/sql/sqlite/updates/update_3_to_4.sql new file mode 100644 index 0000000..94d2edd --- /dev/null +++ b/src/sql/sqlite/updates/update_3_to_4.sql @@ -0,0 +1,13 @@ + +-- add two columns to table tmw_accounts +ALTER TABLE tmw_accounts ADD + authorization TEXT NULL, + expiration INTEGER NULL +; + +-- update the database version, and set date of update +UPDATE tmw_world_states + SET value = '4', + moddate = strftime('%s','now') + WHERE state_name = 'database_version'; + |