Script untuk membuat kategori baru

INSERT INTO m_product_ctgr_tree(tenant_id, product_ctgr_tree_code, product_ctgr_tree_name,
            ctgr_parent_id, flg_use_attr, flg_serial_number, flg_warranty,
            flg_lot, flg_barcode, flg_expired, flg_weight, flg_dimension,
            flg_spec, flg_cust_info, flg_supp_info, flg_parts, flg_year_made,
            flg_attr_confirmed, create_datetime, create_user_id, update_datetime,
            update_user_id, version, active, active_datetime, non_active_datetime,
            group_product_id)
    VALUES (11,'A0315','TAS PINGGANG',537,'Y','N','N','N','Y','N','Y','Y','N','Y','Y','N','N','Y','20181108171500',-1,'20181108171500',-1,0,'Y','20181108171500','',-99),
       (11,'I0212','BLUETOOTH HEADSET',102,'Y','N','N','N','Y','N','Y','Y','N','Y','Y','N','N','Y','20181108171500',-1,'20181108171500',-1,0,'Y','20181108171500','',-99);
INSERT INTO m_product_ctgr_tree_code_size(
            product_ctgr_tree_code, size,
            create_datetime, create_user_id, update_datetime, update_user_id,
            version, active, active_datetime, non_active_datetime)
    VALUES ('A0315','NONE','20181108172700',-1,'20181108172700',-1,0,'Y','20181108172700',''),
       ('A0315','ALL SIZE','20181108172700',-1,'20181108172700',-1,0,'Y','20181108172700',''),
       ('I0212','ALL SIZE','20181108172700',-1,'20181108172700',-1,0,'Y','20181108172700',''),
       ('I0212','NONE','20181108172700',-1,'20181108172700',-1,0,'Y','20181108172700','');