rendered paste body---- PostgreSQL database dump--SET client_encoding = 'UNICODE';SET check_function_bodies = false;SET SESSION AUTHORIZATION 'postgres';---- TOC entry 4 (OID 2200)-- Name: public; Type: ACL; Schema: -; Owner: postgres--REVOKE ALL ON SCHEMA public FROM PUBLIC;GRANT ALL ON SCHEMA public TO PUBLIC;SET SESSION AUTHORIZATION 'tjfontaine';SET search_path = public, pg_catalog;---- TOC entry 8 (OID 92282)-- Name: channels; Type: TABLE; Schema: public; Owner: tjfontaine--CREATE TABLE channels ( chanid integer DEFAULT nextval('"channels_chanid_seq"'::text) 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);---- TOC entry 5 (OID 92292)-- Name: channels_chanid_seq; Type: SEQUENCE; Schema: public; Owner: tjfontaine--CREATE SEQUENCE channels_chanid_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1;---- TOC entry 9 (OID 92295)-- Name: irclog; Type: TABLE; Schema: public; Owner: tjfontaine--CREATE TABLE irclog ( msgid integer DEFAULT nextval('"irclog_msgid_seq"'::text) NOT NULL, chanid integer DEFAULT 0 NOT NULL, "timestamp" integer DEFAULT 0 NOT NULL, nick character varying(64) NOT NULL, msgtype integer DEFAULT 0 NOT NULL, message text NOT NULL);---- TOC entry 6 (OID 92311)-- Name: irclog_msgid_seq; Type: SEQUENCE; Schema: public; Owner: tjfontaine--CREATE SEQUENCE irclog_msgid_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1;---- TOC entry 10 (OID 92314)-- Name: nicks; Type: TABLE; Schema: public; Owner: tjfontaine--CREATE TABLE nicks ( chanid integer DEFAULT 0 NOT NULL, nick character varying(64) NOT NULL, lastseen timestamp without time zone NOT NULL, lastnotice timestamp without time zone NOT NULL, present integer DEFAULT 0 NOT NULL);---- TOC entry 11 (OID 92320)-- Name: plugins; Type: TABLE; Schema: public; Owner: tjfontaine--CREATE TABLE plugins ( "pluginName" character varying(64) NOT NULL, "libName" character varying(64) NOT NULL, preload integer NOT NULL, arguments character varying(255) NOT NULL);---- TOC entry 12 (OID 92324)-- Name: servers; Type: TABLE; Schema: public; Owner: tjfontaine--CREATE TABLE servers ( serverid integer DEFAULT nextval('"servers_serverid_seq"'::text) NOT NULL, server character varying(255) NOT NULL, port integer DEFAULT 6667 NOT NULL, nick character varying(64) NOT NULL, realname character varying(255) NOT NULL, nickserv character varying(64) NOT NULL, nickservmsg character varying(255) NOT NULL, username character varying(16) NOT NULL);---- TOC entry 7 (OID 92337)-- Name: servers_serverid_seq; Type: SEQUENCE; Schema: public; Owner: tjfontaine--CREATE SEQUENCE servers_serverid_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1;---- TOC entry 14 (OID 92291)-- Name: serverChan; Type: INDEX; Schema: public; Owner: tjfontaine--CREATE INDEX "serverChan" ON channels USING btree (serverid, channel);---- TOC entry 17 (OID 92305)-- Name: timeChan; Type: INDEX; Schema: public; Owner: tjfontaine--CREATE INDEX "timeChan" ON irclog USING btree ("timestamp", chanid);---- TOC entry 15 (OID 92306)-- Name: fulltext; Type: INDEX; Schema: public; Owner: tjfontaine--CREATE INDEX fulltext ON irclog USING btree (nick, message);---- TOC entry 20 (OID 92332)-- Name: serverNick; Type: INDEX; Schema: public; Owner: tjfontaine--CREATE INDEX "serverNick" ON servers USING btree (server, port, nick);---- TOC entry 13 (OID 92289)-- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: tjfontaine--ALTER TABLE ONLY channels ADD CONSTRAINT channels_pkey PRIMARY KEY (chanid);---- TOC entry 16 (OID 92303)-- Name: irclog_pkey; Type: CONSTRAINT; Schema: public; Owner: tjfontaine--ALTER TABLE ONLY irclog ADD CONSTRAINT irclog_pkey PRIMARY KEY (msgid);---- TOC entry 18 (OID 92318)-- Name: nicks_pkey; Type: CONSTRAINT; Schema: public; Owner: tjfontaine--ALTER TABLE ONLY nicks ADD CONSTRAINT nicks_pkey PRIMARY KEY (chanid, nick);---- TOC entry 19 (OID 92322)-- Name: plugins_pkey; Type: CONSTRAINT; Schema: public; Owner: tjfontaine--ALTER TABLE ONLY plugins ADD CONSTRAINT plugins_pkey PRIMARY KEY ("pluginName");---- TOC entry 21 (OID 92330)-- Name: servers_pkey; Type: CONSTRAINT; Schema: public; Owner: tjfontaine--ALTER TABLE ONLY servers ADD CONSTRAINT servers_pkey PRIMARY KEY (serverid);---- TOC entry 23 (OID 92307)-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: tjfontaine--ALTER TABLE ONLY irclog ADD CONSTRAINT "$1" FOREIGN KEY (chanid) REFERENCES channels(chanid) ON UPDATE CASCADE ON DELETE CASCADE;---- TOC entry 22 (OID 92333)-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: tjfontaine--ALTER TABLE ONLY channels ADD CONSTRAINT "$1" FOREIGN KEY (serverid) REFERENCES servers(serverid) ON UPDATE CASCADE ON DELETE CASCADE;SET SESSION AUTHORIZATION 'postgres';---- TOC entry 3 (OID 2200)-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres--COMMENT ON SCHEMA public IS 'Standard public schema';