item/event linkage

3 files changed, 6 insertions, 1 deletions

diff --git a/boot.php b/boot.php
index af16e8cbb..6de0f7a7f 100644
--- a/boot.php
+++ b/boot.php
@@ -6,7 +6,7 @@ ini_set('pcre.backtrack_limit', 250000);
 
 define ( 'FRIENDIKA_VERSION',      '2.2.993' );
 define ( 'DFRN_PROTOCOL_VERSION',  '2.21'    );
-define ( 'DB_UPDATE_VERSION',      1058      );
+define ( 'DB_UPDATE_VERSION',      1059      );
 
 define ( 'EOL',                    "<br />\r\n"     );
 define ( 'ATOM_TIME',              'Y-m-d\TH:i:s\Z' );
diff --git a/database.sql b/database.sql
index 008d00a0d..8948e9b06 100644
--- a/database.sql
+++ b/database.sql
@@ -186,6 +186,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `target` text NOT NULL,
   `plink` char(255) NOT NULL, 
   `resource-id` char(255) NOT NULL,
+  `event-id` int(10) unsigned NOT NULL,
   `tag` mediumtext NOT NULL,
   `attach` mediumtext NOT NULL,
   `inform` mediumtext NOT NULL,
diff --git a/update.php b/update.php
index 30ebd66f2..a53e4df78 100644
--- a/update.php
+++ b/update.php
@@ -495,3 +495,7 @@ function update_1056() {
 function update_1057() {
 	q("ALTER TABLE `attach` ADD `filename` CHAR( 255 ) NOT NULL AFTER `hash` ");
 }
+
+function update_1058() {
+	q("ALTER TABLE `item` ADD `event-id` INT NOT NULL AFTER `resource-id` ");
+}