5 lines
258 B
SQL
5 lines
258 B
SQL
INSERT INTO team_member (user_id, team_id, addeddate, role_code)
|
|
SELECT owner as user_id, team_id, NOW() as addeddate, 'admin' as role_code
|
|
FROM team ON CONFLICT ON CONSTRAINT team_member_team_id_user_id_key DO NOTHING;
|
|
ALTER TABLE team DROP COLUMN owner;
|