From b300e82d2078792d57316a796a4929a1ee7bd1c5 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Thu, 12 Jan 2006 06:24:39 +0000 Subject: [PATCH] Changing table column names; removing no-longer-used columns --- includes/cachev.php | 9 +++------ index.php | 6 ++---- 2 files changed, 5 insertions(+), 10 deletions(-) diff --git a/includes/cachev.php b/includes/cachev.php index 3c0946f..b21d738 100644 --- a/includes/cachev.php +++ b/includes/cachev.php @@ -199,11 +199,8 @@ class cacheV { if (trim($path['action']) == 'A') { - if (!isset($addlist["$path[value]"])) - { - $path['value'] = preg_replace('#^/#', '', $path['value']); - $addlist["$path[value]"] = $log['revision']; - } + $path['value'] = preg_replace('#^/#', '', $path['value']); + $addlist["$path[value]"] = $log['revision']; } } } @@ -225,7 +222,7 @@ class cacheV // insert _nodes $this->registry->db->query(" REPLACE INTO {$this->hash}_nodes - (name, addrevs, revs, properties) + (name, revadd, revnow, properties) VALUES " . implode(",\n", $inserts['nodes']) ); diff --git a/index.php b/index.php index 9d17fd9..32af714 100644 --- a/index.php +++ b/index.php @@ -60,10 +60,8 @@ foreach ($viewsvn->repos->fetch_list() AS $repos) CREATE TABLE {$hash}_nodes ( name VARCHAR(255) NOT NULL DEFAULT '', - uuid VARCHAR(50) NOT NULL DEFAULT '', - delrevs MEDIUMTEXT NOT NULL DEFAULT '', - addrevs MEDIUMTEXT NOT NULL DEFAULT '', - revs MEDIUMTEXT NOT NULL DEFAULT '', + revnow INT(20) UNSIGNED NOT NULL DEFAULT '', + revadd INT(20) UNSIGNED NOT NULL DEFAULT '', properties MEDIUMTEXT NOT NULL DEFAULT '', PRIMARY KEY (name) )" -- 2.22.5