差分

Tep3-onk-2

970 バイト追加, 2022年9月18日 (日) 08:26
旧clientsテーブルをclientsとotherに分ける
=# update clients_old set nusi = false where id = 1346;
不要データ削除不要データ削除 修正
=# delete from clients_old where id in (4028,3911,3912,2998,3007,4359);
 
<nowiki>tep5_development=# update clients_old set nusi = true where id = 523;
UPDATE 1
tep5_development=# delete from clients_old where id = 845;
DELETE 1
tep5_development=# update clients_old set ie_id = 1264 where id = 515;
UPDATE 1
tep5_development=# update clients_old set ie_id = 1264 where id = 1463;
UPDATE 1
tep5_development=# update clients_old set nusi = false where id = 515;
UPDATE 1
tep5_development=# delete from clients_old where id = 217;
DELETE 1
tep5_development=# update clients_old set nusi = false where id = 218;
UPDATE 1
tep5_development=# update clients_old set ie_id = 204 where id = 218;
UPDATE 1
tep5_development=# delete from clients_old where id = 811;
DELETE 1
tep5_development=# update clients_old set nusi = true where id = 1792;
UPDATE 1
tep5_development=# delete from clients_old where id = 810;
DELETE 1
tep5_development=# delete from clients_old where ie_id = 22653;
DELETE 3
tep5_development=# insert into others</nowiki>
list_idをnullを許可する あと適切な時点で戻す