-
Notifications
You must be signed in to change notification settings - Fork 0
/
banking_sys.sql
104 lines (82 loc) · 14.9 KB
/
banking_sys.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 20, 2021 at 11:43 AM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `banking_sys`
--
-- --------------------------------------------------------
--
-- Table structure for table `customers`
--
CREATE TABLE `customers` (
`id` int(11) NOT NULL,
`img` blob DEFAULT NULL,
`c_name` varchar(20) NOT NULL,
`email` varchar(30) NOT NULL,
`country` varchar(10) NOT NULL,
`balance` int(8) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `customers`
--//Example of insert record with img
INSERT INTO `customers` (`id`, `img`, `c_name`, `email`, `country`, `balance`) VALUES
(1, 0xffd8ffe000104a46494600010100000100010000ffdb0084000a0708151615181616151818181a1c1c1a1c1a1a1a1a1a1a1a1a1e1a1a1a211e181c21212e251e1e2b211a212638272b2f313535351a243b403b343f2e343531010c0c0c100f101f12121e342b242b3434343434343434343434343434343434343434343434343434343434343434343434343434343431343434343434343434ffc000110800ae012203012200021101031101ffc4001b00000105010100000000000000000000000301020405060007ffc4003c1000020102030505060405040301000000010200031104122105063141512261718191133252a1b1c11472d1f023334262e1071582f14353c216ffc400190100030101010000000000000000000000010203000405ffc4002411000202020300010403000000000000000001021121310312412204516171133233ffda000c03010002110311003f00a66692f6437f1564088188d41b19da792b66edf10838b0f580c5ed8a2a75713159d8f127d65363dbb7164a8b71b6dd1abdebda29515021bdaf793765ff00293c2642afb8b361b33f949e022c763cb44c8a624e942621333fbdadfc1ff909a06133bbdbfca1f98412d0d1d94fb31ec9e725d5c48552cc6c0489b357b03c4c87bc6d6545f8989d3b870f9c594bac6cd18f69d12136eaea4061d386be52c703bd050df523a100dfe8662400bc49bf21d35fd223d7effd6714ae4ecf46318c5522ff006961d310cce0b2b1b91702d7f51a794cd3965254dc5b430e312cba826ffbee80662cd989b93346fd0bfc1c2bdba9f3f978413b927596747649617e10cbb13ade1ed141e92653d33d617f1240b2e83e72c9f629e523d4d92e20ed161e924261b1d90685afd158afa91afce3db683b3025b41c8683af9c84d86606d631eb4caf1fbe933481f234182c7047cefda245b21e770458f3ee9a7c1edb76aaeed619402c7419481d907fbcdf87874981c3a8bdc137eefb7496786a8745404f3b0b9d4f3f1937863d60dd6d7c48af8646b82f4c8bf0272b97b7901966729bd84b5c3e05d307519cd8974ba91aeadd9bfce542709ddf4b759383eaaaf018bc6ce9d79d871314c6318e83a8663099e77b48206231114c3daa41a3c4630683481948e83fb49d9e3624228bed0ce8dbce9825b911ad0b960dc691090d5369458f7ed8bf59705a50e3dbb7125a2dc5b2fb6a2d3094f21d6dacd3ecdfe5a78098876ec2cdbece1fc34fca22c76525a44a11d1b1d284c4699cdedfe58fcc2689a6777b8ff097f30825a1e3b3b77f66abd1562e0124e92a77cb06a853b41b4623bb86bf28fd94f640254ef3622ee17a017ef27503f7d64f91fc06e1ff004289defac0978e730539523b9b1d792b074c93fbfac860cb3c0b01cbeff29a5a0c726b36620c96929e9095f84a9617933dade459d11d0e14c4934f08adca435ab2c7095b5ef88ca20b436223117407c44bca1bab49d42b20371d23301585c4d1ecbc5006c4ca452f45936b47976d6dd4fc36232107237690f5079788b1135bb1367a8456cc329d3502c79db35efc44d36fb6cd1570d9d476e99cea7a8d330f4d7c544c861d99503d13a665cc87e12466b1e5a42e35225dae3644decc59b253b644cc5b2a8b02402016e679f3d2f29b0fb36ab28654241e064dde7625d0937e3f484c06dba888aa3801d27a3c783cae477b211d975be068c3b3aafc0de92f57786a741e91c378dfe11e929d88d233e70353e06f4827c154f81bd0cd28de47f847a472ef1b7c0be90f635232bf837f81bd0c69c2bfc0de866adb792dc507a44fff004ebf00f483b07aa326d867f81bd0c18a2d61d93e866b9b79d00d698894b7a2937f4081c828ca321e87d22153d0cd97fbfd1e74d62ffbe61fff0058f94dd8d48c4da74db7fbce1bff0050f9449bb1a8cbff00b8a41d6da296952cf0555f492ecc75c312c8ed049498aac19b48b7814176115c9b1a3051765c254baaf74dee03f969f944f3da7c27a160bdc4fca2183cb34d611284e8d8e12a4c4699adf0f713f34d2b4cd6f8fb89f9a2cb4347655602a284173aca3de26ed923fb7e96d3d25861c68246db14732adb8960a3ccc94f312bc4aa5fb28aa01e761f3d60a5d62b0b4d8e540c0a8b6726e188ea2da4ac143b594b007a9be5f32351e9209a675ca2d6c6514b996986c2936d2068611d18065b5f81d0ab7e561a1f233434500024e6ca71ab170b4ec38c3a031aa54713680afb52929e26255966d22c1104b0c3e19b42267d36c237036f197781c70006a0881a6831927a2f300183af2bcd0e1158b8b6b28296352f9b922ebe245c7d65dec2da286d702fa5fd7f7eb0c4d266a69a164643a86047a8ff0033cc1d1d2b144b1cc41235b5830b9bf2238fca7acd200804759e5786aa2a3bd40383320d7a31cda78da5a31ed248e5e49758b654ef29eda79c0e129764185de4f7a9f9c8349cd86b3b96cf36594591a7a411a7233d636e303edcf58c4bab277b28829c85eddbace5c43759834c9159201a998dab5dbac19ae7ac01a676253b260f6753b88988aa729d67609ca81698649d32c4518ef65a5ad02314d38628c1805309eca7417e31bba74d8353299907582aaa2dc623b41bb5e499d20cdbac1d3b6684c9df3a861ce61c2258f44ca478f8cf44c27b89f947d279e84b4f42c2fb8be023c3647903c74688e12c48461331be0dd841fdd34e665f7c0f653f318b2d0d1d94587e0226212e539d9c37a063f583a644908c2e07536fb7de4a5fd597e3c497ec8f88c8a990def7d4af1b9e27c3ed2a6b6182a923adaf2f2b61cdd9ed707dde9e10b8ba4ac8c80000dbd473f94e352a3d2946ca7d905c5f29ecf353aa9f1074bf7f1974b95f4d55b4016c5949b81606f7075d01079ebd63e0f0b916d785ac7481bb1631a446dac8d4dd91802ca6c75040d01e5c654b633fb54dbfb57ec3ef279a7dd789f85bf688d3a7ef94c9d6c0e245c2e5a8d6f663fe3994fd48f593b06a81d5159d0b1005f2badcf236ca40e5ce753a68bc140f0241fadf943d27b32defef29f7deda10785f53cbce35d8b4d1a4a384191d0625039a996eeb5154b29b650729d6f69585713ed084c4530eac54afb44d4836e7612d368d3b53a4e400c5eabdb96665cc1bbec6fe604ce53c2deaa9046bc6e2d66e4476c6be04448aad94936f47a5ee7ed2c5e70954a5b995a94d89ff008ab1b13df23b617d9dd32951724660413737bf0d7c61765615d03d4670e5299c8fcca9055559ae49019baf2ee128b64ed247ac2917285ce5018f60d4bdb516b237f70b03cc126e2dc3349b6ce6e7e36d52645de43db4f3950bca5cef3a65a88a6d71981b1047911a194e8784ed5b38a5842d463691f3187aaf001cc61285ce62a398c350c40e603216a31bc69bf49cec623d56200278682018471a43d3436122bb1b43a1d04c1a08c0c4cc677b4317da4166a1b9cce8bed0749d31a8ab680aa34921a05c6911944468ec3139a172af59d41466d0c9d94a2550727d67a461bdc5f013ce30e3eb3d1f0fee2f8094810e40a23a363a58908c665b7c7827899a96995df0e09e262cb434766711a39db4d24727584cf653a5cf978739393a45a2ad96385c68aa808b661a329ebfe7ac1d326e6e2daf0bde546cda06e581b7874ef96942fadface19249e0f4149b5924b982731e20d86b0328865341ce1d69c6ad3bc2b52005c9b01e1033511f1242a9f978c16029e770c7400f0b5b8758c7d1c33fbbcaff007ef9270d8f4bf638f4b5a146a5e9bcda3b396a6051cdf3536234e8e42fff005f2996a58565750c09e86dc7c3acd86efed546a6f4d8d81a6c49d3b397504f84bca780a18855b2a862332b211949eb95882baf2171e3124f490d1556d89b5b2d2d9fa9b139413a682f9adf2e13cd777a8e7ad9f2f6546b7e6dfbfacdbef260dda87b177ed67e36be83b2472b68ddf2bb07855a6811780ffb9d5f4f16d651c3f53349b49949bc7efa7819549c04b3de3fe627e532a11f84ec5b38a5a1d5a47b42bb5e3230a36d094d230c70680286b08d223ed38898209d7492106820aa708741a0802842b3b2c265884406b0790ce84cb3a109585046941d4463181aa64de87448ca3ba752d0dee24226261c76a4a8a2659a107875fbcf44c3fbabe03e93cdf08a45aff17de7a4d1f7478095811e50822c49d795222b4caef736a83c66a4ccaef6b0ba75d6096878eccd64d6129d2b9b75d2462faf9c77b4399101ed3b0517e009205cfac9bd1549de0b6a38364a61ed60c4807ae5e3f5b7948e0ea67a36d4d92af8614906a8064bf1247104f53af999e695c11e3d0fde724e34cede2976884f6bca117595e953b7e3a498ad118e9925633138a516b9b01f33066a4a6a9419d893e5ad85a64ade46949f84ac4ed153a4161f134c1e16371c3c6752c1df4c8bea65861f6386d3d95f5e21f8f8de3604a93f4f43dd518674b53b063ef03c4e96235e235facb0d95866a755501d03d90f1194f0f97d279fa8ad84715929bad88ec9b15b7730d66db77f6a9a94d2b37f4963e81ac3c2ee3ac0e37a1d49c6d489bb72adeb30bfbb71e7724fd6de520447724924dc9373e2674f4231eb148f2672ed26cccef21fe227e53f5952bc04b3de53fc54fca7eb2b52b580d215b33d239846da3cd51d22fb45e9184b04445023f3ac72b2cc10768a442e658b75e90048d506924531a088e45b4124201617100c3008a54436559d917acc0b0161121b20eb3a6019c304e214c1d4922a809109801db110c7e08f6c442859545b381e1f59bea5ee8f01f498066bbaf88facf40a7c0780fa4a40872783e2448b7952471995dedf793ce6a09998dea5bb53b9038f181ab43c5e4ca30d4f2e7e52b6bd725ae0dadc3bad25ed2acb7ca849ea7a9eeee9592127583a611f4f63dd7db62bd156bf6d7b2c3a30e7e078ff00d4aadeed93c6ba0d09ed81fd24ff0058ee3cfbfc661761ed56c3d40c2e54e8cbf10fd4711fe67ac60f18b5503290cac3c883d47ca2b4a4a829b84ad1e5b5178fefce3e962b28d787597fbc5b08d2bd4417a6788e69dc7fb7a1f5efce14e5ca41aac33a93525683d03998917928211c255a394f3e7ca4ea18f16d479fef8456831925b2363d1ad996e35e46330ef5dac14371ea648af8a0c45bc658ec4c4e570471fdf18da4069365fecfc13b618e724b15e64903c2fce5c60690a749105b41736ea64ec45746a29900d7436e56eee5ca4467b9b996e1e3cf66737d472e3aa1d1418dbce9d671197de33fc65fc9f79091069a495bc27f8e3f27de2a2e83c268ecd378447f64b10d35925963488d44fb00f64b08940475a1e8acd41ecc00c389c70e24ebebc23c9ee8283d995af4eca6d24a520c05fa43d6a802f086c3d4045f2c15928a5f121fe1c4ef6024cac83a418510d09d88fec0759d0f9674146eccc798c78e611ae2459d23088ec2fbd1a4476186b118e89d43de5f11f59e869c0784f3cc37bcbf987d67a2270f294810e410ce114cccedcde40974a5a9e6fd3f2feb2a4d26f08b1db5b61280b7bcfc97eedd07ce79ded2da2f51cb31b9f40074039082c5e2598924924ea49373eb219325397d8e9e3e34b2c6937893a748963a69b74b6e7b16f66e7b0c743f0375f03cff00ee66a74c06ad1ed94dc30e4411a83c3ce65b6eeed15bbd1175e269f31f93a8eef4e907ba1b64bafb363da41c49d597803e2381f29b247061945490b193833cb505c70b8e1ff717f0773d9d2e784dd6d6ddc5a9774b239d7fb5ff00377f7ccdfe02a2be4742ac397dc1e63be4251713aa2e334561d895b37b8c6dae9d05bf7eb343b03747135ea2a6434c702ec2c146bc475b0e1dd355bbfb3d917dab8e5a5fba6eb6012e3da0e048b74d2c3d48bfac45272743ce0a31b29367e029a2350750eea4e6cc2d73d539816d748cabbbe87dc72b7e4c330f5d25def2ecfbb2d45d1b85fbc70bf75be929e8638dece2c79febe13d2824e2a8f3a6b392a71bb2aad3d596ebf12ea3cf98f390819b6c362fa9b89171fb1a9b8250046e208e07c57f48c4dc7ec793ede3fc7ff8086a67845de4c33a624aba90720f022fc4751df114709a1b6479b48468c842dac6be928490d86a322b55179270cf78024ba4bdb12e1f0e0f00254d1f7c493b5712c96ca6d050e985c4e1b4e0204201ca44a18876e26e24a60601d3b883ae7591cd4922b99159c422213399d12fdd3a00d81d9030c32b5417ea24cdab5b02fee25bcadf299da54c91a0263db0cfc7299165fd24354a03827ca45c456420854020dd6018da4d94885c00ed27e61f59e8388ae8899dd82a81fbb0e6679f609c2e563c14dffc08bb4f6d1a8c4bf9283c07412bc6b1927356c2edfde67a9744ba273eade3fa4ce3d763d61aad6a678061e922965e578252fc9484525a06d18638b46c9bc95424e8b12284e9d3a74c62560314d4aa2baf1537f11cc7989eb3b3716b511594dd58023f43dfcbca78ecd8ee26d3b39a0c746d53b9b9af98d7c477c31124bd3d0f0d56c66830d85a15800e05c6a3aa9fed3fb133f4e9caade5de35c305a6a47b46b31bdec12fa8623552d6201b682e7a476b14c48377836f8cd9ed5915505949cad7b0212f62e08241b0d6dc65fecdc0ad046b31b5b98caa2c3903facc2e037bd6952156a02b44e88a2c5aa39172a08be80712343c01e322e23786b62d416bd34b8294c02b600f64b7c5a8e3c34d2423c759a3a25cb292a66ca8ed6f6b4a9ad40333a820ae803017d41e5df2bf1088caa785c71f1e4ddd28f69630d3c1d47e0529ba291c8bd434d48f00f7f28bba5b6057a166d5d7461d7bc759d5c3a39e6d92bdae436274e5f4b4b5c2e2b8027c3b8cacc451d2dc3a771fdfef490e9d62010788e53a2ac9dd04decc225440ad60e5ad49f98a87fa18fc2f6b78da613393a70fb4d6ef6d4353055181219066ef0508753f294b89a0195312b6295806b8fe8a845d94f9dfe7d22ac3a27ccbe2994e289bdef2494d22baeb1d4d239cd764628248c3ae90ad40112d301841ecc9220614c8543df13b6f36a23e8d3ed8b426d8c13b1165bc03229f0b58ded2dd5e44c16cea97bb2102592e118f05262e078a7445adc645665932be15c1ed2903acbbdd7dd95c43967d29a71e598fc20fd7fcc12924ad86316dd233363d274f6d5a34d40508961a7babcb48b23fcdf82ffc1f93c436562d11006b131f89da29623aca3a6a6f1ef4fac360ac80aaa09e303ecd46a4f086ac8aaa598d80e333b8cc716361a2f4ebe3158f14d92b1d8dcc6ca4003be5735f893f7812670315cacaa8d0fb08db4e1ac598224e11408aa2040b108884425a2342e26b053a3ed1a440d04e87c3d42ac0a9b10410471041b8220cac65e6d1b67b6ec3c71ad405555ccd975506ddb1c46bc05f5f03327b537619ddea3bd4577259b3a2b03dc39580d00e56107fe9ded1bb35027dfd57b980fa11a792cd7e3aa37badacab49a249b8b3c85abba314cc6c8cc2d7ec8209e0bc06b3d7f75768d3c561290d16a52cc8e078dee7b8defe39a6077bb616444c4a0ecbb157e81ed981ff00976bd3be5b7fa541b356517d429e1a707f43c38758b1bba656ee383678da77a5528b8051d400ddc0df875d279a6c5da8f83c51527b39b29e847233d2b698caa6e6791ef17f30b03ac37d744e3f2593da96bab5b5ecb0bab71163c8feb22e2e8e5373a723cefcc1079dff005995dc4dafeda835063674ed277af3b7ef94d72d40c8093af03e2387d07ace98cad5a24d5619574c870f48f0752b63e1a4a3dcdad9b035a839d69b35bb8821b4f9facb3c73657561d6506e659b1789a44d95d987802ce2ff004824ea4999ab8b44b4a71cd408e7f292c10ac7b3aa9208ef06d2526d73cd1616d9c692f4a8426fc25ca121786862bed5b7fe35f592a9ed3ba5b2081dfd8c92fb90f069db1c00eb2f0554045c82647a55d48b941eb23be35038ec7d3f48adb6522d22cf1f89454e42177729865bf2332bbc35f32f0b4bcdd177144586822cb4514acbcdaf875f66da0e1266ce6a783c329acc1001737e258ea4db9b1e43a012b8ed2d7b7951411766e035d3cc9b01e333ff00ea56ddbb53a4a11d4a870752c18dc6a2f6e034bf5909bf0e8e349bb0f57fd48c3e636a0e45cd8f5d7c62cf35fc51eb3a4ecad0ef68a22fe29348155bc8fb43b14c9f2f5e72cd9ce9157b671b9db2afbaba0ef3cccac8b12f11bb3a12a3a74e9d1427422eb071c0da327406394eb1f6d636a0e7d759c6130f9d68823d638a0da722fac4a822236b15ef21f02a881a8b632481ac15511a4ad013c92f616d0342ba541c8fc8cf5cc4554a812aaeaac2febcbc8cf129e87fe9fe34d447a0dc146653d3911e9045e28135e9337a7196c355a0e01560ae87e17575247782bf4941b91b53f0d54b9636051eca40b804861626d7b13627e57bc95be15332e43c986bdd627ed32fb19c8af4c8b5f3022e2e38f31ce64f23457c707a96f05563713ce36de14ea67ae6d6c3022fc2e01f0b807ef307b5f0c2c6696c58e3064b62ed06a1556a0e5c6dd38fda7afe18a3d135299395ecf96e48522d70a3fa469eef0d678ad65b3113d03fd39daac55e835c802ea7a5b97d7d63f0ca9d03917a5eed35cca18723a7f999adca17c7573d339e7f18fd66bf1146ca45ff0062ff00a4ca6eab84c7e2548b921ac472b3032b3f3f62474cd4d3c39c4a31cb6ac8ce86da0a990e80ff007142181e7660794a60269b6754f6356a102f9c82472b8005fc7491f6fe040535d6c3b79597912750c3a778f3f178dfa73f2c3d453aea2d245300095a31241933db5d41848516b847553c6071c41705657ae20de73e20de2d6464b0136c9b26a25b6ec622d480901f0c6badd9aca05cdb563af017d0433d444a6ea032a22dd8a905d81609652740493a9b682f6179393495b2f18b69511f6bef661e8bae52b51d18e642095cd94d88e448fbcc5ed0da82bbb3f324922ff2eefb48fb5b1145cb353a3ecf5b9bbb54249ef36b784cfbb6b71a4e593ececeb847aaa2f3f123bbd4fe93a537e34f413a2d143fffd9, 'TONY STARK', 'tstark@gmail.com', 'United Sta', 49900);
-- --------------------------------------------------------
--
-- Table structure for table `transaction`
--
CREATE TABLE `transaction` (
`srno` int(11) NOT NULL,
`Sender_name` varchar(20) NOT NULL,
`Receiver` varchar(20) NOT NULL,
`balance` int(11) NOT NULL,
`Date-Time` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `transaction`
--
INSERT INTO `transaction` (`srno`, `Sender_name`, `Receiver`, `balance`, `Date-Time`) VALUES
(1, 'TONY STARK', 'STEVE ROGERS', 100, '2021-05-20 15:02:38');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
ADD PRIMARY KEY (`srno`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
MODIFY `srno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;