22 lines
515 B
SQL
22 lines
515 B
SQL
USE model_operations;
|
|
|
|
INSERT INTO ops_model_categories (
|
|
category_code,
|
|
category_name,
|
|
sort_order,
|
|
status,
|
|
is_deleted,
|
|
deleted_at
|
|
) VALUES
|
|
('std', '标准A卡', 10, 'active', 0, NULL),
|
|
('bai', '白户A卡', 20, 'active', 0, NULL),
|
|
('big', '大额A卡', 30, 'active', 0, NULL),
|
|
('afd', '反欺诈评分', 40, 'active', 0, NULL)
|
|
ON DUPLICATE KEY UPDATE
|
|
category_name = VALUES(category_name),
|
|
sort_order = VALUES(sort_order),
|
|
status = VALUES(status),
|
|
is_deleted = 0,
|
|
deleted_at = NULL;
|
|
|