summaryrefslogtreecommitdiff
path: root/src/odbc/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/odbc/mysql.sql')
-rw-r--r--src/odbc/mysql.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql
index 17c7d9b7..97623011 100644
--- a/src/odbc/mysql.sql
+++ b/src/odbc/mysql.sql
@@ -273,3 +273,12 @@ CREATE TABLE motd (
xml text,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) CHARACTER SET utf8;
+
+CREATE TABLE caps_features (
+ node varchar(250) NOT NULL,
+ subnode varchar(250) NOT NULL,
+ feature text,
+ created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+) CHARACTER SET utf8;
+
+CREATE INDEX i_caps_features_node_subnode ON caps_features(node(75), subnode(75));