aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMike Macgirvin <mike@macgirvin.com>2010-10-16 22:11:21 -0700
committerMike Macgirvin <mike@macgirvin.com>2010-10-16 22:11:21 -0700
commitf5a8a92df101cbf37fedb9ac3f7702f60a40772e (patch)
tree5f89c16597a4120148128af306e26c1d26f5666f
parent36e1afa6ae35890a26910951dec6dda98dcdee8f (diff)
downloadvolse-hubzilla-f5a8a92df101cbf37fedb9ac3f7702f60a40772e.tar.gz
volse-hubzilla-f5a8a92df101cbf37fedb9ac3f7702f60a40772e.tar.bz2
volse-hubzilla-f5a8a92df101cbf37fedb9ac3f7702f60a40772e.zip
infrastructure for supporting pages/groups
-rw-r--r--boot.php10
-rw-r--r--database.sql18
-rw-r--r--update.php5
3 files changed, 26 insertions, 7 deletions
diff --git a/boot.php b/boot.php
index 296ae13c3..3a9173ef8 100644
--- a/boot.php
+++ b/boot.php
@@ -2,7 +2,7 @@
set_time_limit(0);
-define ( 'BUILD_ID', 1007 );
+define ( 'BUILD_ID', 1008 );
define ( 'DFRN_PROTOCOL_VERSION', '2.0' );
define ( 'EOL', "<br />\r\n" );
@@ -20,6 +20,14 @@ define ( 'REL_VIP', 1);
define ( 'REL_FAN', 2);
define ( 'REL_BUD', 3);
+
+// page/profile types
+
+define ( 'PAGE_NORMAL', 0 );
+define ( 'PAGE_AUTO_FAN', 1 );
+define ( 'PAGE_AUTO_FAN_RW', 2 );
+define ( 'PAGE_AUTO_BUD', 3 );
+
// Maximum number of "people who like (or don't like) this"
// that we will list by name
diff --git a/database.sql b/database.sql
index 24dd9495d..8b1f35cd2 100644
--- a/database.sql
+++ b/database.sql
@@ -351,12 +351,18 @@ CREATE TABLE IF NOT EXISTS `user` (
`prvkey` text NOT NULL,
`spubkey` text NOT NULL,
`sprvkey` text NOT NULL,
- `verified` tinyint(1) unsigned NOT NULL DEFAULT '0', `blocked`
- tinyint(1) unsigned NOT NULL DEFAULT '0', `notify-flags` int(11)
- unsigned NOT NULL DEFAULT '65535', `pwdreset` char(255) NOT NULL,
- `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL,
- `deny_cid` mediumtext NOT NULL, `deny_gid` mediumtext NOT NULL,
- PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+ `verified` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0',
+ `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535',
+ `page-flags` int(11) unsigned NOT NULL DEFAULT '0',
+ `pwdreset` char(255) NOT NULL,
+ `allow_cid` mediumtext NOT NULL,
+ `allow_gid` mediumtext NOT NULL,
+ `deny_cid` mediumtext NOT NULL,
+ `deny_gid` mediumtext NOT NULL,
+ PRIMARY KEY (`uid`),
+ KEY `nickname` (`nickname`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `register` (
diff --git a/update.php b/update.php
index 2ce83d5ce..43101855c 100644
--- a/update.php
+++ b/update.php
@@ -63,3 +63,8 @@ function update_1006() {
}
}
}
+
+function update_1007() {
+ q("ALTER TABLE `user` ADD `page-flags` INT NOT NULL DEFAULT '0' AFTER `notify-flags`");
+ q("ALTER TABLE `user` ADD INDEX ( `nickname` )");
+} \ No newline at end of file