summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMichael Foster <savetheinternet@tinyboard.org>2013-09-06 23:10:25 +1000
committerMichael Foster <savetheinternet@tinyboard.org>2013-09-06 23:10:25 +1000
commit33737fd7233ed4b7d99a5f8a783f9c5da0338f8c (patch)
tree3e060f18d3a098436285120f1a5d7d51381d6275
parentf309e4037c11197e4392e402992882358e4678c7 (diff)
CHARACTER SET not needed here
-rw-r--r--install.php2
-rw-r--r--install.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/install.php b/install.php
index 0011a274..45244b90 100644
--- a/install.php
+++ b/install.php
@@ -395,7 +395,7 @@ if (file_exists($config['has_installed'])) {
case 'v0.9.6-dev-18':
query("CREATE TABLE IF NOT EXISTS ``flood`` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `ip` varchar(39) CHARACTER SET ascii NOT NULL,
+ `ip` varchar(39) NOT NULL,
`board` varchar(58) CHARACTER SET utf8 NOT NULL,
`time` int(11) NOT NULL,
`posthash` char(32) NOT NULL,
diff --git a/install.sql b/install.sql
index 3c8cc886..25c0a0f1 100644
--- a/install.sql
+++ b/install.sql
@@ -253,7 +253,7 @@ CREATE TABLE IF NOT EXISTS `theme_settings` (
CREATE TABLE IF NOT EXISTS `flood` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `ip` varchar(39) CHARACTER SET ascii NOT NULL,
+ `ip` varchar(39) NOT NULL,
`board` varchar(58) CHARACTER SET utf8 NOT NULL,
`time` int(11) NOT NULL,
`posthash` char(32) NOT NULL,