From d39fb9b1d5208b18da364873d10f51e23b94bd7e Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Fri, 14 Dec 2012 00:45:30 -0800
Subject: converging on a workable crypto auth handshake

---
 install/update.php | 20 +++++++++++++++++++-
 1 file changed, 19 insertions(+), 1 deletion(-)

(limited to 'install/update.php')

diff --git a/install/update.php b/install/update.php
index edd4701a1..f767c2f22 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1001 );
+define( 'UPDATE_VERSION' , 1002 );
 
 /**
  *
@@ -43,3 +43,21 @@ function update_r1000() {
 }
 
 
+function update_r1001() {
+	$r = q("CREATE TABLE if not exists `verify` (
+		`id` INT(10) UNSIGNED NOT NULL ,
+		`channel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+		`type` CHAR( 32 ) NOT NULL DEFAULT '',
+		`token` CHAR( 255 ) NOT NULL DEFAULT '',
+		`meta` CHAR( 255 ) NOT NULL DEFAULT '',
+		`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
+		PRIMARY KEY ( `id` )
+		) ENGINE = MYISAM ");
+
+	$r2 = q("alter table `verify` add index (`channel`), add index (`type`), add index (`token`),
+		add index (`meta`), add index (`created`)");
+
+	if($r && $r2)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
-- 
cgit v1.2.3