X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F02_networking.sql;h=8b3e0d6d75ab213c3103bf269142c0722b7ca17a;hb=fb813fb52d5ab65ca9a5b92b5cb9089523380d79;hp=17172c93ecffb6547dd2a435b5e8952426dbc1e4;hpb=7972436ae72911c7f2e8d5f3a26204a7ca0ee39d;p=platal.git

diff --git a/upgrade/newdirectory-0.0.1/02_networking.sql b/upgrade/newdirectory-0.0.1/02_networking.sql
index 17172c9..8b3e0d6 100644
--- a/upgrade/newdirectory-0.0.1/02_networking.sql
+++ b/upgrade/newdirectory-0.0.1/02_networking.sql
@@ -13,7 +13,8 @@ CREATE TABLE IF NOT EXISTS `profile_networking` (
     `network_type` tinyint unsigned NOT NULL,
     `address` varchar(255) NOT NULL,
     `pub` enum('private','public') NOT NULL DEFAULT 'private',
-    PRIMARY KEY (`uid`, `nwid`)
+    PRIMARY KEY (`uid`, `nwid`),
+    INDEX uid (uid)
 ) CHARSET=utf8 COMMENT='networking addresses';
 
 -- Insert a first address type for old URLs
@@ -42,3 +43,4 @@ ALTER TABLE `watch_profile`
 ALTER TABLE `auth_user_quick` DROP COLUMN `profile_web`;
 ALTER TABLE `auth_user_quick` DROP COLUMN `profile_web_pub`;
 
+# vim:set syntax=mysql: