diff options
Diffstat (limited to 'src/odbc/pg.sql')
| -rw-r--r-- | src/odbc/pg.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index 30ea19ca5..1abc84abf 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -245,6 +245,15 @@ CREATE TABLE muc_registered ( CREATE INDEX i_muc_registered_nick ON muc_registered USING btree (nick); CREATE UNIQUE INDEX i_muc_registered_jid_host ON muc_registered USING btree (jid, host); +CREATE TABLE irc_custom ( + jid text NOT NULL, + host text NOT NULL, + data text NOT NULL, + created_at TIMESTAMP NOT NULL DEFAULT now() +); + +CREATE UNIQUE INDEX i_irc_custom_jid_host ON irc_custom USING btree (jid, host); + CREATE TABLE motd ( username text PRIMARY KEY, xml text, |