1 files changed, 19 insertions, 15 deletions
diff --git a/updates/3.00-to-x.xx.mysql b/updates/3.00-to-x.xx.mysql
index 0495ff5c9..b8d90b2bc 100644
--- a/updates/3.00-to-x.xx.mysql
+++ b/updates/3.00-to-x.xx.mysql
@@ -155,18 +155,22 @@ ALTER TABLE book DROP pid;
 #   visit http://www.yoursite.com/3.00-to-x.xx.php?part=3
 #
 
-## work in progress
-
-# ALTER TABLE users ADD session TEXT DEFAULT '' NOT NULL;
-# ALTER TABLE users ADD data TEXT DEFAULT '' NOT NULL;
-
-#CREATE TABLE mail (
-#  mid tinyint(10) DEFAULT '0' NOT NULL auto_increment,
-#  subject varchar(255) DEFAULT '' NOT NULL,
-#  recepient varchar(255) DEFAULT '' NOT NULL,
-#  sender varchar(255) DEFAULT '' NOT NULL,
-#  header text,
-#  body text,
-#  timestamp int(11) DEFAULT '0' NOT NULL,
-#  PRIMARY KEY (mid)
-#);
+# 08/11/01:
+ALTER TABLE watchdog CHANGE message message text NOT NULL;
+
+# 14/11/01:
+CREATE TABLE authmap (
+  aid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
+  authname varchar(128) DEFAULT '' NOT NULL,
+  uid int(10) DEFAULT '' NOT NULL,
+  module varchar(128) DEFAULT '' NOT NULL,
+  UNIQUE authname (authname),
+  PRIMARY KEY (aid)
+);
+
+DELETE FROM variable WHERE name = 'user_jabber';
+DELETE FROM variable WHERE name = 'user_drupal';
+
+# TODO:
+#   write some PHP code that moves the 'jabber' and 'drupal' fields
+#   to the new 'authmap' table.