[kronolith] Fwd: kronolith also works with newest stable pgsql under freebsd after applying the following kronolith.pgsql

[Jan Schneider]

----- Weitergeleitete Nachricht von Fritz.Heinrichmeyer at Fernuni-Hagen.de
-----
    Datum: Wed, 14 Jan 2004 13:00:22 +0100
    Von: Fritz Heinrichmeyer <Fritz.Heinrichmeyer at Fernuni-Hagen.de>
Antwort an: Fritz Heinrichmeyer <Fritz.Heinrichmeyer at Fernuni-Hagen.de>
 Betreff: kronolith also works with newest stable pgsql under freebsd after
applying the following kronolith.pgsql
      An: thierry at pompo.net

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;




----- Ende der weitergeleiteten Nachricht -----


Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - Neue Wege des Lernens
http://www.tip4all.de - Deine private Tippgemeinschaft