From b57be65c9f7b9ae4d3259bd309a0f18479780d50 Mon Sep 17 00:00:00 2001
From: Savetheinternet <savetheinternet@tinyboard.org>
Date: Mon, 5 Dec 2011 13:17:34 +1100
Subject: track cites (remove broken links after a post 404s)

---
 install.php | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

(limited to 'install.php')

diff --git a/install.php b/install.php
index f68f1575..50c80301 100644
--- a/install.php
+++ b/install.php
@@ -1,6 +1,6 @@
 <?php
 	// Installation/upgrade file	
-	define('VERSION', 'v0.9.5-dev-1');
+	define('VERSION', 'v0.9.5-dev-2');
 	
 	require 'inc/functions.php';
 	require 'inc/display.php';
@@ -159,8 +159,11 @@
 						CHANGE  `email`  `email` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
 						CHANGE  `name`  `name` VARCHAR( 35 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL", $board['uri'])) or error(db_error());
 				}
-				
-				
+			case 'v0.9.5-dev-1':
+				foreach($boards as &$board) {
+					query(sprintf("ALTER TABLE  `posts_%s` ADD  `body_nomarkup` TEXT NULL AFTER  `body`", $board['uri'])) or error(db_error());
+				}
+				query("CREATE TABLE IF NOT EXISTS `cites` (  `board` varchar(8) NOT NULL,  `post` int(11) NOT NULL,  `target_board` varchar(8) NOT NULL,  `target` int(11) NOT NULL,  KEY `target` (`target_board`,`target`),  KEY `post` (`board`,`post`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;") or error(db_error());
 			case false:
 				// Update version number
 				file_write($config['has_installed'], VERSION);
-- 
cgit v1.3