Creating triggers with SQLite

CREATE TRIGGER `new_user` AFTER INSERT ON `users` BEGIN
INSERT INTO `user_org` (`user_id`, `org_id`) VALUES (NEW.id, last_insert_rowid ());
END;