Database Migrations & DDL History

Declarative version control for database schemas. Apply UP migrations or execute DOWN rollbacks in SQLite.

Total Migrations

Applied

Pending

Engine State

SQLite WASM v3

Migration History & Queue

20261001_001

Applied

initial_core_schema

Initial foundational tables: students, courses, products

Applied: 2026-10-01 10:00:0012.4 ms

20261015_002

Applied

add_enrollments_relations

Add relational enrollments table linking students and courses with foreign keys

Applied: 2026-10-15 14:30:008.2 ms

20261028_003

Pending

add_course_reviews

Add student reviews and rating feedback for courses

20261030_004

Pending

create_performance_indexes

Create B-Tree indexes on student GPA and product categories for fast scan avoidance

20261101_005

Pending

create_audit_log_triggers

Track schema changes and record mutations in an automated audit table

20261001_001initial_core_schema

Initial foundational tables: students, courses, products

▲ Forward Migration (UP SQL)Executes on Apply

-- Core entities
CREATE TABLE IF NOT EXISTS students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  age INTEGER,
  grade TEXT,
  favorite_subject TEXT,
  gpa REAL
);

CREATE TABLE IF NOT EXISTS courses (
  course_id INTEGER PRIMARY KEY,
  course_name TEXT NOT NULL,
  teacher TEXT,
  credits INTEGER,
  department TEXT
);

CREATE TABLE IF NOT EXISTS products (
  product_id INTEGER PRIMARY KEY,
  title TEXT NOT NULL,
  category TEXT,
  price REAL,
  stock INTEGER,
  rating REAL
);

▼ Rollback Script (DOWN SQL)Executes on Revert

DROP TABLE IF EXISTS products;
DROP TABLE IF EXISTS courses;
DROP TABLE IF EXISTS students;

Migration Console Logs

No migration runner actions logged yet.