[RCD] Postgres / SQLite Scripts for calendar plugin (new _reminders_ feature)

A.L.E.C alec at alec.pl
Tue Aug 30 08:11:13 CEST 2011


On 30.08.2011 07:54, Roland Liebl wrote:
> No one?

-- PostgreSQL:

CREATE SEQUENCE reminder_ids
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;

CREATE TABLE reminders (
    reminder_id integer DEFAULT nextval('reminder_ids') PRIMARY KEY,
    user_id integer NOT NULL
	REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE,
    events integer NOT NULL,
    cache integer NOT NULL,
    caldav integer NOT NULL,
    "type" text,
    props text,
    runtime integer NOT NULL
);

-- SQLite:

CREATE TABLE reminders (
    reminder_id integer NOT NULL PRIMARY KEY,
    user_id integer NOT NULL,
    events integer NOT NULL,
    cache integer NOT NULL,
    caldav integer NOT NULL,
    "type" text,
    props text,
    runtime integer NOT NULL
);

-- 
Aleksander 'A.L.E.C' Machniak
LAN Management System Developer [http://lms.org.pl]
Roundcube Webmail Developer  [http://roundcube.net]
---------------------------------------------------
PGP: 19359DC1 @@ GG: 2275252 @@ WWW: http://alec.pl
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80



More information about the Dev mailing list