「Tep3」を編集中
この編集を取り消せます。
下記の差分を確認して、本当に取り消していいか検証してください。よろしければ変更を保存して取り消しを完了してください。
最新版 | 編集中の文章 | ||
192行目: | 192行目: | ||
\COPY (select properties.ie_id as id, categories.id as list_id from categories join properties on categories.id = properties.tiku_id where categories.jiin_id = 1 order by properties.ie_id asc) TO '/Users/jq/3tep_gomi/ie_id_list_id_1.csv' WITH CSV DELIMITER ',' FORCE QUOTE * NULL AS '' HEADER; | \COPY (select properties.ie_id as id, categories.id as list_id from categories join properties on categories.id = properties.tiku_id where categories.jiin_id = 1 order by properties.ie_id asc) TO '/Users/jq/3tep_gomi/ie_id_list_id_1.csv' WITH CSV DELIMITER ',' FORCE QUOTE * NULL AS '' HEADER; | ||
</pre> | </pre> | ||
− | * | + | * tep3_developmentデータベース内に作業用一時テーブルを作る Clientsのlist_idに上で抜き出したlist_idを入れるため |
<pre> | <pre> | ||
CREATE TABLE x_list_id (client_id int, list_id int); | CREATE TABLE x_list_id (client_id int, list_id int); | ||
205行目: | 205行目: | ||
UPDATE clients SET list_id = x_list_id.list_id FROM x_list_id WHERE clients.id = x_list_id.client_id; | UPDATE clients SET list_id = x_list_id.list_id FROM x_list_id WHERE clients.id = x_list_id.client_id; | ||
</pre> | </pre> | ||
− | |||
==== Categories ==== | ==== Categories ==== | ||
* 旧Categories set_id 2 が主なカテゴリ | * 旧Categories set_id 2 が主なカテゴリ |