From 1a6415807ebf9ae859134c99eb64a90d7363747a Mon Sep 17 00:00:00 2001 From: friendica Date: Mon, 29 Oct 2012 19:31:38 -0700 Subject: more structural stuff --- install/database.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'install') diff --git a/install/database.sql b/install/database.sql index 5c0e2d85b..92a8df651 100644 --- a/install/database.sql +++ b/install/database.sql @@ -13,7 +13,7 @@ CREATE TABLE IF NOT EXISTS `abook` ( `abook_xchan` char(255) NOT NULL DEFAULT '', `abook_my_perms` int(11) NOT NULL DEFAULT '0', `abook_their_perms` int(11) NOT NULL DEFAULT '0', - `abook_closeness` tinyint(3) unsigned NOT NULL DEFAULT '255', + `abook_closeness` tinyint(3) unsigned NOT NULL DEFAULT '99', `abook_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `abook_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `abook_connnected` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', @@ -700,7 +700,7 @@ CREATE TABLE IF NOT EXISTS `pconfig` ( `v` mediumtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `access` (`uid`,`cat`,`k`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `photo` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, @@ -734,7 +734,7 @@ CREATE TABLE IF NOT EXISTS `photo` ( KEY `type` (`type`), KEY `contact-id` (`contact-id`), KEY `aid` (`aid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `profile` ( `id` int(11) NOT NULL AUTO_INCREMENT, @@ -907,7 +907,7 @@ CREATE TABLE IF NOT EXISTS `xchan` ( `xchan_photo_m` char(255) NOT NULL DEFAULT '', `xchan_photo_s` char(255) NOT NULL DEFAULT '', `xchan_addr` char(255) NOT NULL DEFAULT '', - `xchan_profile` char(255) NOT NULL DEFAULT '', + `xchan_url` char(255) NOT NULL DEFAULT '', `xchan_name` char(255) NOT NULL DEFAULT '', `xchan_network` char(255) NOT NULL DEFAULT '', `xchan_photo_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', @@ -915,7 +915,7 @@ CREATE TABLE IF NOT EXISTS `xchan` ( PRIMARY KEY (`xchan_hash`), KEY `xchan_guid` (`xchan_guid`), KEY `xchan_addr` (`xchan_addr`), - KEY `xchan_profile` (`xchan_profile`), KEY `xchan_name` (`xchan_name`), - KEY `xchan_network` (`xchan_network`) + KEY `xchan_network` (`xchan_network`), + KEY `xchan_url` (`xchan_url`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3