diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/database.sql b/database.sql index 02701b740..eeb3700ff 100644 --- a/database.sql +++ b/database.sql @@ -66,6 +66,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `issued-id` char(255) NOT NULL, `dfrn-id` char(255) NOT NULL, `url` char(255) NOT NULL, + `nurl` char(255) NOT NULL, `addr` char(255) NOT NULL, `alias` char(255) NOT NULL, `pubkey` text NOT NULL, @@ -106,6 +107,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( KEY `nick` (`nick`), KEY `attag` (`attag`), KEY `url` (`url`), + KEY `nurl` (`nurl`), KEY `addr` (`addr`), KEY `batch` (`batch`), KEY `issued-id` (`issued-id`), |