aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-12-29 03:02:22 -0800
committerfriendica <info@friendica.com>2012-12-29 03:02:22 -0800
commit39c30d161f2d576252399a92620bfdc9a2f8a9f6 (patch)
tree4b0f3d004d4adaa4a937692be598ee4d5c1b6f32 /install
parent098de66c2fcda2e6e2449640e888a0d1f9e5aa84 (diff)
downloadvolse-hubzilla-39c30d161f2d576252399a92620bfdc9a2f8a9f6.tar.gz
volse-hubzilla-39c30d161f2d576252399a92620bfdc9a2f8a9f6.tar.bz2
volse-hubzilla-39c30d161f2d576252399a92620bfdc9a2f8a9f6.zip
add item expires field
Diffstat (limited to 'install')
-rw-r--r--install/database.sql2
-rw-r--r--install/update.php11
2 files changed, 12 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index 02bbb5f0f..cab10005e 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -432,6 +432,7 @@ CREATE TABLE IF NOT EXISTS `item` (
`thr_parent` char(255) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
@@ -484,6 +485,7 @@ CREATE TABLE IF NOT EXISTS `item` (
KEY `verb` (`verb`),
KEY `item_private` (`item_private`),
KEY `llink` (`llink`),
+ KEY `expires` (`expires`),
FULLTEXT KEY `title` (`title`),
FULLTEXT KEY `body` (`body`),
FULLTEXT KEY `allow_cid` (`allow_cid`),
diff --git a/install/update.php b/install/update.php
index e8f52273e..3b75f0e5f 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1011 );
+define( 'UPDATE_VERSION' , 1012 );
/**
*
@@ -180,3 +180,12 @@ ADD INDEX ( `abook_dob` )");
return UPDATE_FAILED;
}
+function update_r1011() {
+ $r = q("ALTER TABLE `item` ADD `expires` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `edited` ,
+ADD INDEX ( `expires` )");
+
+ if($r)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+}
+