From b51fc38783c1b93f1667ea4fb41a077de66dad49 Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Sun, 1 Sep 2013 02:04:42 +1000
Subject: Some SQL and indexes improvements

---
 templates/posts.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'templates')

diff --git a/templates/posts.sql b/templates/posts.sql
index e41a7f38..0b0e32b9 100644
--- a/templates/posts.sql
+++ b/templates/posts.sql
@@ -27,8 +27,8 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` (
    `embed` text,
    UNIQUE KEY `id` (`id`),
    KEY `thread_id` (`thread`,`id`),
+   KEY `filehash` (`filehash`),
    KEY `time` (`time`),
-   FULLTEXT KEY `body` (`body`),
    KEY `ip` (`ip`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
  
\ No newline at end of file
-- 
cgit v1.3


From cf3173d226271c59eab1fe841baec6ec309771f3 Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Sun, 1 Sep 2013 09:57:09 +1000
Subject: Fix issue #136

---
 templates/posts.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'templates')

diff --git a/templates/posts.sql b/templates/posts.sql
index 0b0e32b9..b35865ca 100644
--- a/templates/posts.sql
+++ b/templates/posts.sql
@@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` (
    `embed` text,
    UNIQUE KEY `id` (`id`),
    KEY `thread_id` (`thread`,`id`),
-   KEY `filehash` (`filehash`),
+   KEY `filehash` (`filehash`(40)),
    KEY `time` (`time`),
    KEY `ip` (`ip`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
-- 
cgit v1.3


From 22fcca343f8d4e820745a673972286b47a6a17ba Mon Sep 17 00:00:00 2001
From: Michael Foster <savetheinternet@tinyboard.org>
Date: Sun, 1 Sep 2013 22:15:03 +1000
Subject: New index in post tables for listing threads slightly faster (index
 pages)

---
 install.php         | 7 ++++++-
 templates/posts.sql | 3 ++-
 2 files changed, 8 insertions(+), 2 deletions(-)

(limited to 'templates')

diff --git a/install.php b/install.php
index 967af7de..d60e5aab 100644
--- a/install.php
+++ b/install.php
@@ -1,7 +1,7 @@
 <?php
 
 // Installation/upgrade file	
-define('VERSION', 'v0.9.6-dev-15');
+define('VERSION', 'v0.9.6-dev-16');
 
 require 'inc/functions.php';
 
@@ -381,6 +381,11 @@ if (file_exists($config['has_installed'])) {
 			query("ALTER TABLE ``bans`` ADD INDEX `ip` (`ip`)") or error(db_error());
 			query("ALTER TABLE ``noticeboard`` ADD INDEX `time` (`time`)") or error(db_error());
 			query("ALTER TABLE ``pms`` ADD INDEX `to` (`to`, `unread`)") or error(db_error());
+		case 'v0.9.6-dev-15':
+			foreach ($boards as &$board) {
+				query(sprintf("ALTER TABLE  ``posts_%s``
+					ADD INDEX `list_threads` (`thread`, `sticky`, `bump`)", $board['uri'])) or error(db_error());
+			}
 		case false:
 			// Update version number
 			file_write($config['has_installed'], VERSION);
diff --git a/templates/posts.sql b/templates/posts.sql
index b35865ca..c1f491f2 100644
--- a/templates/posts.sql
+++ b/templates/posts.sql
@@ -29,6 +29,7 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` (
    KEY `thread_id` (`thread`,`id`),
    KEY `filehash` (`filehash`(40)),
    KEY `time` (`time`),
-   KEY `ip` (`ip`)
+   KEY `ip` (`ip`),
+   KEY `list_threads` (`thread`, `sticky`, `bump`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
  
\ No newline at end of file
-- 
cgit v1.3