User Tools

Site Tools


scratch_gb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​
scratch_gb.txt ยท Last modified: 2022/07/01 17:42 by admin