Page MenuHomePhorge
Files F6065415

mysql.initial.sql
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

mysql.initial.sql
View Options

/**
* Roundcube Tasklist plugin database
*
* @version @package_version@
* @author Thomas Bruederli
* @licence GNU AGPL
* @copyright (C) 2012, Kolab Systems AG
*/
CREATE TABLE `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 `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',
`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 */;
INSERT INTO `system` (`name`, `value`) VALUES ('tasklist-database-version', '2013011000');

File Metadata

Mime Type
text/plain
Expires
Fri, May 22, 4:36 AM (1 d, 12 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
746622
Default Alt Text
mysql.initial.sql (1 KB)

Event Timeline