(j=SrSSKrSSKrSSKrSSKJrJr SSKrSSKr Sr \R"S5r /SQ/SQS.r \"\R!\ S \ S -55rS rS rS r"SS\5rSrSrSrSrSrSrSrSrSrSr Sr!Sr"Sr#Sr$Sr%Sr&S r'S!r(S"r)S#r*S$r+S+S%jr,S&r-S'r.S(r/S)r0S*r1g),zAccounts and tenancy: admin (platform) -> parent (tenant) -> kid (sub-tenant). Every parent owns only the kids whose parent_id is theirs; a parent may own at most max_kids kids. A suspended parent blocks its own login and the logins of all its kids.N)generate_password_hashcheck_password_hash)adminparentkidz^[a-z0-9][a-z0-9._-]{2,29}$)u🐱u🐶u🦊u🐼u🐨u🐯u🦁u🐸u🐵u🦄u🐰u🐻u🐧u🦉u🐙u🦖u🐬u🦋u🐢🚀⚽u🌟)u 🧑‍🚀u🦸u🥷u🧙u🐺u🦅u🐉u🦈u🎧u🎮u🏀r u🎸u🛹u📷u🧭u⚡u🔥u🌍ru🏆u🎯)kidsjuniorr r c[R"U5(a&[R"U5RSS5OSn[RU[S5S$)zcFirst avatar of the age band of the kid's course level (a cat for 8 years old, an explorer for 11).bandr r)CURlevelgetAVATARS_BY_BAND)rrs F:\Yaseen\AI\French2\accounts.pydefault_avatarrsJ3699U3C3C399U    /D   t_V%< =a @@a CREATE TABLE 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 1, created_at TEXT DEFAULT (datetime('now','localtime')), last_login TEXT )c\rSrSrSrSrg) AccountError.z:A user-facing problem (shown in Arabic in the dashboards).N)__name__ __module__ __qualname____firstlineno____doc____static_attributes__rrrrr.sDrrcN[R"5nURS5R5=(d SS0S=(d SnSU;GaCURS5R 5Vs/sHo"SPM nnURS5 UR[ 5 SVs/sH oDU;dM UPM nnURS S R U5S S R U5S 35 URS 5 URS5R5nU(aURSUS45 URS5R5nU(aUSS:XaURS5 UR5 SURS5R 5Vs/sHo"SPM sn;aURS5 URS[S45 UR5 UR5 gs snfs snfs snf)zZUpgrade the old users table (kid/parent only) to the tenancy schema, keeping ids and data.z0SELECT sql FROM sqlite_master WHERE name='users'sqlz'admin'zPRAGMA table_info(users)namez%ALTER TABLE users RENAME TO users_old)idusernamerole password_hash display_name created_atzINSERT INTO users (,z ) SELECT z FROM users_oldzDROP TABLE users_oldz