summaryrefslogtreecommitdiff
path: root/tools/sql-migrate-20091125.sql
blob: ec1b60fb3d0db57629012cde2346553dda34a19d (plain)
1
2
3
4
5
6
ALTER TABLE rego_otk ADD COLUMN date TIMESTAMP;
UPDATE rego_otk SET date=now();
BEGIN;
ALTER TABLE rego_otk DROP CONSTRAINT "$1";
ALTER TABLE rego_otk ADD CONSTRAINT "$1" FOREIGN KEY (name) REFERENCES users ON DELETE CASCADE;
END;