diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-03 20:23:41 +1000 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2012-04-03 20:23:41 +1000 |
| commit | 5fab00011eeed532ac5c7a9c64c03b72f56c40d6 (patch) | |
| tree | d58975a959db8542d51f787246e99a91abbed3d3 /src/odbc/pg.sql | |
| parent | ODBC support for mod_vcard_xupdate (diff) | |
ODBC support for mod_irc
Diffstat (limited to '')
| -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, |