Overview
Comment: | Add missing changes from trunk lost when changing the symlink |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | dev |
Files: | files | file ages | folders |
SHA3-256: |
9f4e4538a86ab7f0200e53513b4e4b2e |
User & Date: | bohwaz on 2022-08-27 20:13:04 |
Other Links: | branch diff | manifest | tags |
Context
2022-08-28
| ||
05:34 | schema: Fix webdav locks table, change sessions table to have the primary key on the selector check-in: bf01e0222f user: bohwaz tags: dev | |
2022-08-27
| ||
20:13 | Add missing changes from trunk lost when changing the symlink check-in: 9f4e4538a8 user: bohwaz tags: dev | |
19:37 | We need to use ErrorDocument as well, as .php files may not be handled by FallbackResource. A bug has been reported to the mod_php Debian maintainers. check-in: 3911250bfd user: bohwaz tags: dev | |
Changes
Modified src/include/data/1.2.0_schema.sql from [8701148cc0] to [5d015730f5].
︙ | ︙ | |||
46 47 48 49 50 51 52 53 54 55 56 57 58 59 | ( signal TEXT NOT NULL, plugin TEXT NOT NULL REFERENCES plugins (id), callback TEXT NOT NULL, PRIMARY KEY (signal, plugin) ); CREATE TABLE IF NOT EXISTS searches -- Saved searches ( id INTEGER NOT NULL PRIMARY KEY, id_user INTEGER NULL REFERENCES users (id) ON DELETE CASCADE, -- If not NULL, then search will only be visible by this user label TEXT NOT NULL, created TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP CHECK (datetime(created) IS NOT NULL AND datetime(created) = created), | > > > > > > > > > > > > > | 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 | ( signal TEXT NOT NULL, plugin TEXT NOT NULL REFERENCES plugins (id), callback TEXT NOT NULL, PRIMARY KEY (signal, plugin) ); CREATE TABLE IF NOT EXISTS api_credentials ( id INTEGER NOT NULL PRIMARY KEY, label TEXT NOT NULL, key TEXT NOT NULL, secret TEXT NOT NULL, created TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, last_use TEXT NULL, access_level INT NOT NULL ); CREATE UNIQUE INDEX IF NOT EXISTS api_credentials_key ON api_credentials (key); CREATE TABLE IF NOT EXISTS searches -- Saved searches ( id INTEGER NOT NULL PRIMARY KEY, id_user INTEGER NULL REFERENCES users (id) ON DELETE CASCADE, -- If not NULL, then search will only be visible by this user label TEXT NOT NULL, created TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP CHECK (datetime(created) IS NOT NULL AND datetime(created) = created), |
︙ | ︙ | |||
189 190 191 192 193 194 195 | description TEXT NULL, amount INTEGER NULL, formula TEXT NULL, -- Formula to calculate fee amount dynamically (this contains a SQL statement) id_service INTEGER NOT NULL REFERENCES services (id) ON DELETE CASCADE, id_account INTEGER NULL REFERENCES acc_accounts (id) ON DELETE SET NULL CHECK (id_account IS NULL OR id_year IS NOT NULL), -- NULL if fee is not linked to accounting, this is reset using a trigger if the year is deleted | | > | 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 | description TEXT NULL, amount INTEGER NULL, formula TEXT NULL, -- Formula to calculate fee amount dynamically (this contains a SQL statement) id_service INTEGER NOT NULL REFERENCES services (id) ON DELETE CASCADE, id_account INTEGER NULL REFERENCES acc_accounts (id) ON DELETE SET NULL CHECK (id_account IS NULL OR id_year IS NOT NULL), -- NULL if fee is not linked to accounting, this is reset using a trigger if the year is deleted id_year INTEGER NULL REFERENCES acc_years (id) ON DELETE SET NULL, -- NULL if fee is not linked to accounting id_analytical INTEGER NULL REFERENCES acc_accounts (id) ON DELETE SET NULL ); CREATE TABLE IF NOT EXISTS services_users -- Records of services and fees linked to users ( id INTEGER NOT NULL PRIMARY KEY, id_user INTEGER NOT NULL REFERENCES users (id) ON DELETE CASCADE, |
︙ | ︙ |