track cites (remove broken links after a post 404s)

1 files changed, 16 insertions, 0 deletions

diff --git a/install.sql b/install.sql
index 1d032114..de6cc0c8 100644
--- a/install.sql
+++ b/install.sql
@@ -188,6 +188,7 @@ CREATE TABLE IF NOT EXISTS `posts_b` (
   `trip` varchar(15) DEFAULT NULL,
   `capcode` varchar(50) DEFAULT NULL,
   `body` text NOT NULL,
+  `body_nomarkup` text DEFAULT NULL,
   `time` int(11) NOT NULL,
   `bump` int(11) DEFAULT NULL,
   `thumb` varchar(50) DEFAULT NULL,
@@ -251,6 +252,21 @@ CREATE TABLE IF NOT EXISTS `theme_settings` (
   KEY `theme` (`theme`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `cites`
+--
+
+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;
+
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;