diff options
| author | Zach Prezkuta <fermion@gmx.com> | 2012-06-03 14:52:42 -0600 |
|---|---|---|
| committer | Zach Prezkuta <fermion@gmx.com> | 2012-06-03 14:53:30 -0600 |
| commit | 2a01ae8149e8a16ea0c0c5619a8dd0b682dba21c (patch) | |
| tree | 3ec279fab94641faa31d9a031dab93260bc416f3 /database.sql | |
| parent | 9920fb39e566a10c44aa7ead9603ff3d1893a01a (diff) | |
| download | volse-hubzilla-2a01ae8149e8a16ea0c0c5619a8dd0b682dba21c.tar.gz volse-hubzilla-2a01ae8149e8a16ea0c0c5619a8dd0b682dba21c.tar.bz2 volse-hubzilla-2a01ae8149e8a16ea0c0c5619a8dd0b682dba21c.zip | |
database updates
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 6 |
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; -- -------------------------------------------------------- |