This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
scratch_gb [2022/07/01 17:34] admin |
scratch_gb [2022/07/01 17: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> |