coder
diff --git a/‎coderd/database/dump.sql
+2-1 b/‎coderd/database/dump.sql
+2-1
diff --git a/‎coderd/database/migrations/000053_last_seen_at.down.sql
+3 b/‎coderd/database/migrations/000053_last_seen_at.down.sql
+3
diff --git a/‎coderd/database/migrations/000053_last_seen_at.up.sql
+2 b/‎coderd/database/migrations/000053_last_seen_at.up.sql
+2
diff --git a/‎coderd/database/models.go
+1 b/‎coderd/database/models.go
+1
diff --git a/‎coderd/database/querier.go
+1 b/‎coderd/database/querier.go
+1
diff --git a/‎coderd/database/queries.sql.go
+52-8 b/‎coderd/database/queries.sql.go
+52-8
diff --git a/‎coderd/database/queries/users.sql
+9 b/‎coderd/database/queries/users.sql
+9
@@ -0,0 +1,3 @@
+ALTER TABLE ONLY users
+	DROP COLUMN last_seen_at;
+
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY users
+	ADD COLUMN last_seen_at timestamp NOT NULL DEFAULT '0001-01-01 00:00:00+00:00';
@@ -157,6 +157,15 @@ SET
 WHERE
 	id = $1 RETURNING *;
 
+-- name: UpdateUserLastSeenAt :one
+UPDATE
+	users
+SET
+	last_seen_at = $2,
+	updated_at = $3
+WHERE
+	id = $1 RETURNING *;
+
 
 -- name: GetAuthorizationUserRoles :one
 -- This function returns roles for authorization purposes. Implied member roles
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+ALTER TABLE ONLY users`
	`2`	`+ ADD COLUMN last_seen_at timestamp NOT NULL DEFAULT '0001-01-01 00:00:00+00:00';`