· 6 years ago · May 30, 2019, 12:30 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.6
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost
6-- Generation Time: May 17, 2019 at 06:28 PM
7-- Server version: 5.5.56-MariaDB
8-- PHP Version: 7.0.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `cryptolab`
23--
24CREATE DATABASE IF NOT EXISTS `kyc` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
25USE `kyc`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `_pu_users`
31--
32
33CREATE TABLE `_pu_users` (
34 `UID` int(20) NOT NULL UNIQUE,
35 `LASTNAME` varchar(255) DEFAULT NULL,
36 `FIRSTNAME` varchar(255) DEFAULT NULL,
37 `CATEGORY` varchar(50) DEFAULT NULL,
38 `TITLE` varchar(50) DEFAULT NULL,
39 `SUB_CATEGORY` varchar(30) DEFAULT NULL,
40 `POSITION` varchar(100) DEFAULT NULL,
41 `AGE` varchar(50) DEFAULT NULL,
42 `DOB` varchar(50) DEFAULT NULL,
43 `PLACE_OF_BIRTH` varchar(100) DEFAULT NULL,
44 `DECEASED` varchar(100) DEFAULT NULL,
45 `SSN` varchar(50) DEFAULT NULL,
46 `E/I` varchar(1) DEFAULT NULL,
47 `FURTHER_INFO` varchar(1000) DEFAULT NULL,
48 `ENTERED` varchar(50) DEFAULT NULL,
49 `UPDATED` varchar(50) DEFAULT NULL,
50 `EDITOR` varchar(20) DEFAULT NULL,
51 `AGE_DATE` varchar(50) DEFAULT NULL
52) ENGINE=InnoDB DEFAULT CHARSET=utf8;
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `ALIASES`
58--
59
60CREATE TABLE `_pu_aliases` (
61 `USER_UID` int(20) NOT NULL,
62 `ALIAS` varchar(255) NOT NULL,
63 primary key (`USER_UID`, `ALIAS`),
64 FOREIGN KEY (`USER_UID`)
65 REFERENCES `_pu_users`(`UID`)
66 ON DELETE CASCADE
67) ENGINE=InnoDB DEFAULT CHARSET=utf8;
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `ALTERNATIVE_SPELLING`
73--
74
75CREATE TABLE `_pu_alternative_spelling` (
76 `USER_UID` int(20) NOT NULL,
77 `ALTERNATIVE_SPELLING` varchar(255) NOT NULL,
78 primary key (`USER_UID`, `ALTERNATIVE_SPELLING`),
79 FOREIGN KEY (`USER_UID`)
80 REFERENCES `_pu_users`(`UID`)
81 ON DELETE CASCADE
82) ENGINE=InnoDB DEFAULT CHARSET=utf8;
83
84-- --------------------------------------------------------
85
86--
87-- Table structure for table `PASSPORTS`
88--
89
90CREATE TABLE `_pu_passports` (
91 `USER_UID` int(20) NOT NULL,
92 `PASSPORT` varchar(255) NOT NULL,
93 primary key (`USER_UID`, `PASSPORT`),
94 FOREIGN KEY (`USER_UID`)
95 REFERENCES `_pu_users`(`UID`)
96 ON DELETE CASCADE
97) ENGINE=InnoDB DEFAULT CHARSET=utf8;
98
99
100-- --------------------------------------------------------
101
102--
103-- Table structure for table `LOCATIONS`
104--
105
106CREATE TABLE `_pu_locations` (
107 `USER_UID` int(20) NOT NULL,
108 `CITY` varchar(255) NOT NULL,
109 `STATE` varchar(255) NOT NULL,
110 `COUNTRY` varchar(255) NOT NULL,
111 primary key (`USER_UID`, `CITY`, `STATE`, `COUNTRY`),
112 FOREIGN KEY (`USER_UID`)
113 REFERENCES `_pu_users`(`UID`)
114 ON DELETE CASCADE
115) ENGINE=InnoDB DEFAULT CHARSET=utf8;
116
117-- --------------------------------------------------------
118
119--
120-- Table structure for table `COUNTIRES`
121--
122
123CREATE TABLE `_pu_countries` (
124 `USER_UID` int(20) NOT NULL,
125 `COUNTRY` varchar(255) NOT NULL,
126 primary key (`USER_UID`, `COUNTRY`),
127 FOREIGN KEY (`USER_UID`)
128 REFERENCES `_pu_users`(`UID`)
129 ON DELETE CASCADE
130) ENGINE=InnoDB DEFAULT CHARSET=utf8;
131
132-- --------------------------------------------------------
133
134--
135-- Table structure for table `COMPANIES`
136--
137
138CREATE TABLE `_pu_companies` (
139 `USER_UID` int(20) NOT NULL,
140 `COMPANY` varchar(255) NOT NULL,
141 primary key (`USER_UID`, `COMPANY`),
142 FOREIGN KEY (`USER_UID`)
143 REFERENCES `_pu_users`(`UID`)
144 ON DELETE CASCADE
145) ENGINE=InnoDB DEFAULT CHARSET=utf8;
146
147-- --------------------------------------------------------
148
149--
150-- Table structure for table `LINKED_TO`
151--
152
153CREATE TABLE `_pu_linked_to` (
154 `USER_UID` int(20) NOT NULL,
155 `LINKED_TO` varchar(255) NOT NULL,
156 primary key (`USER_UID`, `LINKED_TO`),
157 FOREIGN KEY (`USER_UID`)
158 REFERENCES `_pu_users`(`UID`)
159 ON DELETE CASCADE
160) ENGINE=InnoDB DEFAULT CHARSET=utf8;
161
162-- --------------------------------------------------------
163
164--
165-- Table structure for table `KEYWORDS`
166--
167
168CREATE TABLE `_pu_keywords` (
169 `USER_UID` int(20) NOT NULL,
170 `KEYWORD` varchar(255) NOT NULL,
171 primary key (`USER_UID`, `KEYWORD`),
172 FOREIGN KEY (`USER_UID`)
173 REFERENCES `_pu_users`(`UID`)
174 ON DELETE CASCADE
175) ENGINE=InnoDB DEFAULT CHARSET=utf8;
176
177-- --------------------------------------------------------
178
179--
180-- Table structure for table `EXTERNAL SOURCES`
181--
182
183CREATE TABLE `_pu_external_sources` (
184 `USER_UID` int(20) NOT NULL,
185 `URI` varchar(500) NOT NULL,
186 primary key (`USER_UID`, `URI`),
187 FOREIGN KEY (`USER_UID`)
188 REFERENCES `_pu_users`(`UID`)
189 ON DELETE CASCADE
190) ENGINE=InnoDB DEFAULT CHARSET=utf8;
191
192
193
194
195--
196-- Table structure for table `_pu_logs`
197--
198
199CREATE TABLE `_pu_logs` (
200 `id` bigint(20) NOT NULL UNIQUE auto_increment,
201 `message` varchar(255) DEFAULT NULL,
202 `created` bigint(20) DEFAULT NULL
203) ENGINE=InnoDB DEFAULT CHARSET=utf8;
204
205COMMIT;