tynQMPg0

1CREATE TABLE IF NOT EXISTS `banks` (
2  `bank_id` INT NOT NULL,
3  `bank_name` VARCHAR(100) NOT NULL,
4  `bank_code` VARCHAR(50) NOT NULL,
5  `icon` VARCHAR(150),
6  `vendor_id` INT(11) NOT NULL,
7  `status` enum("active", "block") DEFAULT "active",
8  PRIMARY KEY (`bank_id`));
9ALTER TABLE banks CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
10
11CREATE TABLE IF NOT EXISTS `vendors` (
12  `id` INT NOT NULL AUTO_INCREMENT,
13  `name` VARCHAR(100) NOT NULL,
14  `alias` VARCHAR(50) NOT NULL,
15  `icon` VARCHAR(150),
16  `status` enum("active", "block") DEFAULT "active",
17  PRIMARY KEY (`id`));
18ALTER TABLE vendors CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
19
20INSERT INTO vendors(name, alias, icon)
21VALUES ("OnePay", "onepay", "");
22INSERT INTO vendors(name, alias, icon)
23VALUES ("VNPT Pay", "vnptpay", "");
24INSERT INTO vendors(name, alias, icon)
25VALUES ("MegaPay", "megapay", "");
26
27INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
28VALUES(1, "Vietcombank", "VCB", "", 2);
29INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
30VALUES(2, "Techcombank", "TECHCOMBANK", "", 2);
31INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
32VALUES(3, "TienPhong Bank", "TPBANK", "", 2);
33INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
34VALUES(4, "Viettin Bank", "VIETINBANK", "", 2);
35INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
36VALUES(5, "VIB", "VIB", "", 3);
37INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
38VALUES(6, "DongA Bank", "DAB", "", 2);
39INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
40VALUES(7, "HD Bank", "HDBANK", "", 2);
41INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
42VALUES(8, "MB", "MB", "", 2);
43INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
44VALUES(9, "VietA Bank", "VIETABANK", "", 3);
45INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
46VALUES(10, "Maritime Bank", "MARITIMEBANK", "", 3);
47INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
48VALUES(11, "Eximbank", "EXIMBANK", "", 3);
49INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
50VALUES(12, "SHB", "SHB", "", 2);
51INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
52VALUES(14, "VP Bank", "VPBANK", "", 3);
53INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
54VALUES(15, "AnBinh Bank", "ABBANK", "", 3);
55INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
56VALUES(16, "SacomBank", "SACOMBANK", "", 3);
57INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
58VALUES(17, "NamA Bank", "NAMA", "", 3);
59INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
60VALUES(18, "Ocean Bank", "OCEANBANK", "", 3);
61INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
62VALUES(19, "BIDV", "BIDV", "", 2);
63INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
64VALUES(20, "Sea Bank", "SEABANK", "", 2);
65INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
66VALUES(22, "BacA Bank", "BACA", "", 3);
67INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
68VALUES(23, "Navibank", "NAVIBANK", "", 3);
69INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
70VALUES(24, "Agribank", "AGRIBANK", "", 3);
71INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
72VALUES(25, "Saigonbank", "SAIGONBANK", "", 3);
73INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
74VALUES(27, "PVCombank", "PVBANK", "", 3);
75INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
76VALUES(28, "ACB", "ACB", "", 3);
77INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
78VALUES(29, "LVBANK", "LVBANK", "", 3);
79INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
80VALUES(30, "BVBANK", "BVBANK", "", 3);
81INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
82VALUES(31, "OCB", "OCB", "", 3);
83INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
84VALUES(32, "KIENLONGBANK", "KIENLONGBANK", "", 3);
85INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
86VALUES(33, "VRB", "VRB", "", 3);
87INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
88VALUES(34, "MTV", "MTV", "", 3);
89INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
90VALUES(35, "NCB", "NCB", "", 3);
91INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
92VALUES(36, "PGBANK", "PGBANK", "", 3);
93INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
94VALUES(37, "GPBANK", "GPBANK", "", 3);
95INSERT INTO banks(bank_id, bank_name, bank_code, icon, vendor_id)
96VALUES(38, "VNPTWALLET", "VNPTWALLET", "", 2);