about summary refs log tree commit diff
path: root/sql
diff options
context:
space:
mode:
authorBonfaceKilz2021-06-07 19:44:00 +0300
committerzsloan2021-06-18 22:08:04 +0000
commitbb55cf948974d85fb31d2f424f7ee94f7ab5e3d6 (patch)
tree7e66ebe7ad446ff6e99bdcb4871ddf474fccf3a3 /sql
parente67316601be4b43da6f60322fef1f4ce15ed5905 (diff)
downloadgenenetwork3-bb55cf948974d85fb31d2f424f7ee94f7ab5e3d6.tar.gz
Rename json_data column to json_diff_data
Diffstat (limited to '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))
 );