diff options
| author | friendica <info@friendica.com> | 2014-01-30 20:10:47 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2014-01-30 20:10:47 -0800 |
| commit | a1d40431f22e82b8e018dce65ced0801c40b20ff (patch) | |
| tree | 1b9fa64a689ff56a932f82428cc8cd3a1d932303 /install/database.sql | |
| parent | 49f07bd90f7304e76c2b06d0a9616d680df6ab47 (diff) | |
| download | volse-hubzilla-a1d40431f22e82b8e018dce65ced0801c40b20ff.tar.gz volse-hubzilla-a1d40431f22e82b8e018dce65ced0801c40b20ff.tar.bz2 volse-hubzilla-a1d40431f22e82b8e018dce65ced0801c40b20ff.zip | |
chat expiration (default 2 hours) - but can be set on a per-chatroom basis
Diffstat (limited to 'install/database.sql')
| -rw-r--r-- | install/database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql index dba03da65..c89e4cef2 100644 --- a/install/database.sql +++ b/install/database.sql @@ -247,6 +247,7 @@ CREATE TABLE IF NOT EXISTS `chatroom` ( `cr_name` char(255) NOT NULL DEFAULT '', `cr_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `cr_edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `cr_expire` int(10) unsigned NOT NULL DEFAULT '0', `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, @@ -256,7 +257,8 @@ CREATE TABLE IF NOT EXISTS `chatroom` ( KEY `cr_uid` (`cr_uid`), KEY `cr_name` (`cr_name`), KEY `cr_created` (`cr_created`), - KEY `cr_edited` (`cr_edited`) + KEY `cr_edited` (`cr_edited`), + KEY `cr_expire` (`cr_expire`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `clients` ( |