Automated SQL Backups with Instant Schema Inspection

-- In-Process Streaming Backup: remote libSQL / Turso SQLite
-- Reconstructs DDL from sqlite_schema & preserves sqlite_sequence
PRAGMA foreign_keys = OFF;
BEGIN TRANSACTION;

CREATE TABLE "users" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "email" TEXT NOT NULL UNIQUE,
  "role" TEXT NOT NULL DEFAULT 'member',
  "created_at" TEXT NOT NULL DEFAULT (CURRENT_TIMESTAMP)
);

-- Preserve autoincrement sequence counter
INSERT INTO "sqlite_sequence" ("name", "seq") VALUES ('users', 4281);

-- Batched streaming insert
INSERT INTO "users" ("id", "email", "role", "created_at") VALUES
  (1, 'alice@example.com', 'admin', '2026-03-14 09:12:00'),
  (2, 'bob@example.com', 'member', '2026-03-14 09:15:30'),
  (3, 'carol@example.com', 'member', '2026-03-14 09:21:45');

CREATE INDEX "idx_users_email" ON "users" ("email");
COMMIT;