i-generation

DBテーブル調整
delete from stat_log_201404 where c_id = 1233
delete from stat_log_client_201404 where c_id = 1233
delete from stat_log_201405 where c_id = 1233
delete from stat_log_client_201405 where c_id = 1233
update click_log_201404 set c_id = 1243 where c_id = 1233
update action_log_201404 set c_id = 1243 where c_id = 1233
update click_log_201405 set c_id = 1243 where c_id = 1233
update action_log_201405 set c_id = 1243 where c_id = 1233
update access_action_log_201404 set c_id = 1243 where c_id = 1233
update access_action_log_201405 set c_id = 1243 where c_id = 1233

集計ログ調整
cat 20140501/cl_* | grep ",1233," > 20140501/cl_20140501_9999.log1
cat 20140502/cl_* | grep ",1233," > 20140502/cl_20140502_9999.log1
cat 20140503/cl_* | grep ",1233," > 20140503/cl_20140503_9999.log1
cat 20140504/cl_* | grep ",1233," > 20140504/cl_20140504_9999.log1
cat 20140505/cl_* | grep ",1233," > 20140505/cl_20140505_9999.log1
cat 20140506/cl_* | grep ",1233," > 20140506/cl_20140506_9999.log1
cat 20140507/cl_* | grep ",1233," > 20140507/cl_20140507_9999.log1
cat 20140508/cl_* | grep ",1233," > 20140508/cl_20140508_9999.log1
cat 20140509/cl_* | grep ",1233," > 20140509/cl_20140509_9999.log1
cat 20140510/cl_* | grep ",1233," > 20140510/cl_20140510_9999.log1
cat 20140511/cl_* | grep ",1233," > 20140511/cl_20140511_9999.log1
cat 20140512/cl_* | grep ",1233," > 20140512/cl_20140512_9999.log1
cat 20140513/cl_* | grep ",1233," > 20140513/cl_20140513_9999.log1

mv 20140501/cl_20140501_9999.log1 20140501/cl_20140501_9999.log
mv 20140502/cl_20140502_9999.log1 20140502/cl_20140502_9999.log
mv 20140503/cl_20140503_9999.log1 20140503/cl_20140503_9999.log
mv 20140504/cl_20140504_9999.log1 20140504/cl_20140504_9999.log
mv 20140505/cl_20140505_9999.log1 20140505/cl_20140505_9999.log
mv 20140506/cl_20140506_9999.log1 20140506/cl_20140506_9999.log
mv 20140507/cl_20140507_9999.log1 20140507/cl_20140507_9999.log
mv 20140508/cl_20140508_9999.log1 20140508/cl_20140508_9999.log
mv 20140509/cl_20140509_9999.log1 20140509/cl_20140509_9999.log
mv 20140510/cl_20140510_9999.log1 20140510/cl_20140510_9999.log
mv 20140511/cl_20140511_9999.log1 20140511/cl_20140511_9999.log
mv 20140512/cl_20140512_9999.log1 20140512/cl_20140512_9999.log
mv 20140513/cl_20140513_9999.log1 20140513/cl_20140513_9999.log

cat 20140501/ac_* | grep ",1233," > 20140501/ac_20140501_9999.log1
cat 20140502/ac_* | grep ",1233," > 20140502/ac_20140502_9999.log1
cat 20140503/ac_* | grep ",1233," > 20140503/ac_20140503_9999.log1
cat 20140504/ac_* | grep ",1233," > 20140504/ac_20140504_9999.log1
cat 20140505/ac_* | grep ",1233," > 20140505/ac_20140505_9999.log1
cat 20140506/ac_* | grep ",1233," > 20140506/ac_20140506_9999.log1
cat 20140507/ac_* | grep ",1233," > 20140507/ac_20140507_9999.log1
cat 20140508/ac_* | grep ",1233," > 20140508/ac_20140508_9999.log1
cat 20140509/ac_* | grep ",1233," > 20140509/ac_20140509_9999.log1
cat 20140510/ac_* | grep ",1233," > 20140510/ac_20140510_9999.log1
cat 20140511/ac_* | grep ",1233," > 20140511/ac_20140511_9999.log1
cat 20140512/ac_* | grep ",1233," > 20140512/ac_20140512_9999.log1
cat 20140513/ac_* | grep ",1233," > 20140513/ac_20140513_9999.log1

mv 20140501/ac_20140501_9999.log1 20140501/ac_20140501_9999.log
mv 20140502/ac_20140502_9999.log1 20140502/ac_20140502_9999.log
mv 20140503/ac_20140503_9999.log1 20140503/ac_20140503_9999.log
mv 20140504/ac_20140504_9999.log1 20140504/ac_20140504_9999.log
mv 20140505/ac_20140505_9999.log1 20140505/ac_20140505_9999.log
mv 20140506/ac_20140506_9999.log1 20140506/ac_20140506_9999.log
mv 20140507/ac_20140507_9999.log1 20140507/ac_20140507_9999.log
mv 20140508/ac_20140508_9999.log1 20140508/ac_20140508_9999.log
mv 20140509/ac_20140509_9999.log1 20140509/ac_20140509_9999.log
mv 20140510/ac_20140510_9999.log1 20140510/ac_20140510_9999.log
mv 20140511/ac_20140511_9999.log1 20140511/ac_20140511_9999.log
mv 20140512/ac_20140512_9999.log1 20140512/ac_20140512_9999.log
mv 20140513/ac_20140513_9999.log1 20140513/ac_20140513_9999.log