From b36798db11af2703588b6ba9dae2ac6853afb9e0 Mon Sep 17 00:00:00 2001 From: hylom Date: Mon, 31 Oct 2016 21:37:17 +0900 Subject: [PATCH] utils/db_script: udpate sqls --- src/utils/db_scripts/data/011ac_users_info.sql | 4 +++- src/utils/db_scripts/data/021users_info.sql | 5 +++-- 2 files changed, 6 insertions(+), 3 deletions(-) diff --git a/src/utils/db_scripts/data/011ac_users_info.sql b/src/utils/db_scripts/data/011ac_users_info.sql index b0262b18..87cf6c1a 100644 --- a/src/utils/db_scripts/data/011ac_users_info.sql +++ b/src/utils/db_scripts/data/011ac_users_info.sql @@ -1,4 +1,6 @@ INSERT INTO users_info (uid, totalmods, realname, bio, tokens, lastgranted, m2info, karma, maillist, totalcomments, lastm2, m2_mods_saved, lastaccess, m2fair, up_fair, down_fair, m2unfair, up_unfair, down_unfair, m2fairvotes, m2voted_up_fair, m2voted_down_fair, m2unfairvotes, m2voted_up_unfair, m2voted_down_unfair, m2voted_lonedissent, m2voted_majority, upmods, downmods, stirred, session_login, cookie_location, registered, reg_id, expiry_days, expiry_comm, user_expiry_days, user_expiry_comm, initdomain, created_ipid, created_at, tag_clout, people, people_status, csq_bonuses) VALUES - (1, 0, "名無しのゴンベエ", "", 0, "1970-01-01 00:00:00", "", -25, 0, 177375, "1970-01-01 00:00:00", "", "2016-10-18", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 555, 505, 0, 1, "none", 1, "", 62763, 55484, 1, 1, "", "", "2001-01-01 00:00:00", 1, "2 1 592 2338 124 2123 604 942 277 3 2 2 5", "ok", 0) + (1, 0, "名無しのゴンベエ", "", 0, "1970-01-01 00:00:00", "", -25, 0, 177375, "1970-01-01 00:00:00", + "", "2016-10-18", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 555, 505, 0, 1, "none", 1, "", 62763, 55484, 1, 1, + "", "", "2001-01-01 00:00:00", 1, "2 1 592 2338 124 2123 604 942 277 3 2 2 5", "ok", 0) diff --git a/src/utils/db_scripts/data/021users_info.sql b/src/utils/db_scripts/data/021users_info.sql index f2262112..50274158 100644 --- a/src/utils/db_scripts/data/021users_info.sql +++ b/src/utils/db_scripts/data/021users_info.sql @@ -1,5 +1,6 @@ INSERT INTO users_info (uid, totalmods, realname, bio, tokens, lastgranted, m2info, karma, maillist, totalcomments, lastm2, m2_mods_saved, lastaccess, m2fair, up_fair, down_fair, m2unfair, up_unfair, down_unfair, m2fairvotes, m2voted_up_fair, m2voted_down_fair, m2unfairvotes, m2voted_up_unfair, m2voted_down_unfair, m2voted_lonedissent, m2voted_majority, upmods, downmods, stirred, session_login, cookie_location, registered, reg_id, expiry_days, expiry_comm, user_expiry_days, user_expiry_comm, initdomain, created_ipid, created_at, tag_clout, people, people_status, csq_bonuses) VALUES - (2, 0, "テスト01", "", 0, 1970-01-01 00:00:00, "", -25, 0, 177375, 1970-01-01 00:00:00, "", 2016-10-18, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 555, 505, 0, 1, none, 1, "", 62763, 55484, 1, 1, "", , 2001-01-01 00:00:00, 1, 2 1 592 2338 124 2123 604 942 277 3 2 2 5, ok, 0, -, 3, 0, NULL, "", 0, 1900-01-01 00:00:00, "", 0, 0, 0, 1970-01-01 00:00:00, "", 2016-10-31, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, none, 1, "", 1, 1, 1, 1, "", , 2016-10-31 11:23:07, 1, NULL, ok, 0) + (2, 0, "テスト01", "", 0, "1970-01-01 00:00:00", "", -25, 0, 177375, "1970-01-01 00:00:00", + "", "2016-10-18", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 555, 505, 0, 1, "none", 1, "", 62763, 55484, 1, 1, + "", "", "2001-01-01 00:00:00", 1, "2 1 592 2338 124 2123 604 942 277 3 2 2 5", "ok", 0) -- 2.11.0