Hi,
I'm implementing _reminders_ into my calendar plugin.
I'd like to ask if someone could please help to convert to following MySQL-Script for Postgres and/or SQLite.
Thanks in advance!
Regards, R.
CREATE TABLE reminders (
reminder_id int(10) unsigned NOT NULL AUTO_INCREMENT,
user_id int(10) unsigned NOT NULL,
events int(10) unsigned NOT NULL,
cache int(10) unsigned NOT NULL,
caldav int(10) unsigned NOT NULL,
type text,
props text,
runtime int(11) NOT NULL,
PRIMARY KEY (reminder_id),
CONSTRAINT reminders_ibfk_1 FOREIGN KEY (user_id)
REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
List info: http://lists.roundcube.net/dev/ BT/aba52c80
No one?
Am 28.08.2011 21:19, schrieb Roland Liebl:
Hi,
I'm implementing _reminders_ into my calendar plugin.
I'd like to ask if someone could please help to convert to following MySQL-Script for Postgres and/or SQLite.
Thanks in advance!
Regards, R.
CREATE TABLE
reminders(reminder_idint(10) unsigned NOT NULL AUTO_INCREMENT,user_idint(10) unsigned NOT NULL,eventsint(10) unsigned NOT NULL,cacheint(10) unsigned NOT NULL,caldavint(10) unsigned NOT NULL,typetext,propstext,runtimeint(11) NOT NULL, PRIMARY KEY (reminder_id), CONSTRAINTreminders_ibfk_1FOREIGN KEY (user_id) REFERENCESusers(user_id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
List info: http://lists.roundcube.net/dev/ BT/8d1870bd
--- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/Hb/UVTwTr9d/vcard.vcf Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< ---
List info: http://lists.roundcube.net/dev/ BT/aba52c80
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 );
On Tue, 30 Aug 2011 07:54:57 +0200, Roland Liebl wrote:
No one?
http://devlabs.linuxassist.net/projects/policyd/repository/revisions/25089d6...
List info: http://lists.roundcube.net/dev/ BT/aba52c80
-
A.L.E.C -
Benny Pedersen -
Roland Liebl