From 1ad9afb8a7a1a3e2eaeacd34579386139654049e Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Mon, 10 May 2004 20:34:25 +0000
Subject: - Added support for multiple user roles.  Patch by Jim Hriggs.

---
 update.php | 35 ++++++++++++++++++++++++++++++++---
 1 file changed, 32 insertions(+), 3 deletions(-)

(limited to 'update.php')

diff --git a/update.php b/update.php
index b92e011d7..4936880a5 100644
--- a/update.php
+++ b/update.php
@@ -109,7 +109,29 @@ function update_info() {
   print "</ol>";
   print "Notes:";
   print "<ol>";
-  print " <li>If you <strong>upgrade from Drupal 4.3.x</strong>, you have will need to add the <code>bootstrap</code> and <code>throttle</code> fields to the <code>system</code> table manually before upgrading. To add the required fields, issue the following SQL commands:
+  print " <li>If you <strong>upgrade from Drupal 4.4.x</strong>, you will need to create the <code>users_roles</code> table manually before upgrading. To create the <code>users_roles</code> table, issue the following SQL commands:
+
+  <p>MySQL specific example:
+  <pre>
+  CREATE TABLE users_roles (
+    uid int(10) unsigned NOT NULL default '0',
+    rid int(10) unsigned NOT NULL default '0',
+    PRIMARY KEY (uid, rid)
+  );
+  </pre>
+  </p>
+
+  <p>PostgreSQL specific example:
+  <pre>
+  CREATE TABLE users_roles (
+    uid integer NOT NULL default '0',
+    rid integer NOT NULL default '0',
+    PRIMARY KEY (uid, rid)
+  );
+  </pre>
+  </p>
+  </li>";
+  print " <li>If you <strong>upgrade from Drupal 4.3.x</strong>, you will need to add the <code>bootstrap</code> and <code>throttle</code> fields to the <code>system</code> table manually before upgrading. To add the required fields, issue the following SQL commands:
 
   <p>MySQL specific example:
   <pre>
@@ -128,7 +150,11 @@ function update_info() {
   </pre>
   </p>
   </li>";
-  print " <li>If you <strong>upgrade from Drupal 4.2.0</strong>, you have to create the <code>sessions</code> table manually before upgrading.  After you created the table, you'll want to log in and immediately continue the upgrade.  To create the <code>sessions</code> table, issue the following SQL command (MySQL specific example):<pre>CREATE TABLE sessions (
+  print " <li>If you <strong>upgrade from Drupal 4.2.0</strong>, you will need to create the <code>sessions</code> table manually before upgrading.  After creating the table, you will want to log in and immediately continue the upgrade.  To create the <code>sessions</code> table, issue the following SQL command:
+
+  <p>MySQL specific example:
+  <pre>
+  CREATE TABLE sessions (
   uid int(10) unsigned NOT NULL,
   sid varchar(32) NOT NULL default '',
   hostname varchar(128) NOT NULL default '',
@@ -136,7 +162,10 @@ function update_info() {
   session text,
   KEY uid (uid),
   KEY sid (sid(4)),
-  KEY timestamp (timestamp));</pre></li>";
+  KEY timestamp (timestamp));
+  </pre>
+  </p>
+  </li>";
   print "</ol>";
   print update_page_footer();
 }
-- 
cgit v1.2.3