summaryrefslogtreecommitdiff
path: root/tools/sql-migrate-20111130.sql
blob: a06d83e31838ea0a1492d866c14b7e39b81186f7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
begin;
alter table journals drop constraint "$1";
alter table journals add foreign key (submitted_by) references users (name) on update cascade;
end;
begin;
alter table roles drop constraint "$1";
alter table roles add foreign key (user_name) references users (name) on update cascade;
end;
begin;
alter table cookies drop constraint cookies_name_fkey;
alter table cookies add foreign key (name) references users (name) on update cascade on delete cascade;
end;
begin;
alter table openids drop constraint openids_name_fkey;
alter table openids add foreign key (name) references users (name) on update cascade on delete cascade;
end;
begin;
alter table sshkeys drop constraint sshkeys_name_fkey;
alter table sshkeys add foreign key (name) references users (name) on update cascade on delete cascade;
end;
begin;
alter table csrf_tokens drop constraint csrf_tokens_name_fkey;
alter table csrf_tokens add foreign key (name) references users (name) on update cascade on delete cascade;
end;