From 73e0986710f0324a41fb995172d33e7b942dc438 Mon Sep 17 00:00:00 2001 From: Friendika Date: Fri, 27 May 2011 18:47:28 -0700 Subject: item/event linkage --- boot.php | 2 +- database.sql | 1 + update.php | 4 ++++ 3 files changed, 6 insertions(+), 1 deletion(-) 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', "
\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` "); +} -- cgit v1.2.3