diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-04 20:37:43 +1000 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-04 20:37:43 +1000 |
| commit | 41a0eae0bd1b70a15225c8ed95fa8c86115191c6 (patch) | |
| tree | e44d4c98844f9ee4df4abd0d17189839801522bc /src/odbc/mysql.sql | |
| parent | ODBC support for mod_irc (diff) | |
ODBC support for mod_shared_roster
Diffstat (limited to 'src/odbc/mysql.sql')
| -rw-r--r-- | src/odbc/mysql.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index e57b135ed..c2611b0d2 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -59,6 +59,21 @@ CREATE TABLE rostergroups ( CREATE INDEX pk_rosterg_user_jid ON rostergroups(username(75), jid(75)); +CREATE TABLE sr_group ( + name varchar(250) NOT NULL, + opts text NOT NULL, + created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP +) CHARACTER SET utf8; + +CREATE TABLE sr_user ( + jid varchar(250) NOT NULL, + grp varchar(250) NOT NULL, + created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP +) CHARACTER SET utf8; + +CREATE UNIQUE INDEX i_sr_user_jid_group ON sr_user(jid(75), grp(75)); +CREATE INDEX i_sr_user_jid ON sr_user(jid); +CREATE INDEX i_sr_user_grp ON sr_user(grp); CREATE TABLE spool ( username varchar(250) NOT NULL, |