Description
user_card_holder
12体削除
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 22;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 24;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 25;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 28;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 39;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 46;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 55;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 70;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 71;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 72;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 93;
DELETE FROM user_card_holder WHERE user_card_holder.card_holder_no = 50307;
INSERT INTO user_card_holder (card_holder_no, user_no, card_no, lv, growth, exp, max_lv, bonus_stamina, bonus_attack, bonus_speed, deck_set, skill_no1, skill_no2, skill_no3, skill_no4, block_flg, test_flg, reg_date) VALUES
(22, 3, 461, 5, 4, 663, 30, 0, 0, 0, 6, 47, 8027, 547, -1, 0, 0, '2020-05-25 09:37:19'),
(24, 3, 930, 4, 2, 1706, 25, 0, 0, 0, 8, 142, 10535, -1, -1, 0, 0, '2020-05-25 09:37:19'),
(25, 3, 930, 1, 4, 0, 25, 0, 0, 0, 0, 142, 10535, -1, -1, 0, 0, '2020-05-25 09:37:19'),
(28, 3, 461, 1, 6, 0, 30, 0, 0, 0, 0, 47, 8027, 547, -1, 0, 0, '2020-05-25 09:37:19'),
(39, 1, 30, 32, 2, 790, 40, 0, 0, 0, 0, 8014, 7007, 4067, 0, 0, 0, '2020-05-26 13:39:37'),
(46, 7, 30, 1, 4, 0, 40, 0, 0, 0, 0, 8014, 7007, 4067, 0, 0, 0, '2020-05-27 07:47:42'),
(55, 1, 930, 3, 1, 1212, 25, 0, 0, 0, 0, 142, 10535, -1, -1, 0, 0, '2020-05-30 16:00:19'),
(70, 1, 482, 35, 5, 1694, 35, 0, 0, 0, 0, 1223, 0, -1, -1, 0, 0, '2020-05-30 16:05:02'),
(71, 1, 482, 35, 4, 670, 35, 0, 0, 0, 0, 1223, 0, -1, -1, 0, 0, '2020-05-30 16:05:02'),
(72, 1, 30, 34, 6, 1539, 40, 0, 0, 0, 0, 8014, 7007, 4067, 0, 0, 0, '2020-05-30 16:05:02'),
(93, 1, 30, 3, 1, 1029, 40, 0, 0, 0, 0, 8014, 7007, 4067, 0, 0, 0, '2020-06-02 14:27:51'),
(50307, 2, 30, 1, 4, 0, 40, 0, 0, 0, 0, 8014, 7007, 4067, 0, 0, 0, '2020-06-17 15:11:47');
----------------------------------------------------------------------------------------------------------
user_deck_stock
2体削除
DELETE FROM user_deck_stock WHERE user_deck_stock.user_no = 3 AND user_deck_stock.deck_no = 1 AND user_deck_stock.position = 6;
DELETE FROM user_deck_stock WHERE user_deck_stock.user_no = 3 AND user_deck_stock.deck_no = 1 AND user_deck_stock.position = 8;
INSERT INTO user_deck_stock (user_no, deck_no, card_holder_no, position, equip_now) VALUES
(3, 1, 22, 6, 1),
(3, 1, 24, 8, 1);
----------------------------------------------------------------------------------------------------------
user_deck_stock_teamWar
設定されてないようです