Mercurial > hg > rc1

annotate SQL/postgres/2011121400.sql @ 18:e8f197ce1af3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
try to reuse same tab for linking back to message
author Charlie Root
date Mon, 15 Jan 2018 10:28:32 -0500
parents 1e000243b222
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
1e000243b222 vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
1 -- Updates from version 0.7
1e000243b222 vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
2
1e000243b222 vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
3 DROP INDEX contacts_user_id_idx;
1e000243b222 vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
4 CREATE INDEX contacts_user_id_idx ON contacts USING btree (user_id, del);
1e000243b222 vanilla 1.3.3 distro, I hope
Charlie Root
parents:
diff changeset
5 ALTER TABLE contacts ALTER email TYPE text;