From d11c1c63c02e88b3c73336741a2240ccc18d3b02 Mon Sep 17 00:00:00 2001 From: Mike Macgirvin Date: Sun, 8 Aug 2010 21:03:08 -0700 Subject: lots of fixes - most recent photo updates for contacts --- database.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 1411ec6da..eeba76f7e 100644 --- a/database.sql +++ b/database.sql @@ -60,6 +60,9 @@ CREATE TABLE IF NOT EXISTS `contact` ( `ret-id` char(255) NOT NULL, `ret-pubkey` text NOT NULL, `last-update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `priority` tinyint(3) NOT NULL, `blocked` tinyint(1) NOT NULL DEFAULT '1', `readonly` tinyint(1) NOT NULL DEFAULT '0', -- cgit v1.2.3