Skip site navigation (1)Skip section navigation (2) 
Date:      Wed, 14 Jan 2004 13:00:22 +0100
From:      Fritz Heinrichmeyer <Fritz.Heinrichmeyer@Fernuni-Hagen.de>
To:        thierry@pompo.net
Cc:        bjn@horde.org
Subject:   kronolith also works with newest stable pgsql under freebsd after applying the following kronolith.pgsql
Message-ID:  <1074081622.92960.15.camel@jfh00.fernuni-hagen.de>
next in thread | raw e-mail | index | archive | help 
drop table kronolith_events;
drop sequence kronolith_events_seq;
create sequence kronolith_events_seq;


CREATE TABLE kronolith_events (
    event_id bigint 
      not null default nextval('public.kronolith_events_seq'::text),
    calendar_id VARCHAR(255) NOT NULL,
    event_description TEXT,
    event_location TEXT,
    event_keywords TEXT,
    event_exceptions TEXT,
    event_title VARCHAR(80),
    event_category VARCHAR(80),
    event_recurtype VARCHAR(11) DEFAULT '0',
    event_recurinterval VARCHAR(11),
    event_recurdays VARCHAR(11),
    event_recurenddate timestamp,
    event_start timestamp,
    event_end timestamp,
    event_alarm INT DEFAULT 0,
    event_modified INT NOT NULL,

    PRIMARY KEY (event_id)
);

CREATE INDEX kronolith_calendar_idx ON kronolith_events (calendar_id);

GRANT SELECT, INSERT, UPDATE, DELETE ON kronolith_events TO horde;

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1074081622.92960.15.camel>