Package: kronolith
Version: 1.1.4-2
if using the standard kronolith.sql in
"/usr/share/doc/kronolith/examples/scripts/drivers/" with postgres
(7.4.7-6sarge1) no sequence table "kronolith_events_seq" will be created
(check /var/log/postgresql/postgres.log for errors) .
Therefore events will be saved, but not stored to database. These
lines (at the end of kronolith.sql) will help:
CREATE SEQUENCE kronolith_events_seq;
GRANT SELECT, INSERT, UPDATE, DELETE ON kronolith_events_seq TO horde;
This is a working kronolith.sql for postgres:
-------------------
-- $Horde: kronolith SQL table for postgresql, Schoppa 28.12.2005
<[EMAIL PROTECTED]>
CREATE TABLE kronolith_events (
event_id BIGINT DEFAULT 0 NOT NULL,
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;
CREATE SEQUENCE kronolith_events_seq;
GRANT SELECT, INSERT, UPDATE, DELETE ON kronolith_events_seq TO horde;
-------------------
--
Hobbes: What would you call the creation of the universe?
Calvin: The Horrendous Space Kablooie!
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
