aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-10-01 19:09:13 -0700
committerfriendica <info@friendica.com>2012-10-01 19:09:13 -0700
commitd0f62d1219d035d92f3adb717d9fdbed03fa6dd5 (patch)
treed1a7c049fbd9dc1dbc323a53626476c38b39b3bd
parentdc8a46477b245dc89c3de69ddc61e83a2b8bd22a (diff)
downloadvolse-hubzilla-d0f62d1219d035d92f3adb717d9fdbed03fa6dd5.tar.gz
volse-hubzilla-d0f62d1219d035d92f3adb717d9fdbed03fa6dd5.tar.bz2
volse-hubzilla-d0f62d1219d035d92f3adb717d9fdbed03fa6dd5.zip
db update
-rw-r--r--database.sql9
1 files changed, 3 insertions, 6 deletions
diff --git a/database.sql b/database.sql
index 35a7f8f7a..67a789aff 100644
--- a/database.sql
+++ b/database.sql
@@ -936,19 +936,16 @@ CREATE TABLE IF NOT EXISTS `userd` (
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `xchan` (
- `xchan_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `xchan_hash` char(255) NOT NULL,
`xchan_guid` char(255) NOT NULL DEFAULT '',
- `xchan_sig` char(255) NOT NULL DEFAULT '',
- `xchan_hash` char(255) NOT NULL DEFAULT '',
+ `xchan_guid_sig` char(255) NOT NULL DEFAULT '',
`xchan_photo` char(255) NOT NULL DEFAULT '',
`xchan_addr` char(255) NOT NULL DEFAULT '',
`xchan_profile` char(255) NOT NULL DEFAULT '',
`xchan_name` char(255) NOT NULL DEFAULT '',
`xchan_network` char(255) NOT NULL DEFAULT '',
- PRIMARY KEY (`xchan_id`),
+ PRIMARY KEY (`xchan_hash`),
KEY `xchan_guid` (`xchan_guid`),
- KEY `xchan_sig` (`xchan_sig`),
- KEY `xchan_hash` (`xchan_hash`),
KEY `xchan_addr` (`xchan_addr`),
KEY `xchan_profile` (`xchan_profile`),
KEY `xchan_name` (`xchan_name`),