Nov 25, 2023
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000171_optin_template_bump_1h.down.sql b/coderd/database/migrations/000171_optin_template_bump_1h.down.sql
 BEGIN;

 ALTER TABLE templates DROP COLUMN activity_bump_by_1h;

 DROP VIEW template_with_users;

 CREATE VIEW
    template_with_users
 AS
    SELECT
        templates.*,
 coalesce(visible_users.avatar_url, '') AS created_by_avatar_url,
 coalesce(visible_users.username, '') AS created_by_username
    FROM
        templates
    LEFT JOIN
 visible_users
 ON
    templates.created_by = visible_users.id;

 COMMENT ON VIEW template_with_users IS 'Joins in the username + avatar url of the created by user.';

 COMMIT;
diff --git a/coderd/database/migrations/000171_optin_template_bump_1h.up.sql b/coderd/database/migrations/000171_optin_template_bump_1h.up.sql
 BEGIN;

 ALTER TABLE templates ADD COLUMN activity_bump_by_1h boolean not null default false;

 DROP VIEW template_with_users;

 CREATE VIEW
    template_with_users
 AS
    SELECT
        templates.*,
 coalesce(visible_users.avatar_url, '') AS created_by_avatar_url,
 coalesce(visible_users.username, '') AS created_by_username
    FROM
        templates
    LEFT JOIN
 visible_users
 ON
    templates.created_by = visible_users.id;

 COMMENT ON VIEW template_with_users IS 'Joins in the username + avatar url of the created by user.';

 COMMIT;
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/querier.go b/coderd/database/querier.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,23 @@
		BEGIN;

		ALTER TABLE templates DROP COLUMN activity_bump_by_1h;

		DROP VIEW template_with_users;

		CREATE VIEW
		template_with_users
		AS
		SELECT
		templates.*,
		coalesce(visible_users.avatar_url, '') AS created_by_avatar_url,
		coalesce(visible_users.username, '') AS created_by_username
		FROM
		templates
		LEFT JOIN
		visible_users
		ON
		templates.created_by = visible_users.id;

		COMMENT ON VIEW template_with_users IS 'Joins in the username + avatar url of the created by user.';

		COMMIT;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,23 @@
		BEGIN;

		ALTER TABLE templates ADD COLUMN activity_bump_by_1h boolean not null default false;

		DROP VIEW template_with_users;

		CREATE VIEW
		template_with_users
		AS
		SELECT
		templates.*,
		coalesce(visible_users.avatar_url, '') AS created_by_avatar_url,
		coalesce(visible_users.username, '') AS created_by_username
		FROM
		templates
		LEFT JOIN
		visible_users
		ON
		templates.created_by = visible_users.id;

		COMMENT ON VIEW template_with_users IS 'Joins in the username + avatar url of the created by user.';

		COMMIT;