alter table cardtypes  add menuitemid int

ALTER TABLE `banksfinders`.`cardtypes` 
CHANGE COLUMN `menuitemid` `menuitem` VARCHAR(50) NULL DEFAULT NULL ;


UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'cash-back' WHERE (`idcardtype` = '1');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'welcome-bonus' WHERE (`idcardtype` = '2');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'free-for-life' WHERE (`idcardtype` = '3');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'travel-card' WHERE (`idcardtype` = '4');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'premium-card' WHERE (`idcardtype` = '5');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'etihad-miles' WHERE (`idcardtype` = '6');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'emirate-skywords' WHERE (`idcardtype` = '7');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'balance-transfer' WHERE (`idcardtype` = '8');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'fixed-deposit' WHERE (`idcardtype` = '9');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'islamic-card' WHERE (`idcardtype` = '10');
UPDATE `banksfinders`.`cardtypes` SET `menuitem` = 'business-card' WHERE (`idcardtype` = '11');



INSERT INTO `banksfinders`.`cardtypes` (`cardtypecode`, `cardtypedesc`, `useascategory`, `menuitem`) VALUES ('EIC', 'Emarati Cards', '0', 'business-card'); 

INSERT INTO `banksfinders`.`banks` (`bankcode`, `bankname`) VALUES ('CityBank', 'City Bank');
UPDATE `banksfinders`.`banks` SET `bankcode` = 'LivBank' WHERE (`idbanks` = '24');


INSERT INTO `banksfinders`.`banks` (`bankcode`, `bankname`) VALUES ('STB', 'Standard Chartered');
UPDATE `banksfinders`.`banks` SET `bankcode` = 'DubaiFirst' WHERE (`idbanks` = '22');


CREATE TABLE `creditcardsoffers` (
  `idcreditcardsoffers` int NOT NULL AUTO_INCREMENT,
  `creditcardsoffersDetails` varchar(500) DEFAULT NULL,
  `idcreditcards` int DEFAULT NULL,
  PRIMARY KEY (`idcreditcardsoffers`),
  KEY `fk_creditcardsoffers_1_idx` (`idcreditcards`),
  CONSTRAINT `fk_creditcardsoffers_1` FOREIGN KEY (`idcreditcards`) REFERENCES `creditcards` (`idcreditcards`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ;
ALTER TABLE `banksfinders`.`creditcards` 
CHANGE COLUMN `MinimumSalary` `MinimumSalary` DECIMAL NULL DEFAULT NULL ;