Changeset 23640


Ignore:
Timestamp:
2014/10/10 12:58:06 (9 years ago)
Author:
Seasoft
Message:

#2631 (「商品登録」「商品登録CSV」での入力必須不整合)

Location:
branches/version-2_13-dev/html/install/sql
Files:
3 edited

Legend:

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

    r23617 r23640  
    314314    classcategory_id2 int NOT NULL DEFAULT 0, 
    315315    product_type_id int NOT NULL DEFAULT 0, 
    316     product_code text, 
     316    product_code text NOT NULL, 
    317317    stock numeric, 
    318318    stock_unlimited smallint NOT NULL DEFAULT 0, 
  • branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql

    r23639 r23640  
    314314    classcategory_id2 int NOT NULL DEFAULT 0, 
    315315    product_type_id int NOT NULL DEFAULT 0, 
    316     product_code text, 
     316    product_code text NOT NULL, 
    317317    stock numeric, 
    318318    stock_unlimited smallint NOT NULL DEFAULT 0, 
  • branches/version-2_13-dev/html/install/sql/insert_data.sql

    r23617 r23640  
    282282INSERT 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 (44, 1, 'del_flg', '削除フラグ', 44, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); 
    283283INSERT 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 (45, 1, 'product_type_id', '商品種別ID', 45, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); 
    284 INSERT 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 (46, 1, 'product_code', '商品コード', 46, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); 
     284INSERT 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 (46, 1, 'product_code', '商品コード', 46, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'EXIST_CHECK,SPTAB_CHECK,MAX_LENGTH_CHECK'); 
    285285INSERT 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 (47, 1, 'stock', '在庫数', 47, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'AMOUNT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); 
    286286INSERT 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 (48, 1, 'stock_unlimited', '在庫無制限フラグ', 48, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); 
Note: See TracChangeset for help on using the changeset viewer.