aboutsummaryrefslogtreecommitdiff
path: root/sql/metadata_audit.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/metadata_audit.sql')
-rw-r--r--sql/metadata_audit.sql12
1 files changed, 6 insertions, 6 deletions
diff --git a/sql/metadata_audit.sql b/sql/metadata_audit.sql
index 9771e74..514a2fc 100644
--- a/sql/metadata_audit.sql
+++ b/sql/metadata_audit.sql
@@ -20,10 +20,10 @@
-- This table stores data on diffs when editing a Published dataset's data
CREATE TABLE metadata_audit (
PRIMARY KEY (id),
- id INTEGER AUTO_INCREMENT NOT NULL,
- dataset_id INTEGER NOT NULL,
- editor VARCHAR(255) NOT NULL,
- json_data VARCHAR(2048) NOT NULL,
- time_stamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
- CHECK (JSON_VALID(json_data))
+ id INTEGER AUTO_INCREMENT NOT NULL,
+ dataset_id INTEGER NOT NULL,
+ editor VARCHAR(255) NOT NULL,
+ json_diff_data VARCHAR(2048) NOT NULL,
+ time_stamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
+ CHECK (JSON_VALID(json_diff_data))
);