Ignore:
Timestamp:
2013/01/07 18:03:31 (11 years ago)
Author:
m_uehara
Message:

#2004 郵便番号を2カラムから1カラムに変更しました。

Location:
branches/version-2_12-multilang/html/install/sql
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • branches/version-2_12-multilang/html/install/sql/create_table_mysql.sql

    r22177 r22205  
    7474    zip01 text, 
    7575    zip02 text, 
     76    zipcode text, 
    7677    pref smallint, 
    7778    addr01 text, 
    … …  
    8889    law_zip01 text, 
    8990    law_zip02 text, 
     91    law_zipcode text, 
    9092    law_pref smallint, 
    9193    law_addr01 text, 
    … …  
    485487    zip01 text, 
    486488    zip02 text, 
     489    zipcode text, 
    487490    pref smallint, 
    488491    addr01 text, 
    … …  
    538541    order_zip01 text, 
    539542    order_zip02 text, 
     543    order_zipcode text, 
    540544    order_pref smallint, 
    541545    order_addr01 text, 
    … …  
    595599    order_zip01 text, 
    596600    order_zip02 text, 
     601    order_zipcode text, 
    597602    order_pref smallint, 
    598603    order_addr01 text, 
    … …  
    654659    shipping_zip01 text, 
    655660    shipping_zip02 text, 
     661    shipping_zipcode text, 
    656662    shipping_addr01 text, 
    657663    shipping_addr02 text, 
    … …  
    690696    zip01 text, 
    691697    zip02 text, 
     698    zipcode text, 
    692699    pref smallint, 
    693700    addr01 text, 

  • branches/version-2_12-multilang/html/install/sql/create_table_pgsql.sql

    r22177 r22205  
    7474    zip01 text, 
    7575    zip02 text, 
     76    zipcode text, 
    7677    pref smallint, 
    7778    addr01 text, 
    … …  
    8889    law_zip01 text, 
    8990    law_zip02 text, 
     91    law_zipcode text, 
    9092    law_pref smallint, 
    9193    law_addr01 text, 
    … …  
    485487    zip01 text, 
    486488    zip02 text, 
     489    zipcode text, 
    487490    pref smallint, 
    488491    addr01 text, 
    … …  
    538541    order_zip01 text, 
    539542    order_zip02 text, 
     543    order_zipcode text, 
    540544    order_pref smallint, 
    541545    order_addr01 text, 
    … …  
    595599    order_zip01 text, 
    596600    order_zip02 text, 
     601    order_zipcode text, 
    597602    order_pref smallint, 
    598603    order_addr01 text, 
    … …  
    654659    shipping_zip01 text, 
    655660    shipping_zip02 text, 
     661    shipping_zipcode text, 
    656662    shipping_addr01 text, 
    657663    shipping_addr02 text, 
    … …  
    690696    zip01 text, 
    691697    zip02 text, 
     698    zipcode text, 
    692699    pref smallint, 
    693700    addr01 text, 

  • branches/version-2_12-multilang/html/install/sql/insert_data.sql

    r22179 r22205  
    313313INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (77, 2, 'zip01', '郵便番号1', 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    314314INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (78, 2, 'zip02', '郵便番号2', 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     315INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (79, 2, 'zipcode', '郵便番号', 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    315316INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (80, 2, 'addr01', '住所1', 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    316317INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, status, create_date, update_date) VALUES (81, 2, 'addr02', '住所2', 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    … …  
    348349INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (113, 3, 'order_zip01', '郵便番号1', 15, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'ZIP01_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK'); 
    349350INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (114, 3, 'order_zip02', '郵便番号2', 16, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'ZIP02_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK'); 
     351INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (115, 3, 'order_zipcode', '郵便番号', 17, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'ZIPCODE_LEN', 'MAX_LENGTH_CHECK,NUM_CHECK,NUM_COUNT_CHECK'); 
    350352INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (116, 3, 'order_addr01', '住所1', 18, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,NUM_CHECK'); 
    351353INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (117, 3, 'order_addr02', '住所2', 19, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'MTEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK,NUM_CHECK'); 
    … …  
    11511153INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SEARCH_CATEGORY_LEN', '18', 208, '検索カテゴリ最大表示文字数(byte)'); 
    11521154INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('FILE_NAME_LEN', '10', 209, 'ファイル名表示文字数'); 
     1155INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ZIPCODE_LEN', '10', 210, '郵便番号'); 
    11531156INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('COOKIE_EXPIRE', '365', 212, 'クッキー保持期限(日)'); 
    11541157INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SEPA_CATNAVI', '" > "', 235, 'カテゴリ区切り文字'); 
Note: See TracChangeset for help on using the changeset viewer.