From owner-freebsd-ports@FreeBSD.ORG  Wed Jan 14 04:00:37 2004
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id DF9E116A4CE
	for <ports@freebsd.org>; Wed, 14 Jan 2004 04:00:37 -0800 (PST)
Received: from oak.FernUni-Hagen.de (oak.fernuni-hagen.de [132.176.114.41])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 70BA443D68
	for <ports@freebsd.org>; Wed, 14 Jan 2004 04:00:33 -0800 (PST)
	(envelope-from jfh@es-i2.FernUni-Hagen.de)
Received: from amavis by oak.FernUni-Hagen.de with scanned-ok (Exim 4.04)
	id 1AgjhI-00038h-00; Wed, 14 Jan 2004 13:00:32 +0100
Received: from es-i2.fernuni-hagen.de ([132.176.7.81])
	by oak.FernUni-Hagen.de with esmtp (Exim 4.04)
	id 1Agjh8-000386-00; Wed, 14 Jan 2004 13:00:22 +0100
Received: from [132.176.7.6] (jfh00.fernuni-hagen.de [132.176.7.6])
	by es-i2.fernuni-hagen.de (Postfix) with ESMTP
	id B977D55A4; Wed, 14 Jan 2004 13:00:21 +0100 (CET)
From: Fritz Heinrichmeyer <Fritz.Heinrichmeyer@Fernuni-Hagen.de>
To: thierry@pompo.net
Content-Type: text/plain
Message-Id: <1074081622.92960.15.camel@jfh00.fernuni-hagen.de>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Wed, 14 Jan 2004 13:00:22 +0100
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS perl-11
cc: ports@freebsd.org
cc: jan@horde.org
cc: bjn@horde.org
Subject: kronolith also works with newest stable pgsql under freebsd after
	applying the following kronolith.pgsql
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 14 Jan 2004 12:00:38 -0000

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;