Ignore:
Timestamp:
2010/10/30 14:59:12 (12 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:
5 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/html/install/sql/column_comment.sql

    r18853 r18876  
    158158INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (157, 'dtb_products', 'comment5', 'コメント5'); 
    159159INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (158, 'dtb_products', 'comment6', 'コメント6'); 
    160 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (159, 'dtb_products', 'file1', 'アップロードファイル1'); 
    161 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (160, 'dtb_products', 'file2', 'アップロードファイル2'); 
    162 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (161, 'dtb_products', 'file3', 'アップロードファイル3'); 
    163 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (162, 'dtb_products', 'file4', 'アップロードファイル4'); 
    164 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (163, 'dtb_products', 'file5', 'アップロードファイル5'); 
    165 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (164, 'dtb_products', 'file6', 'アップロードファイル6'); 
    166160INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (165, 'dtb_products', 'main_list_comment', 'メイン一覧コメント'); 
    167161INSERT 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

    r18858 r18876  
    267267    comment6 text, 
    268268    note text, 
    269     file1 text, 
    270     file2 text, 
    271     file3 text, 
    272     file4 text, 
    273     file5 text, 
    274     file6 text, 
    275269    main_list_comment text, 
    276270    main_list_image text, 
  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r18858 r18876  
    267267    comment6 text, 
    268268    note text, 
    269     file1 text, 
    270     file2 text, 
    271     file3 text, 
    272     file4 text, 
    273     file5 text, 
    274     file6 text, 
    275269    main_list_comment text, 
    276270    main_list_image text, 
  • branches/version-2_5-dev/html/install/sql/create_view.sql

    r18824 r18876  
    1313        dtb_products.comment6, 
    1414        dtb_products.note, 
    15         dtb_products.file1, 
    16         dtb_products.file2, 
    17         dtb_products.file3, 
    18         dtb_products.file4, 
    19         dtb_products.file5, 
    20         dtb_products.file6, 
    2115        dtb_products.main_list_comment, 
    2216        dtb_products.main_list_image, 
  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r18873 r18876  
    7070INSERT 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); 
    7171INSERT 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); 
    72 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); 
    73 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); 
    7472INSERT 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); 
    7573INSERT 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); 
     
    392390INSERT INTO dtb_product_categories (product_id, category_id, rank) VALUES (2, 4, 1); 
    393391 
    394 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); 
    395 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); 
     392INSERT 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); 
     393INSERT 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); 
    396394 
    397395INSERT 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); 
Note: See TracChangeset for help on using the changeset viewer.