3,728
回編集
差分
→schedulesテーブル
4
(3 rows)</nowiki>
アプリから替え玉を作って確認
<nowiki>tep5_development=# select * from clients where id = 1;
id | user_id | note_id | list_id | content | client_line | memo | created_at | updated_at
----+---------+---------+---------+---------+-------------+------+----------------------------+----------------------------
1 | 1 | 1 | 1 | 替え玉 | | | 2022-09-27 01:42:10.816742 | 2022-09-27 01:42:10.816742
(1 row)
tep5_development=# select * from clients where id = 2;
id | user_id | note_id | list_id | content | client_line | memo | created_at | updated_at
----+---------+---------+---------+---------+-------------+------+----------------------------+----------------------------
2 | 1 | 2 | 3 | 替え玉 | | | 2022-09-27 01:46:11.282471 | 2022-09-27 01:46:11.282471
(1 row)
tep5_development=# select * from clients where id = 3;
id | user_id | note_id | list_id | content | client_line | memo | created_at | updated_at
----+---------+---------+---------+---------+-------------+------+----------------------------+----------------------------
3 | 1 | 4 | 4 | 替え玉 | | | 2022-09-27 01:56:31.755069 | 2022-09-27 01:56:31.755069
(1 row)</nowiki>
替え玉のidでschedulesのclient_id null を埋める
=== ダンプ ここまで形を整えたデータベースをバックアップしとく ===
