user_token field (from REL1_3A)

diff --git a/maintenance/archives/patch-user_token.sql b/maintenance/archives/patch-user_token.sql
new file mode 100644 (file)
index 0000000..02d0420
--- /dev/null
+++ b/maintenance/archives/patch-user_token.sql
@@ -0,0 +1,15 @@
+-- user_token patch
+-- 2004-09-23
+
+ALTER TABLE user ADD user_token char(32) binary NOT NULL default '';
+
+UPDATE user SET user_token = concat(
+       substring(rand(),3,4),
+       substring(rand(),3,4),
+       substring(rand(),3,4),
+       substring(rand(),3,4),
+       substring(rand(),3,4),
+       substring(rand(),3,4),
+       substring(rand(),3,4),
+       substring(rand(),3,4)
+);