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