DELIMITER $$
CREATE  PROCEDURE `adm_mst_spGetMenuDataangular`(user_gid varchar(100))
BEGIN

  SET @ExecuteSQL = CONCAT( 'SELECT a.module_gid, b.module_name,b.lw_flag, b.sref, b.icon, ', 'b.menu_level, b.module_gid_parent, b.display_order ', 'FROM adm_mst_tprivilegeangular a ', 'LEFT JOIN adm_mst_tmoduleangular b ON a.module_gid = b.module_gid ', 'WHERE user_gid = ''', user_gid, ''' AND ', 'b.lw_flag = ''Y'' ', 'GROUP BY a.module_gid ', 'ORDER BY b.display_order ASC' );

    PREPARE stmt FROM @ExecuteSQL;

    EXECUTE stmt;

    DEALLOCATE PREPARE stmt;

    END$$
DELIMITER ;

CREATE TABLE `adm_mst_tprivilegeangular` (
  `privilege_gid` varchar(64) NOT NULL,
  `usergroup_gid` varchar(64) DEFAULT NULL,
  `module_gid` varchar(64) DEFAULT NULL,
  `isallow` char(1) DEFAULT NULL,
  `user_gid` varchar(64) DEFAULT NULL,
  `module_parent_gid` varchar(64) DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  PRIMARY KEY (`privilege_gid`),
  KEY `ind_usergroupgid` (`usergroup_gid`),
  KEY `ind_modulegid` (`module_gid`),
  KEY `ind_usergid` (`user_gid`),
  KEY `ind_moduleparentgid` (`module_parent_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `adm_mst_tmoduleangular` (
  `module_gid` varchar(64) NOT NULL,
  `module_gid_parent` varchar(64) DEFAULT NULL,
  `module_code` varchar(32) DEFAULT NULL,
  `display_order` int(11) DEFAULT NULL,
  `module_link` varchar(128) DEFAULT NULL,
  `menu_level` int(11) DEFAULT NULL,
  `max_menulevel` int(11) DEFAULT NULL,
  `module_name` varchar(64) DEFAULT NULL,
  `status` char(1) DEFAULT NULL,
  `image_url` text,
  `group_type` varchar(45) DEFAULT NULL,
  `modulemanager_gid` varchar(64) DEFAULT NULL,
  `breadcrumb_name` varchar(64) DEFAULT NULL,
  `approval_flag` char(1) DEFAULT NULL,
  `approval_tablename` varchar(45) DEFAULT NULL,
  `approval_type` varchar(64) DEFAULT NULL,
  `approval_limit` char(1) DEFAULT 'N',
  `module_flag` char(1) DEFAULT 'N',
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `lw_flag` char(1) DEFAULT 'N',
  `sref` varchar(64) DEFAULT NULL,
  `icon` varchar(64) DEFAULT NULL,
  `shopify_flag` varchar(1) DEFAULT NULL,
  `icon_name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`module_gid`),
  KEY `ind_modulegidparent` (`module_gid_parent`),
  KEY `ind_modulemanagergid` (`modulemanager_gid`),
  KEY `ind_modulecode` (`module_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

alter table adm_mst_tmoduleangular add column shopify_flag varchar(1) default null;
alter table adm_mst_tmoduleangular add column icon_name varchar(64) default null;