aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to 'install')
-rw-r--r--install/database.sql9
-rw-r--r--install/update.php10
2 files changed, 13 insertions, 6 deletions
diff --git a/install/database.sql b/install/database.sql
index cab10005e..6876514f2 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -756,10 +756,7 @@ CREATE TABLE IF NOT EXISTS `site` (
PRIMARY KEY (`site_url`),
KEY `site_flags` (`site_flags`),
KEY `site_update` (`site_update`),
- KEY `site_directory` (`site_directory`),
- KEY `site_flags_2` (`site_flags`),
- KEY `site_update_2` (`site_update`),
- KEY `site_directory_2` (`site_directory`)
+ KEY `site_directory` (`site_directory`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `spam` (
@@ -833,6 +830,7 @@ CREATE TABLE IF NOT EXISTS `xchan` (
`xchan_photo_s` char(255) NOT NULL DEFAULT '',
`xchan_addr` char(255) NOT NULL DEFAULT '',
`xchan_url` char(255) NOT NULL DEFAULT '',
+ `xchan_connurl` char(255) NOT NULL DEFAULT '',
`xchan_name` char(255) NOT NULL DEFAULT '',
`xchan_network` char(255) NOT NULL DEFAULT '',
`xchan_flags` int(10) unsigned NOT NULL DEFAULT '0',
@@ -844,7 +842,8 @@ CREATE TABLE IF NOT EXISTS `xchan` (
KEY `xchan_name` (`xchan_name`),
KEY `xchan_network` (`xchan_network`),
KEY `xchan_url` (`xchan_url`),
- KEY `xchan_flags` (`xchan_flags`)
+ KEY `xchan_flags` (`xchan_flags`),
+ KEY `xchan_connurl` (`xchan_connurl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `xprof` (
diff --git a/install/update.php b/install/update.php
index 3b75f0e5f..614887709 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1012 );
+define( 'UPDATE_VERSION' , 1013 );
/**
*
@@ -189,3 +189,11 @@ ADD INDEX ( `expires` )");
return UPDATE_FAILED;
}
+function update_r1012() {
+ $r = q("ALTER TABLE `xchan` ADD `xchan_connurl` CHAR( 255 ) NOT NULL DEFAULT '' AFTER `xchan_url` ,
+ADD INDEX ( `xchan_connurl` )");
+
+ if($r)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+}