From d0310d98a4745ac1dab97a7029eccfcf39a5ed65 Mon Sep 17 00:00:00 2001 From: Tim Starling Date: Sun, 26 Sep 2004 08:53:48 +0000 Subject: [PATCH] user_token field (from REL1_3A) --- maintenance/archives/patch-user_token.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 maintenance/archives/patch-user_token.sql diff --git a/maintenance/archives/patch-user_token.sql b/maintenance/archives/patch-user_token.sql new file mode 100644 index 0000000000..02d042024f --- /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) +); -- 2.20.1