useful-qry/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`, `icon`, `is_enabled`)
VALUES (1, '0', '0', '100000', 'kkcrm', '1a2738', '/dabory/erp', 'fas fa-comment-dollar', '1');

REPLACE INTO `dbr_sort_menu` (`id`, `created_on`, `updated_on`, `menu_code`, `sort_type`, `bgcolor_code`, `dash_page_url`, `icon`, `is_enabled`)
VALUES (2, '0', '0', '200000', 'shop', '1a3300', '/dabory/erp', 'fas fa-shopping-cart', '1');

REPLACE INTO `dbr_sort_menu` (`id`, `created_on`, `updated_on`, `menu_code`, `sort_type`, `bgcolor_code`, `dash_page_url`, `icon`, `is_enabled`)
VALUES (3, '0', '0', '300000', 'homepage', '4d1a00', '/dabory/erp', 'fas fa-home', '1');

REPLACE INTO `dbr_sort_menu` (`id`, `created_on`, `updated_on`, `menu_code`, `sort_type`, `bgcolor_code`, `dash_page_url`, `icon`, `is_enabled`)
VALUES (4, '0', '0', '400000', 'erp', '260d0d', '/dabory/erp', 'fas fa-sitemap', '1');

REPLACE INTO `dbr_sort_menu` (`id`, `created_on`, `updated_on`, `menu_code`, `sort_type`, `bgcolor_code`, `dash_page_url`, `icon`, `is_enabled`)
VALUES (5, '0', '0', '500000', 'groupware', '4d3300', '/dabory/erp', 'fas fa-layer-group', '1');

REPLACE INTO `dbr_sort_menu` (`id`, `created_on`, `updated_on`, `menu_code`, `sort_type`, `bgcolor_code`, `dash_page_url`, `icon`, `is_enabled`)
VALUES (6, '0', '0', '600000', 'optical_pos', '00004d', '/dabory/erp', 'fas fa-glasses', '1');

REPLACE INTO `dbr_sort_menu` (`id`, `created_on`, `updated_on`, `menu_code`, `sort_type`, `bgcolor_code`, `dash_page_url`, `icon`, `is_enabled`)
VALUES (7, '0', '0', '700000', 'dbr_main', '263806', '/dabory/erp', 'fas fa-glasses', '1');


[create spd_struct]
REPLACE INTO `spd_struct` (`id`, `created_on`, `updated_on`, `sort`, `struct_code`, `solution_code`, `seq_no`, `component`, `parameter`, `struct_json`, `status`) VALUES (1, '0', '0', '0', 'unknown', 'unknown', '1', '', '', NULL, '');
REPLACE INTO `spd_struct` (`id`, `created_on`, `updated_on`, `sort`, `struct_code`, `solution_code`, `seq_no`, `component`, `parameter`, `struct_json`, `status`) VALUES (2, '0', '0', '0', 'woo-type', 'WooCommerce', '1', 'popup-struct.form-a.woo-type-form', '/popup-struct/form-a/woo-type', NULL, '');

[create pro_member_perm]
REPLACE INTO `pro_member_perm` (`id`, `created_on`, `updated_on`, `perm_no`, `perm_date`, `perm_name`, `perm_desc`) VALUES ('3', '1611569505', '1613191833',
REPLACE INTO `dbr_sort_menu` (`id`, `created_on`, `updated_on`, `menu_code`, `sort_type`, `bgcolor_code`, `dash_page_url`, `icon`, `is_enabled`)
VALUES (7, '0', '0', '700000', 'dabory_main', '263806', '/dabory/erp', 'fas fa-glasses', '1');


[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');