Created
January 19, 2022 02:30
-
-
Save luisnquin/05b868c2b2eeaae0feaec34f74b79bde to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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