--
-- PostgreSQL database dump
--

\connect - ismailuser

SET search_path = public, pg_catalog;

--
-- TOC entry 2 (OID 43468)
-- Name: users; Type: TABLE; Schema: public; Owner: ismailuser
--

CREATE TABLE users (
    id serial NOT NULL,
    username character varying(128) NOT NULL
);


--
-- TOC entry 3 (OID 43488)
-- Name: settings; Type: TABLE; Schema: public; Owner: ismailuser
--

CREATE TABLE settings (
    id serial NOT NULL,
    userid integer NOT NULL,
    setting character varying(32) DEFAULT '' NOT NULL,
    value character varying(32) DEFAULT '' NOT NULL
);


--
-- TOC entry 4 (OID 43534)
-- Name: identities; Type: TABLE; Schema: public; Owner: ismailuser
--

CREATE TABLE identities (
    id serial NOT NULL,
    userid integer NOT NULL,
    name character varying(64) DEFAULT '' NOT NULL,
    isdefault boolean DEFAULT 'f' NOT NULL,
    displayname character varying(128) DEFAULT '' NOT NULL,
    fromaddress character varying(128) DEFAULT '' NOT NULL,
    replyto character varying(128) DEFAULT '' NOT NULL,
    organization character varying(128) DEFAULT '' NOT NULL,
    signature text DEFAULT '' NOT NULL
);


--
-- TOC entry 5 (OID 43595)
-- Name: emails; Type: TABLE; Schema: public; Owner: ismailuser
--

CREATE TABLE emails (
    id serial NOT NULL,
    entryid integer NOT NULL,
    email character varying(128) NOT NULL,
    isdefault boolean DEFAULT 'f' NOT NULL
);


--
-- TOC entry 6 (OID 43608)
-- Name: entries; Type: TABLE; Schema: public; Owner: ismailuser
--

CREATE TABLE entries (
    id serial NOT NULL,
    userid integer NOT NULL,
    first character varying(32) DEFAULT '' NOT NULL,
    middle character varying(32) DEFAULT '' NOT NULL,
    last character varying(32) DEFAULT '' NOT NULL,
    nickname character varying(64) DEFAULT '' NOT NULL
);


--
-- TOC entry 7 (OID 43508)
-- Name: users_id_pkay; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_id_pkay PRIMARY KEY (id);


--
-- TOC entry 8 (OID 43514)
-- Name: settings_id_pkay; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY settings
    ADD CONSTRAINT settings_id_pkay PRIMARY KEY (id);


--
-- TOC entry 12 (OID 43528)
-- Name: settings_userid; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY settings
    ADD CONSTRAINT settings_userid FOREIGN KEY (userid) REFERENCES users(id) ON UPDATE NO ACTION ON DELETE CASCADE;


--
-- TOC entry 9 (OID 43546)
-- Name: identities_id_pkey; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY identities
    ADD CONSTRAINT identities_id_pkey PRIMARY KEY (id);


--
-- TOC entry 13 (OID 43548)
-- Name: identities_userid_fkey; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY identities
    ADD CONSTRAINT identities_userid_fkey FOREIGN KEY (userid) REFERENCES users(id) ON UPDATE NO ACTION ON DELETE CASCADE;


--
-- TOC entry 11 (OID 43617)
-- Name: entries_id_pkey; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY entries
    ADD CONSTRAINT entries_id_pkey PRIMARY KEY (id);


--
-- TOC entry 10 (OID 43619)
-- Name: emails_id_pkey; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY emails
    ADD CONSTRAINT emails_id_pkey PRIMARY KEY (id);


--
-- TOC entry 15 (OID 43621)
-- Name: entries_userid_fkey; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY entries
    ADD CONSTRAINT entries_userid_fkey FOREIGN KEY (userid) REFERENCES users(id) ON UPDATE NO ACTION ON DELETE CASCADE;


--
-- TOC entry 14 (OID 43625)
-- Name: emails_userid_fkey; Type: CONSTRAINT; Schema: public; Owner: ismailuser
--

ALTER TABLE ONLY emails
    ADD CONSTRAINT emails_userid_fkey FOREIGN KEY (entryid) REFERENCES entries(id) ON UPDATE NO ACTION ON DELETE CASCADE;