PostgreSQL init script do not have caldav_calendars DDLs
#13
Comments
|
Ok, on second glimpse, it appears that |
|
We got this from a user (updated /**
* CalDAV Client
*
* @version @package_version@
* @author Hugo Slabbert <[email protected]>
*
* Copyright (C) 2014, Hugo Slabbert <[email protected]>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
CREATE TYPE caldav_type AS ENUM ('vcal','vevent','vtodo','');
CREATE SEQUENCE caldav_calendars_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
CREATE TABLE IF NOT EXISTS caldav_calendars (
calendar_id integer DEFAULT nextval('caldav_calendars_seq'::regclass) NOT NULL,
calendar_type caldav_type NOT NULL,
user_id integer NOT NULL
REFERENCES users (user_id) ON UPDATE CASCADE ON DELETE CASCADE,
name character varying(255) NOT NULL,
color character varying(8) NOT NULL,
showalarms smallint NOT NULL DEFAULT 1,
caldav_url character varying(255) NOT NULL,
caldav_tag character varying(255) DEFAULT NULL,
caldav_user character varying(255) DEFAULT NULL,
caldav_pass character varying(1024) DEFAULT NULL,
caldav_last_change timestamp without time zone DEFAULT now() NOT NULL,
PRIMARY KEY (calendar_id)
);
CREATE OR REPLACE FUNCTION upd_timestamp() RETURNS TRIGGER
LANGUAGE plpgsql
AS
$$
BEGIN
NEW.caldav_last_change = CURRENT_TIMESTAMP;
RETURN NEW;
END;
$$;
CREATE TRIGGER update_timestamp
BEFORE INSERT OR UPDATE
ON caldav_calendars
FOR EACH ROW
EXECUTE PROCEDURE upd_timestamp();
CREATE SEQUENCE caldav_events_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
CREATE TABLE IF NOT EXISTS caldav_events (
event_id integer DEFAULT nextval('caldav_events_seq'::regclass) NOT NULL,
calendar_id integer NOT NULL
REFERENCES caldav_calendars (calendar_id) ON UPDATE CASCADE ON DELETE CASCADE,
recurrence_id integer NOT NULL DEFAULT 0,
uid varchar(255) NOT NULL DEFAULT '',
instance varchar(16) NOT NULL DEFAULT '',
isexception smallint NOT NULL DEFAULT '0',
created timestamp without time zone DEFAULT now() NOT NULL,
changed timestamp without time zone DEFAULT now(),
sequence integer NOT NULL DEFAULT 0,
"start" timestamp without time zone DEFAULT now() NOT NULL,
"end" timestamp without time zone DEFAULT now() NOT NULL,
recurrence varchar(255) DEFAULT NULL,
title character varying(255) NOT NULL DEFAULT '',
description text NOT NULL DEFAULT '',
location character varying(255) NOT NULL DEFAULT '',
categories character varying(255) NOT NULL DEFAULT '',
url character varying(255) NOT NULL DEFAULT '',
all_day smallint NOT NULL DEFAULT 0,
free_busy smallint NOT NULL DEFAULT 0,
priority smallint NOT NULL DEFAULT 0,
sensitivity smallint NOT NULL DEFAULT 0,
status character varying(32) NOT NULL DEFAULT '',
alarms text DEFAULT NULL,
attendees text DEFAULT NULL,
notifyat timestamp without time zone DEFAULT NULL,
caldav_url character varying(255) NOT NULL,
caldav_tag character varying(255) DEFAULT NULL,
caldav_last_change timestamp without time zone DEFAULT now() NOT NULL,
PRIMARY KEY (event_id)
);
CREATE TRIGGER update_timestamp
BEFORE INSERT OR UPDATE
ON caldav_events
FOR EACH ROW
EXECUTE PROCEDURE upd_timestamp();
CREATE INDEX caldav_events_calendar_id_notifyat_idx ON caldav_events (calendar_id, notifyat);
CREATE INDEX caldav_events_uid_idx ON caldav_events (uid);
CREATE INDEX caldav_events_recurrence_id_idx ON caldav_events (recurrence_id);
CREATE SEQUENCE caldav_attachments_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
CREATE TABLE caldav_attachments (
attachment_id integer DEFAULT nextval('caldav_attachments_seq'::regclass) NOT NULL,
event_id integer NOT NULL
REFERENCES caldav_events (event_id) ON DELETE CASCADE ON UPDATE CASCADE,
filename character varying(255) NOT NULL DEFAULT '',
mimetype character varying(255) NOT NULL DEFAULT '',
size integer NOT NULL DEFAULT 0,
data text NOT NULL DEFAULT '',
PRIMARY KEY (attachment_id)
);
CREATE INDEX caldav_attachments_user_id_idx ON caldav_attachments (event_id);
INSERT INTO system (name, value) VALUES ('calendar-database-version', '2015022700');Does it work for you? |
|
Hi ya. So, did some testing and I got a bit further, but not quite to the end. The DB related errors disappear, but it looks like something in the code is missing (not sure if this is related though). This is the exception I get: This happens when I enable the default calendar (via Is there a way to enable debugging, so I can dive into it a bit more? |
|
Alright, I did a test install with MySQL and can confirm that the behaviour is the same. So the not working + button and the error when using a default caldav calendar are bugs non-related to this issue. So I think it is save to say that the SQL works :) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I ran into a weird issue while trying out the installation of this plugin (alongside carddav).
Roundcube's error log show me these lines whenever I try to add a calendar:
Doing a quick grep for this table reveals the issue, the MySQL init scripts to have, the PHP code references it, but Postgres has no idea of what we are talking about:
Looks like this needs to be copied over to PostgreSQL as well?
The text was updated successfully, but these errors were encountered: