je^SSKrSSKrSSKr\RR S5r\(dk\R R\R R\R R\ 55SSS5r\R R\5rSr Sr \S:Xa\ "5 gg) NDB_PATHz.._Datazscience_grades.dbc[R"[SS9n[RUlUR S5 U$)N )timeoutzPRAGMA foreign_keys = ON)sqlite3connectrRow row_factoryexecute)conns db_init.pyget_dbr s0 ??7B /D{{DLL+, Kc [R"[RR[5SS9 [ 5nUR 5nURS5 SURS5R5Vs/sHo"SPM sn;aURS5 SURS 5R5Vs/sHo"SPM sn;aURS 5 /S QnUHupEpgnURS XEXgU45 M UR5 UR5 [S [35 gs snfs snf)NT)exist_oka CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, role TEXT NOT NULL CHECK(role IN ('admin','parent','kid')), password_hash TEXT NOT NULL, display_name TEXT NOT NULL, parent_id INTEGER, max_kids INTEGER DEFAULT 3, active INTEGER DEFAULT 1, avatar TEXT DEFAULT '', unlock_all INTEGER DEFAULT 0, course_level INTEGER DEFAULT 2, created_at TEXT DEFAULT (datetime('now','localtime')), last_login TEXT ); CREATE TABLE IF NOT EXISTS units ( id INTEGER PRIMARY KEY AUTOINCREMENT, code TEXT NOT NULL, name TEXT NOT NULL, color TEXT NOT NULL, icon TEXT NOT NULL, sort_order INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS chapters ( id INTEGER PRIMARY KEY AUTOINCREMENT, unit_id INTEGER NOT NULL REFERENCES units(id), code TEXT NOT NULL, name TEXT NOT NULL, sort_order INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS sections ( id INTEGER PRIMARY KEY AUTOINCREMENT, chapter_id INTEGER NOT NULL REFERENCES chapters(id), code TEXT NOT NULL, name TEXT NOT NULL, sort_order INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS activities ( id INTEGER PRIMARY KEY AUTOINCREMENT, section_id INTEGER NOT NULL REFERENCES sections(id), activity_type TEXT NOT NULL, title TEXT NOT NULL, data_json TEXT NOT NULL, points INTEGER DEFAULT 10, sort_order INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS experiments ( id INTEGER PRIMARY KEY AUTOINCREMENT, section_id INTEGER NOT NULL REFERENCES sections(id), title TEXT NOT NULL, data_json TEXT NOT NULL, points INTEGER DEFAULT 20, sort_order INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS activity_attempts ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL REFERENCES users(id), activity_id INTEGER NOT NULL REFERENCES activities(id), score REAL NOT NULL, points_earned INTEGER NOT NULL, answers_json TEXT, time_spent INTEGER DEFAULT 0, attempted_at TEXT DEFAULT (datetime('now','localtime')) ); CREATE TABLE IF NOT EXISTS experiment_completions ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL REFERENCES users(id), experiment_id INTEGER NOT NULL REFERENCES experiments(id), completed INTEGER DEFAULT 0, notes TEXT DEFAULT '', completed_at TEXT DEFAULT (datetime('now','localtime')) ); CREATE TABLE IF NOT EXISTS badges ( id INTEGER PRIMARY KEY AUTOINCREMENT, code TEXT UNIQUE NOT NULL, name TEXT NOT NULL, description TEXT NOT NULL, icon TEXT NOT NULL, color TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS user_badges ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL REFERENCES users(id), badge_id INTEGER NOT NULL REFERENCES badges(id), awarded_at TEXT DEFAULT (datetime('now','localtime')), UNIQUE(user_id, badge_id) ); CREATE TABLE IF NOT EXISTS section_progress ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL REFERENCES users(id), section_id INTEGER NOT NULL REFERENCES sections(id), status TEXT DEFAULT 'not_started', best_score REAL DEFAULT 0, total_points INTEGER DEFAULT 0, activities_completed INTEGER DEFAULT 0, last_accessed TEXT, UNIQUE(user_id, section_id) ); CREATE TABLE IF NOT EXISTS user_stats ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL REFERENCES users(id), total_points INTEGER DEFAULT 0, total_stars INTEGER DEFAULT 0, streak_days INTEGER DEFAULT 0, last_active_date TEXT, UNIQUE(user_id) ); levelzPRAGMA table_info(units)namez4ALTER TABLE units ADD COLUMN level INTEGER DEFAULT 2partialz$PRAGMA table_info(activity_attempts)zBALTER TABLE activity_attempts ADD COLUMN partial INTEGER DEFAULT 0) ) first_stepsz First StepszComplete your first activitystar#FFD700) plant_expertz Plant Expertz%Complete all Plant chapter activitiesleafz#4CAF50) body_masterz Body Masterz&Complete all People chapter activitiesheartz#E91E63) matter_geniusz Matter Geniusz(Complete all States of Matter activitiesatomz#2196F3) force_heroz Force Heroz'Complete all Motion & Forces activitiesboltz#FF9800)earth_guardianzEarth Guardianz%Complete all Earth Science activitiesglobez#8BC34A) sky_explorerz Sky ExplorerzComplete all The Sky activitiesmoonz#9C27B0) perfect_scorez Perfect ScorezGet 100% on any activitytrophyr) scientistzYoung ScientistzComplete 5 experimentsflaskz#00BCD4)streak_7z Week WarriorzLearn 7 days in a rowfirez#FF5722) all_completezScience ChampionzComplete the entire workbookcrownr) quiz_masterz Quiz MasterzComplete 20 activitiesbrainz#7C4DFFzRINSERT OR IGNORE INTO badges (code,name,description,icon,color) VALUES (?,?,?,?,?)zDatabase initialized at ) osmakedirspathdirnamerrcursor executescriptr fetchallcommitcloseprint) r crbadgescoderdesciconcolors rinit_dbr@sKK(48 8D AOOww t!))4N*O*X*X*Z[*ZQy*Z[[ HIAII6\,],f,f,hi,hq6,hii VW F*0%D ft51 3*0 KKMJJL $WI ./3\is E  E__main__)rr/hashlibenvirongetrr1joinr2abspath__file__normpathrr@__name__rrrKs  **.. #ggll277??277??8+DEtWVijGggw'GX0v z Ir