aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-05-02 01:45:57 -0700
committerfriendica <info@friendica.com>2012-05-02 01:45:57 -0700
commitdc31b93941c2412ad3d61bf7d67d25a3a4153af3 (patch)
treed489581a1fde41a49bfcdba9702c3f4d9908bf2b
parent06d6ab481280d786c40b0741ebd0b787addee40d (diff)
downloadvolse-hubzilla-dc31b93941c2412ad3d61bf7d67d25a3a4153af3.tar.gz
volse-hubzilla-dc31b93941c2412ad3d61bf7d67d25a3a4153af3.tar.bz2
volse-hubzilla-dc31b93941c2412ad3d61bf7d67d25a3a4153af3.zip
provide "service_class" identifier which will let us provide service_class limits such as number of FB friends, etc.
-rw-r--r--boot.php2
-rw-r--r--database.sql4
-rw-r--r--update.php11
3 files changed, 14 insertions, 3 deletions
diff --git a/boot.php b/boot.php
index ed083d617..f357487b9 100644
--- a/boot.php
+++ b/boot.php
@@ -11,7 +11,7 @@ require_once('include/cache.php');
define ( 'FRIENDICA_PLATFORM', 'Friendica');
define ( 'FRIENDICA_VERSION', '2.3.1329' );
define ( 'DFRN_PROTOCOL_VERSION', '2.23' );
-define ( 'DB_UPDATE_VERSION', 1142 );
+define ( 'DB_UPDATE_VERSION', 1143 );
define ( 'EOL', "<br />\r\n" );
define ( 'ATOM_TIME', 'Y-m-d\TH:i:s\Z' );
diff --git a/database.sql b/database.sql
index dc586bc2b..cf086796a 100644
--- a/database.sql
+++ b/database.sql
@@ -1027,6 +1027,7 @@ CREATE TABLE IF NOT EXISTS `user` (
`account_expired` tinyint(1) NOT NULL DEFAULT '0',
`account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `service_class` char(32) NOT NULL,
`allow_cid` mediumtext NOT NULL,
`allow_gid` mediumtext NOT NULL,
`deny_cid` mediumtext NOT NULL,
@@ -1042,7 +1043,8 @@ CREATE TABLE IF NOT EXISTS `user` (
KEY `verified` (`verified`),
KEY `unkmail` (`unkmail`),
KEY `cntunkmail` (`cntunkmail`),
- KEY `account_removed` (`account_removed`)
+ KEY `account_removed` (`account_removed`),
+ KEY `service_class` (`service_class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
diff --git a/update.php b/update.php
index cce942f27..e363aa942 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1142 );
+define( 'UPDATE_VERSION' , 1143 );
/**
*
@@ -1239,3 +1239,12 @@ function update_1141() {
}
+function update_1142() {
+ $r = q("alter table user add service_class char(32) not null after expire_notification_sent, add index(service_class) ");
+ if(! $r)
+ return UPDATE_FAILED ;
+ return UPDATE_SUCCESS ;
+}
+
+
+