diff options
| -rw-r--r-- | boot.php | 10 | ||||
| -rw-r--r-- | database.sql | 18 | ||||
| -rw-r--r-- | update.php | 5 |
3 files changed, 26 insertions, 7 deletions
@@ -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 |