diff options
| -rw-r--r-- | install.php | 5 | ||||
| -rw-r--r-- | install.sql | 12 |
2 files changed, 16 insertions, 1 deletions
diff --git a/install.php b/install.php index 42fbb15d..542762ae 100644 --- a/install.php +++ b/install.php @@ -1,7 +1,7 @@ <?php // Installation/upgrade file -define('VERSION', 'v0.9.6-dev-8 + <a href="https://github.com/vichan-devel/Tinyboard/">vichan-devel-4.0.1</a>'); +define('VERSION', 'v0.9.6-dev-8 + <a href="https://github.com/vichan-devel/Tinyboard/">vichan-devel-4.0.2</a>'); require 'inc/functions.php'; @@ -230,6 +230,9 @@ if (file_exists($config['has_installed'])) { case 'v0.9.6-dev-7': case 'v0.9.6-dev-7 + <a href="https://github.com/vichan-devel/Tinyboard/">vichan-devel-4.0-gold</a>': query("ALTER TABLE `bans` ADD `seen` BOOLEAN NOT NULL") or error(db_error()); + case 'v0.9.6-dev-8': + case 'v0.9.6-dev-8 + <a href="https://github.com/vichan-devel/Tinyboard/">vichan-devel-4.0.1</a>': + query("CREATE TABLE IF NOT EXISTS `search_queries` ( `ip` varchar(39) NOT NULL, `time` int(11) NOT NULL, `query` text NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;") or error(db_error()); case false: // Update version number file_write($config['has_installed'], VERSION); diff --git a/install.sql b/install.sql index 04896681..9c6a0acd 100644 --- a/install.sql +++ b/install.sql @@ -234,6 +234,18 @@ CREATE TABLE IF NOT EXISTS `robot` ( -- -------------------------------------------------------- -- +-- Table structure for table `search_queries` +-- + +CREATE TABLE IF NOT EXISTS `search_queries` ( + `ip` varchar(39) NOT NULL, + `time` int(11) NOT NULL, + `query` text NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- -- Table structure for table `theme_settings` -- |