Differences From Artifact [efe750515a]:
- File archives/0.9.1_schema.sql — part of check-in [e807e8f5d7] at 2020-10-25 01:07:04 on branch dev — Add 2018 accounting chart for France, use it for upgrade and install, and archive old SQL schemas and migrations (user: bohwaz, size: 14209) [annotate] [blame] [check-ins using] [more...]
- File src/include/data/0.9.1_schema.sql — part of check-in [757810afbb] at 2020-01-20 00:12:49 on branch dev — Garder les anciens schémas SQL pour les migrations qui les utilisent (user: bohwaz, size: 14209) [annotate] [blame] [check-ins using]
- File src/include/data/schema.sql — part of check-in [3ef9a80ec7] at 2018-09-04 00:05:28 on branch dev — Recherche avancée fonctionnelle (user: bohwaz, size: 14209) [annotate] [blame] [check-ins using]
To Artifact [c8df01c2dd]:
- File archives/0.9.5_schema.sql — part of check-in [e807e8f5d7] at 2020-10-25 01:07:04 on branch dev — Add 2018 accounting chart for France, use it for upgrade and install, and archive old SQL schemas and migrations (user: bohwaz, size: 14532) [annotate] [blame] [check-ins using] [more...]
- File src/include/data/0.9.5_schema.sql — part of check-in [757810afbb] at 2020-01-20 00:12:49 on branch dev — Garder les anciens schémas SQL pour les migrations qui les utilisent (user: bohwaz, size: 14532) [annotate] [blame] [check-ins using]
- File src/include/data/schema.sql — part of check-in [08954e712c] at 2019-12-03 17:40:32 on branch trunk — Ajout vérification de mot de passe compromis avec l'API HaveIBeenPwned, et mot de passe minimum de 10 caractères au lieu de 8 (user: bohwaz, size: 14532) [annotate] [blame] [check-ins using]
︙ | ︙ | |||
394 395 396 397 398 399 400 | id_membre INTEGER NULL REFERENCES membres (id) ON DELETE CASCADE, -- Si non NULL, alors la recherche ne sera visible que par le membre associé intitule TEXT NOT NULL, creation TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP CHECK (datetime(creation) IS NOT NULL AND datetime(creation) = creation), cible TEXT NOT NULL, -- "membres" ou "compta_journal" type TEXT NOT NULL, -- "json" ou "sql" contenu TEXT NOT NULL ); | > > > > > > > > > > > > > > | 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 | id_membre INTEGER NULL REFERENCES membres (id) ON DELETE CASCADE, -- Si non NULL, alors la recherche ne sera visible que par le membre associé intitule TEXT NOT NULL, creation TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP CHECK (datetime(creation) IS NOT NULL AND datetime(creation) = creation), cible TEXT NOT NULL, -- "membres" ou "compta_journal" type TEXT NOT NULL, -- "json" ou "sql" contenu TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS compromised_passwords_cache -- Cache des hash de mots de passe compromis ( hash TEXT NOT NULL PRIMARY KEY ); CREATE TABLE IF NOT EXISTS compromised_passwords_cache_ranges -- Cache des préfixes de mots de passe compromis ( prefix TEXT NOT NULL PRIMARY KEY, date INTEGER NOT NULL ); |