diff options
author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-07-16 07:34:49 +0000 |
---|---|---|
committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-07-16 07:34:49 +0000 |
commit | ee40f5605e50b1d421e3456f672a324360aff5a7 (patch) | |
tree | 3c0b8b491da00c20d1f4b38a634d5be12e13cee4 /util | |
parent | 94e9da6f6c654f45bc7efb7a4e6591c64f0553c5 (diff) |
Accounts can be deleted, home page now shows age of last post instead of user, removed the /u+/pending URL, and small bugfix in dump.sql
git-svn-id: svn://vndb.org/vndb@69 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'util')
-rw-r--r-- | util/dump.sql | 7 | ||||
-rw-r--r-- | util/updates/update_1.20.sql | 4 |
2 files changed, 8 insertions, 3 deletions
diff --git a/util/dump.sql b/util/dump.sql index 1ed22c22..ce0f8be4 100644 --- a/util/dump.sql +++ b/util/dump.sql @@ -361,7 +361,8 @@ $$ LANGUAGE plpgsql; CREATE SEQUENCE covers_seq; CREATE SEQUENCE relgraph_seq; --- We can't live without multi -INSERT INTO users (id, username, mail, rank, registered) - VALUES (1, 'multi', 'multi@vndb.org', 0, EXTRACT(EPOCH FROM NOW())); +INSERT INTO users (id, username, mail, rank) + VALUES (0, 'deleted', 'del@vndb.org', 0); +INSERT INTO users (username, mail, rank, registered) + VALUES ('multi', 'multi@vndb.org', 0, EXTRACT(EPOCH FROM NOW())); diff --git a/util/updates/update_1.20.sql b/util/updates/update_1.20.sql new file mode 100644 index 00000000..9c02e184 --- /dev/null +++ b/util/updates/update_1.20.sql @@ -0,0 +1,4 @@ + +-- deleted user +INSERT INTO users (id, username, mail, rank) + VALUES (0, 'deleted', 'del@vndb.org', 0); |