aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-08-18 17:10:40 -0700
committerredmatrix <redmatrix@redmatrix.me>2015-08-18 17:10:40 -0700
commit37d07a7d2a3808169b87c5033ef413ce957bf2ef (patch)
tree9ace4e8f13b6ae947dc6e9182009ab68c8dd5660 /install/schema_mysql.sql
parent75fbf21e6b423a91ff589d2fa349487623bc1a36 (diff)
downloadvolse-hubzilla-37d07a7d2a3808169b87c5033ef413ce957bf2ef.tar.gz
volse-hubzilla-37d07a7d2a3808169b87c5033ef413ce957bf2ef.tar.bz2
volse-hubzilla-37d07a7d2a3808169b87c5033ef413ce957bf2ef.zip
add event_sequence for vtodo's
Diffstat (limited to 'install/schema_mysql.sql')
-rw-r--r--install/schema_mysql.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index ef52bcbec..3e0e88535 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -436,6 +436,7 @@ CREATE TABLE IF NOT EXISTS `event` (
`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,
+ `event_sequence` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `type` (`type`),
@@ -447,7 +448,8 @@ CREATE TABLE IF NOT EXISTS `event` (
KEY `aid` (`aid`),
KEY `event_hash` (`event_hash`),
KEY `event_xchan` (`event_xchan`),
- KEY `event_status` (`event_status`)
+ KEY `event_status` (`event_status`),
+ KEY `event_sequence` (`event_sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------