This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
scratch_gb [2022/07/01 16:34] admin |
scratch_gb [2022/07/01 16:42] (current) admin |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | * https://www.sqlite.org/download.html | + | * https://www.sqlite.org/download.html |
| - | * https://sqlitebrowser.org/dl/ | + | * https://sqlitebrowser.org/dl/ |
| + | |||
| + | <code sql> | ||
| + | CREATE TABLE `jobs` ( | ||
| + | `job_reference` TEXT, | ||
| + | `job_title` TEXT, | ||
| + | `job_status` TEXT, | ||
| + | `reply_to` TEXT | ||
| + | ); | ||
| + | |||
| + | |||
| + | CREATE TABLE `job_history` ( | ||
| + | `job_reference` TEXT, | ||
| + | `field_name` TEXT, | ||
| + | `old_value` TEXT, | ||
| + | `new_value` TEXT, | ||
| + | `changed_on` TEXT | ||
| + | ); | ||
| + | </code> | ||
| <code php extract.php> | <code php extract.php> | ||