【7/5】仲介屋UI更新 #837

本家更新
https://github.com/rzstaffgit/jrce2_github/pull/7891

#ルシエ紹介用の所持金
CREATE TABLE `user_pirate_store_money` (
  `user_no` bigint(20) NOT NULL,
  `money1` int(11) NOT NULL,
  `money2` int(11) NOT NULL,
  `money3` int(11) NOT NULL,
  PRIMARY KEY (`user_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ルシエ商会所持金';

#所持金の変動ログ
CREATE TABLE `log_pirate_store_money` (
  `id` int(11) NOT NULL,
  `user_no` bigint(20) NOT NULL,
  `status` mediumint(9) NOT NULL COMMENT '0買取所、それ以外lineup_no',
  `money_json` text COLLATE utf8_unicode_ci,
  `after_money_json` text COLLATE utf8_unicode_ci,
  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ルシエ商会所持金ログ';

ALTER TABLE `log_pirate_store_money`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reg_date` (`reg_date`),
  ADD KEY `user_no` (`user_no`,`reg_date`);

ALTER TABLE `log_pirate_store_money`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

#購入ログ
CREATE TABLE `log_pirate_store_sell` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_no` bigint(20) NOT NULL,
  `lineup_no` mediumint(9) NOT NULL,
  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `reg_date` (`reg_date`),
  KEY `user_no` (`user_no`,`reg_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ルシエ商会所購入ログ';