From 0ffeb4cf92c559edc52175059612050091badb4b Mon Sep 17 00:00:00 2001
From: Michael Vogel <icarus@dabo.de>
Date: Fri, 25 Oct 2013 23:33:53 +0200
Subject: [PATCH] New field "network" in item table to speed up the system.

---
 boot.php                  |  2 +-
 database.sql              |  2 ++
 update.php                | 16 +++++++++++++++-
 view/default.php          |  2 +-
 view/theme/vier/style.css |  5 +----
 5 files changed, 20 insertions(+), 7 deletions(-)

diff --git a/boot.php b/boot.php
index af164ec424..b02ee01c7c 100644
--- a/boot.php
+++ b/boot.php
@@ -14,7 +14,7 @@ require_once('include/features.php');
 define ( 'FRIENDICA_PLATFORM',     'Friendica');
 define ( 'FRIENDICA_VERSION',      '3.2.1744' );
 define ( 'DFRN_PROTOCOL_VERSION',  '2.23'    );
-define ( 'DB_UPDATE_VERSION',      1163      );
+define ( 'DB_UPDATE_VERSION',      1164      );
 define ( 'EOL',                    "<br />\r\n"     );
 define ( 'ATOM_TIME',              'Y-m-d\TH:i:s\Z' );
 
diff --git a/database.sql b/database.sql
index f2c558241a..69d87c3698 100644
--- a/database.sql
+++ b/database.sql
@@ -562,6 +562,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `forum_mode` tinyint(1) NOT NULL DEFAULT '0',
   `mention` tinyint(1) NOT NULL DEFAULT '0',
   `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1',
+  `network` char(32) NOT NULL,
   PRIMARY KEY (`id`),
   KEY `uri` (`uri`),
   KEY `uid` (`uid`),
@@ -593,6 +594,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   KEY `mention` (`mention`),
   KEY `resource-id` (`resource-id`),
   KEY `event_id` (`event-id`),
+  KEY `network` (`network`),
   FULLTEXT KEY `title` (`title`),
   FULLTEXT KEY `body` (`body`),
   FULLTEXT KEY `allow_cid` (`allow_cid`),
diff --git a/update.php b/update.php
index 40f22e6aa6..d48be0a7a5 100644
--- a/update.php
+++ b/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1163 );
+define( 'UPDATE_VERSION' , 1164 );
 
 /**
  *
@@ -1441,3 +1441,17 @@ function update_1162() {
 	require_once('include/tags.php');
 	update_items();
 }
+
+function update_1163() {
+	set_config('system', 'maintenance', 1);
+
+	$r = q("ALTER TABLE `item` ADD `network` char(32) NOT NULL,
+		ADD INDEX (`network`)");
+
+	set_config('system', 'maintenance', 0);
+
+	if(!$r)
+		return UPDATE_FAILED;
+
+	return UPDATE_SUCCESS;
+}
diff --git a/view/default.php b/view/default.php
index 61f5f68635..792b2fbbcd 100644
--- a/view/default.php
+++ b/view/default.php
@@ -10,7 +10,7 @@
 	<aside><?php if(x($page,'aside')) echo $page['aside']; ?></aside>
 	<section><?php if(x($page,'content')) echo $page['content']; ?>
 		<div id="page-footer"></div>
-	</section>
+	</section>
 	<right_aside><?php if(x($page,'right_aside')) echo $page['right_aside']; ?></right_aside>
 	<footer><?php if(x($page,'footer')) echo $page['footer']; ?></footer>
 </body>
diff --git a/view/theme/vier/style.css b/view/theme/vier/style.css
index 359907dbd9..f3379fe618 100644
--- a/view/theme/vier/style.css
+++ b/view/theme/vier/style.css
@@ -292,14 +292,11 @@ body {
   font-family: 'Lato', "Helvetica Neue", Helvetica, Arial, sans-serif;
   font-size: 14px;
   background-color: #ffffff;
-  /* background-color: #ddd; */
-  /* background-color: #F2F2F2; */
   color: #2d2d2d;
-  /* margin: 37px 0px 0px 0px; */
   margin: 0px 0px 0px 0px;
   display: table;
-  /* width: 100% */
 }
+
 h4 {
   font-size: 1.1em;
 }
-- 
2.39.5