diff options
author | 2018-02-22 14:54:43 +0300 | |
---|---|---|
committer | 2018-02-22 14:54:43 +0300 | |
commit | 023c0e62aeadf600f9d9ebffc6bb5392c8e387fd (patch) | |
tree | f63e9ff4cf9f499d1f7dcf1c72442a2b849de9df /juick-server-jdbc/src/main/java/com/juick/configuration | |
parent | 445efce2abf8310acc5b7bb652feef7968c86a2a (diff) |
h2: varchar_ignorecase for tag names
Diffstat (limited to 'juick-server-jdbc/src/main/java/com/juick/configuration')
-rw-r--r-- | juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java | 2 |
1 files changed, 1 insertions, 1 deletions
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)"); |