create table foo(
 userid INTEGER NOT NULL REFERENCES users ON UPDATE CASCADE,
 owner INTEGER NOT NULL REFERENCES users.userid ON UPDATE CASCADE
);