summaryrefslogtreecommitdiff
path: root/util/updates/update_2.19.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/update_2.19.sql')
-rw-r--r--util/updates/update_2.19.sql13
1 files changed, 12 insertions, 1 deletions
diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql
index 313fa567..b867356f 100644
--- a/util/updates/update_2.19.sql
+++ b/util/updates/update_2.19.sql
@@ -182,13 +182,24 @@ INSERT INTO traits_parents (trait, parent) VALUES
SELECT edit_char_init(null);
UPDATE edit_revision SET comments = 'New test entry', requester = 2, ip = '0.0.0.0';
UPDATE edit_char SET name = 'Phorni', original = 'フォーニ', "desc" = 'Sprite of Music', height = 14, gender = 'f';
+INSERT INTO edit_char_vns VALUES (38, 'primary', 0), (97, 'appears', 2);
SELECT edit_char_commit();
-- saya (incorrect test data)
SELECT edit_char_init(null);
UPDATE edit_revision SET comments = '2nd test entry', requester = 2, ip = '0.0.0.0';
-UPDATE edit_char SET name = 'Saya', original = '沙耶', "desc" = 'There is more than meets the eye!', alias = 'Cute monster', height = 140, weight = 52, s_bust = 41, s_waist = 38, s_hip = 40, b_month = 3, b_day = 15, bloodt = 'a', gender = 'f';
+UPDATE edit_char SET name = 'Saya', original = '沙耶', "desc" = 'There is more than meets the eye!', alias = 'Cute monster', height = 140, weight = 52, s_bust = 41, s_waist = 38, s_hip = 40, b_month = 3, b_day = 15, bloodt = 'a', gender = 'f', main = 1;
INSERT INTO edit_char_traits VALUES (4, 0), (12, 2), (22, 0), (27, 0), (18, 1);
+INSERT INTO edit_char_vns VALUES (97, 'primary', 0);
+SELECT edit_char_commit();
+
+-- lafiel (not even a VN character...)
+SELECT edit_char_init(null);
+UPDATE edit_revision SET comments = '3rd test entry', requester = 2, ip = '0.0.0.0';
+UPDATE edit_char SET name = 'Abriel Nei Debrusc Borl Paryun Lafiel', original = 'アブリアル・ネイ=ドゥブレスク・パリューニュ・ベール・パリュン・ラフィール',
+ alias = E'Ablïarsec néïc Dubreuscr Bœrh Parhynr Lamhirh\nLafiel', gender = 'f', height = 163, weight = 53, main = 1, desc = 'Not scary at all!';
+INSERT INTO edit_char_traits VALUES (13, 0), (17, 0), (22, 0);
+INSERT INTO edit_char_vns VALUES (97, 'primary', 0), (17, 2479, 'side', 1), (17, 626, 'primary', 2), (17, 0, 'appears', 0);
SELECT edit_char_commit();
SELECT traits_chars_calc();