SELECT
  u.id,
  u.login,
  u.active,
  u.activated
FROM users u
WHERE u.login = 'marigbf@gmail.com';
-- id: 1077472

SELECT count(ud.id)
FROM users_devices ud
WHERE ud.user_id = 1077472;
-- 0 users_devices

SELECT count(*)
FROM oauth_access_token
WHERE user_name = 'marigbf@gmail.com';
-- 38 access_token

DELETE FROM oauth_access_token
WHERE user_name = 'marigbf@gmail.com';

SELECT count(r.token_id)
FROM oauth_refresh_token r
  JOIN oauth_access_token t ON r.token_id = t.token_id
WHERE t.user_name = 'marigbf@gmail.com';
-- 0 refresh_token

SELECT
  cc.id,
  c.display_name,
  s.active,
  s.full_name,
  su.active,
  su.id,
  su.status,
  su.parentage
FROM students_users su
  JOIN students s ON su.student_id = s.id
  JOIN contracts_colleges cc ON s.contract_college_id = cc.id
  JOIN colleges c ON cc.college_id = c.id
WHERE su.user_id = 1077472;
-- 0 students_users

SELECT
  cc.id,
  c.display_name,
  s.active,
  s.display_name,
  s.status
FROM contacts s
  JOIN contracts_colleges cc ON s.contract_college_id = cc.id
  JOIN colleges c ON cc.college_id = c.id
WHERE s.user_id = 1077472;
-- 1 contacts

SELECT count(cm.id)
FROM conversations_members cm
WHERE cm.user_id = 1077472;
-- 17 conversations_members

UPDATE conversations_members
SET
  active = FALSE,
  last_modified_date = now()
WHERE user_id = 1077472;

SELECT count(cc.id)
FROM contents_consumers cc
WHERE cc.user_id = 1077472;
-- 13 contents_consumers

UPDATE contents_consumers
SET
  active = FALSE, last_modified_date = now()
WHERE user_id = 1077472;




-- 1
UPDATE users_devices
SET active = FALSE, last_modified_date = now()
WHERE user_id = 437823;
SELECT *
FROM users_devices
WHERE user_id = 437823;


SELECT
  c.display_name,
  s.full_name,
  s.id,
  su.status,
  su.parentage,
  su.active AS su_active,
  s.active  AS stu_active,
  su.created_date
FROM students_users su
  JOIN students s ON su.student_id = s.id
  JOIN contracts_colleges cc ON s.contract_college_id = cc.id
  JOIN colleges c ON cc.college_id = c.id
WHERE su.user_id = 437823;

SELECT *
FROM students_users
WHERE student_id = 325575
ORDER BY created_date DESC;

select * from events_members where user_id = 1077472;
-- 0 events_members

update events_members set active = false, last_modified_date = now();