From b3b566c907f3e48d0522fcd75c0a9ee9f988030c Mon Sep 17 00:00:00 2001
From: redmatrix <redmatrix@redmatrix.me>
Date: Sun, 16 Aug 2015 17:17:34 -0700
Subject: add DB support for tasks, todo items and repeating events

---
 install/schema_mysql.sql | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 4d0da366f..ef52bcbec 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -432,6 +432,10 @@ CREATE TABLE IF NOT EXISTS `event` (
   `allow_gid` mediumtext NOT NULL,
   `deny_cid` mediumtext NOT NULL,
   `deny_gid` mediumtext NOT NULL,
+  `event_status` char(255) NOT NULL DEFAULT '',
+  `event_status_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `event_percent` smallint(6) NOT NULL DEFAULT '0',
+  `event_repeat` text NOT NULL,
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
   KEY `type` (`type`),
@@ -442,7 +446,8 @@ CREATE TABLE IF NOT EXISTS `event` (
   KEY `ignore` (`ignore`),
   KEY `aid` (`aid`),
   KEY `event_hash` (`event_hash`),
-  KEY `event_xchan` (`event_xchan`)
+  KEY `event_xchan` (`event_xchan`),
+  KEY `event_status` (`event_status`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
-- 
cgit v1.2.3

