diff options
| author | friendica <info@friendica.com> | 2012-06-25 20:55:27 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-06-25 20:55:27 -0700 |
| commit | fbaca4b74237c80c380d6ccf2bdddeec5ad4f013 (patch) | |
| tree | ca1ca05c84f8bd17acab9749b674d3b23fdcd2a5 /database.sql | |
| parent | 53f0aee82d61b7d61fb2271eb7f41cacc2eaf8f3 (diff) | |
| download | volse-hubzilla-fbaca4b74237c80c380d6ccf2bdddeec5ad4f013.tar.gz volse-hubzilla-fbaca4b74237c80c380d6ccf2bdddeec5ad4f013.tar.bz2 volse-hubzilla-fbaca4b74237c80c380d6ccf2bdddeec5ad4f013.zip | |
event summary/title
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 8178ffa86..b3b8c3a06 100644 --- a/database.sql +++ b/database.sql @@ -254,6 +254,7 @@ CREATE TABLE IF NOT EXISTS `event` ( `edited` datetime NOT NULL, `start` datetime NOT NULL, `finish` datetime NOT NULL, + `summary` text NOT NULL, `desc` text NOT NULL, `location` text NOT NULL, `type` char(255) NOT NULL, @@ -263,7 +264,14 @@ CREATE TABLE IF NOT EXISTS `event` ( `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `uid` ( `uid` ), + KEY `cid` ( `cid` ), + KEY `uri` ( `uri` ), + KEY `type` ( `type` ), + KEY `start` ( `start` ), + KEY `finish` ( `finish` ), + KEY `adjust` ( `adjust` ) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- |