DROP TABLE IF EXISTS `Credit`; CREATE TABLE `Credit` ( id int(11) NOT NULL, Name varchar(20) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; ALTER TABLE `Credit` ADD PRIMARY KEY (`id`); INSERT INTO `Credit` (`ID`,`Name`) VALUES (1,'JCB'), (2,'VISA'), (3,'MASTER'), (4,'AMEX'), (5,'QUIC pay'), (6,'Diners Clib'), (7,'UC'), (8,'TS3'), (9,''), (10,''), (11,''), (12,''), (13,''), (14,''), (15,'');