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