SQLite Multi-Table Administration Task
SQLite Multi-Table Administration Task: a task in repo2rlenv-seta-evol (Harbor dataset). There is a SQLite database at /home/user/sitedb/users.db . It already contains a users table with columns: id (INTEGER PRIMARY KEY AUTOINCREMENT), username (TEXT NOT NULL UNIQUE), email (TEXT NOT NULL), role…
The task
There is a SQLite database at `/home/user/sitedb/users.db`. It already contains a `users` table with columns: `id` (INTEGER PRIMARY KEY AUTOINCREMENT), `username` (TEXT NOT NULL UNIQUE), `email` (TEXT NOT NULL), `role` (TEXT NOT NULL DEFAULT 'viewer'), `active` (INTEGER NOT NULL DEFAULT 1), `created_at` (TEXT NOT…
Part of FineEnvs/repo2rlenv-seta-evol.