The Architecture of Offline-First: Why We Ban Analytics, Sentry, and Network Permissions

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="app.nook.games">

    <!-- CRITICAL ARCHITECTURAL AXIOM:
         android.permission.INTERNET is intentionally OMITTED.
         The OS kernel physically prevents the runtime from opening sockets,
         making network exfiltration mathematically impossible. -->

    <application
        android:allowBackup="true"
        android:dataExtractionRules="@xml/data_extraction_rules"
        android:fullBackupContent="@xml/backup_rules"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/Theme.NookGames">
        
        <activity
            android:name=".MainActivity"
            android:exported="true"
            android:screenOrientation="portrait"
            android:configChanges="orientation|screenSize|screenLayout|keyboardHidden">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />
                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>
</manifest>

CREATE TABLE IF NOT EXISTS game_sessions (
    id TEXT PRIMARY KEY NOT NULL,
    game_slug TEXT NOT NULL,
    collection TEXT NOT NULL,
    seed INTEGER NOT NULL,
    tier TEXT NOT NULL, -- 'gentle', 'standard', 'deep', 'beyond_master'
    state_blob BLOB NOT NULL,
    move_count INTEGER DEFAULT 0,
    elapsed_seconds INTEGER DEFAULT 0,
    is_completed INTEGER DEFAULT 0,
    created_at INTEGER NOT NULL,
    updated_at INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS move_journal (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    session_id TEXT NOT NULL REFERENCES game_sessions(id) ON DELETE CASCADE,
    move_index INTEGER NOT NULL,
    delta_payload TEXT NOT NULL,
    timestamp INTEGER NOT NULL
);

CREATE INDEX IF NOT EXISTS idx_journal_session ON move_journal(session_id, move_index);