mirror of https://codeberg.org/PostERG/xamxam.git synced 2026-09-25 01:53:03 +02:00

Files

T

History

Pontoporeia 30a16f9e9e fix: display db timestamps in Brussels time

(heure de dépôt was showing UTC)

- feat: add date_depot column (real TFE deposit date)
with CSV round-trip + Brussels→UTC sanitization
- fix: keep PHP default tz at UTC to preserve token/share-link
 expiry consistency; convert to Brussels only in db_datetime()

2026-09-18 16:26:36 +02:00

cache

fix: author name casing not updating — use ID lookup priority

2026-06-10 00:17:00 +02:00

logs

Fix logs being captured

2026-06-10 00:21:56 +02:00

tfe

cleanup: remove _write guard — FilePond external API doesn't expose _write

2026-06-10 00:18:49 +02:00

theses

cleanup modal: list stale files to remove; storage restructure: documents/ → {objet}/

2026-05-19 23:58:51 +02:00

tmp

Fix dialog margins, add admin-dialog__body/styles, give trash page horizontal margins

2026-05-19 23:58:51 +02:00

.~lock.Database_TFE_test.csv#

fix CSV importer AP/orientation name resolution + seed missing AP programs

2026-04-24 23:03:49 +02:00

.gitkeep

feat: extract MediaController, wire into Dispatcher, delete media.php

2026-04-20 12:32:00 +02:00

database.sqlite

feat: mandatory auto-generated passwords for share links + admin password copy/regeneration + password gate rate limiting

2026-05-19 00:08:06 +02:00

README.md

logs: standardise log filenames to xamxam-{service}-{date}.log

2026-08-24 11:34:34 +02:00

schema.sql

fix: display db timestamps in Brussels time

2026-09-18 16:26:36 +02:00

schema.sql.new

Reintroduce TFE duration metadata: DB columns, form fields, controllers, views, and migration

2026-06-15 15:56:52 +02:00

xamxam.sqlite

fix: spurious HTMX console warnings from checkbox-list default hx-include

2026-05-19 00:08:05 +02:00

README.md

Database documentation

XAMXAM stores its data in a SQLite database. See also the top-level docs/database.md.

Quick start

Database file: xamxam.db
Schema (baseline + seed): schema.sql
Migrations: applied set under app/migrations/applied/ (run via just migrate)

just query          # open an interactive sqlite3 shell on xamxam.db
just init-db        # (re)create xamxam.db from schema.sql
just reset-db       # rm xamxam.db + init-db
just migrate        # run pending migrations

Files here

Path	Purpose
`xamxam.db`	The live SQLite database
`schema.sql`	Full, fully-migrated schema + seed data (regenerated from the local DB)
`backups/`	`just backup-snapshot` hot-backups (`*.db.gz`)
`cache/`	Runtime cache (rate limits, etc.)
`logs/`	Dev-only runtime logs (cli-server); production logs live in `/var/log/xamxam/`
`covers/`	Cover images
`theses/`, `tfe/`, `tmp/`	Uploaded files / staging