Server IP : 23.254.227.96 / Your IP : 216.73.216.120 Web Server : Apache/2.4.62 (Unix) OpenSSL/1.1.1k System : Linux hwsrv-1277026.hostwindsdns.com 4.18.0-477.13.1.el8_8.x86_64 #1 SMP Tue May 30 14:53:41 EDT 2023 x86_64 User : viralblo ( 1001) PHP Version : 8.1.31 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /usr/local/cwpsrv/var/services/roundcube/plugins/tasklist/drivers/database/SQL/ |
Upload File : |
/** * Roundcube Tasklist plugin database * * @version @package_version@ * @author Thomas Bruederli * @licence GNU AGPL * @copyright (C) 2012, Kolab Systems AG */ CREATE TABLE IF NOT EXISTS `tasklists` ( `tasklist_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `name` varchar(255) NOT NULL, `color` varchar(8) NOT NULL, `showalarms` tinyint(2) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`tasklist_id`), KEY `user_id` (`user_id`), CONSTRAINT `fk_tasklist_user_id` FOREIGN KEY (`user_id`) REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE ) /*!40000 ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci */; CREATE TABLE IF NOT EXISTS `tasks` ( `task_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tasklist_id` int(10) unsigned NOT NULL, `parent_id` int(10) unsigned DEFAULT NULL, `uid` varchar(255) NOT NULL, `created` datetime NOT NULL, `changed` datetime NOT NULL, `del` tinyint(1) unsigned NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL, `description` text, `tags` text, `date` varchar(10) DEFAULT NULL, `time` varchar(5) DEFAULT NULL, `startdate` varchar(10) DEFAULT NULL, `starttime` varchar(5) DEFAULT NULL, `flagged` tinyint(4) NOT NULL DEFAULT '0', `complete` float NOT NULL DEFAULT '0', `status` enum('','NEEDS-ACTION','IN-PROCESS','COMPLETED','CANCELLED') NOT NULL DEFAULT '', `alarms` varchar(255) DEFAULT NULL, `recurrence` varchar(255) DEFAULT NULL, `organizer` varchar(255) DEFAULT NULL, `attendees` text, `notify` datetime DEFAULT NULL, PRIMARY KEY (`task_id`), KEY `tasklisting` (`tasklist_id`,`del`,`date`), KEY `uid` (`uid`), CONSTRAINT `fk_tasks_tasklist_id` FOREIGN KEY (`tasklist_id`) REFERENCES `tasklists`(`tasklist_id`) ON DELETE CASCADE ON UPDATE CASCADE ) /*!40000 ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci */; REPLACE INTO `system` (`name`, `value`) VALUES ('tasklist-database-version', '2014051900');