From 5a29f511c1fa609f58f50d9148edd1fe77b23d9d Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Fri, 15 Mar 2013 15:36:58 -0700
Subject: add xconfig table and functions, update strings and doco

---
 install/database.sql | 12 ++++++++++++
 install/update.php   | 19 ++++++++++++++++++-
 2 files changed, 30 insertions(+), 1 deletion(-)

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index 4f503fc12..c321af401 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -889,6 +889,18 @@ CREATE TABLE IF NOT EXISTS `xchan` (
   KEY `xchan_connurl` (`xchan_connurl`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+CREATE TABLE IF NOT EXISTS `xconfig` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `xchan` char(255) NOT NULL,
+  `cat` char(255) NOT NULL,
+  `k` char(255) NOT NULL,
+  `v` mediumtext NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `xchan` (`xchan`),
+  KEY `cat` (`cat`),
+  KEY `k` (`k`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 CREATE TABLE IF NOT EXISTS `xign` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `uid` int(11) NOT NULL DEFAULT '0',
diff --git a/install/update.php b/install/update.php
index 4bdba3507..0c7c6e0df 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1035 );
+define( 'UPDATE_VERSION' , 1036 );
 
 /**
  *
@@ -445,3 +445,20 @@ KEY `ud_date` ( `ud_date` )
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1035() {
+	$r = q("CREATE TABLE if not exists `xconfig` (
+`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`xchan` CHAR( 255 ) NOT NULL ,
+`cat` CHAR( 255 ) NOT NULL ,
+`k` CHAR( 255 ) NOT NULL ,
+`v` MEDIUMTEXT NOT NULL,
+KEY `xchan` ( `xchan` ),
+KEY `cat` ( `cat` ),
+KEY `k` ( `k` )
+) ENGINE = MYISAM DEFAULT CHARSET = utf8");
+
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
-- 
cgit v1.2.3