Overview
| Comment: | Fixed foreign key constraint in table 'variants'. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | documentation |
| Files: | files | file ages | folders |
| SHA3-256: |
d9dce7106a73a3eb3a7d0ae42fc99ac5 |
| User & Date: | florian 2024-07-30 17:44:08 |
Context
|
2024-07-31
| ||
| 14:43 | Added and documented column 'title' in table 'formats'. check-in: 1d25e1d09c user: florian tags: documentation | |
| 14:21 | Merged changes from documentation. check-in: 3df69d54d7 user: florian tags: development | |
|
2024-07-30
| ||
| 17:44 | Fixed foreign key constraint in table 'variants'. check-in: d9dce7106a user: florian tags: documentation | |
| 16:19 | Updated required Luna LMS version in demo database. check-in: 51e2606a5f user: florian tags: documentation | |
Changes
Changes to dokumentation/programmierung.md.
| ︙ | ︙ | |||
427 428 429 430 431 432 433 |
... "key" INTEGER,
... "identifier" TEXT UNIQUE,
... "filename" TEXT NOT NULL,
... "isPartOf" TEXT,
... "data" BLOB,
... "format" TEXT NOT NULL,
... PRIMARY KEY("key"),
| | | 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 |
... "key" INTEGER,
... "identifier" TEXT UNIQUE,
... "filename" TEXT NOT NULL,
... "isPartOf" TEXT,
... "data" BLOB,
... "format" TEXT NOT NULL,
... PRIMARY KEY("key"),
... FOREIGN KEY("format") REFERENCES "formats"("identifier") ON UPDATE CASCADE ON DELETE RESTRICT
... );
... ''')
>>> result.fetchone()
- Jede Variante ist entweder eine Datei oder ein Ordner.
- Diese Dateien und Ordner sind **nicht** die Mediathek.
- Dateien enthalten die zulässigen Datentypen
|
| ︙ | ︙ |