Index: /branches/version-2_13-dev/html/install/sql/insert_data.sql
===================================================================
--- /branches/version-2_13-dev/html/install/sql/insert_data.sql (revision 23617)
+++ /branches/version-2_13-dev/html/install/sql/insert_data.sql (revision 23640)
@@ -282,5 +282,5 @@
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 (44, 1, 'del_flg', '削除フラグ', 44, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
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 (45, 1, 'product_type_id', '商品種別ID', 45, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
-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');
+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', 'EXIST_CHECK,SPTAB_CHECK,MAX_LENGTH_CHECK');
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 (47, 1, 'stock', '在庫数', 47, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'AMOUNT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
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 (48, 1, 'stock_unlimited', '在庫無制限フラグ', 48, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
Index: /branches/version-2_13-dev/html/install/sql/create_table_mysql.sql
===================================================================
--- /branches/version-2_13-dev/html/install/sql/create_table_mysql.sql (revision 23617)
+++ /branches/version-2_13-dev/html/install/sql/create_table_mysql.sql (revision 23640)
@@ -314,5 +314,5 @@
classcategory_id2 int NOT NULL DEFAULT 0,
product_type_id int NOT NULL DEFAULT 0,
- product_code text,
+ product_code text NOT NULL,
stock numeric,
stock_unlimited smallint NOT NULL DEFAULT 0,
Index: /branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql
===================================================================
--- /branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql (revision 23639)
+++ /branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql (revision 23640)
@@ -314,5 +314,5 @@
classcategory_id2 int NOT NULL DEFAULT 0,
product_type_id int NOT NULL DEFAULT 0,
- product_code text,
+ product_code text NOT NULL,
stock numeric,
stock_unlimited smallint NOT NULL DEFAULT 0,