Skip to content

Instantly share code, notes, and snippets.

@luisnquin
Created January 19, 2022 02:30
Show Gist options
  • Save luisnquin/05b868c2b2eeaae0feaec34f74b79bde to your computer and use it in GitHub Desktop.
Save luisnquin/05b868c2b2eeaae0feaec34f74b79bde to your computer and use it in GitHub Desktop.
DROP TABLE IF EXISTS banking_entities CASCADE;
CREATE TABLE IF NOT EXISTS banking_entities(
id INTEGER GENERATED ALWAYS AS IDENTITY, --PRIMARY KEY
name VARCHAR(40) NOT NULL UNIQUE,
created_at DATE NOT NULL DEFAULT CURRENT_DATE,
PRIMARY KEY(id)
);
DROP TABLE IF EXISTS branches CASCADE;
CREATE TABLE IF NOT EXISTS branches(
id INTEGER GENERATED ALWAYS AS IDENTITY, --PRIMARY KEY
bank INTEGER NOT NULL, --FOREIGN KEY
location VARCHAR(90) NOT NULL,
created_at DATE NOT NULL DEFAULT CURRENT_DATE,
PRIMARY KEY(id),
CONSTRAINT fk_branchoffice_bankingentities FOREIGN KEY(bank) REFERENCES banking_entities(id) ON UPDATE CASCADE ON DELETE CASCADE
);
DROP TABLE IF EXISTS customers CASCADE;
CREATE TABLE IF NOT EXISTS customers (
identification_card INTEGER, --PRIMARY KEY
firstname VARCHAR(50) NOT NULL,
lastname VARCHAR(50) NOT NULL,
email VARCHAR(60) NOT NULL,
phone_number VARCHAR(12) NOT NULL,
city VARCHAR(45) NOT NULL,
PRIMARY KEY(identification_card)
);
DROP TABLE IF EXISTS franchises CASCADE;
CREATE TABLE IF NOT EXISTS franchises (
id INTEGER GENERATED ALWAYS AS IDENTITY,
name VARCHAR(30) NOT NULL UNIQUE,
PRIMARY KEY(id)
);
DROP TABLE IF EXISTS payment_methods CASCADE;
CREATE TABLE IF NOT EXISTS payment_methods (
id INTEGER GENERATED ALWAYS AS IDENTITY,
name VARCHAR(10),
PRIMARY KEY(id)
);
DROP TABLE IF EXISTS cards CASCADE;
CREATE TABLE IF NOT EXISTS cards (
card_number BIGINT, --PRIMARY KEY
identification_card INTEGER NOT NULL, --FOREIGN KEY
franchise INTEGER NOT NULL, --FOREIGN KEY
expires_at DATE NOT NULL DEFAULT CURRENT_DATE + INTEGER '1460',
secret_card_key VARCHAR(60) NOT NULL, --Bcrypt
secret_client_key VARCHAR(60) NOT NULL, --Bcrypt
branch INTEGER NOT NULL, --FOREIGN KEY
PRIMARY KEY(card_number),
CONSTRAINT fk_cards_customers FOREIGN KEY(identification_card) REFERENCES customers(identification_card) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT fk_cards_branches FOREIGN KEY(branch) REFERENCES branches(id) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT fk_card_franchises FOREIGN KEY(franchise) REFERENCES franchises(id) ON UPDATE CASCADE ON DELETE CASCADE
);
DROP TABLE IF EXISTS account_types CASCADE;
CREATE TABLE IF NOT EXISTS account_types (
id INTEGER GENERATED ALWAYS AS IDENTITY, --PRIMARY KEY
name VARCHAR(20) NOT NULL UNIQUE,
PRIMARY KEY(id)
);
DROP TABLE IF EXISTS currencies CASCADE;
CREATE TABLE IF NOT EXISTS currencies (
id INTEGER GENERATED ALWAYS AS IDENTITY, --PRIMARY KEY
name VARCHAR(20) NOT NULL UNIQUE,
PRIMARY KEY(id)
);
DROP TABLE IF EXISTS accounts CASCADE;
CREATE TABLE IF NOT EXISTS accounts (
account_number BIGINT, --PRIMARY KEY
interbank_account BIGINT NOT NULL UNIQUE,
money NUMERIC(20, 2) NOT NULL DEFAULT 0.00,
card_number BIGINT NOT NULL, --FOREIGN KEY
account_type INTEGER NOT NULL, --FOREIGN KEY
currency INTEGER NOT NULL, --FOREIGN KEY
PRIMARY KEY(account_number),
CONSTRAINT fk_account_card FOREIGN KEY(card_number) REFERENCES cards(card_number) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT fk_account_accounttype FOREIGN KEY(account_type) REFERENCES account_types(id) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT fk_account_currency FOREIGN KEY(currency) REFERENCES currencies(id) ON UPDATE CASCADE ON DELETE CASCADE
);
DROP TABLE IF EXISTS transactions CASCADE;
CREATE TABLE IF NOT EXISTS transactions(
id INTEGER GENERATED ALWAYS AS IDENTITY,
account_number BIGINT NOT NULL, --FOREIGN KEY
sender BIGINT NOT NULL, --FOREIGN KEY
receiver BIGINT NOT NULL, --FOREIGN KEY
money NUMERIC(20, 2) NOT NULL,
transaction_stamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY(id),
CONSTRAINT fk_accountmovements_accountnumber_account FOREIGN KEY(account_number) REFERENCES accounts(account_number) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT fk_accountmovements_sender_account FOREIGN KEY(sender) REFERENCES accounts(account_number) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT fk_accountmovements_receiver_account FOREIGN KEY(receiver) REFERENCES accounts(account_number) ON UPDATE CASCADE ON DELETE CASCADE
);
CREATE OR REPLACE VIEW general_customer_info AS
SELECT
cus.identification_card AS id_card,
CONCAT(cus.firstname, ' ',cus.lastname) AS fullname,
cus.email,
cus.city,
be.name AS bank,
bo.location AS branch,
ac.card_number,
at.name AS account_type,
cu.name AS currency
FROM customers AS cus
INNER JOIN cards AS ca ON cus.identification_card=ca.identification_card
INNER JOIN accounts AS ac ON ca.card_number=ac.card_number
INNER JOIN account_types AS at ON ac.account_type=at.id
INNER JOIN currencies AS cu ON cu.id=ac.currency
INNER JOIN branches AS bo ON bo.id=ca.branch
INNER JOIN banking_entities AS be ON be.id=bo.bank;
CREATE OR REPLACE VIEW banks_info AS
SELECT
bes.name AS bank,
br.location AS city,
(SELECT COUNT(*) FROM cards WHERE branch=br.id) AS customers
FROM banking_entities AS bes
INNER JOIN branches AS br ON br.bank = bes.id
ORDER BY bes.id ASC, br.id ASC;
CREATE OR REPLACE VIEW cards_info AS
SELECT
ca.identification_card AS id_card,
ca.card_number,
ca.expires_at,
(SELECT COUNT(*) FROM accounts WHERE card_number=ca.card_number) AS accounts,
br.location AS origin_city
FROM cards AS ca
INNER JOIN branches AS br ON br.id=ca.branch
ORDER BY ca.identification_card ASC;
CREATE OR REPLACE VIEW accounts_info AS
SELECT
ac.card_number,
ac.account_number,
ac.interbank_account,
cu.name AS currency,
ac.money,
at.name AS account_type
FROM accounts AS ac
INNER JOIN account_types AS at ON ac.account_type=at.id
INNER JOIN currencies AS cu ON ac.currency=cu.id
ORDER BY card_number ASC;
/*
CREATE OR REPLACE FUNCTION transaction_time()
RETURNS TRIGGER AS $$
BEGIN
UPDATE accounts SET money=OLD.money + received WHERE account_number=received;
UPDATE accounts SET money=OLD.money - sended WHERE account_number=sender;
RETURN NEW;
END
$$ LANGUAGE plpgsql;
CREATE TRIGGER TransactionUpdate AFTER UPDATE ON transactions
FOR EACH ROW
EXECUTE PROCEDURE transaction_time();
*/
-----------
INSERT INTO franchises(name) VALUES('Mastercard'), ('Visa');
-----------
INSERT INTO payment_methods(name) VALUES('Debit'), ('Credit');
-----------
INSERT INTO account_types(name) VALUES('Standard'), ('Premium');
-----------
INSERT INTO currencies(name) VALUES('Dollars'), ('Peruvian Soles');
-----------
INSERT INTO banking_entities(name) VALUES('National Bank');
INSERT INTO banking_entities(name) VALUES('RandBank');
INSERT INTO banking_entities(name) VALUES('Raspel');
INSERT INTO banking_entities(name) VALUES('Percel');
-----------
INSERT INTO branches(bank, location) VALUES(2, 'Persna'), (2, 'Math'), (2, 'Aesaturday'), (2, 'Ladol');
INSERT INTO branches(bank, location) VALUES(1, 'Tar'), (1, 'Dallas'), (1, 'Mitsure'), (1, 'New Japan'), (1, 'Aboutaesda');
INSERT INTO branches(bank, location) VALUES(3, 'Oial'), (3, 'Dallas'), (3, 'Ladol'), (3, 'Aboutaesda');
INSERT INTO branches(bank, location) VALUES(4, 'Teras'), (4, 'Math'), (4, 'Aesturday'), (4, 'Mire'), (4, 'Mitsure');
-----------
INSERT INTO customers VALUES(91722856, 'Paul', 'Wagner', '[email protected]', '926348636', 'Behābād');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291541102044064, 91722856, 1, '$2a$12$972x64N5xaI01D4sM99GP4o4N6583306F7kYk169Z3i49Cc64w..6', '$2a$12$Jjpe4oNg4559XF675q70eca2.ye293P/6/TIT4vtwt857RfA/13P5', 17);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(98094138885027, 00930314231908016210, 136472.17, 4291541102044064, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(98094138885027, 00930314231908016210, 136472.17, 4291541102044064, 1, 2);
INSERT INTO customers VALUES(61338282, 'Daniel', 'Shea', '[email protected]', '953574234', 'Madison');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291273615845399, 61338282, 2, '$2a$12$43110147w11v/m240AH2d1E0p.4OV15668495F63W3DOf653450/6', '$2a$12$dWCAR19V9W45sxM05190858tu.K5o262n43BXi06Z9091e689O9j8', 14);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(80964259238438, 00364736446263449913, 592704.4, 4291273615845399, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(80964259238438, 00364736446263449913, 592704.4, 4291273615845399, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(80964259238438, 00364736446263449913, 592704.4, 4291273615845399, 2, 2);
INSERT INTO customers VALUES(33234560, 'Anna', 'Cardenas', '[email protected]', '917365672', 'Hällefors');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291398424521474, 33234560, 2, '$2a$12$i11/ro3OHy2zs057r4e6M5592.P5704gEptm.32Ml6//dy//21330', '$2a$12$7V80L9D3647861l/57VzMlCJo5Xms6VewVJuIXB716pf1eT32IPv.', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(20023977362688, 00757146184608680304, 623653.82, 4291398424521474, 1, 2);
INSERT INTO customers VALUES(87457943, 'Richard', 'Wise', '[email protected]', '945643214', 'Yunxian Chengguanzhen');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291381779539722, 87457943, 1, '$2a$12$mc81.MW366Y./F735C3ed2pb461Z25aKX9H04TW80176J75Q1347m', '$2a$12$56.28j1E609Kts.gjz9Xy392Hl4.N1O427l826632y34qTpxG444A', 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(30861657240829, 00643309554114182660, 414767.16, 4291381779539722, 2, 2);
INSERT INTO customers VALUES(76201668, 'Melissa', 'Duncan', '[email protected]', '991389981', 'Rybnoye');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291559864431029, 76201668, 2, '$2a$12$481M3p1dRH5S38cu301/5D6s18oq76hkDH7p/.e8/2T2I/36a4sdu', '$2a$12$8Iif59/16n1a9l800Dg3nb792Hl2438H1U7HZU2x1905mZc/xjXp2', 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(50219527844824, 00456152254453009411, 711394.42, 4291559864431029, 2, 1);
INSERT INTO customers VALUES(80979924, 'Shelly', 'Davis', '[email protected]', '923126524', 'Bolorejo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291447578728223, 80979924, 2, '$2a$12$d763RyWY4n/8d65T8p018C33/6N83pN6.9Z9/53y540319700gms7', '$2a$12$3S10566w.A6Z0842y4404MGg6979l931F176277/v6eB0160e260E', 10);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(95367615796935, 00866646621433698752, 308355.74, 4291447578728223, 2, 2);
INSERT INTO customers VALUES(25807118, 'Mrs.', 'Megan', '[email protected]', '933240873', 'Madison');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291265759901665, 25807118, 1, '$2a$12$re957r7798O8a/c37Kn77662RM33u2Xh01575/142DO5KzCp8CH27', '$2a$12$9N9y9011/7/.8GT3NIbW217t23x89EvU1lv4P6j23G8x6Cc951edM', 13);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(21803100672742, 00895057168883610380, 322858.81, 4291265759901665, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(21803100672742, 00895057168883610380, 322858.81, 4291265759901665, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(21803100672742, 00895057168883610380, 322858.81, 4291265759901665, 2, 2);
INSERT INTO customers VALUES(58934080, 'Cindy', 'Ball', '[email protected]', '925257648', 'Yangfang');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291975419199439, 58934080, 2, '$2a$12$RA30L647Y8jWr45j996e2z.5326U4RIbbui6qq8v1LT1vJ5n6n6Dm', '$2a$12$.028j2ln0O.96rHeHT66xR503T4.ta681b21Pu31U.xpo793/iaGj', 12);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(14214949978205, 00348914604749698896, 998312.65, 4291975419199439, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(14214949978205, 00348914604749698896, 998312.65, 4291975419199439, 2, 2);
INSERT INTO customers VALUES(80137418, 'Eddie', 'Walker', '[email protected]', '934946636', 'Somba');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291794769363470, 80137418, 1, '$2a$12$0l1WTW5aU90q3qK0L9B.rczj/078T9n318CN64g.7460290J0sh83', '$2a$12$J946rF7965799404959pSJ0CAgm44UPcjdx3YuyL70o464BiR22/9', 10);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(83553756068714, 00334014746460214533, 566494.86, 4291794769363470, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(83553756068714, 00334014746460214533, 566494.86, 4291794769363470, 1, 2);
INSERT INTO customers VALUES(33077905, 'Teresa', 'Middleton', '[email protected]', '922326884', 'Yangfang');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291559551331063, 33077905, 1, '$2a$12$9DH8kJb5M3l3PYQ6Q24/28LdSw333.51s23s1WW440E6624QJC551', '$2a$12$K/M7671c87/S83/Jhu30g8m/3hIm.j514d550V8q368g5p8867X59', 13);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(74758768634917, 00686643803373700739, 487561.30, 4291559551331063, 2, 2);
INSERT INTO customers VALUES(66767091, 'Steven', 'Berg', '[email protected]', '935198535', 'Rybnoye');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291207273740253, 66767091, 1, '$2a$12$cMjP6S/8W74937/MXm4Ycd80WH325c955C1r48tgRt47g194BPDEJ', '$2a$12$6Rb720s24ed0B5m762sW/mk7F1oq0s67B6VYCpg9lc28b0L52.Y.e', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(33194019935985, 00846075368900481781, 27600.31, 4291207273740253, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(33194019935985, 00846075368900481781, 27600.31, 4291207273740253, 1, 1);
INSERT INTO customers VALUES(31062571, 'Mary', 'Fisher', '[email protected]', '963939440', 'Vienna');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291434213752472, 31062571, 2, '$2a$12$3V/0C.F.6LD.p51.5.y7o.PCl793J2V9077/G5518k83D9455Ym2.', '$2a$12$0lma798yt7M6OzN78cP42q/451278/7b921A7AtT/2H.6g4.7ACu2', 7);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(26276338475252, 00676519096975688209, 264926.86, 4291434213752472, 2, 1);
INSERT INTO customers VALUES(64804328, 'Nancy', 'Neal', '[email protected]', '965952916', 'Yangfang');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291280365605106, 64804328, 1, '$2a$12$p9iU97E738.22621/4L4.A8W8.u9lAHHe/4sBu41365Ebq75Q36q7', '$2a$12$7y/h5/PX89a3mj79R.038hjD204.714g34.m9010.67e18p.iwSS7', 18);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(87305514787695, 00399763597398330875, 863727.72, 4291280365605106, 2, 1);
INSERT INTO customers VALUES(43294607, 'Jason', 'Thomas', '[email protected]', '988165884', 'Rybnoye');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291715256607785, 43294607, 1, '$2a$12$7ESmth2NW2Yml79v3/X/7liU37K50u./.U9uD4A7cl686310OCvP6', '$2a$12$n43nU7bpE455XsU610730aPz8H388UB57.1v/85171blyy5R6/QL8', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(95640696140686, 00166240165579977686, 844146.60, 4291715256607785, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(95640696140686, 00166240165579977686, 844146.60, 4291715256607785, 2, 2);
INSERT INTO customers VALUES(18271980, 'Todd', 'Ramirez', '[email protected]', '966550560', 'Behābād');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291109546958809, 18271980, 1, '$2a$12$g2H3chv77WmUHa3H59p18DH48R035W902HYGLo81y87o993Z58b4o', '$2a$12$1d3332367.d3zEQ319N7I9801G/88565j552U19nit0A.qL432MO7', 5);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(40191851905212, 00724031794458398500, 909441.1, 4291109546958809, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(40191851905212, 00724031794458398500, 909441.1, 4291109546958809, 2, 2);
INSERT INTO customers VALUES(74210063, 'Tina', 'Berger', '[email protected]', '967224584', 'Behābād');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291174354781797, 74210063, 2, '$2a$12$2hvS.R290R3r01Y6826k3724addH307BA3.k73bp66n75v38408/4', '$2a$12$.J/3z6E299x785a5Fp442M2332c07z95553827z4/1C0K9m224E90', 17);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(54339189285179, 00249253444021177301, 752289.88, 4291174354781797, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(54339189285179, 00249253444021177301, 752289.88, 4291174354781797, 1, 1);
INSERT INTO customers VALUES(44618447, 'Todd', 'Burgess', '[email protected]', '964362904', 'Ramaram');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291555529491629, 44618447, 1, '$2a$12$/.hr089U17KX3/7E627c4q3827Umr9B502akpdi6shD9Q813v4P/F', '$2a$12$03p1e4N23f.474fO5c5e8.7hT06.0p597XN7ZTo1938U19a347757', 15);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(81968057694728, 00387103542254820430, 381444.89, 4291555529491629, 2, 1);
INSERT INTO customers VALUES(25629270, 'Stephen', 'Becker', '[email protected]', '968879531', 'Mungging');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291119878609606, 25629270, 1, '$2a$12$/Y.oFCK4x37704N66iQ.154328f73X1RQ.1468751c0F3FYal7g87', '$2a$12$4J7j4VS2J84hVf425d4D1k892X81O4U3482671Vbj57f374Q43j6Y', 3);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(37112327053411, 00195287950317544676, 229924.1, 4291119878609606, 1, 2);
INSERT INTO customers VALUES(48022701, 'Samantha', 'Anderson', '[email protected]', '936867203', 'Santo Domingo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291435657731294, 48022701, 2, '$2a$12$s.1Cyl8C72EUOo37T.54aCwu3sI781828uUG659Zi15FJ697cs2d3', '$2a$12$s.88cg3B53Ljts/I507780yh12JS8Ap34816839DbDK8Tt8.m71/1', 12);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(76179185808315, 00666847569185729960, 544751.78, 4291435657731294, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(76179185808315, 00666847569185729960, 544751.78, 4291435657731294, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(76179185808315, 00666847569185729960, 544751.78, 4291435657731294, 1, 2);
INSERT INTO customers VALUES(31291447, 'Sandra', 'Mayo', '[email protected]', '934557197', 'Tuka');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291308131254969, 31291447, 2, '$2a$12$58f0029SEy4rqZGy39l9mG7.uLi4E951z9js27/M2e5u.vD7c1767', '$2a$12$42ZZeD967GO83scru8Dkk5x81Wb..T56xaH7/2947S78.2./9531E', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(27372177482820, 00962991601350040491, 35259.16, 4291308131254969, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(27372177482820, 00962991601350040491, 35259.16, 4291308131254969, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(27372177482820, 00962991601350040491, 35259.16, 4291308131254969, 2, 2);
INSERT INTO customers VALUES(29473447, 'Scott', 'Barnes', '[email protected]', '949673601', 'Rybnoye');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291939738886382, 29473447, 1, '$2a$12$5D/t/9Qzl955sw052A2.52Rj5yUu5SLO955v9p6kVO2p7P539Qijs', '$2a$12$837054c0159NJ7O853/06G4G7M117Pdx6fa5Z4i3SZAJ5Ah92H631', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(21973992727221, 00145814485896153753, 672152.35, 4291939738886382, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(21973992727221, 00145814485896153753, 672152.35, 4291939738886382, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(21973992727221, 00145814485896153753, 672152.35, 4291939738886382, 1, 1);
INSERT INTO customers VALUES(92333008, 'Monica', 'Morris', '[email protected]', '972226269', 'Santo Domingo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291234800170105, 92333008, 1, '$2a$12$a9111.d/K9Td7472.Ke1327o82US4Ut.ehfw89/sub9yrXp4.3201', '$2a$12$9dEAz518/p8oai0ZDb40q/6v143/jRaI66zV5v2Nkc3268pkZ4t8E', 7);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(36013178641389, 00950486037137055692, 825599.3, 4291234800170105, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(36013178641389, 00950486037137055692, 825599.3, 4291234800170105, 2, 1);
INSERT INTO customers VALUES(98836876, 'Ana', 'Parsons', '[email protected]', '989078998', 'Tuka');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291420220124832, 98836876, 1, '$2a$12$89O7vp78z53H6PBz6o1r6CERY.4evBelL1TN2046.850Z808.R..1', '$2a$12$Eh183CZZ7F215ZYi38j9ep29j7P5Y3B/.kg4Vw3205822tc1H8vOP', 4);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(11460174115106, 00620823355680057459, 925117.55, 4291420220124832, 2, 1);
INSERT INTO customers VALUES(20924821, 'Cristian', 'Alvarez', '[email protected]', '954970283', 'Bayan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291782579494032, 20924821, 1, '$2a$12$.9StlkRyXY087Cq83c8n042t8n9l7V4G708476Xmlt92fp3f516L7', '$2a$12$1332l4Odaf464Ny2yvH85K10slF7.7x2/6g37WMUK.25/0M0I4f29', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(91853029614461, 00700889901801112490, 452030.20, 4291782579494032, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(91853029614461, 00700889901801112490, 452030.20, 4291782579494032, 1, 1);
INSERT INTO customers VALUES(54551652, 'Heather', 'Johnson', '[email protected]', '981228186', 'Santo Domingo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291401054119161, 54551652, 1, '$2a$12$682f49J0/Y0Eck88085Q/8Cgtj68P4189DB274F3Y7V6DcK7C377A', '$2a$12$e6u17LJfpGEE.63842/1.22vq49mwh9yyl9ijm15696644J4W4726', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(56728334347014, 00521885028800213723, 361608.93, 4291401054119161, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(56728334347014, 00521885028800213723, 361608.93, 4291401054119161, 2, 1);
INSERT INTO customers VALUES(80067033, 'Ryan', 'Drake', '[email protected]', '981442049', 'Somba');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291457517464981, 80067033, 2, '$2a$12$K/HkBlX7qXpg4R0l829l249fR6390TZG976I44YwD1/w.c02O02/G', '$2a$12$PL0.k39c9.n1PXNL9f14Ui6GW556.52C9431C9Jme9011Ib91E3MW', 11);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(67573180719423, 00135735332544997688, 804700.50, 4291457517464981, 1, 2);
INSERT INTO customers VALUES(78158584, 'Matthew', 'Abbott', '[email protected]', '983449890', 'Tuka');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291236995632224, 78158584, 2, '$2a$12$330b/37If10051y0M0cm4T854.6P03.Rj0.L20L91a25X9L96A5Sq', '$2a$12$6x3td8/F1873E865/6a236k2tS72icA72rA227/24/76qBCt7aw4t', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(72286438940369, 00945654165226323195, 381211.5, 4291236995632224, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(72286438940369, 00945654165226323195, 381211.5, 4291236995632224, 2, 1);
INSERT INTO customers VALUES(63889225, 'Sara', 'Middleton', '[email protected]', '966836461', 'Mazraat Bayt Jinn');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291482355520064, 63889225, 2, '$2a$12$vst678Gc2ao08Q47aSLtw447388VS6J8Mh/3049880g.g1ZLH8885', '$2a$12$4.6N0R9764k3O/5L.4a.ID5/P6RV0nJo777a8400H58bh09199162', 17);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(88957673564860, 00744067502449913417, 545490.61, 4291482355520064, 1, 2);
INSERT INTO customers VALUES(54059229, 'Adriana', 'Rosales', '[email protected]', '931729733', 'Yunxian Chengguanzhen');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291147658518272, 54059229, 1, '$2a$12$q6o9xHxf14/64w3709185d66/2A/MDVe14dY662Z5N8kYNf84RjFc', '$2a$12$gtZ0Ic249/18Dfo8ly/e98V10r3yL1OO411/G4423V9rOc9/0b2n.', 3);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(91618139794705, 00678907014180382202, 287915.8, 4291147658518272, 2, 2);
INSERT INTO customers VALUES(29198364, 'Elizabeth', 'Rodriguez', '[email protected]', '915655732', 'Mungging');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291242574794041, 29198364, 2, '$2a$12$B42R2h/n097pPD1G02941zTjtSp220fXfr6ZG81wG4m883./92d62', '$2a$12$D3za7A3yn831l0K1p839C9Z31D93o9CVu/442RGoQQ3f883E33/j3', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(35554411986247, 00920794448010850240, 796503.2, 4291242574794041, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(35554411986247, 00920794448010850240, 796503.2, 4291242574794041, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(35554411986247, 00920794448010850240, 796503.2, 4291242574794041, 2, 2);
INSERT INTO customers VALUES(58105794, 'Walter', 'Henry', '[email protected]', '987581568', 'Madison');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291588728199020, 58105794, 2, '$2a$12$C10152g.9XJ683//8h1632U55/1LssL81HFN78MDb.q4ThCvdK55a', '$2a$12$48U4/7DTxdr.7.6e..5W9e7D732uk3zK913.0i7w76m9318X214l1', 5);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(76047713792462, 00216060890070765112, 368497.37, 4291588728199020, 2, 1);
INSERT INTO customers VALUES(78377130, 'James', 'Jackson', '[email protected]', '959555982', 'Madison');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291112448085295, 78377130, 1, '$2a$12$05u2oE3Pz9ova9Xf539Jk/fNZ8838k6zS4818AOf0w4p91Avg128k', '$2a$12$jNtvus3r9wJ7I490/z6w3B7K7e//8GWNv90648XP68p39139gsm9t', 13);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(42152989072346, 00337137815666917664, 905322.95, 4291112448085295, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(42152989072346, 00337137815666917664, 905322.95, 4291112448085295, 1, 2);
INSERT INTO customers VALUES(75483600, 'Duane', 'Stephens', '[email protected]', '914759869', 'Yangfang');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(42918339116386, 75483600, 2, '$2a$12$64s867153x6.UG7221vx2e4VJ3b98n4C0WdJG0a5Zyw.B6K1n21FF', '$2a$12$RXgcy8141O97o9wLp5Mv656.81RmPA84475H1i7J6l9a/Iz0GMy26', 12);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(64976724172921, 00565438695340394961, 315521.86, 42918339116386, 2, 1);
INSERT INTO customers VALUES(38059849, 'Alexandra', 'Garcia', '[email protected]', '913528309', 'Mungging');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291928907782910, 38059849, 2, '$2a$12$3/RWu.62KP78Vh0.R5.X16v128bbR56i76tJ2AX070G80ZYCg478y', '$2a$12$StI91nKsW7l57w1Iw51IMrzqlhZ5m144.769F/5764I0xDD55UZ84', 11);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(59129719277828, 00155831072255362605, 313007.15, 4291928907782910, 1, 2);
INSERT INTO customers VALUES(78825554, 'Timothy', 'Johnson', '[email protected]', '945244597', 'Yangfang');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291325054564248, 78825554, 1, '$2a$12$786/hL26hePG7NO9g4U343400Zp05W9G/a8ya6o36uyy.LY64.q6m', '$2a$12$a937tx7B7cN4R992hr7965rvN559969Gx331GDK790.N195b0L7b7', 8);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(58392450460411, 00923176500253671825, 134511.66, 4291325054564248, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(58392450460411, 00923176500253671825, 134511.66, 4291325054564248, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(58392450460411, 00923176500253671825, 134511.66, 4291325054564248, 1, 2);
INSERT INTO customers VALUES(90918643, 'Robert', 'Barnes', '[email protected]', '956696263', 'Santo Domingo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291714130119747, 90918643, 1, '$2a$12$3j103qRQhL4GJJ9q66Cnl1n7b03jy48TD7/68tm538lhErqJh1689', '$2a$12$t58e6O0841/8C365o0Anwo8O05/1833TpEt04L.X8042bx13v973F', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(36511727152402, 00652598750846545764, 956532.29, 4291714130119747, 2, 2);
INSERT INTO customers VALUES(84416886, 'James', 'Butler', '[email protected]', '912579079', 'Mazraat Bayt Jinn');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291984154625701, 84416886, 2, '$2a$12$/e59a804B/584/oB4z7wG431KrKX92iy4Atcw2Y.52gVJT75Yg170', '$2a$12$7.M5E30qG0ZT6a9bX0kn5.1H5r7/I68o93/03b3659c4FDu0q2DPb', 5);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(25009872710573, 00777235595846915678, 569924.64, 4291984154625701, 2, 1);
INSERT INTO customers VALUES(53317512, 'Andrea', 'Williams', '[email protected]', '962219298', 'Madison');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291267706371751, 53317512, 1, '$2a$12$Szc261Co0d5187v2g2.2960y/569N785jE076sO0y799Xr4/B7jJS', '$2a$12$060xdV055.89o54D748KV77/5908jt0XximV08B3448lwJQ1e0z/6', 9);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(84005805754089, 00257161660029140177, 824195.57, 4291267706371751, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(84005805754089, 00257161660029140177, 824195.57, 4291267706371751, 1, 2);
INSERT INTO customers VALUES(52022327, 'Jamie', 'Schultz', '[email protected]', '942219999', 'Bayan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291376385291616, 52022327, 2, '$2a$12$73LMXuQ86.69UNcW4k873.6U7N47D8h8h7636ozeYC494087o9dHq', '$2a$12$R7R656u2P681Tw8Jz24P5.A10X2Y63HTWSD/v552.x083R5511154', 18);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(65975980004972, 00293223631610818326, 741830.58, 4291376385291616, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(65975980004972, 00293223631610818326, 741830.58, 4291376385291616, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(65975980004972, 00293223631610818326, 741830.58, 4291376385291616, 1, 2);
INSERT INTO customers VALUES(65369805, 'Brian', 'Brown', '[email protected]', '977170788', 'Mungging');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291526012069388, 65369805, 1, '$2a$12$2e110o6/U2S2GLCmq20r0.yrAU28344c.Vb4Ss80b82Y47Z4I4AhH', '$2a$12$h527g0n96408eg/317VDF1326Yr.i.5wZoO/tF865u8.fr458W./Z', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(97529024652433, 00436946763938667169, 330722.38, 4291526012069388, 2, 1);
INSERT INTO customers VALUES(60254831, 'Rita', 'Collier', '[email protected]', '969392861', 'Bolorejo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291504653286861, 60254831, 1, '$2a$12$j92c8KkWL7/Ib883aQ8Z24IGs5F37.68P4zoH6bm2094y7O0R4ai7', '$2a$12$QH5448x78d986a6d13.0L/p9OsIoFL03U71d/91e/950M6X14.O3h', 10);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(17470632998443, 00626662465248880994, 339171.96, 4291504653286861, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(17470632998443, 00626662465248880994, 339171.96, 4291504653286861, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(17470632998443, 00626662465248880994, 339171.96, 4291504653286861, 1, 2);
INSERT INTO customers VALUES(29594859, 'Nicholas', 'Cordova', '[email protected]', '927824159', 'Somba');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291156968652995, 29594859, 2, '$2a$12$216/jn2S6zjv1tV05j2d96A3733mRTE88102cy447F12X75t152/u', '$2a$12$2T2m03b34x9h0734HCy4Z715968lri3p960cGy.99S27cy6q3pQnv', 14);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(47344410116084, 00476883656755402148, 222468.0, 4291156968652995, 1, 1);
INSERT INTO customers VALUES(62519624, 'Kristi', 'Guerrero', '[email protected]', '935612540', 'Yunxian Chengguanzhen');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291652451607320, 62519624, 1, '$2a$12$834/1n7/6..g3Q1K90.0y76z1sXqi83229MX05iW4mO.n554l80aV', '$2a$12$3k9L3m5RU07031.8qZ150ti897XtwB/09Nt.v91045RT/gAx4370J', 5);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(38724742184883, 00829573049213077830, 923428.86, 4291652451607320, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(38724742184883, 00829573049213077830, 923428.86, 4291652451607320, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(38724742184883, 00829573049213077830, 923428.86, 4291652451607320, 1, 1);
INSERT INTO customers VALUES(89398448, 'Lisa', 'Moses', '[email protected]', '921011391', 'Santo Domingo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291424185020030, 89398448, 2, '$2a$12$Io03766X6Ab8187738Y56O.N78OLg/89731y0UA22353twYmJ.//7', '$2a$12$y4RTJ91y.Ki6Lk94580l.649OY630a528lZSb6AiN/1muEk977V6f', 13);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(79634295266938, 00331899165152302855, 988107.34, 4291424185020030, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(79634295266938, 00331899165152302855, 988107.34, 4291424185020030, 1, 1);
INSERT INTO customers VALUES(99681111, 'Bryce', 'Lopez', '[email protected]', '920903430', 'Somba');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291656819177921, 99681111, 2, '$2a$12$o/mYm931I91811/R//fA27.1jv3b085.x2g/t5403Wv6rG/6nE61Y', '$2a$12$j9248yo36T.A3w27otR6vKczWGJ.0da3Spy01.8//00//272q24vd', 16);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(57886582482839, 00593913349867887956, 66324.43, 4291656819177921, 2, 2);
INSERT INTO customers VALUES(73871420, 'Derek', 'Thomas', '[email protected]', '912795000', 'Yunxian Chengguanzhen');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291473531407903, 73871420, 1, '$2a$12$2.s9B8.fJ36vF.JB3L782QHrDs0f93VSp87gZ9309F34o5Ua78p32', '$2a$12$EFPKWSn.fs4w13KV/7y87079Ri6w7441qbE.UT44nn3i3ldO313M/', 17);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(47155818116490, 00625098800873139409, 398896.32, 4291473531407903, 1, 2);
INSERT INTO customers VALUES(98504585, 'Kimberly', 'Combs', '[email protected]', '945751592', 'Mungging');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291790741769569, 98504585, 2, '$2a$12$K4294905//IG5/66123CSA2999/45.1v09m54wxYd9m393187P47t', '$2a$12$12p2738i26rS7pH07O848Bj38.c5n8UO70Y2fK3I273023n7v32sP', 18);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(16975239752518, 00942394475152896241, 576582.81, 4291790741769569, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(16975239752518, 00942394475152896241, 576582.81, 4291790741769569, 2, 2);
INSERT INTO customers VALUES(23098147, 'Melissa', 'Davis', '[email protected]', '958988989', 'Rybnoye');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291259463991878, 23098147, 2, '$2a$12$73Pie024T78TA9J/9092tF4EXK9/SX6ng1664F1N3/F7LC254uibU', '$2a$12$011n9Er9O8Hi7/W.9Q9mat070i9mtDW/8434moMur6iShv7p4/9H.', 14);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(28753981959786, 00389254180986486588, 772600.67, 4291259463991878, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(28753981959786, 00389254180986486588, 772600.67, 4291259463991878, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(28753981959786, 00389254180986486588, 772600.67, 4291259463991878, 2, 2);
INSERT INTO customers VALUES(99965116, 'Jacqueline', 'Rollins', '[email protected]', '910212103', 'Hällefors');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291736670331469, 99965116, 2, '$2a$12$36voZ00/1b97zV5W0A3yN72oc38sw280D84k0N26R17mEqS24x07t', '$2a$12$3S506394s94Q42P51G93i76916394HQTIzkF6U102C8IM.11An68P', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(87756028714723, 00561305998319315965, 23618.80, 4291736670331469, 2, 2);
INSERT INTO customers VALUES(14348068, 'Charles', 'Walsh', '[email protected]', '981531556', 'Hällefors');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291672016728812, 14348068, 2, '$2a$12$/V69I1307.988m1Sxs1e94D80FzpF565r.4t/V4t7p/5/0P6.e88r', '$2a$12$228o01c//73d785SmHK95g90kR03d39150todhN91r9839D5Q77d9', 3);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(19872616250611, 00353129227774220278, 284641.8, 4291672016728812, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(19872616250611, 00353129227774220278, 284641.8, 4291672016728812, 2, 2);
INSERT INTO customers VALUES(25443379, 'Kim', 'Williams', '[email protected]', '955478000', 'Ramaram');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291858150409994, 25443379, 2, '$2a$12$kz2q422i/2YR7c56vG3VjNEeA4571p1321U0Hd1Bg61175j2621w7', '$2a$12$37Rd86Pk09tQ3U0/RM7Nv20805Wv91/958Z515ew2748k71sO22y0', 13);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(58100215910584, 00104292279701388213, 38856.55, 4291858150409994, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(58100215910584, 00104292279701388213, 38856.55, 4291858150409994, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(58100215910584, 00104292279701388213, 38856.55, 4291858150409994, 1, 2);
INSERT INTO customers VALUES(78608259, 'Wayne', 'Edwards', '[email protected]', '916408429', 'Bayan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291734226983497, 78608259, 1, '$2a$12$f6J5064466Gz5N.D/4jJ2i4UnniB3h2oA02H47.70N5BiC49wm4Af', '$2a$12$hu28m847go3d58h06W9k9y40jY6V/C4lU..bn3wp3R80/J4X113H0', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(52619947471095, 00779312081503527119, 120407.7, 4291734226983497, 1, 2);
INSERT INTO customers VALUES(19140921, 'Deborah', 'White', '[email protected]', '934866200', 'Ramaram');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291799122623461, 19140921, 1, '$2a$12$d5G6E265e8D6J6q/65.0HMlQY18G.15vc4KK08ie2/1/V8zwURm95', '$2a$12$CBxgu.01a.X.Y7j19715R..U//438E3c17.E6disX9/3v32478T.G', 18);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(80471537471059, 00206503016133374214, 451815.61, 4291799122623461, 2, 2);
INSERT INTO customers VALUES(22633693, 'Shawn', 'Flores', '[email protected]', '977206093', 'Saipan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291233727041775, 22633693, 1, '$2a$12$T/9d//1FRD79A/b5t36cp76serT13820HW432333EpY7/4TtoN680', '$2a$12$3s78Wr9G3n66g4qaZ690/65bp658q57wZ5U/qC32G237AD7o7/ZZY', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(89493813289280, 00329028367848930928, 436124.85, 4291233727041775, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(89493813289280, 00329028367848930928, 436124.85, 4291233727041775, 1, 2);
INSERT INTO customers VALUES(29054000, 'Brittney', 'Hensley', '[email protected]', '939891872', 'Bolorejo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291287929634716, 29054000, 1, '$2a$12$QHIW.b87637/5.98494N8561N2b7W6SAO40zx0668q5f557/62C13', '$2a$12$huu/Wmv884/U50iR3uz520w5K465..HZF7.J68369I62J.fE6w464', 11);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(30097789540551, 00206670702191226566, 734971.98, 4291287929634716, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(30097789540551, 00206670702191226566, 734971.98, 4291287929634716, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(30097789540551, 00206670702191226566, 734971.98, 4291287929634716, 1, 2);
INSERT INTO customers VALUES(68650892, 'Susan', 'Shaw', '[email protected]', '983422800', 'Ramaram');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291756831944919, 68650892, 2, '$2a$12$8978035iji.7n9Q2P428YgoVnKVt1298DM.1.5ZJ57PK36F.4y750', '$2a$12$Y85703rT8z49M37Oa6z88VoKsd.EM4nrpNW.G983l2qKhv.9F929C', 9);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(15909753744376, 00148481895405541318, 967508.57, 4291756831944919, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(15909753744376, 00148481895405541318, 967508.57, 4291756831944919, 2, 2);
INSERT INTO customers VALUES(60837178, 'Chase', 'Anderson', '[email protected]', '924573547', 'Somba');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291295286158976, 60837178, 1, '$2a$12$ke823H0827gWXe03af7G33v..6.73.9/e4K1/UZSdDTAxVQ45gF48', '$2a$12$6380c2w59149C1.2tn554081113YHF3.207/7RI13B2t8aQW58Qz/', 11);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(16337562157765, 00182645167193087352, 690324.1, 4291295286158976, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(16337562157765, 00182645167193087352, 690324.1, 4291295286158976, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(16337562157765, 00182645167193087352, 690324.1, 4291295286158976, 2, 1);
INSERT INTO customers VALUES(16711631, 'Daniel', 'Gross', '[email protected]', '985748776', 'Madison');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291440920555371, 16711631, 2, '$2a$12$3q5rl4DIE3ERv8M160w26s365261s/06i7V4e41617Q4Q045728os', '$2a$12$m6Np/x4.V40S9F3Z55aHVD8b761Y69H30fn19A3/VG0385db.dcZ4', 12);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(59338747744281, 00104860649761128471, 870043.95, 4291440920555371, 2, 2);
INSERT INTO customers VALUES(40178996, 'Alexander', 'Carroll', '[email protected]', '968937979', 'Yangfang');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291195932522569, 40178996, 1, '$2a$12$4.3C686/152W4186Sra7.LA0XF8q5Xk30.wH0H6xk240C01431Qr.', '$2a$12$37OB8Ys38pT29478kw8Ma7831ayk61p0wl5T0/.5/2830.i/2O29o', 8);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(56550501402755, 00462918994774195881, 666361.68, 4291195932522569, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(56550501402755, 00462918994774195881, 666361.68, 4291195932522569, 1, 1);
INSERT INTO customers VALUES(66580330, 'Melissa', 'Cervantes', '[email protected]', '941378532', 'Behābād');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291128055687916, 66580330, 2, '$2a$12$1XX2679M74990469/Bpj7E.35A350Yo8Z31i962qb853TP97iD/4p', '$2a$12$79yO5y7/x501Fm7Fz6S3b73856m50rGr76xX825Q07hTz326Xc252', 9);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(68658660844971, 00275089800337450046, 463014.77, 4291128055687916, 1, 2);
INSERT INTO customers VALUES(16257870, 'Julie', 'Porter', '[email protected]', '998635573', 'Hällefors');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291820842272620, 16257870, 2, '$2a$12$.v.SrQ4u0k311/3TL7HD17w4750N685x9e0.68v5ew85H1l403j2/', '$2a$12$628r2TTcV.Iw33h/r6Pg24676Z8Tcz31U2o35goRs7HtE9u133N5B', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(17319078686991, 00519262174660404146, 806686.6, 4291820842272620, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(17319078686991, 00519262174660404146, 806686.6, 4291820842272620, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(17319078686991, 00519262174660404146, 806686.6, 4291820842272620, 2, 1);
INSERT INTO customers VALUES(50167926, 'Nicole', 'Joyce', '[email protected]', '945111739', 'Yangfang');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291580414998726, 50167926, 2, '$2a$12$214nkq5dvx2c60J7N6//I.y1BR4Q7pH3Vv9/0Z7a19h4zWX52EeZO', '$2a$12$C2AL679150.88pK4C8V42jm0c/2.7/u6/5COK8T4q386tX9eZBG34', 7);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(52521516096576, 00417499598977936945, 680009.81, 4291580414998726, 1, 1);
INSERT INTO customers VALUES(17496032, 'Michael', 'Martin', '[email protected]', '976664346', 'Saipan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291943113507874, 17496032, 1, '$2a$12$U85qBfAzX775Ru88S/u209/1x57n1497Tr69.738q35Zk.r.Q/p9u', '$2a$12$9M4Ji80O6qe./4MG/0N8r6.t24/TJT75F56.82k2L9WBLaV85EUe6', 12);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(78430620532844, 00918678559067776423, 651761.49, 4291943113507874, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(78430620532844, 00918678559067776423, 651761.49, 4291943113507874, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(78430620532844, 00918678559067776423, 651761.49, 4291943113507874, 1, 1);
INSERT INTO customers VALUES(44536217, 'Edward', 'Mitchell', '[email protected]', '998379207', 'Santo Domingo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291975817128146, 44536217, 2, '$2a$12$D2.WGZE5m2898l.357V7302t3ZZP4e972NoV542616h6a3Aam2L36', '$2a$12$Irp7192l/889380Wf18226KAnhq35UEmxfWP71HHK8/46nh6Dnpp2', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(51175521798132, 00243195292712073411, 880128.50, 4291975817128146, 2, 2);
INSERT INTO customers VALUES(56264824, 'Audrey', 'Mendoza', '[email protected]', '988638130', 'Mazraat Bayt Jinn');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291970898583103, 56264824, 2, '$2a$12$59w4CD077C3c6td6FHJv5p97T95S8m83473C3hW7Y4K1J1k3Mp9B/', '$2a$12$416YA4677v9h9C00bf388813e9Nz03J4D.QbO9B7q8/b1rt07Dt19', 9);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(93948557106158, 00467061472804942407, 585491.33, 4291970898583103, 1, 1);
INSERT INTO customers VALUES(31417270, 'Daniel', 'Reyes', '[email protected]', '929488460', 'Quaraí');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291221794799131, 31417270, 2, '$2a$12$8Ek2JdO143w440J8Y.086719Bb40zw9UWobE5.04Cl14/K7Q9/MZ0', '$2a$12$2WJu2b4L8v2y2S2.4.7f/090I16unmA1J5QBs0V/84.z1432/g0OY', 18);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(44929378233862, 00976953243831651235, 908183.80, 4291221794799131, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(44929378233862, 00976953243831651235, 908183.80, 4291221794799131, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(44929378233862, 00976953243831651235, 908183.80, 4291221794799131, 2, 1);
INSERT INTO customers VALUES(68598339, 'Laura', 'Carr', '[email protected]', '955418030', 'Santo Domingo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291762432302972, 68598339, 1, '$2a$12$iZ1Br4358v7412/94d/9719M/Mis7aYGqs5W17Y26.GwM79x7J93N', '$2a$12$9R43RHVv.27f3o9i3G47.ra/G9639Dt1du.j.4E7GJx1.39141t9i', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(99131690252177, 00457421761760109855, 12646.65, 4291762432302972, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(99131690252177, 00457421761760109855, 12646.65, 4291762432302972, 1, 1);
INSERT INTO customers VALUES(98111380, 'Michelle', 'Garcia', '[email protected]', '932046147', 'Mungging');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291269046921194, 98111380, 2, '$2a$12$K51c5DNE399927v9Jx/3D..77B828wuB7S84Q9v3n0.X2/00gpYv4', '$2a$12$pbJR9KXQHHL4NX76SZem817x5.21iS34c6A462Q77u9j12Up0H/B9', 15);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(96547402092218, 00256675006342679366, 24588.42, 4291269046921194, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(96547402092218, 00256675006342679366, 24588.42, 4291269046921194, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(96547402092218, 00256675006342679366, 24588.42, 4291269046921194, 2, 2);
INSERT INTO customers VALUES(26688247, 'Laura', 'Murphy', '[email protected]', '991172021', 'Mungging');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291450464573124, 26688247, 2, '$2a$12$083z/29O58K281mu37.RCL6Ws0.Fi0i4782/87TY996A786x7euGM', '$2a$12$od3v2628196W52X14Kyu08h7.Ltu4a1NChi8.47142.74I4288xCf', 10);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(53693317282588, 00335343902997014439, 967239.81, 4291450464573124, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(53693317282588, 00335343902997014439, 967239.81, 4291450464573124, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(53693317282588, 00335343902997014439, 967239.81, 4291450464573124, 1, 1);
INSERT INTO customers VALUES(74138262, 'Christopher', 'Garza', '[email protected]', '978466035', 'Hällefors');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291549074451383, 74138262, 2, '$2a$12$44.5u5n4cV1/.N.761.owol1H.y30CF68bDP87s/u898bz5qN1/D4', '$2a$12$U6O3T6/x9qYy4SoeRJEiJL91zW2B/201./62.gmP4128.365202/Y', 13);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(27467493231138, 00311363719720034927, 72789.0, 4291549074451383, 2, 2);
INSERT INTO customers VALUES(91151616, 'Linda', 'Watson', '[email protected]', '917386445', 'Somba');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291618129525296, 91151616, 1, '$2a$12$l2C52rvJ37yxG/B3Y253kL5TK463N994611o7cI6dGm5P5e453EC7', '$2a$12$11379mi2wnE5//0A6202G7h2.55GTQ8Pc6U0c49i14jh272FMqodE', 9);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(35084650309679, 00544306679548040162, 679128.72, 4291618129525296, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(35084650309679, 00544306679548040162, 679128.72, 4291618129525296, 2, 2);
INSERT INTO customers VALUES(31114290, 'Kevin', 'Brown', '[email protected]', '959907233', 'Ramaram');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291317201009948, 31114290, 1, '$2a$12$3DA8044254LA5lJ6x5/99u7Kf085S9Q1622A58tOR/4v.h.Qb.WO6', '$2a$12$r6Qyyz9304j7/jU1g.0.1373GOq66Dv6/1lS4E20wm97s8I7j.926', 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(59393387545527, 00725282699024531700, 415201.95, 4291317201009948, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(59393387545527, 00725282699024531700, 415201.95, 4291317201009948, 2, 2);
INSERT INTO customers VALUES(20818866, 'Hunter', 'Howard', '[email protected]', '928692718', 'Bayan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291150540008655, 20818866, 2, '$2a$12$p1904EPU.6N7t5lW9c3.O9VMN9u239Cmv/Q468q63yO7xy1916V3B', '$2a$12$inI.A27P.6Sc8HgTjM8rq7T08pqL2d0j7w97041LPoY3/25C08yzk', 7);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(80379450676414, 00903491618717587737, 854650.40, 4291150540008655, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(80379450676414, 00903491618717587737, 854650.40, 4291150540008655, 2, 2);
INSERT INTO customers VALUES(48601120, 'James', 'Anderson', '[email protected]', '969610994', 'Bolorejo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291832578206425, 48601120, 2, '$2a$12$9801u1E7Yh64..l0x1y38Ksh02X1KQ4AP78qO4S1dR38Bg75PJ082', '$2a$12$4513c.R545R91r46/B/TX61856X147TiP26/xCT559xJy0ua70106', 16);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(73409800592884, 00370535721850768834, 28915.80, 4291832578206425, 2, 1);
INSERT INTO customers VALUES(38160337, 'Kristina', 'Anderson', '[email protected]', '911915292', 'Ramaram');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291403044815389, 38160337, 1, '$2a$12$5K75.v04019AJ037botLL244A3G7fcOL5/3lgK9L986ILB3266ju9', '$2a$12$i1333/826u6f029n.H51P/76d23k2910.0Z02l17/vA5K36Hwjhg3', 10);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(24095134983080, 00377852173625118066, 671984.76, 4291403044815389, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(24095134983080, 00377852173625118066, 671984.76, 4291403044815389, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(24095134983080, 00377852173625118066, 671984.76, 4291403044815389, 2, 1);
INSERT INTO customers VALUES(74460164, 'Tammy', 'Washington', '[email protected]', '960168852', 'Bayan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291812245043202, 74460164, 2, '$2a$12$JlOa6Q5O9119217M0z45uI4/3.7Tf35ycT66Au201k30IAR55bi4h', '$2a$12$x16b839nSit3M134DBw3p9VQ410547SY5Npon38164OF618oy26W0', 3);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(71001829321338, 00843092159896386295, 671219.59, 4291812245043202, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(71001829321338, 00843092159896386295, 671219.59, 4291812245043202, 1, 1);
INSERT INTO customers VALUES(27467122, 'Jasmine', 'Walsh', '[email protected]', '938070209', 'Dehī');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291362623690544, 27467122, 1, '$2a$12$/hT9E6/hu8FL48v7J6v9W71pm80ZCbR33Chs504x0TbV/zPc90J/3', '$2a$12$/82A156h297Zc.2oW276uR86z1IUR5zc92I42pmYhSA/S.76//W.W', 17);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(95665481502045, 00403722279267624725, 773181.52, 4291362623690544, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(95665481502045, 00403722279267624725, 773181.52, 4291362623690544, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(95665481502045, 00403722279267624725, 773181.52, 4291362623690544, 1, 2);
INSERT INTO customers VALUES(17343540, 'Gerald', 'Wright', '[email protected]', '978086551', 'Mazraat Bayt Jinn');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291300520935289, 17343540, 2, '$2a$12$/mPcnpI9V1/59/Z92X527.eW608/20o5kp5oT20LKl9ax0Y4.847J', '$2a$12$2Q591SZcBo342yGav03273mmflbtmNXhOD80d3k97.7Ujn6.Tu1CM', 8);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(71181874968579, 00922564489294593723, 174386.4, 4291300520935289, 1, 1);
INSERT INTO customers VALUES(42398600, 'Gabriella', 'White', '[email protected]', '988710991', 'Yunxian Chengguanzhen');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291780661490829, 42398600, 2, '$2a$12$R07571Zo5g2m24917X8H0Aq.79pr6G86uP89o/100MF7327.U021s', '$2a$12$t8/3iv583z7lf.4PI70218bB04g84Gz79/2.93Od3pb7f4q0H5k.g', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(21195181441495, 00927173300487595783, 342445.38, 4291780661490829, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(21195181441495, 00927173300487595783, 342445.38, 4291780661490829, 2, 2);
INSERT INTO customers VALUES(34550500, 'Julia', 'Bond', '[email protected]', '942628253', 'Tuka');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291209358055714, 34550500, 2, '$2a$12$sl663/hX0lb02804R869d3UY637XLnYEe4/1584Q9597p.jx6994g', '$2a$12$/6i1LoDT02vi848206766//S17Wx891FSG8K.20N9B9P.W3yE1/3u', 10);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(57488635769435, 00190218724018477831, 177571.97, 4291209358055714, 1, 2);
INSERT INTO customers VALUES(87640139, 'Tony', 'Shelton', '[email protected]', '990690989', 'Saipan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291398302993394, 87640139, 2, '$2a$12$4n4J9xzi8u6Cr3./B694Fom40ehureY3m9M1cx7L5E040A278602j', '$2a$12$4i9M45w8YF.857n54vk0y9xo894DN89t/5r.H2S171mB/819.04F9', 15);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(62690662475767, 00927051090803873478, 635446.25, 4291398302993394, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(62690662475767, 00927051090803873478, 635446.25, 4291398302993394, 1, 1);
INSERT INTO customers VALUES(57815414, 'Zachary', 'Morris', '[email protected]', '935568750', 'Saipan');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291233607014917, 57815414, 2, '$2a$12$OmwM93.dH0m7/Q071/2.5j95k/bQw659I1cy7nw1w8WD/bIP4kvF6', '$2a$12$793E.432K17O1G79WlHuG9p27l4972S/mu8y4s6THZnJ26vU/s9YU', 13);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(84479691706051, 00794573952661833663, 869164.19, 4291233607014917, 2, 2);
INSERT INTO customers VALUES(16843103, 'John', 'Lee', '[email protected]', '923316617', 'Mazraat Bayt Jinn');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291507475538117, 16843103, 2, '$2a$12$40Ds9XeXEPen.8Ez33WI7375289erD1l1d3GfxUZ5Jel91456.3e7', '$2a$12$4/7q51/.0Y51ozZ421989270suLYOnu500696T.K40wMupm77478C', 11);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(54757829063222, 00191211594411547448, 23734.96, 4291507475538117, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(54757829063222, 00191211594411547448, 23734.96, 4291507475538117, 1, 2);
INSERT INTO customers VALUES(89790790, 'Jennifer', 'Shaw', '[email protected]', '911882347', 'Tuka');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291367014965181, 89790790, 2, '$2a$12$625KYp0l35d1bn3vJ0h7B99h20ls12x864L88q736p9B/1V71W/K1', '$2a$12$071344J6R696C43/2iz3Q57Ne906YZ825976.q6Pn50C5.A12W3j/', 6);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(15011912970750, 00875483944653368946, 78161.89, 4291367014965181, 1, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(15011912970750, 00875483944653368946, 78161.89, 4291367014965181, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(15011912970750, 00875483944653368946, 78161.89, 4291367014965181, 1, 2);
INSERT INTO customers VALUES(82092225, 'Sara', 'Davis', '[email protected]', '951747392', 'Hällefors');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291200618877849, 82092225, 1, '$2a$12$45/157682E6j1/Qd3J3s640NOr81O8e16J89m7HePVOtGgn47U4vw', '$2a$12$Z1E955P.5k9j62EV67/44.i7c191067BVD7525Hno.79WrOxp1jg5', 11);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(73547578693351, 00314770449489389777, 43331.78, 4291200618877849, 2, 2);
INSERT INTO customers VALUES(17683655, 'Sierra', 'Garcia', '[email protected]', '923195010', 'Santo Domingo');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291842614559891, 17683655, 1, '$2a$12$ZGFv93mR9a041A1m985zL2V1000k39748/TX9kgK/K90q5cs0p95Z', '$2a$12$9M2pV2v8.H9xpt42P4H3687i2B6h0e6558i7/6826.19773z7Ztkg', 5);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(13755386939407, 00456240959216795556, 684086.70, 4291842614559891, 1, 1);
INSERT INTO customers VALUES(83745120, 'Kathleen', 'Murphy', '[email protected]', '989944445', 'Madison');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291415822228466, 83745120, 2, '$2a$12$0p6HzZ/H68283n778X8o2IL6c1a78T3bq/11Y367JL11.458.A03Y', '$2a$12$Okf33/2//7C6Lh62UGRX7xU3E2uE4l56.9PnTe5730X7Er2l991F7', 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(63792238109431, 00842411294123824284, 456717.88, 4291415822228466, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(63792238109431, 00842411294123824284, 456717.88, 4291415822228466, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(63792238109431, 00842411294123824284, 456717.88, 4291415822228466, 2, 2);
INSERT INTO customers VALUES(84206307, 'Brian', 'Bright', '[email protected]', '948585504', 'Somba');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291799227259844, 84206307, 2, '$2a$12$6X4/8Z69/4N0O97Ms12n/b838qSuX5.4.3vgaN9859609p3.REa2J', '$2a$12$t908ky17f8fZ1.0wFgS32S42/1X62385E0x15P239b848L767l2T0', 12);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(95648302336864, 00702809835898639988, 833886.77, 4291799227259844, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(95648302336864, 00702809835898639988, 833886.77, 4291799227259844, 1, 1);
INSERT INTO customers VALUES(18788538, 'Gail', 'Ramirez', '[email protected]', '979965686', 'Quaraí');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291122540181316, 18788538, 1, '$2a$12$r.3.xv600UL5uswV4g/07P7J/zE6jY6x0K8W/89Z2t75gf2U.d/70', '$2a$12$.77t4MKy6th1j8B8u5530/8t7096Pg.mL7o67.l1vN.3599v85Nrv', 15);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(87089610601756, 00509416884777005607, 574996.74, 4291122540181316, 2, 1);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(87089610601756, 00509416884777005607, 574996.74, 4291122540181316, 1, 2);
INSERT INTO customers VALUES(80240892, 'Kevin', 'Deleon', '[email protected]', '982676002', 'Ramaram');
INSERT INTO cards(card_number, identification_card, franchise, secret_card_key, secret_client_key, branch) VALUES(4291574850616195, 80240892, 2, '$2a$12$/3l43/d894965BeJG929O6N72M6H65O701l1YZ89916kv61U/MS1t', '$2a$12$babl34v91B5v9o75N06rr3r427G27j4V0.8j/Q36U488O9T0s4r9C', 7);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(45038692095952, 00864709040328476359, 592761.27, 4291574850616195, 2, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(45038692095952, 00864709040328476359, 592761.27, 4291574850616195, 1, 2);
INSERT INTO accounts(account_number, interbank_account, money, card_number, account_type, currency) VALUES(45038692095952, 00864709040328476359, 592761.27, 4291574850616195, 1, 2);
-----------
/*
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(454644424542, 984894981658, 454644424542, 5040.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(343463435401, 343463435401, 894984871156, 59400.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(354546874687, 354546874687, 454644424542, 5040.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(771717719191, 771717719191, 165123135468, 548.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984191981981, 489489489498, 984191981981, 5010.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(981981561231, 654848949848, 981981561231, 2500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984987987984, 165123135468, 984987987984, 500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(213165497894, 213165497894, 489489489498, 3500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(489489489498, 651654684847, 489489489498, 5050.40);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(648648949848, 948494981564, 321656844898, 500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(894984871156, 789798485165, 894984871156, 10.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(348181894894, 348181894894, 789916541651, 5000.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984894981658, 789798485165, 984894981658, 500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(165123135468, 654848949848, 165123135468, 900.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(321656844898, 348181894894, 321656844898, 30.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(132135465448, 132135465448, 116313519864, 4500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(948494981564, 948494981564, 151984189484, 5100.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(213216546546, 213216546546, 789798749846, 2500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(654848949848, 156189488789, 654848949848, 500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(789798485165, 789798485165, 948648646545, 5100.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(116313519864, 116313519864, 156189488789, 500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(948648646545, 181979841321, 948648646545, 5100.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(584949489498, 132116545649, 584949489498, 5100.11);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(151984189484, 151984189484, 121561654869, 500.55);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(181918918198, 181979841321, 651654684847, 4500.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(575649841189, 575649841189, 231231654864, 700.49);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(651654684847, 981891984857, 651654684847, 51.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(181979841321, 981891984857, 181979841321, 62.49);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(981891984857, 981891984857, 156189488789, 16.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(231231654864, 231231654864, 558494989513, 200.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(132116545649, 121561654869, 132116545649, 90.30);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(248948948944, 789798749846, 248948948944, 510.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(558494989513, 156189488789, 558494989513, 10.49);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(156189488789, 132116545649, 156189488789, 40.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984949845135, 984949845135, 213216546549, 170.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(121561654869, 121561654869, 181979841321, 580.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(789798749846, 335489489449, 789798749846, 40.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(213216546549, 651654684847, 213216546549, 105.50);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(144987487994, 144987487994, 981891984857, 97.50);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984894789798, 984894789798, 315468468484, 112.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(335489489449, 144987487994, 335489489449, 98.20);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(132165456464, 132165456464, 335489489449, 120.40);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(152165468486, 123165485489, 152165468486, 560.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(789916541651, 789916541651, 315468468484, 90.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(654548949132, 315468468484, 654548949132, 180.30);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(894498456651, 894498456651, 123165485489, 50.25);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(123165485489, 123165485489, 132165456464, 429.30);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(456498884987, 456498884987, 519519498484, 10.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(315468468484, 213216546549, 315468468484, 2610.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(519519498484, 121561654869, 519519498484, 100.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(454644424542, 984894981658, 454644424542, 5.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(343463435401, 343463435401, 894984871156, 2.99);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(354546874687, 354546874687, 454644424542, 158.11);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(771717719191, 771717719191, 165123135468, 11.12);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984191981981, 489489489498, 984191981981, 170.50);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(981981561231, 654848949848, 981981561231, 580.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984987987984, 165123135468, 984987987984, 40.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(213165497894, 213165497894, 489489489498, 105.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(489489489498, 651654684847, 489489489498, 97.50);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(648648949848, 948494981564, 321656844898, 112.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(894984871156, 789798485165, 894984871156, 98.20);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(348181894894, 348181894894, 789916541651, 120.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984894981658, 789798485165, 984894981658, 560.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(165123135468, 654848949848, 165123135468, 90.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(321656844898, 348181894894, 321656844898, 180.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(132135465448, 132135465448, 116313519864, 50.20);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(948494981564, 948494981564, 151984189484, 429.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(213216546546, 213216546546, 789798749846, 10.20);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(654848949848, 156189488789, 654848949848, 26.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(789798485165, 789798485165, 948648646545, 150.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(116313519864, 116313519864, 156189488789, 5.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(948648646545, 181979841321, 948648646545, 2.99);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(584949489498, 132116545649, 584949489498, 195.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(151984189484, 151984189484, 121561654869, 60.40);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(181918918198, 181979841321, 651654684847, 49.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(575649841189, 575649841189, 231231654864, 105.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(651654684847, 981891984857, 651654684847, 97.50);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(181979841321, 981891984857, 181979841321, 112.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(981891984857, 981891984857, 156189488789, 98.20);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(231231654864, 231231654864, 558494989513, 170.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(132116545649, 121561654869, 132116545649, 580.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(248948948944, 789798749846, 248948948944, 40.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(558494989513, 156189488789, 558494989513, 105.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(156189488789, 132116545649, 156189488789, 97.50);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984949845135, 984949845135, 213216546549, 112.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(121561654869, 121561654869, 181979841321, 98.20);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(789798749846, 335489489449, 789798749846, 120.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(213216546549, 651654684847, 213216546549, 560.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(144987487994, 144987487994, 981891984857, 90.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(984894789798, 984894789798, 315468468484, 180.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(335489489449, 144987487994, 335489489449, 50.20);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(132165456464, 132165456464, 335489489449, 429.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(152165468486, 123165485489, 152165468486, 10.90);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(789916541651, 789916541651, 315468468484, 26.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(654548949132, 315468468484, 654548949132, 100.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(894498456651, 894498456651, 123165485489, 5.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(123165485489, 123165485489, 132165456464, 2.99);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(456498884987, 456498884987, 519519498484, 158.00);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(315468468484, 213216546549, 315468468484, 11.10);
INSERT INTO transactions(account_number, sender, receiver, money) VALUES(519519498484, 121561654869, 519519498484, 130.00);
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment