sql schema: more test/demo helpers in new schema

1 files changed, 18 insertions, 1 deletions

diff --git a/rust/migrations/2019-05-09-051834_v0.3/up.sql b/rust/migrations/2019-05-09-051834_v0.3/up.sql
index aca02c85..6b8fc2e2 100644
--- a/rust/migrations/2019-05-09-051834_v0.3/up.sql
+++ b/rust/migrations/2019-05-09-051834_v0.3/up.sql
@@ -72,9 +72,26 @@ CREATE INDEX IF NOT EXISTS work_edit_ident_idx ON work_edit(ident_id);
 
 -- IMPORTANT: don't create new entities here, only mutate existing
 
+BEGIN;
+
+UPDATE release_rev SET
+    subtitle = 'and here a reasonable-length subtitle',
+    withdrawn_status = 'withdrawn',
+    withdrawn_date = '2018-06-07',
+    withdrawn_year = '2018',
+    number = 'RN9594',
+    version = 'v12'
+WHERE id = '00000000-0000-0000-4444-FFF000000002';
+
 INSERT INTO release_rev_extid (release_rev, extid_type, value) VALUES
     ('00000000-0000-0000-4444-FFF000000002', 'isbn13',  '978-3-16-148410-0'),
     ('00000000-0000-0000-4444-FFF000000002', 'arxiv',   '1905.03769v1'),
     ('00000000-0000-0000-4444-FFF000000002', 'jstor',   '1819117828'),
-    ('00000000-0000-0000-4444-FFF000000002', 'ark',     'ark:/asdf/924'),
+    ('00000000-0000-0000-4444-FFF000000002', 'ark',     'ark:/13030/m53r5pzm'),
     ('00000000-0000-0000-4444-FFF000000002', 'mag',     '992489213');
+
+UPDATE release_contrib SET given_name = 'John', surname = 'Ioannidis' WHERE release_rev = '00000000-0000-0000-4444-FFF000000003';
+
+UPDATE webcapture_rev_cdx SET size_bytes = 12345 WHERE webcapture_rev = '00000000-0000-0000-7777-FFF000000003';
+
+commit;