mod_caps.sql « mysql « sql - github.com/processone/ejabberd.git - Unnamed repository; edit this file 'description' to name the repository.

Welcome to mirror list, hosted at ThFree Co, Russian Federation.

mod_caps.sql « mysql « sql - github.com/processone/ejabberd.git - Unnamed repository; edit this file 'description' to name the repository.

summary refs log tree commit diff

path: root/sql/mysql/mod_caps.sql

blob: 63d9dde2fe56ee0fef9d47b67dab8481a31a3af3 (plain)

CREATE TABLE caps_features (
    node varchar(191) NOT NULL,
    subnode varchar(191) NOT NULL,
    feature text,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE INDEX i_caps_features_node_subnode ON caps_features(node(75), subnode(75));