From 61601dc23d3e8305720bfc4e4e6b6dbd7b85f546 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 20 Jun 2013 18:36:02 -0700
Subject: Add site registration policy to site record. This is not yet used or
 stored, but potentially can be exchanged through directory mirrors to
 automatically create "open site" lists.

---
 install/database.sql |  4 +++-
 install/update.php   | 11 ++++++++++-
 2 files changed, 13 insertions(+), 2 deletions(-)

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index 9964e98ea..056124649 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -797,10 +797,12 @@ CREATE TABLE IF NOT EXISTS `site` (
   `site_flags` int(11) NOT NULL DEFAULT '0',
   `site_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `site_directory` char(255) NOT NULL DEFAULT '',
+  `site_register` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`site_url`),
   KEY `site_flags` (`site_flags`),
   KEY `site_update` (`site_update`),
-  KEY `site_directory` (`site_directory`)
+  KEY `site_directory` (`site_directory`),
+  KEY `site_register` (`site_register`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `spam` (
diff --git a/install/update.php b/install/update.php
index ba5ec0262..c57b8562e 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1045 );
+define( 'UPDATE_VERSION' , 1046 );
 
 /**
  *
@@ -556,3 +556,12 @@ ADD INDEX ( `imgurl` ) ");
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1045() {
+	$r = q("ALTER TABLE `site` ADD `site_register` INT NOT NULL DEFAULT '0',
+ADD INDEX ( `site_register` ) ");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
+	
-- 
cgit v1.2.3