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

Roland Liebl roland at roland-liebl.de
Tue Aug 30 07:54:57 CEST 2011


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

-------------- next part --------------
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80


More information about the Dev mailing list