X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=1c361b6762b26531f509e1cf8e65aa7fc18898f7;hb=37d5bc1a51312dd4de3438843eb1b521444b5398;hp=da39341f154ee5676a4a304810a6b54f2f7fc6fc;hpb=2951243b079499e3a70e855a8b1d9b078cbfbfd9;p=friendica.git

diff --git a/database.sql b/database.sql
index da39341f15..1c361b6762 100644
--- a/database.sql
+++ b/database.sql
@@ -523,17 +523,14 @@ CREATE TABLE IF NOT EXISTS `workerqueue` (
 CREATE TABLE IF NOT EXISTS `delayed-post` (
 	`id` int unsigned NOT NULL auto_increment,
 	`uri` varchar(255) COMMENT 'URI of the post that will be distributed later',
-	`title` varchar(255) COMMENT 'post title',
-	`body` mediumtext COMMENT 'post body content',
-	`private` tinyint unsigned COMMENT '0=public, 1=private, 2=unlisted',
-	`wid` int unsigned COMMENT 'Workerqueue id',
 	`uid` mediumint unsigned COMMENT 'Owner User id',
 	`delayed` datetime COMMENT 'delay time',
+	`wid` int unsigned COMMENT 'Workerqueue id',
 	 PRIMARY KEY(`id`),
 	 UNIQUE INDEX `uid_uri` (`uid`,`uri`(190)),
 	 INDEX `wid` (`wid`),
-	FOREIGN KEY (`wid`) REFERENCES `workerqueue` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE,
-	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
+	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
+	FOREIGN KEY (`wid`) REFERENCES `workerqueue` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Posts that are about to be distributed at a later time';
 
 --