Docs  /  Program MySQL databases

Program MySQL databases

_DatabaseFunctions::InitializeProgramDatabases() is the database creator. It is idempotent (CREATE DATABASE/TABLE IF NOT EXISTS) and runs at program startup (see AugmentedIntelligence.cpp).

Catalog (all logical databases)

Database Role
ai_settings Primary configuration store (settings tables, application profiles, automation, passwords, legacy RL mirrors). See MySQLConfiguration.md.
rl_checkpoints All domain RL / MathNN / CAD-DCC checkpoint tables
mathnn_learning Learn meta / transfer / quantize / federate / promote + events
reality_construct Construct voxels + events + checkpoints
vision (or mysql_vision_database) Camera frames, reading OCR, kinesthetic
sound Microphone / sound tables
thought LLM thought logs
computer Computer entries + RL episode logs
working_memory / short_term_memory / long_term_memory Memory entry stores
dictionary Dictionary + wiki_vectors
wikipedia_pos_tagged_words / _sentences Wiki POS destinations
ImportantObjects / objects / LongTermMemory / LTM vision cams Object & LTM vision
us_code / case_law Legal corpora
ai_inventory Cooking / inventory items
receipts Receipt ingestion
semantic_vectors Offline embedding store
semantic_knowledge GloVe + wiki + corpus multi-*2vec (books/Bible/media); see BookBibleMediaVectors.md
ai_features AI audit log, dialogue state, intent corrections, memory promotion queue, RAG/usage logs
bible KJV + ASV verse tables: bible_verses_kjv, bible_verses_asv (see corpus / bible load-db)
bible_kjv Legacy per-book KJV chapter tables (optional)
discoveries Optional MySQL mirror of discovery journal
cad_dcc_rl CAD/DCC RL episode logs
portal_metrics Portal export snapshots
Remote mirror names Same logical DBs when remote_mysql_* settings differ

Charset: utf8mb4 / utf8mb4_unicode_ci.

Post-create steps

  1. _SettingsMySQL::EnsureStorageTables() — settings + automation + profiles schema
  2. _SettingsMySQL::SeedDefaultProfilesIfMissing() — includes v11 discovery/WP/cad_rl/simple_nn profiles
  3. _Settings::LoadConfiguration() — optional settings.txt migrate, then SeedSettingsIfEmpty + LoadAll (MySQL is source of truth)
  4. _RLCheckpointMySQL::EnsureAllTables() — full RL + learning + construct tables

Operator

Startup creates everything automatically when MySQL credentials work. Bootstrap credentials remain in settings.txt (host/user/pass only by default).

Manual re-run is available wherever the product exposes database init (historically tied to settings/MySQL bootstrap). From code:

_DatabaseFunctions::InitializeProgramDatabases();
_Settings::LoadConfiguration();
Generated from the project markdown docs on 2026-07-24. This is a static, self-contained site.