summaryrefslogtreecommitdiff
path: root/tools
diff options
context:
space:
mode:
authorDonald Stufft <donald@stufft.io>2013-05-23 15:47:58 -0400
committerDonald Stufft <donald@stufft.io>2013-05-23 15:47:58 -0400
commit3f64bd42d609b5edf459a4037982097fe2bce838 (patch)
treebc565af6e5aa6096bcd5277135c3bbf39ce93afa /tools
parentd86ef604dcbed3c5da4e16dce722e35f8797263a (diff)
downloaddecorator-3f64bd42d609b5edf459a4037982097fe2bce838.tar.gz
Add a unique index to ensure case insensivitive uniqueness
Diffstat (limited to 'tools')
-rw-r--r--tools/sql-migrate-20130523.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/tools/sql-migrate-20130523.sql b/tools/sql-migrate-20130523.sql
new file mode 100644
index 0000000..75606c8
--- /dev/null
+++ b/tools/sql-migrate-20130523.sql
@@ -0,0 +1 @@
+CREATE UNIQUE INDEX ON users (LOWER(name));