aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-08-21 17:15:56 -0700
committerfriendica <info@friendica.com>2013-08-21 17:15:56 -0700
commit2d3a489f5171a8fe8b6b7aeb022c945a689d9f1a (patch)
treeaef39fd3b1a1c4cf51561b8a2e67cf5b253e4842 /install
parentd8ef1417fb2ff8d736e4392c118c51c63dc66b1d (diff)
downloadvolse-hubzilla-2d3a489f5171a8fe8b6b7aeb022c945a689d9f1a.tar.gz
volse-hubzilla-2d3a489f5171a8fe8b6b7aeb022c945a689d9f1a.tar.bz2
volse-hubzilla-2d3a489f5171a8fe8b6b7aeb022c945a689d9f1a.zip
basic structure for premium channel implementation
Diffstat (limited to 'install')
-rw-r--r--install/database.sql4
-rw-r--r--install/update.php10
2 files changed, 13 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index cefb081d1..dbffbf59b 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -926,6 +926,8 @@ CREATE TABLE IF NOT EXISTS `xchan` (
`xchan_addr` char(255) NOT NULL DEFAULT '',
`xchan_url` char(255) NOT NULL DEFAULT '',
`xchan_connurl` char(255) NOT NULL DEFAULT '',
+ `xchan_follow` char(255) NOT NULL DEFAULT '',
+ `xchan_connpage` char(255) NOT NULL DEFAULT '',
`xchan_name` char(255) NOT NULL DEFAULT '',
`xchan_network` char(255) NOT NULL DEFAULT '',
`xchan_instance_url` char(255) NOT NULL DEFAULT '',
@@ -940,6 +942,8 @@ CREATE TABLE IF NOT EXISTS `xchan` (
KEY `xchan_url` (`xchan_url`),
KEY `xchan_flags` (`xchan_flags`),
KEY `xchan_connurl` (`xchan_connurl`),
+ KEY `xchan_follow` (`xchan_follow`),
+ KEY `xchan_connpage` (`xchan_connpage`),
KEY `xchan_instance_url` (`xchan_instance_url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
diff --git a/install/update.php b/install/update.php
index c5eaa4f19..9beb25254 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1063 );
+define( 'UPDATE_VERSION' , 1064 );
/**
*
@@ -742,3 +742,11 @@ KEY `pelm_result` (`pelm_result`)
return UPDATE_FAILED;
}
+function update_r1063() {
+ $r = q("ALTER TABLE `xchan` ADD `xchan_follow` CHAR( 255 ) NOT NULL DEFAULT '' AFTER `xchan_connurl` ,
+ADD `xchan_connpage` CHAR( 255 ) NOT NULL DEFAULT '' AFTER `xchan_follow` ,
+ADD INDEX ( `xchan_follow` ), ADD INDEX ( `xchan_connpage`) ");
+ if($r)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+}