aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2014-02-25 19:48:13 -0800
committerfriendica <info@friendica.com>2014-02-25 19:48:13 -0800
commite7e97e578b3069b8d24ea2a18ce4d3648b402ca3 (patch)
treea2fce103f82322b6680b6ac7207ca080c53f29cb /install/database.sql
parent2c72e49d1f63404b464f284d86ce2dce7f2eb493 (diff)
downloadvolse-hubzilla-e7e97e578b3069b8d24ea2a18ce4d3648b402ca3.tar.gz
volse-hubzilla-e7e97e578b3069b8d24ea2a18ce4d3648b402ca3.tar.bz2
volse-hubzilla-e7e97e578b3069b8d24ea2a18ce4d3648b402ca3.zip
put bookmarked chatrooms into poco
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index 5d00afb03..2c8bc50c7 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -1032,10 +1032,12 @@ CREATE TABLE IF NOT EXISTS `xchat` (
`xchat_url` char(255) NOT NULL DEFAULT '',
`xchat_desc` char(255) NOT NULL DEFAULT '',
`xchat_xchan` char(255) NOT NULL DEFAULT '',
+ `xchat_edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
PRIMARY KEY (`xchat_id`),
KEY `xchat_url` (`xchat_url`),
KEY `xchat_desc` (`xchat_desc`),
- KEY `xchat_xchan` (`xchat_xchan`)
+ KEY `xchat_xchan` (`xchat_xchan`),
+ KEY `xchat_edited` (`xchat_edited`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `xconfig` (