useful-qry/table-controls/z-소트-뱃지-생성.sql

[create sort_menu]
truncate table dbr_sort_menu;

REPLACE INTO `dbr_sort_menu` (`id`, `created_on`, `updated_on`, `menu_code`, `sort_type`, `bgcolor_code`, `dash_page_url`, `component`, `parameter`, `icon`, `is_enabled`, `mgt_type`) VALUES 
(1001, '1699861794', '1699861794', '100000', 'myapp_shop', '034514', '/dabory/myapp', '', '', 'fas fa-shopping-cart', '1', 'member')

[create item_badge]
truncate table pro_item_badge;
REPLACE INTO `pro_item_badge` (`id`, `created_on`, `updated_on`, `sort`, `badge_name`, `lang_type`, `device_type`, `badge_type`, `badge_image`, `x_pos`, `y_pos`, `is_hide`) VALUES (1, '0', '0', '1', '신제품', 'ko', 'desktop', '1', '', '3', '3', '0');
REPLACE INTO `pro_item_badge` (`id`, `created_on`, `updated_on`, `sort`, `badge_name`, `lang_type`, `device_type`, `badge_type`, `badge_image`, `x_pos`, `y_pos`, `is_hide`) VALUES (2, '0', '0', '1', '10%할인', 'ko', 'desktop', '1', '', '3', '3', '0');
REPLACE INTO `pro_item_badge` (`id`, `created_on`, `updated_on`, `sort`, `badge_name`, `lang_type`, `device_type`, `badge_type`, `badge_image`, `x_pos`, `y_pos`, `is_hide`) VALUES (3, '0', '0', '1', '경품할인', 'ko', 'desktop', '1', '', '3', '3', '0');
REPLACE INTO `pro_item_badge` (`id`, `created_on`, `updated_on`, `sort`, `badge_name`, `lang_type`, `device_type`, `badge_type`, `badge_image`, `x_pos`, `y_pos`, `is_hide`) VALUES (4, '0', '0', '1', '타임세일', 'ko', 'desktop', '1', '', '3', '3', '0');