Turn on a new «is_active» flag for every existing user
Table users already has several rows, and you need to add an «is active» flag so existing users automatically get TRUE instead of failing the not-null requirement. Build users with id (primary key) and a required email (up to 255 chars), insert three test rows, then add an is_active column of type BOOLEAN, required, with a default of TRUE — old rows pick up the default automatically.
Just CREATE/ALTER/DROP — no trailing SELECT needed.
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inNo starting schema
This task starts with no tables — you'll create them via CREATE TABLE.
Focus radio
Paused · SomaFM · Fluid