X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=89b821e23a47ce2e50a0c0dc17544c304f916cf0;hb=84238e1b89c0a40cfd2dfa72972fdfc2f65c4fab;hp=02e5c9b37832bfd221481b4cd81b99471c8a39b3;hpb=56cb6cc8972f55d82030c8c2b908b05e656640f6;p=friendica.git diff --git a/database.sql b/database.sql index 02e5c9b378..89b821e23a 100644 --- a/database.sql +++ b/database.sql @@ -901,13 +901,11 @@ CREATE TABLE IF NOT EXISTS `session` ( CREATE TABLE IF NOT EXISTS `sign` ( `id` int(10) unsigned NOT NULL auto_increment, `iid` int(10) unsigned NOT NULL DEFAULT 0, - `retract_iid` int(10) unsigned NOT NULL DEFAULT 0, `signed_text` mediumtext NOT NULL, `signature` text NOT NULL, `signer` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY(`id`), - INDEX `iid` (`iid`), - INDEX `retract_iid` (`retract_iid`) + INDEX `iid` (`iid`) ) DEFAULT CHARSET=utf8; --