Mercurial > hg > rc2

comparison SQL/postgres/2008030300.sql @ 0:4681f974d28b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
vanilla 1.3.3 distro, I hope
author Charlie Root
date Thu, 04 Jan 2018 15:52:31 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:4681f974d28b
1 -- Updates from version 0.1-stable to 0.1.1
2
3 CREATE INDEX cache_user_id_idx ON cache (user_id, cache_key);
4 CREATE INDEX contacts_user_id_idx ON contacts (user_id);
5 CREATE INDEX identities_user_id_idx ON identities (user_id);
6
7 CREATE INDEX users_username_id_idx ON users (username);
8 CREATE INDEX users_alias_id_idx ON users (alias);
9
10 -- added ON DELETE/UPDATE actions
11 ALTER TABLE messages DROP CONSTRAINT messages_user_id_fkey;
12 ALTER TABLE messages ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
13 ALTER TABLE identities DROP CONSTRAINT identities_user_id_fkey;
14 ALTER TABLE identities ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
15 ALTER TABLE contacts DROP CONSTRAINT contacts_user_id_fkey;
16 ALTER TABLE contacts ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;
17 ALTER TABLE cache DROP CONSTRAINT cache_user_id_fkey;
18 ALTER TABLE cache ADD FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE;