gQuest

Database Viewer

Browse the SQL that builds any database used across the lessons, without running it.

Loaded: Lesson 3 database ยท insert-update-delete.database-init

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  email TEXT NOT NULL,
  active BOOLEAN NOT NULL DEFAULT true
);


INSERT INTO users (name, email, active)
VALUES
  ('Ada Lovelace', 'ada@example.com', true),
  ('Grace Hopper', 'grace@example.com', true),
  ('Alan Turing', 'alan@example.com', true);