summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authoryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-07-16 07:34:49 +0000
committeryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-07-16 07:34:49 +0000
commitee40f5605e50b1d421e3456f672a324360aff5a7 (patch)
tree3c0b8b491da00c20d1f4b38a634d5be12e13cee4 /util
parent94e9da6f6c654f45bc7efb7a4e6591c64f0553c5 (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.sql7
-rw-r--r--util/updates/update_1.20.sql4
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);