diff options
Diffstat (limited to 'util/updates/update_2.19.sql')
-rw-r--r-- | util/updates/update_2.19.sql | 13 |
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(); |