hjortronmyren.sql

-- Avboka lägenheter
SELECT * FROM projects WHERE id = 7;
SELECT number, assigned_user_id, status FROM properties WHERE project_id = 7 ORDER BY id;
UPDATE properties SET assigned_user_id = null, status = 'AVAILABLE' WHERE project_id = 7;

-- Radera användare
SELECT id, queue_number, first_name, email FROM users WHERE project_id = 7;
DELETE FROM users WHERE project_id = 7;
UPDATE projects SET queue_counter = 0 WHERE id = 7;

-- Ställ in tider
SELECT * FROM projects WHERE id = 7;
UPDATE projects SET signup_open_at = '2018-10-11 09:00:00' WHERE id = 7;
UPDATE projects SET signup_close_at = '2018-10-11 12:00:00' WHERE id = 7;

heroku ps:scale -a boka-objekt
heroku ps:scale web=2:standard-1x -a boka-objekt

heroku ps:scale web=1:hobby -a boka-objekt