diff options
| author | friendica <info@friendica.com> | 2012-10-18 20:59:00 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-10-18 20:59:00 -0700 |
| commit | 2c3c933ed4cf6846c0240f576082da2deda5a25a (patch) | |
| tree | 1d58de4e19906f40dcf4f1cef1d3fecddd1c1a70 /database.sql | |
| parent | 0b37d4efd69de4306bb27de8d19090c5f1149abc (diff) | |
| download | volse-hubzilla-2c3c933ed4cf6846c0240f576082da2deda5a25a.tar.gz volse-hubzilla-2c3c933ed4cf6846c0240f576082da2deda5a25a.tar.bz2 volse-hubzilla-2c3c933ed4cf6846c0240f576082da2deda5a25a.zip | |
get profile edits working
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/database.sql b/database.sql index c096c0f12..d88782a50 100644 --- a/database.sql +++ b/database.sql @@ -18,6 +18,7 @@ CREATE TABLE IF NOT EXISTS `abook` ( `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `connnected` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `abook_flags` int(11) NOT NULL DEFAULT '0', + `abook_profile` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -724,6 +725,7 @@ CREATE TABLE IF NOT EXISTS `photo` ( CREATE TABLE IF NOT EXISTS `profile` ( `id` int(11) NOT NULL AUTO_INCREMENT, + `profile_guid` char(64) NOT NULL DEFAULT '', `aid` int(10) unsigned NOT NULL DEFAULT '0', `uid` int(11) NOT NULL, `profile_name` char(255) NOT NULL, @@ -765,6 +767,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( `thumb` char(255) NOT NULL, `publish` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), + UNIQUE KEY `guid` (`profile_guid`,`uid`), KEY `uid` (`uid`), KEY `locality` (`locality`), KEY `hometown` (`hometown`), @@ -777,6 +780,7 @@ CREATE TABLE IF NOT EXISTS `profile` ( KEY `hide_friends` (`hide_friends`), KEY `postal_code` (`postal_code`), KEY `country_name` (`country_name`), + KEY `profile_guid` (`profile_guid`), FULLTEXT KEY `pub_keywords` (`pub_keywords`), FULLTEXT KEY `prv_keywords` (`prv_keywords`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |