Changeset 18876 for branches/version-2_5-dev/html

Timestamp:

2010/10/30 14:59:12 (16 years ago)

Author:

Seasoft

Message:

#628(未使用処理・定義の削除)

• dtb_products.file1
• dtb_products.file2
• dtb_products.file3
• dtb_products.file4
• dtb_products.file5
• dtb_products.file6

Location:

branches/version-2_5-dev/html/install/sql

Files:

• column_comment.sql (modified) (1 diff)
• create_table_mysql.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (1 diff)
• create_view.sql (modified) (1 diff)
• insert_data.sql (modified) (2 diffs)

branches/version-2_5-dev/html/install/sql/column_comment.sql

@@ -158 +158 @@
 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (157, 'dtb_products', 'comment5', 'コメント5');
 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (158, 'dtb_products', 'comment6', 'コメント6');
-INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (159, 'dtb_products', 'file1', 'アップロードファイル1');
-INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (160, 'dtb_products', 'file2', 'アップロードファイル2');
-INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (161, 'dtb_products', 'file3', 'アップロードファイル3');
-INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (162, 'dtb_products', 'file4', 'アップロードファイル4');
-INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (163, 'dtb_products', 'file5', 'アップロードファイル5');
-INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (164, 'dtb_products', 'file6', 'アップロードファイル6');
 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (165, 'dtb_products', 'main_list_comment', 'メイン一覧コメント');
 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (166, 'dtb_products', 'main_list_image', 'メイン一覧画像');

branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

@@ -267 +267 @@
     comment6 text,
     note text,
-    file1 text,
-    file2 text,
-    file3 text,
-    file4 text,
-    file5 text,
-    file6 text,
     main_list_comment text,
     main_list_image text,

branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

@@ -267 +267 @@
     comment6 text,
     note text,
-    file1 text,
-    file2 text,
-    file3 text,
-    file4 text,
-    file5 text,
-    file6 text,
     main_list_comment text,
     main_list_image text,

branches/version-2_5-dev/html/install/sql/create_view.sql

@@ -13 +13 @@
         dtb_products.comment6,
         dtb_products.note,
-        dtb_products.file1,
-        dtb_products.file2,
-        dtb_products.file3,
-        dtb_products.file4,
-        dtb_products.file5,
-        dtb_products.file6,
         dtb_products.main_list_comment,
         dtb_products.main_list_image,

branches/version-2_5-dev/html/install/sql/insert_data.sql

@@ -70 +70 @@
 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (21, 1, 'main_image', '詳細-メイン画像', 21, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (22, 1, 'main_large_image', '詳細-メイン拡大画像 ', 22, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
-INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (23, 1, 'file1', 'カラー比較画像', 23, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
-INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (24, 1, 'file2', '商品詳細ファイル    ', 24, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (25, 1, 'sub_title1', '詳細-サブタイトル(1)', 25, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (26, 1, 'sub_comment1', '詳細-サブコメント(1)', 26, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
@@ -392 +390 @@
 INSERT INTO dtb_product_categories (product_id, category_id, rank) VALUES (2, 4, 1);
 
-INSERT INTO dtb_products (product_id, name, maker_id, rank, status, comment1, comment2, comment3, comment4, comment5, comment6, note, file1, file2, file3, file4, file5, file6, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id) VALUES (1, 'アイスクリーム', NULL, 1, 1, NULL, NULL, 'アイス,バニラ,チョコ,抹茶', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '暑い夏にどうぞ。', '08311201_44f65122ee5fe.jpg', '冷たいものはいかがですか?', '08311202_44f6515906a41.jpg', '08311203_44f651959bcb5.jpg', NULL, '<b>おいしいよ<b>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 2);
-INSERT INTO dtb_products (product_id, name, maker_id, rank, status, comment1, comment2, comment3, comment4, comment5, comment6, note, file1, file2, file3, file4, file5, file6, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id) VALUES (2, 'おなべ', NULL, 1, 1, NULL, NULL, '鍋,なべ,ナベ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '一人用からあります。', '08311311_44f661811fec0.jpg', 'たまには鍋でもどうでしょう。', '08311313_44f661dc649fb.jpg', '08311313_44f661e5698a6.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 3);
+INSERT INTO dtb_products (product_id, name, maker_id, rank, status, comment1, comment2, comment3, comment4, comment5, comment6, note, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id) VALUES (1, 'アイスクリーム', NULL, 1, 1, NULL, NULL, 'アイス,バニラ,チョコ,抹茶', NULL, NULL, NULL, NULL, '暑い夏にどうぞ。', '08311201_44f65122ee5fe.jpg', '冷たいものはいかがですか?', '08311202_44f6515906a41.jpg', '08311203_44f651959bcb5.jpg', NULL, '<b>おいしいよ<b>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 2);
+INSERT INTO dtb_products (product_id, name, maker_id, rank, status, comment1, comment2, comment3, comment4, comment5, comment6, note, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id) VALUES (2, 'おなべ', NULL, 1, 1, NULL, NULL, '鍋,なべ,ナベ', NULL, NULL, NULL, NULL, '一人用からあります。', '08311311_44f661811fec0.jpg', 'たまには鍋でもどうでしょう。', '08311313_44f661dc649fb.jpg', '08311313_44f661e5698a6.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 3);
 
 INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg, down, down_filename, down_realfilename) VALUES(1, 1, 10, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL);