potential for privacy leakage, plus photo not showing occasionally

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index a0b121b0a6c61827138dc8607f1b6db44adebbbf..8cf72417906f931592514ffe2cbe2cc3c882bb7e 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -227,7 +227,6 @@ CREATE TABLE IF NOT EXISTS `mail` (
   `contact-id` char(255) NOT NULL,
   `title` char(255) NOT NULL,
   `body` text NOT NULL,
-  `delivered` tinyint(1) NOT NULL,
   `seen` tinyint(1) NOT NULL,
   `replied` tinyint(1) NOT NULL,
   `uri` char(255) NOT NULL,
@@ -408,3 +407,10 @@ CREATE TABLE IF NOT EXISTS `auth_codes` (
 PRIMARY KEY ( `id` )
 ) ENGINE = MYISAM DEFAULT CHARSET=utf8;
 
+CREATE TABLE IF NOT EXISTS `queue` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`cid` INT NOT NULL ,
+`created` DATETIME NOT NULL ,
+`last` DATETIME NOT NULL ,
+`content` MEDIUMTEXT NOT NULL
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;