Renames user_id to uid in requests related tables accordingly to our naming convention.

[platal.git] / upgrade / account / 20_naming_convention.sql

diff --git a/upgrade/account/20_naming_convention.sql b/upgrade/account/20_naming_convention.sql
index 877a2b0..5ef1dad 100644 (file)
--- a/upgrade/account/20_naming_convention.sql
+++ b/upgrade/account/20_naming_convention.sql
@@ -50,4 +50,10 @@ CHANGE COLUMN  uid pid INT(11) not null;
   ALTER TABLE  account_auth_openid
 CHANGE COLUMN  user_id uid INT(11) not null;
 
+# request
+  ALTER TABLE  requests
+CHANGE COLUMN  user_id uid INT(11) NOT NULL;
+  ALTER TABLE  requests_hidden
+CHANGE COLUMN  user_id uid INT(11) NOT NULL;
+
 # vim:set ft=mysql: