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

Sun, 28 Aug 2011 12:20:52 -0700 

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/8f4f07cd

Reply via email to