-- PSQL Init for RC calender

CREATE SEQUENCE webmail_event_ids
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;

CREATE TABLE webmail_events (
    event_id integer DEFAULT nextval('webmail_event_ids'::regclass) NOT NULL,
    user_id integer NOT NULL,
    "start" timestamp without time zone DEFAULT now() NOT NULL,
    "end" timestamp without time zone DEFAULT now() NOT NULL,
    "summary" character varying(255) NOT NULL,
    "description" text NOT NULL,
    "location" character varying(255) NOT NULL,
    "categories" character varying(255) NOT NULL,
    "all_day" smallint NOT NULL DEFAULT 0
);

CREATE INDEX webmail_events_event_id_idx ON webmail_events USING btree (event_id);


--
-- Constraints Table `events`
--

ALTER TABLE ONLY webmail_events
    ADD CONSTRAINT webmail_events_user_id_fkey FOREIGN KEY (user_id) REFERENCES webmail_users(user_id) ON UPDATE CASCADE ON DELETE CASCADE;

$rcmail_config['use_calendar'] = 'calendar';
$rcmail_config['db_table_events'] = 'webmail_events';