· 6 years ago · Mar 16, 2019, 05:48 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Mar 16, 2019 at 06:44 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `cryptopostman_db`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `country_code_master`
27--
28
29CREATE TABLE IF NOT EXISTS `country_code_master` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `country_name` varchar(255) NOT NULL,
32 `country_code` int(11) NOT NULL,
33 `updated_by` int(11) DEFAULT NULL,
34 `updated_dt` int(11) DEFAULT NULL,
35 `created_by` int(11) NOT NULL,
36 `created_dt` int(11) NOT NULL,
37 PRIMARY KEY (`id`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
39
40-- --------------------------------------------------------
41
42--
43-- Table structure for table `favourite_coins`
44--
45
46CREATE TABLE IF NOT EXISTS `favourite_coins` (
47 `id` int(11) NOT NULL AUTO_INCREMENT,
48 `coin_api_id` varchar(255) NOT NULL,
49 `user_id` int(11) NOT NULL,
50 `updated_by` int(11) DEFAULT NULL,
51 `updated_dt` int(11) DEFAULT NULL,
52 `created_dt` int(11) NOT NULL,
53 `created_by` int(11) NOT NULL,
54 PRIMARY KEY (`id`),
55 KEY `coin_id` (`coin_api_id`),
56 KEY `user_id` (`user_id`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table `image_master`
63--
64
65CREATE TABLE IF NOT EXISTS `image_master` (
66 `id` int(11) NOT NULL AUTO_INCREMENT,
67 `name` varchar(1000) NOT NULL,
68 `path` varchar(1000) NOT NULL,
69 `type` int(11) NOT NULL,
70 PRIMARY KEY (`id`)
71) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `marketcap`
77--
78
79CREATE TABLE IF NOT EXISTS `marketcap` (
80 `id` int(11) NOT NULL AUTO_INCREMENT,
81 `name` varchar(255) DEFAULT NULL,
82 `symbol` varchar(255) DEFAULT NULL,
83 `price` varchar(255) DEFAULT NULL,
84 `volume_24_h` varchar(255) DEFAULT NULL,
85 `change_24_h` varchar(255) DEFAULT NULL,
86 `market_cap` varchar(255) DEFAULT NULL,
87 `total_supply` varchar(255) DEFAULT NULL,
88 `coin_api_id` varchar(255) NOT NULL,
89 PRIMARY KEY (`id`),
90 UNIQUE KEY `coin_api_id` (`coin_api_id`),
91 KEY `symbol` (`symbol`)
92) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
93
94-- --------------------------------------------------------
95
96--
97-- Table structure for table `news`
98--
99
100CREATE TABLE IF NOT EXISTS `news` (
101 `id` int(11) NOT NULL AUTO_INCREMENT,
102 `title` varchar(1000) NOT NULL,
103 `description` text NOT NULL,
104 `type` int(11) NOT NULL,
105 `news_source` int(11) NOT NULL,
106 `created_by` int(11) NOT NULL,
107 `created_dt` int(11) NOT NULL,
108 `updated_by` int(11) DEFAULT NULL,
109 `updated_dt` int(11) DEFAULT NULL,
110 PRIMARY KEY (`id`)
111) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
112
113-- --------------------------------------------------------
114
115--
116-- Table structure for table `portfolio_elements`
117--
118
119CREATE TABLE IF NOT EXISTS `portfolio_elements` (
120 `id` int(11) NOT NULL AUTO_INCREMENT,
121 `coin_id` int(11) NOT NULL,
122 `quantity` float NOT NULL,
123 `price` int(11) NOT NULL,
124 `purchase_dt` int(11) NOT NULL,
125 `created_by` int(11) NOT NULL,
126 `created_dt` int(11) NOT NULL,
127 `notes` text,
128 `updated_by` int(11) DEFAULT NULL,
129 `updated_dt` int(11) DEFAULT NULL,
130 PRIMARY KEY (`id`)
131) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
132
133-- --------------------------------------------------------
134
135--
136-- Table structure for table `portfolio_master`
137--
138
139CREATE TABLE IF NOT EXISTS `portfolio_master` (
140 `id` int(11) NOT NULL,
141 `name` varchar(1000) NOT NULL,
142 `created_dt` int(11) NOT NULL,
143 `updated_by` int(11) DEFAULT NULL,
144 `updated_dt` int(11) DEFAULT NULL,
145 `created_by` int(11) NOT NULL
146) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147
148-- --------------------------------------------------------
149
150--
151-- Table structure for table `user_master`
152--
153
154CREATE TABLE IF NOT EXISTS `user_master` (
155 `id` bigint(20) NOT NULL AUTO_INCREMENT,
156 `fname` varchar(255) DEFAULT NULL,
157 `password` varchar(255) DEFAULT NULL,
158 `role` int(50) DEFAULT NULL,
159 `email` varchar(100) DEFAULT NULL,
160 `contact_no` varchar(250) DEFAULT NULL,
161 `lname` varchar(255) NOT NULL,
162 `country_code` int(11) NOT NULL,
163 `created_by` int(11) NOT NULL,
164 `created_dt` int(11) NOT NULL,
165 `updated_by` int(11) DEFAULT NULL,
166 `updated_dt` int(11) DEFAULT NULL,
167 `is_block` int(11) NOT NULL,
168 PRIMARY KEY (`id`),
169 KEY `FK3qbgg0mth8ro6a5xa5y23f9k2` (`role`)
170) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=89 ;
171
172--
173-- Dumping data for table `user_master`
174--
175
176INSERT INTO `user_master` (`id`, `fname`, `password`, `role`, `email`, `contact_no`, `lname`, `country_code`, `created_by`, `created_dt`, `updated_by`, `updated_dt`, `is_block`) VALUES
177(1, 'admin', '0192023a7bbd73250516f069df18b500', 1, 'admin@admin.com', '9876543210', '', 0, 0, 0, 0, 0, 0),
178(27, 'Shashikant Sharma', '7992705753c9cad89cc45b55003a9a9e', 4, 'shashikant.s@innovative.in', '8511056310', '', 0, 0, 0, 0, 0, 0),
179(28, 'Pankti Shah', 'a6ec55f9d9885fe1b081f86c4e84d98f', 2, 'pankti.s@innovative.in', '9499514749', '', 0, 0, 0, 0, 0, 0),
180(29, 'Jitin Masand', '7992705753c9cad89cc45b55003a9a9e', 3, 'inoyo.report@innovative.in', '9054444333', '', 0, 0, 0, 0, 0, 0),
181(30, 'Suresh Talwadia', '7992705753c9cad89cc45b55003a9a9e', 4, 'suresh.c@inoyo.in', '7000174165', '', 0, 0, 0, 0, 0, 0),
182(31, 'thanigaivelan.s', '7992705753c9cad89cc45b55003a9a9e', 4, 'thanigaivelan.s@innovative.in', '9841664555', '', 0, 0, 0, 0, 0, 0),
183(32, 'Mohmmad Qasim', '7992705753c9cad89cc45b55003a9a9e', 4, 'qasim.m@innovative.in', '9700168823', '', 0, 0, 0, 0, 0, 0),
184(33, 'Rohit Singh', '7992705753c9cad89cc45b55003a9a9e', 4, 'rohit.s@innovative.in', '7905759092', '', 0, 0, 0, 0, 0, 0),
185(34, 'Sanjari mobile', '7992705753c9cad89cc45b55003a9a9e', 6, 'sanjarimobile2@gmail.com', '0286-2212352', '', 0, 0, 0, 0, 0, 0),
186(35, 'Sandhya Mobile', '7992705753c9cad89cc45b55003a9a9e', 6, 'ran121162@gmail.com', '9898473718', '', 0, 0, 0, 0, 0, 0),
187(36, 'Sudipta', '7992705753c9cad89cc45b55003a9a9e', 2, 'sudipta.r@innovative.in', '8240430493', '', 0, 0, 0, 0, 0, 0),
188(37, 'Delisa Enterprises', '7992705753c9cad89cc45b55003a9a9e', 6, 'delisaenterprises@gmail.com', '8732951313', '', 0, 0, 0, 0, 0, 0),
189(38, 'Sagar Communication', '7992705753c9cad89cc45b55003a9a9e', 6, 'kaluhamanani@gmail.com', '8511716666', '', 0, 0, 0, 0, 0, 0),
190(39, 'Husain Mobile', '7992705753c9cad89cc45b55003a9a9e', 6, 'husainmobile@yahoo.com', '9998056460', '', 0, 0, 0, 0, 0, 0),
191(40, 'M R Mobile', '7992705753c9cad89cc45b55003a9a9e', 6, 'mehulparmar701@gmail.com', '99745040854', '', 0, 0, 0, 0, 0, 0),
192(41, 'Ashish keshewani', '7992705753c9cad89cc45b55003a9a9e', 6, 'anandcomputor@gmail.com', '9936361111', '', 0, 0, 0, 0, 0, 0),
193(42, 'Amar Nath Sahu', '7992705753c9cad89cc45b55003a9a9e', 6, 'amar.gupta948@gmail.com', '9616318888', '', 0, 0, 0, 0, 0, 0),
194(43, 'Saleem khan', '7992705753c9cad89cc45b55003a9a9e', 6, 'azmiaaftab@gmail.com', '9455433786', '', 0, 0, 0, 0, 0, 0),
195(44, 'S S V TECHNOLOGIES', '7992705753c9cad89cc45b55003a9a9e', 6, 'ssvtechnologies.vizag@gmail.com', '9290730559', '', 0, 0, 0, 0, 0, 0),
196(45, 'Mr.Dharmaraj', '7992705753c9cad89cc45b55003a9a9e', 6, 'cellcornervellore@gmail.com', '9345301264', '', 0, 0, 0, 0, 0, 0),
197(46, 'Mr.Nobelvel', '7992705753c9cad89cc45b55003a9a9e', 6, 'smileycommunication2017@gmail.com', '9884472956', '', 0, 0, 0, 0, 0, 0),
198(47, 'Mr.Venkat', '7992705753c9cad89cc45b55003a9a9e', 6, 'kavintech.tpt@gmail.com', '8248873337', '', 0, 0, 0, 0, 0, 0),
199(48, 'Mr.Adhimoolam', '7992705753c9cad89cc45b55003a9a9e', 6, 'adhiyadhav07@gmail.com', '8608608832', '', 0, 0, 0, 0, 0, 0),
200(49, 'Mr.Yagneshwaran', '7992705753c9cad89cc45b55003a9a9e', 6, 'sudarkavicommunication@gmail.com', '9677650340', '', 0, 0, 0, 0, 0, 0),
201(50, 'Mr.Siva', '7992705753c9cad89cc45b55003a9a9e', 6, 'siva_cellhub@yahoo.com', '9894172038', '', 0, 0, 0, 0, 0, 0),
202(51, 'Mr.Narendran', '7992705753c9cad89cc45b55003a9a9e', 6, 'abbsteksolutions@gmail.com', '9962133800', '', 0, 0, 0, 0, 0, 0),
203(52, 'Mr.Narendran/Mr.Karthick', '7992705753c9cad89cc45b55003a9a9e', 6, 'abbsteksolutions.porur@gmail.com', '9962397070', '', 0, 0, 0, 0, 0, 0),
204(53, 'Mr.Devendran', '7992705753c9cad89cc45b55003a9a9e', 6, 'devadd1724@gmail.com', '9597818881', '', 0, 0, 0, 0, 0, 0),
205(54, 'Mr.Kowshik', '7992705753c9cad89cc45b55003a9a9e', 6, 'maduracheckpoint.in@gmail.com', '9791703300', '', 0, 0, 0, 0, 0, 0),
206(55, 'Mr.Ramesh', '7992705753c9cad89cc45b55003a9a9e', 6, 'dreamzpblr@gmail.com', '9367799996', '', 0, 0, 0, 0, 0, 0),
207(56, 'Mr.Kathirvel', '7992705753c9cad89cc45b55003a9a9e', 6, 'kathir7779@live.com', '9976434488', '', 0, 0, 0, 0, 0, 0),
208(57, 'Mr.Dhanancheyan', '7992705753c9cad89cc45b55003a9a9e', 6, 'veermobiles14@gmail.com', '9629286017', '', 0, 0, 0, 0, 0, 0),
209(58, 'Mr. Prakash', '7992705753c9cad89cc45b55003a9a9e', 6, 'bcstirupur@gmail.com', '9965581418', '', 0, 0, 0, 0, 0, 0),
210(59, 'Universal Cell Care', '7992705753c9cad89cc45b55003a9a9e', 6, 'universalcellcare@gmail.com', '9985133225', '', 0, 0, 0, 0, 0, 0),
211(60, 'master mobile service', '7992705753c9cad89cc45b55003a9a9e', 6, 'mastermobileservice@gmail.com', '9949151284', '', 0, 0, 0, 0, 0, 0),
212(61, 'V H Telecommunication', '7992705753c9cad89cc45b55003a9a9e', 6, 'vh.communication@gmail.com', '9177763577', '', 0, 0, 0, 0, 0, 0),
213(62, 'KBN CARE', '7992705753c9cad89cc45b55003a9a9e', 6, 'shaksha_786@yahoo.co.in', '9885980143', '', 0, 0, 0, 0, 0, 0),
214(63, 'SRI DURGA COMMUNICATION', '7992705753c9cad89cc45b55003a9a9e', 6, 'giri.pro007@gmail.com', '9059488885', '', 0, 0, 0, 0, 0, 0),
215(64, 'VAMSI CELL POINT ', '7992705753c9cad89cc45b55003a9a9e', 6, 'vamsicell@gmail.com', '9885596227', '', 0, 0, 0, 0, 0, 0),
216(65, 'Best communication', '7992705753c9cad89cc45b55003a9a9e', 6, 'bestcommunication3638@gmail.com', '9440044521', '', 0, 0, 0, 0, 0, 0),
217(66, 'Anu Mobile Galary ', '7992705753c9cad89cc45b55003a9a9e', 6, 'anumobiles_warangal@yahoo.in', '9291423779', '', 0, 0, 0, 0, 0, 0),
218(67, 'MASTERS', '7992705753c9cad89cc45b55003a9a9e', 6, 'dubeymurali@gmail.com', '9121332199', '', 0, 0, 0, 0, 0, 0),
219(68, 'ALFA MOBILE SOLUTION', '7992705753c9cad89cc45b55003a9a9e', 6, 'alfamobileservice@gmail.com', '9397888886', '', 0, 0, 0, 0, 0, 0),
220(69, 'SATYA ELECTRONICS', '7992705753c9cad89cc45b55003a9a9e', 6, 'satyaele.niz@gmail.com', '9533713181', '', 0, 0, 0, 0, 0, 0),
221(70, 'M & M Technologies', '7992705753c9cad89cc45b55003a9a9e', 6, 'mallesh.mallesh59@gmil.com', '9885559396', '', 0, 0, 0, 0, 0, 0),
222(71, 'ShriRam Mobile ', '7992705753c9cad89cc45b55003a9a9e', 6, 'chandra.sikar@gmail.com', '9314094942', '', 0, 0, 0, 0, 0, 0),
223(72, 'Suresh Talwadiya', '7992705753c9cad89cc45b55003a9a9e', 4, 'suresh.t@inoyo.in', '7000174165', '', 0, 0, 0, 0, 0, 0),
224(73, 'AKS Telecome', 'b44477f979e636411147cc7ce4bd2641', 6, 'shivampatel.ex@gmail.com', '9584458294', '', 0, 0, 0, 0, 0, 0),
225(74, 'AJAY Electronics', 'b44477f979e636411147cc7ce4bd2641', 6, 'ajayelectronics3@gmail.com', '8269164112', '', 0, 0, 0, 0, 0, 0),
226(75, 'Net Gain Compters', 'b44477f979e636411147cc7ce4bd2641', 6, 'Netgainvds@gmail.com', '9907507604', '', 0, 0, 0, 0, 0, 0),
227(76, 'blueshine mobile ', 'b44477f979e636411147cc7ce4bd2641', 6, 'vickyshinde18@rediffmail.com', '9893131999', '', 0, 0, 0, 0, 0, 0),
228(77, 'Trisha Enterprises', 'b44477f979e636411147cc7ce4bd2641', 6, 'Trisha.enterprises4@gmail.com', '9589115715', '', 0, 0, 0, 0, 0, 0),
229(78, 'Dollar Shop', 'b44477f979e636411147cc7ce4bd2641', 6, 'Rafiq_dollarshop@yahoo.com', '9893013324', '', 0, 0, 0, 0, 0, 0),
230(79, 'Techno Mind', 'b44477f979e636411147cc7ce4bd2641', 6, 'technominds.rewa@gmail.com', '7771007660', '', 0, 0, 0, 0, 0, 0),
231(80, 'Aanad Mobile Care', 'b44477f979e636411147cc7ce4bd2641', 6, 'anandmobilecarekatni@gmail.com', '7566496006', '', 0, 0, 0, 0, 0, 0),
232(81, 'Ayushi Electronics', 'b44477f979e636411147cc7ce4bd2641', 6, 'mobileshop1234@rediffmail.com', '9827083970', '', 0, 0, 0, 0, 0, 0),
233(82, 'Aryan Mobile', 'b44477f979e636411147cc7ce4bd2641', 6, 'yogesh.bhargava73@gmail.com', '9893004495', '', 0, 0, 0, 0, 0, 0),
234(83, 'Patidar Mobile', 'b44477f979e636411147cc7ce4bd2641', 6, 'Patidarmobileservice@gmail.com', '9893185333', '', 0, 0, 0, 0, 0, 0),
235(84, 'Jai Shree Mahakal Services', 'b44477f979e636411147cc7ce4bd2641', 6, 'Manojoshi04@gmail.com', '9425704429', '', 0, 0, 0, 0, 0, 0),
236(85, 'Diwakar Agencies', 'b44477f979e636411147cc7ce4bd2641', 6, 'diwakar_jabalpur@yahoo.com', '9300090041', '', 0, 0, 0, 0, 0, 0),
237(86, 'Sunaiya Electronics', 'b44477f979e636411147cc7ce4bd2641', 6, 'sunaniyaharda@gmail.com', '9926767782', '', 0, 0, 0, 0, 0, 0),
238(87, 'ARS Enterprises', '7992705753c9cad89cc45b55003a9a9e', 6, 'hosurarsenterprises@gmail.com', '04344-244766', '', 0, 0, 0, 0, 0, 0),
239(88, 'RM care', '7992705753c9cad89cc45b55003a9a9e', 6, 'rmcaretrichy98@gmail.com', '7502555655', '', 0, 0, 0, 0, 0, 0);
240
241/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
242/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
243/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;