User Tools

Site Tools


scratch_gb

Differences

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

Link to this comparison view

Next revision
Previous revision
scratch_gb [2022/07/01 17:32]
admin created
scratch_gb [2022/07/01 17:42] (current)
admin
Line 1: Line 1:
 +  * https://​www.sqlite.org/​download.html
 +  * 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>​
 <?php <?php
  
Line 74: Line 96:
  
 ?> ?>
 +</​code>​
scratch_gb.1656693145.txt.gz ยท Last modified: 2022/07/01 17:32 by admin