CREATE TABLE channels (
    chanid integer NOT NULL,
    serverid integer DEFAULT 0 NOT NULL,
    channel character varying(64) NOT NULL,
    url text NOT NULL,
    notifywindow integer DEFAULT 24 NOT NULL,
    "cmdChar" character(1) NOT NULL
);

CREATE INDEX "serverChan" ON channels USING btree (serverid, channel);

ALTER TABLE ONLY channels
    ADD CONSTRAINT channels_pkey PRIMARY KEY (chanid);