aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-06-03 14:48:28 -0700
committerfriendica <info@friendica.com>2012-06-03 14:48:28 -0700
commit9f4b89726176f9596cf3330a68cfab8cab5ab361 (patch)
tree688f64270521b0c47eaacae020e2ba92274fddeb /database.sql
parent0b657aa2357bf8785302b55e2cafb397d67cb377 (diff)
parenta66baf29188248fd83ccdf7053a0cf589a9fa8af (diff)
downloadvolse-hubzilla-9f4b89726176f9596cf3330a68cfab8cab5ab361.tar.gz
volse-hubzilla-9f4b89726176f9596cf3330a68cfab8cab5ab361.tar.bz2
volse-hubzilla-9f4b89726176f9596cf3330a68cfab8cab5ab361.zip
Merge https://github.com/friendica/friendica into pull
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/database.sql b/database.sql
index b20846bad..c1d1b27e4 100644
--- a/database.sql
+++ b/database.sql
@@ -944,12 +944,14 @@ 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,
+ `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` char(255) NOT NULL,
PRIMARY KEY (`id`),
- KEY `iid` (`iid`)
+ KEY `iid` (`iid`),
+ KEY `retract_iid` (`retract_iid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------