commit c685857cfadec7741e42ee91147f23555f1b9451
author Jiaxi Luo <jiaxiluo@chromium.org> Mon Jul 21 11:30:04 2014 -0700
committer chrome-internal-fetch <chrome-internal-fetch@google.com> Tue Jul 22 04:12:57 2014 +0000
tree c541dc9ff4a41002e00c8b133925e0523600bb4f
parent dd67bebb78d9b00e6b14106fef9fa711b97044cd

[autotest] Add unqiue constraint on afe_users.login

Add unique constraint to avoid duplicate login names, which happened on moblab.

BUG=chromium:395262
TEST=ran migrate
DEPLOY=migrate

Change-Id: Idbf08957a0b181013e4bb7951c002cd078bcc44e
Reviewed-on: https://chromium-review.googlesource.com/209167
Tested-by: Jiaxi Luo <jiaxiluo@chromium.org>
Reviewed-by: Simran Basi <sbasi@chromium.org>
Reviewed-by: Alex Miller <milleral@chromium.org>
Commit-Queue: Jiaxi Luo <jiaxiluo@chromium.org>

frontend/migrations/093_make_afe_users_login_unique.py

diff --git a/frontend/migrations/093_make_afe_users_login_unique.py b/frontend/migrations/093_make_afe_users_login_unique.py
new file mode 100644
index 0000000..4b37f16
--- /dev/null
+++ b/frontend/migrations/093_make_afe_users_login_unique.py
@@ -0,0 +1,7 @@
+UP_SQL = """
+CREATE UNIQUE INDEX login_unique ON afe_users (login);
+"""
+
+DOWN_SQL = """
+DROP INDEX login_unique ON afe_users;
+"""
\ No newline at end of file