X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2Fnewdirectory-0.0.1%2F02_networking.sql;h=8b3e0d6d75ab213c3103bf269142c0722b7ca17a;hb=8a43972f58f0a77015ae9e509f1c073d188874d2;hp=17172c93ecffb6547dd2a435b5e8952426dbc1e4;hpb=3fdcece4a5eba30e33e6bad164952d9b797813df;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: