diff options
Diffstat (limited to 'install')
| -rw-r--r-- | install/database.sql | 4 | ||||
| -rw-r--r-- | install/update.php | 11 |
2 files changed, 13 insertions, 2 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` ( diff --git a/install/update.php b/install/update.php index 180b8d5a0..e8b6d37f6 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1094 ); +define( 'UPDATE_VERSION' , 1095 ); /** * @@ -1060,3 +1060,12 @@ function update_r1093() { return UPDATE_SUCCESS; return UPDATE_FAILED; } + +function update_r1094() { + $r = q("ALTER TABLE `chatroom` ADD `cr_expire` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `cr_edited` , +ADD INDEX ( `cr_expire` )"); + if($r) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +} + |