aboutsummaryrefslogtreecommitdiffstats
path: root/install/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-10-29 19:31:38 -0700
committerfriendica <info@friendica.com>2012-10-29 19:31:38 -0700
commit1a6415807ebf9ae859134c99eb64a90d7363747a (patch)
tree2f53cb0168079c9f195979474eed950ad7c38734 /install/database.sql
parente36ca7b41f58cf0a478f222548d419e254a201be (diff)
downloadvolse-hubzilla-1a6415807ebf9ae859134c99eb64a90d7363747a.tar.gz
volse-hubzilla-1a6415807ebf9ae859134c99eb64a90d7363747a.tar.bz2
volse-hubzilla-1a6415807ebf9ae859134c99eb64a90d7363747a.zip
more structural stuff
Diffstat (limited to 'install/database.sql')
-rw-r--r--install/database.sql12
1 files changed, 6 insertions, 6 deletions
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;