From 762a5432494711bf481943a0dee72cf65f7a04bb Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 15 Jan 2014 12:57:12 -0800
Subject: allow menus to have special roles

---
 boot.php             |  9 +++++++--
 install/database.sql |  4 +++-
 install/update.php   | 10 +++++++++-
 3 files changed, 19 insertions(+), 4 deletions(-)

diff --git a/boot.php b/boot.php
index b518aa1e0..2cedb8bd6 100755
--- a/boot.php
+++ b/boot.php
@@ -46,7 +46,7 @@ define ( 'RED_PLATFORM',            'Red Matrix' );
 define ( 'RED_VERSION',             trim(file_get_contents('version.inc')) . 'R');
 define ( 'ZOT_REVISION',            1     ); 
 
-define ( 'DB_UPDATE_VERSION',       1090  );
+define ( 'DB_UPDATE_VERSION',       1091  );
 
 define ( 'EOL',                    '<br />' . "\r\n"     );
 define ( 'ATOM_TIME',              'Y-m-d\TH:i:s\Z' );
@@ -218,7 +218,12 @@ define ( 'PHOTO_PROFILE',          0x0001 );
 define ( 'PHOTO_XCHAN',            0x0002 );
 define ( 'PHOTO_THING',            0x0004 );
 
- 
+/**
+ * Menu types
+ */ 
+
+define ( 'MENU_SYSTEM',          0x0001 );
+define ( 'MENU_BOOKMARK',        0x0002 );
 
 /**
  * Network and protocol family types
diff --git a/install/database.sql b/install/database.sql
index d28128795..597124566 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -536,9 +536,11 @@ CREATE TABLE IF NOT EXISTS `menu` (
   `menu_channel_id` int(10) unsigned NOT NULL DEFAULT '0',
   `menu_name` char(255) NOT NULL DEFAULT '',
   `menu_desc` char(255) NOT NULL DEFAULT '',
+  `menu_flags` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`menu_id`),
   KEY `menu_channel_id` (`menu_channel_id`),
-  KEY `menu_name` (`menu_name`)
+  KEY `menu_name` (`menu_name`),
+  KEY `menu_flags` (`menu_flags`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `menu_item` (
diff --git a/install/update.php b/install/update.php
index 3e04df51b..022d7f0dc 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1090 );
+define( 'UPDATE_VERSION' , 1091 );
 
 /**
  *
@@ -986,3 +986,11 @@ ADD INDEX ( `creator` ) ");
 }
 
 
+function update_r1090() {
+	$r = q("ALTER TABLE `menu` ADD `menu_flags` INT NOT NULL DEFAULT '0',
+ADD INDEX ( `menu_flags` )");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
+
-- 
cgit v1.2.3