aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
Diffstat (limited to 'install')
-rw-r--r--install/database.sql1
-rw-r--r--install/update.php11
2 files changed, 11 insertions, 1 deletions
diff --git a/install/database.sql b/install/database.sql
index 990399bc4..817091df5 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -853,6 +853,7 @@ CREATE TABLE IF NOT EXISTS `xprof` (
`xprof_region` char(255) NOT NULL DEFAULT '',
`xprof_postcode` char(32) NOT NULL DEFAULT '',
`xprof_country` char(255) NOT NULL DEFAULT '',
+ `xprof_keywords` text NOT NULL,
PRIMARY KEY (`xprof_hash`),
KEY `xprof_desc` (`xprof_desc`),
KEY `xprof_dob` (`xprof_dob`),
diff --git a/install/update.php b/install/update.php
index 144a972f9..4c5e4d3a6 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
<?php
-define( 'UPDATE_VERSION' , 1009 );
+define( 'UPDATE_VERSION' , 1010 );
/**
*
@@ -160,3 +160,12 @@ function update_r1008() {
return UPDATE_SUCCESS;
return UPDATE_FAILED;
}
+
+function update_r1009() {
+ $r = q("ALTER TABLE `xprof` ADD `xprof_keywords` TEXT NOT NULL");
+ if($r)
+ return UPDATE_SUCCESS;
+ return UPDATE_FAILED;
+}
+
+