- Added Marco's long-awaited taxonmy module and patches - a replacement

  for the meta system.  The patches add some extra functionality to the
  comment system (for example, comments can be set read-only) and fix a
  couple of small problems.

  + I integrated the required SQL updates from the varius *.mysql files
    into the "update.php" script.  Upgrading should be easy ...

  + I did not apply/commit the "user.diff" as requested by Marco ...

  + I didn't know what to do with "forum.module" and "forum2.module":
    what do you want me to do with it Marco?  Which one should go in?

  + Can we remove "node_index()" now; both from "node.module" and the
    themes?

  + Thanks Marco!

1 files changed, 53 insertions, 2 deletions

diff --git a/update.php b/update.php
index 1c8a58a6b..425bf38f8 100644
--- a/update.php
+++ b/update.php
@@ -49,7 +49,8 @@ $mysql_updates = array(
   "2002-02-19" => "update_22",
   "2002-03-05" => "update_23",
   "2002-04-08" => "update_24",
-  "2002-03-11 : modules/themes web config" => "update_25"
+  "2002-04-14 : modules/themes web config" => "update_25",
+  "2002-04-14 : new taxonomy system" => "update_26"
 );
 
 // Update functions
@@ -352,7 +353,57 @@ function update_25() {
   update_sql("REPLACE system SET name = 'system', type = 'module', filename = 'system.module', status = '1';");
   update_sql("REPLACE system SET name = 'user', type = 'module', filename = 'user.module', status = '1';");
   update_sql("REPLACE system SET name = 'watchdog', type = 'module', filename = 'watchdog.module', status = '1';");
-  update_sql("UPDATE users SET theme = LOWER(theme);');
+  update_sql("UPDATE users SET theme = LOWER(theme);");
+}
+
+function update_26() {
+  update_sql("CREATE TABLE vocabulary (
+    vid int UNSIGNED NOT NULL PRIMARY KEY auto_increment,
+    name varchar(255) NOT NULL,
+    description TEXT,
+    relations TINYINT UNSIGNED NOT NULL,
+    hierarchy TINYINT UNSIGNED NOT NULL,
+    multiple TINYINT UNSIGNED NOT NULL,
+    required TINYINT UNSIGNED NOT NULL,
+    types TEXT,
+    weight TINYINT NOT NULL);");
+
+  update_sql("CREATE TABLE term_data (
+    tid int UNSIGNED NOT NULL PRIMARY KEY auto_increment,
+    vid int UNSIGNED NOT NULL,
+    name varchar(255) NOT NULL,
+    description TEXT,
+    weight TINYINT NOT NULL);");
+
+  update_sql("CREATE TABLE term_hierarchy (
+    tid int UNSIGNED NOT NULL,
+    parent int UNSIGNED NOT NULL
+  );");
+
+  update_sql("CREATE TABLE term_relation (
+    tid1 int UNSIGNED NOT NULL,
+    tid2 int UNSIGNED NOT NULL
+  );");
+
+  update_sql("CREATE TABLE term_synonym (
+    tid int UNSIGNED NOT NULL,
+    name varchar(255) NOT NULL
+  );");
+
+  update_sql("CREATE TABLE term_node (
+    nid int UNSIGNED NOT NULL,
+    tid int UNSIGNED NOT NULL
+  );");
+
+  update_sql("ALTER TABLE term_data ADD INDEX (vid);");
+  update_sql("ALTER TABLE term_hierarchy ADD INDEX (tid);");
+  update_sql("ALTER TABLE term_hierarchy ADD INDEX (parent);");
+  update_sql("ALTER TABLE term_relation ADD INDEX (tid1);");
+  update_sql("ALTER TABLE term_relation ADD INDEX (tid2);");
+  update_sql("ALTER TABLE term_synonym ADD INDEX (tid);");
+  update_sql("ALTER TABLE term_synonym ADD INDEX (name(3));");
+  update_sql("ALTER TABLE term_node ADD INDEX (nid);");
+  update_sql("ALTER TABLE term_node ADD INDEX (tid);");
 }
 
 /*