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 );