put oembed settings into a .settings-block div for consistency

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index d9cd016f071182f764d06f5fb32238d79c21bcc2..8948e9b06104aa0442d158dabafa6c1a76424ab1 100644 (file)
--- 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,
@@ -527,6 +528,8 @@ CREATE TABLE IF NOT EXISTS `mailacct` (
 CREATE TABLE IF NOT EXISTS `attach` (
 `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 `uid` INT NOT NULL ,
+`hash` CHAR(64) NOT NULL,
+`filename` CHAR(255) NOT NULL,
 `filetype` CHAR( 64 ) NOT NULL ,
 `filesize` INT NOT NULL ,
 `data` LONGBLOB NOT NULL ,