Get rid of the table "unique_contacts"

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 90604457bc8e16972079624fc39378e46891ac8e..4e6f3d35c7f62ff260cba155e3be2b68882e6e84 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -332,6 +332,7 @@ CREATE TABLE IF NOT EXISTS `gcontact` (
        `about` text NOT NULL,
        `keywords` text NOT NULL,
        `gender` varchar(32) NOT NULL DEFAULT '',
+       `birthday` varchar(32) NOT NULL DEFAULT '0000-00-00',
        `community` tinyint(1) NOT NULL DEFAULT 0,
        `hide` tinyint(1) NOT NULL DEFAULT 0,
        `nsfw` tinyint(1) NOT NULL DEFAULT 0,
@@ -1003,21 +1004,6 @@ CREATE TABLE IF NOT EXISTS `tokens` (
         PRIMARY KEY(`id`)
 ) DEFAULT CHARSET=utf8;
 
---
--- TABLE unique_contacts
---
-CREATE TABLE IF NOT EXISTS `unique_contacts` (
-       `id` int(11) NOT NULL auto_increment,
-       `url` varchar(255) NOT NULL DEFAULT '',
-       `nick` varchar(255) NOT NULL DEFAULT '',
-       `name` varchar(255) NOT NULL DEFAULT '',
-       `avatar` varchar(255) NOT NULL DEFAULT '',
-       `location` varchar(255) NOT NULL DEFAULT '',
-       `about` text NOT NULL,
-        PRIMARY KEY(`id`),
-        INDEX `url` (`url`)
-) DEFAULT CHARSET=utf8;
-
 --
 -- TABLE user
 --