Ignore:
Timestamp:
2010/09/22 13:23:00 (12 years ago)
Author:
eccuore
Message:

#792(ダウンロード販売機能) 入金日追加、規格対応(規格構成変更と並行で作業中なので、作業途中の部分有)

Location:
branches/version-2_5-dev/html/install/sql
Files:
4 edited

Legend:

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

    r18818 r18819  
    307307    update_date datetime, 
    308308    deliv_date_id int, 
    309     down smallint NOT NULL DEFAULT 0, 
    310     down_filename text, 
    311     down_realfilename text, 
    312309    PRIMARY KEY (product_id) 
    313310) TYPE=InnoDB; 
     
    329326    create_date datetime NOT NULL, 
    330327    update_date datetime, 
     328    down smallint NOT NULL , 
     329    down_filename text, 
     330    down_realfilename text, 
    331331    del_flg smallint NOT NULL DEFAULT 0, 
    332332    PRIMARY KEY (product_class_id) 
     
    656656    memo09 text, 
    657657    memo10 text, 
     658    payment_date timestamp, 
    658659    PRIMARY KEY (order_id) 
    659660) TYPE=InnoDB; 
  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r18818 r18819  
    307307    update_date timestamp, 
    308308    deliv_date_id int, 
    309     down smallint NOT NULL DEFAULT 0, 
    310     down_filename text, 
    311     down_realfilename text, 
    312309    PRIMARY KEY (product_id) 
    313310); 
     
    329326    create_date timestamp NOT NULL DEFAULT now(), 
    330327    update_date timestamp, 
     328    down int2 NOT NULL , 
     329    down_filename text, 
     330    down_realfilename text, 
    331331    del_flg smallint NOT NULL DEFAULT 0, 
    332332    PRIMARY KEY (product_class_id) 
     
    658658    memo09 text, 
    659659    memo10 text, 
     660    payment_date timestamp, 
    660661    PRIMARY KEY (order_id) 
    661662); 
  • branches/version-2_5-dev/html/install/sql/create_view.sql

    r18815 r18819  
    5353        dtb_products.update_date, 
    5454        dtb_products.deliv_date_id, 
    55         dtb_products.down, 
    56         dtb_products.down_filename, 
    57         dtb_products.down_realfilename, 
    5855        T4.product_code_min, 
    5956        T4.product_code_max, 
     
    105102            ON T2.category_id = dtb_category.category_id 
    106103; 
     104CREATE VIEW vw_download_class as 
     105        SELECT 
     106            pc.product_id AS product_id, 
     107            pc.classcategory_id1 AS classcategory_id1, 
     108            pc.classcategory_id2 AS classcategory_id2, 
     109            pc.down_realfilename AS down_realfilename, 
     110            pc.down_filename AS down_filename, 
     111            o.order_id AS order_id, 
     112            o.customer_id AS customer_id, 
     113            o.payment_date AS payment_date, 
     114            o.status AS status 
     115        FROM 
     116            dtb_products_class pc, 
     117            dtb_order_detail od, 
     118            dtb_order o 
     119        WHERE 
     120            pc.product_id = od.product_id AND 
     121            pc.classcategory_id1 = od.classcategory_id1 AND 
     122            pc.classcategory_id2 = od.classcategory_id2 AND 
     123            od.order_id = o.order_id 
     124; 
  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r18818 r18819  
    395395INSERT 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); 
    396396 
    397 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) VALUES(1, 1, 10, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    398 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) VALUES(2, 1, 11, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 5, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    399 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) VALUES(3, 1, 12, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    400 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) VALUES(4, 1, 13, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    401 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) VALUES(5, 1, 14, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    402 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) VALUES(6, 1, 15, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    403 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) VALUES(7, 1, 16, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    404 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) VALUES(8, 1, 17, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    405 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) VALUES(9, 1, 18, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    406 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) VALUES(10, 2, NULL, 'nabe-01', 100, 0, 5, 1700, 1650, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     397INSERT 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); 
     398INSERT 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(2, 1, 11, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 5, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     399INSERT 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(3, 1, 12, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     400INSERT 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(4, 1, 13, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     401INSERT 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(5, 1, 14, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     402INSERT 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(6, 1, 15, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     403INSERT 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(7, 1, 16, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     404INSERT 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(8, 1, 17, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     405INSERT 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(9, 1, 18, 'ice-01', NULL, 1, NULL, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
     406INSERT 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(10, 2, NULL, 'nabe-01', 100, 0, 5, 1700, 1650, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, 1, NULL, NULL); 
    407407 
    408408INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(1, NULL, 3, 1); 
Note: See TracChangeset for help on using the changeset viewer.