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

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_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/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