yi1SSKrSSKrSSKrSSKrSSKJr SSKJr SSKJ r \R"\ 5R5RRr\S- r\R "SS5R#5S;r\R "S 5=(d \R&"S 5r"S S \5r\"\R,R/\S S5S9rSrSrSrSrg)N)Jinja2Templates) StaticFiles)Responsez db.sqlite3APP_ENVdev)prod productionAPP_SECRET_KEY@c0^\rSrSrS\4U4SjjrSrU=r$)CachedStaticFilesreturncF>[TU]"U0UD6nSURS'U$)Nz#public, max-age=31536000, immutablez Cache-Control)super file_responseheaders)selfargskwargsresp __class__s ,/home/mario/Escritorio/furbo/app/database.pyrCachedStaticFiles.file_responses*w$d5f5(M _% )__name__ __module__ __qualname____firstlineno__rr__static_attributes__ __classcell__)rs@rr r srr app templates) directorycv[R"[SSS9n[RUlUR S5 UR S5 UR S5 UR S5 UR S5 UR S5 UR S 5 U$![ a U$f=f) NF)isolation_levelcheck_same_threadzPRAGMA foreign_keys = ON;zPRAGMA journal_mode = WAL;zPRAGMA synchronous = NORMAL;zPRAGMA busy_timeout = 5000;zPRAGMA cache_size = -20000;zPRAGMA temp_store = MEMORY;zPRAGMA mmap_size = 268435456;)sqlite3connectDB_PATHRow row_factoryexecute Exception)conns rget_connr1s ??7DE RD{{DLL,-LL-.LL/0LL./LL./LL./  45 K   K sB** B87B8c[5$)N)r1rrr_connr3)s :rcURSUS35R5Vs1sHo"SiM sn$s snf![a [5s$f=f)NzPRAGMA table_info())r.fetchallr/set)r0tablers r_table_columnsr;,sU"ll-?wa+HIRRTUT!TUUU u s%=8==AAc[5nUR5nURS5 URS5 URS5R5Vs1sHo"SiM nnSU;aURS5 SU;aURS5 S U;aURS 5 URS 5 URS 5 URS 5 URS5 URS5 URS5 URS5 URS5 URS5R5Vs1sHo"SiM nnSU;a"URS5 URS5 SU;aURS5 SU;aURS5 SU;aURS5 SU;aURS5 SU;aURS 5 S U;aURS!5 S"U;aURS#5 S$U;aURS%5 S&U;aURS'5 S(U;aURS)5 S*U;aURS+5 URS,5 URS-5R5Vs1sHo"SiM nnS*U;aURS.5 URS/5 URS05 URS15 URS25 URS35 URS45 URS55 URS65 URS75 URS85 URS95 URS:5 URS;5 URS<5 URS=5 URS>5 URS?5 URS@5 URSA5 UR 5 SSS5 gs snfs snfs snf!,(df  g=f)BNzPRAGMA foreign_keys=ONa CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, email TEXT NOT NULL UNIQUE, name TEXT NOT NULL, first_name TEXT, last_name TEXT, phone TEXT, password_hash TEXT NOT NULL, role TEXT NOT NULL DEFAULT 'alumno', created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%S','now','localtime')) ) zPRAGMA table_info(users)r6 first_namez,ALTER TABLE users ADD COLUMN first_name TEXT last_namez+ALTER TABLE users ADD COLUMN last_name TEXTphonez'ALTER TABLE users ADD COLUMN phone TEXTa1 CREATE TABLE IF NOT EXISTS user_profile ( user_id INTEGER PRIMARY KEY, phone TEXT, avatar TEXT, city TEXT, dni TEXT, birth_date TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a CREATE TABLE IF NOT EXISTS user_sports ( user_id INTEGER PRIMARY KEY, team TEXT, category TEXT, position TEXT, dominant_foot TEXT, strengths TEXT, weaknesses TEXT, injury_history TEXT, training_type TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a CREATE TABLE IF NOT EXISTS user_health ( user_id INTEGER PRIMARY KEY, physical_work INTEGER, physical_work_details TEXT, smoking INTEGER, alcohol INTEGER, recovery TEXT, chest_pain INTEGER, discomfort INTEGER, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) ap CREATE TABLE IF NOT EXISTS user_consent ( user_id INTEGER PRIMARY KEY, whatsapp_content INTEGER, video_permission INTEGER, privacy_acceptance INTEGER, data_confirmation INTEGER, agreement INTEGER, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a0 CREATE TABLE IF NOT EXISTS user_guardians ( user_id INTEGER PRIMARY KEY, occupation TEXT, study_place TEXT, parent_name TEXT, parent_email TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a9 CREATE TABLE IF NOT EXISTS user_marketing ( user_id INTEGER PRIMARY KEY, found_us TEXT, enjoyment TEXT, nerves_confidence TEXT, additional_comments TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) z CREATE TABLE IF NOT EXISTS user_finance ( user_id INTEGER PRIMARY KEY, matricula_eur REAL NOT NULL DEFAULT 0, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a CREATE TABLE IF NOT EXISTS reservations ( id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%S','now','localtime')), date TEXT NOT NULL, time TEXT, duration_minutes INTEGER, price_cents INTEGER NOT NULL DEFAULT 0, name TEXT, email TEXT, phone TEXT, notes TEXT, user_id INTEGER, status TEXT NOT NULL DEFAULT 'confirmada', docente_id INTEGER NOT NULL, paid INTEGER NOT NULL DEFAULT 0, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE SET NULL, FOREIGN KEY(docente_id) REFERENCES users(id) ON DELETE CASCADE ) zPRAGMA table_info(reservations) created_atz3ALTER TABLE reservations ADD COLUMN created_at TEXTzmUPDATE reservations SET created_at = strftime('%Y-%m-%dT%H:%M:%S','now','localtime') WHERE created_at IS NULLtimez-ALTER TABLE reservations ADD COLUMN time TEXTduration_minuteszrds .+ << ! ) ) + 2 2 9 9 \ ! ))Iu % + + -1G G YY' ( EG,A,A",E   bggll8UK&P Q   Er