From b57be65c9f7b9ae4d3259bd309a0f18479780d50 Mon Sep 17 00:00:00 2001 From: Savetheinternet Date: Mon, 5 Dec 2011 13:17:34 +1100 Subject: track cites (remove broken links after a post 404s) --- install.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'install.sql') 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 */; -- cgit v1.3