AcadeNice/corentin_wakdo
7
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions

feat(db): initial schema DDL (21 tables) + migration runner #6

Merged
Corentin merged 2 commits from feat/p2-db-foundation into dev 2026-06-15 15:36:05 +02:00
Conversation 0 Commits 2 Files changed 5 +659 -4
Corentin commented 2026-06-15 15:22:21 +02:00
Owner
Copy link

Transcription executable du MLD vers MariaDB.

  • db/migrations/0001_init_schema.sql : 21 tables (catalogue, ingredients/stock, order, RBAC, securite), FK + ON DELETE, CHECK, index, ENUM. InnoDB / utf8mb4.
  • db/migrate.sh : runner idempotent (table schema_migrations), cible wakdo-db, lit .env.
  • db/README.md : doc migrations.

Verifie : applique sans erreur sur MariaDB 11.4 reel (21 tables, 28 FK, 22 CHECK, polymorphisme XOR, coherence TTC, stock signe). Idempotence testee (re-run = 0 applique). DDL genere depuis le MLD via workflow (generation + verif fidelite + verif executable sur base scratch).

A noter : make migrate est encore le stub ; le runner est db/migrate.sh. Cabler make migrate -> db/migrate.sh demande un commit du Makefile (qui porte aussi le target docs-render non commite) : a trancher (politique Makefile).

Base : dev. Type : feat(db) / Bloc 2 (Cr 3.b construction BDD).

Transcription executable du MLD vers MariaDB. - db/migrations/0001_init_schema.sql : 21 tables (catalogue, ingredients/stock, order, RBAC, securite), FK + ON DELETE, CHECK, index, ENUM. InnoDB / utf8mb4. - db/migrate.sh : runner idempotent (table schema_migrations), cible wakdo-db, lit .env. - db/README.md : doc migrations. Verifie : applique sans erreur sur MariaDB 11.4 reel (21 tables, 28 FK, 22 CHECK, polymorphisme XOR, coherence TTC, stock signe). Idempotence testee (re-run = 0 applique). DDL genere depuis le MLD via workflow (generation + verif fidelite + verif executable sur base scratch). A noter : make migrate est encore le stub ; le runner est db/migrate.sh. Cabler make migrate -> db/migrate.sh demande un commit du Makefile (qui porte aussi le target docs-render non commite) : a trancher (politique Makefile). Base : dev. Type : feat(db) / Bloc 2 (Cr 3.b construction BDD).
Corentin added 1 commit 2026-06-15 15:22:22 +02:00
feat(db): initial schema DDL (21 tables) + idempotent migration runner
All checks were successful
CI / secret-scan (push) Successful in 10s
Details
CI / php-lint (push) Successful in 23s
Details
CI / static-tests (push) Successful in 6s
Details
CI / secret-scan (pull_request) Successful in 9s
Details
CI / php-lint (pull_request) Successful in 23s
Details
CI / static-tests (pull_request) Successful in 4s
Details
c70fe2bcfd
Corentin added 1 commit 2026-06-15 15:34:47 +02:00
feat(db): wire make migrate/seed to db runners; add seed runner; commit docs-render target
All checks were successful
CI / secret-scan (push) Successful in 9s
Details
CI / php-lint (push) Successful in 23s
Details
CI / static-tests (push) Successful in 5s
Details
CI / php-lint (pull_request) Successful in 19s
Details
CI / secret-scan (pull_request) Successful in 9s
Details
CI / static-tests (pull_request) Successful in 6s
Details
1244e7f8c3
Corentin merged commit 41f9c96d33 into dev 2026-06-15 15:36:05 +02:00
Corentin deleted branch feat/p2-db-foundation 2026-06-15 15:36:06 +02:00
Sign in to join this conversation.
Reviewers
No reviewers
Labels
Clear labels   
auto-merge

Fusion automatique sur CI verte

No labels
auto-merge
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: AcadeNice/corentin_wakdo#6
No description provided.
Delete branch "feat/p2-db-foundation"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?