diff options
author | Yorhel <git@yorhel.nl> | 2011-03-20 16:37:20 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-03-20 16:37:20 +0100 |
commit | 378fc091c78814377c04fad0bc11edd9dee33a36 (patch) | |
tree | c1187d6165de68934b4d4be75bf542511105ff38 /util/updates | |
parent | a1a53f272aef98e30141e5a9dc554b92cf90b137 (diff) |
chardb: Fixed no-change-edit-bug + test data insertion error
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_2.19.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql index f3e07642..1d980f3d 100644 --- a/util/updates/update_2.19.sql +++ b/util/updates/update_2.19.sql @@ -180,7 +180,7 @@ 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); +INSERT INTO edit_char_vns VALUES (38, null, 0, 'primary'), (97, null, 2, 'appears'); SELECT edit_char_commit(); -- saya (incorrect test data) @@ -188,16 +188,16 @@ 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', 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); +INSERT INTO edit_char_vns VALUES (97, null, 0, 'primary'); 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!'; + 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); +INSERT INTO edit_char_vns VALUES (97, null, 0, 'primary'), (17, 2479, 1, 'side'), (17, 626, 2, 'primary'), (17, null, 0, 'appears'); SELECT edit_char_commit(); SELECT traits_chars_calc(); |