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
Next revision
Previous revision
scratch_gb [2022/07/01 17:34]
admin
scratch_gb [2022/07/01 17:42]
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