Add two tables now, per the spec
[viewsvn.git] / index.php
1 <?php
2 /*=====================================================================*\
3 || ###################################################################
4 || # ViewSVN [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
6 || #
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
10 || #
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
14 || # more details.
15 || #
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
21
22 define('PATH_OVERRIDE', 1);
23
24 $fetchtemplates = array(
25 'index_node',
26 'index'
27 );
28
29 require_once('./global.php');
30
31 // ###################################################################
32
33 $nodes = '';
34
35 $tables = $db->query("SHOW TABLES");
36 while ($table = $db->fetch_array($tables))
37 {
38 $value = array_values($table);
39 $tablelist[] = $value[0];
40 }
41
42 foreach ($viewsvn->repos->fetch_list() AS $repos)
43 {
44 if (!in_array(($hash = md5($viewsvn->repos->fetch_path($repos))) . '_revs', $tablelist))
45 {
46 $viewsvn->debug("creating new cacheV: $repos");
47 $db->query("
48 CREATE TABLE {$hash}_revs
49 (
50 revision INT(20) UNSIGNED NOT NULL DEFAULT 0,
51 author VARCHAR(255) NOT NULL DEFAULT '',
52 dateline VARCHAR(100) NOT NULL DEFAULT '',
53 files MEDIUMTEXT NOT NULL DEFAULT '',
54 message MEDIUMTEXT NOT NULL DEFAULT '',
55 PRIMARY KEY (revision)
56 )"
57 );
58
59 $db->query("
60 CREATE TABLE {$hash}_nodes
61 (
62 name VARCHAR(255) NOT NULL DEFAULT '',
63 uuid VARCHAR(50) NOT NULL DEFAULT '',
64 delrevs MEDIUMTEXT NOT NULL DEFAULT '',
65 addrevs MEDIUMTEXT NOT NULL DEFAULT '',
66 revs MEDIUMTEXT NOT NULL DEFAULT '',
67 properties MEDIUMTEXT NOT NULL DEFAULT '',
68 PRIMARY KEY (name)
69 )"
70 );
71 }
72
73 $link = $viewsvn->paths->out('browse.php', $repos . '/');
74 eval('$nodes .= "' . $template->fetch('index_node') . '";');
75 }
76
77 // ###################################################################
78
79 eval('$template->flush("' . $template->fetch('index') . '");');
80
81 /*=====================================================================*\
82 || ###################################################################
83 || # $HeadURL$
84 || # $Id$
85 || ###################################################################
86 \*=====================================================================*/
87 ?>