From 023c0e62aeadf600f9d9ebffc6bb5392c8e387fd Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Thu, 22 Feb 2018 14:54:43 +0300
Subject: h2: varchar_ignorecase for tag names

---
 .../src/main/java/com/juick/configuration/DataConfiguration.java        | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'juick-server-jdbc/src/main')

diff --git a/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java b/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
index 03009565..f5ed724a 100644
--- a/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
+++ b/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
@@ -139,7 +139,7 @@ public class DataConfiguration implements TransactionManagementConfigurer {
             jdbcTemplate.execute("CREATE TABLE IF NOT EXISTS tags(" +
                     "tag_id int(10) unsigned NOT NULL AUTO_INCREMENT," +
                     "synonym_id int(10) unsigned DEFAULT NULL," +
-                    "name char(48) NOT NULL," +
+                    "name varchar_ignorecase(48) NOT NULL," +
                     "top tinyint(1) unsigned NOT NULL DEFAULT 0," +
                     "stat_messages int(10) unsigned NOT NULL DEFAULT 0," +
                     "stat_users  smallint(5) unsigned NOT NULL DEFAULT 0)");
-- 
cgit v1.2.3