diff options
author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2018-06-20 12:27:44 +0300 |
---|---|---|
committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2018-06-20 12:27:44 +0300 |
commit | 3a5d2dbed8f089b112eba7998e2ad0d2508f01cb (patch) | |
tree | fb2e9ab4348bcf691d673879e00dfcb17eea9dd0 /sql/pg.new.sql | |
parent | Omit summary form for push tests (diff) |
Move mod_irc to ejabberd-contrib
Diffstat (limited to 'sql/pg.new.sql')
-rw-r--r-- | sql/pg.new.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/sql/pg.new.sql b/sql/pg.new.sql index 82fafa64..928d74db 100644 --- a/sql/pg.new.sql +++ b/sql/pg.new.sql @@ -144,9 +144,6 @@ -- ALTER TABLE muc_online_users ADD COLUMN server_host text NOT NULL DEFAULT '<HOST>'; -- ALTER TABLE muc_online_users ALTER COLUMN server_host DROP DEFAULT; --- ALTER TABLE irc_custom ADD COLUMN server_host text NOT NULL DEFAULT '<HOST>'; --- ALTER TABLE irc_custom ALTER COLUMN server_host DROP DEFAULT; - -- ALTER TABLE motd ADD COLUMN server_host text NOT NULL DEFAULT '<HOST>'; -- ALTER TABLE motd DROP CONSTRAINT motd_pkey; -- ALTER TABLE motd ADD PRIMARY KEY (server_host, username); @@ -498,16 +495,6 @@ CREATE TABLE muc_room_subscribers ( CREATE INDEX i_muc_room_subscribers_host_jid ON muc_room_subscribers USING btree (host, jid); CREATE UNIQUE INDEX i_muc_room_subscribers_host_room_jid ON muc_room_subscribers USING btree (host, room, jid); -CREATE TABLE irc_custom ( - jid text NOT NULL, - host text NOT NULL, - server_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 NOT NULL, server_host text NOT NULL, |