Description
define_y.inc#244
$_df['CARD_PIECE_ENABLE'] = false; //仲介屋▼SQL
log_user_card_pieceはログDBにも
-- master_card_piece
CREATE TABLE `master_card_piece` (
`piece_no` int(11) NOT NULL,
`piece_name` char(50) COLLATE utf8_unicode_ci NOT NULL,
`description` char(255) COLLATE utf8_unicode_ci NOT NULL,
`del_flg` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `master_card_piece` (`piece_no`, `piece_name`, `description`, `del_flg`) VALUES
(1, '【鬼っ娘チトセ】勝利の証', '集めると【鬼っ娘チトセ】の仲介依頼に使えます。', 0),
(2, '【旋風の術士クライフ】勝利の証', '集めると【旋風の術士クライフ】の仲介依頼に使えます。', 0);
ALTER TABLE `master_card_piece`
ADD PRIMARY KEY (`piece_no`),
ADD KEY `del_flg` (`del_flg`);
-- master_card_piece_data
CREATE TABLE `master_card_piece_data` (
`piece_no` int(11) NOT NULL,
`card_no` int(11) NOT NULL,
`need_piece_count` int(11) NOT NULL,
`need_gold` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `master_card_piece_data` (`piece_no`, `card_no`, `need_piece_count`, `need_gold`) VALUES
(1, 219, 200, 60000),
(2, 1332, 1500, 500000);
ALTER TABLE `master_card_piece_data`
ADD PRIMARY KEY (`piece_no`) USING BTREE,
ADD KEY `card_no` (`card_no`);
-- user_card_piece
CREATE TABLE `user_card_piece` (
`user_no` bigint(20) NOT NULL,
`piece_no` int(11) NOT NULL,
`piece_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `user_card_piece`
ADD PRIMARY KEY (`user_no`,`piece_no`);
-- log_user_card_piece(ログDBにも)
CREATE TABLE `log_user_card_piece` (
`id` int(11) NOT NULL,
`user_no` bigint(20) NOT NULL,
`piece_no` int(11) NOT NULL,
`piece_count` int(11) NOT NULL,
`status` int(11) NOT NULL,
`after_count` int(11) NOT NULL,
`reg_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `log_user_card_piece`
ADD PRIMARY KEY (`id`),
ADD KEY `user_no` (`user_no`,`piece_no`),
ADD KEY `reg_date` (`reg_date`) USING BTREE;
ALTER TABLE `log_user_card_piece`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;