From b5e9beaa31e9d2a7f54909a1467eda7171ed3229 Mon Sep 17 00:00:00 2001 From: raylu Date: Sun, 20 Oct 2013 03:34:03 -0700 Subject: fix collation for search and importer api-only also, importer whitespace --- db/schema.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'db/schema.sql') diff --git a/db/schema.sql b/db/schema.sql index 7c601ce..3c632a9 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -10,7 +10,7 @@ CREATE TABLE `kills` ( `kill_time` datetime NOT NULL, `moon_id` int unsigned NOT NULL, PRIMARY KEY (`kill_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; CREATE TABLE `characters` ( `id` int unsigned NOT NULL AUTO_INCREMENT, @@ -31,7 +31,7 @@ CREATE TABLE `characters` ( `weapon_type_id` int DEFAULT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_char_km` FOREIGN KEY (`kill_id`) REFERENCES `kills` (`kill_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; CREATE TABLE `items` ( `id` int unsigned NOT NULL AUTO_INCREMENT, @@ -43,17 +43,17 @@ CREATE TABLE `items` ( `singleton` tinyint(4) NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `fk_item_km` FOREIGN KEY (`kill_id`) REFERENCES `kills` (`kill_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; CREATE TABLE `item_costs` ( `type_id` int NOT NULL UNIQUE, `cost` bigint unsigned NOT NULL, PRIMARY KEY (`type_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; CREATE TABLE `kill_costs` ( `kill_id` int unsigned NOT NULL UNIQUE, `cost` bigint unsigned NOT NULL, PRIMARY KEY (`kill_id`), CONSTRAINT `fk_kill_cost_km` FOREIGN KEY (`kill_id`) REFERENCES `kills` (`kill_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; -- cgit v1.2.3