1 files changed, 8 insertions, 4 deletions
diff --git a/tables.sql b/tables.sql
index a90c8a9..7cd7268 100644
--- a/tables.sql
+++ b/tables.sql
@@ -1,7 +1,11 @@
+set global innodb_large_prefix = ON;
+
 CREATE TABLE IF NOT EXISTS theme(
     id INTEGER PRIMARY KEY AUTO_INCREMENT,
-    main TEXT NOT NULL UNIQUE,
-    description TEXT NOT NULL UNIQUE,
+    main VARCHAR(255) NOT NULL,
+    description VARCHAR(255) NOT NULL,
     votes INTEGER DEFAULT FALSE,
-    hidden BOOLEAN DEFAULT FALSE
-);
+    hidden BOOLEAN DEFAULT FALSE,
+
+    UNIQUE KEY main (main, description)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;