From d0947cffcdfb412b64f8f7550f50da0070874daf Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Thu, 12 Jan 2006 02:28:05 +0000 Subject: [PATCH] Add two tables now, per the spec --- index.php | 17 +++++++++++++++-- 1 file changed, 15 insertions(+), 2 deletions(-) diff --git a/index.php b/index.php index 99d9b17..9d17fd9 100644 --- a/index.php +++ b/index.php @@ -41,11 +41,11 @@ while ($table = $db->fetch_array($tables)) foreach ($viewsvn->repos->fetch_list() AS $repos) { - if (!in_array($hash = md5($viewsvn->repos->fetch_path($repos)), $tablelist)) + if (!in_array(($hash = md5($viewsvn->repos->fetch_path($repos))) . '_revs', $tablelist)) { $viewsvn->debug("creating new cacheV: $repos"); $db->query(" - CREATE TABLE $hash + CREATE TABLE {$hash}_revs ( revision INT(20) UNSIGNED NOT NULL DEFAULT 0, author VARCHAR(255) NOT NULL DEFAULT '', @@ -55,6 +55,19 @@ foreach ($viewsvn->repos->fetch_list() AS $repos) PRIMARY KEY (revision) )" ); + + $db->query(" + 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 '', + properties MEDIUMTEXT NOT NULL DEFAULT '', + PRIMARY KEY (name) + )" + ); } $link = $viewsvn->paths->out('browse.php', $repos . '/'); -- 2.22.5