· 6 years ago · May 30, 2019, 12:28 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,
35 `LASTNAME` varchar(100) DEFAULT NULL,
36 `FIRSTNAME` varchar(100) DEFAULT NULL,
37 `CATEGORY` varchar(50) DEFAULT NULL,
38 `TITLE` varchar(50) DEFAULT NULL,
39 `SUB_CATEGORY` varchar(3) DEFAULT NULL,
40 `POSITION` varchar(100) DEFAULT NULL,
41 `AGE` int(3) NULL DEFAULT NULL,
42 `DOB` varchar(20) 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` text DEFAULT NULL,
48 `ENTERED` date DEFAULT NULL,
49 `UPDATED` date DEFAULT NULL,
50 `EDITOR` varchar(20) DEFAULT NULL,
51 `AGE_DATE` date DEFAULT NULL,
52 primary key (`UID`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8;
54
55-- --------------------------------------------------------
56
57--
58-- Table structure for table `ALIASES`
59--
60
61CREATE TABLE `_pu_aliases` (
62 `USER_UID` int(20) NOT NULL,
63 `ALIAS` varchar(255) NOT NULL,
64 primary key (`USER_UID`, `ALIAS`),
65 FOREIGN KEY (`USER_UID`)
66 REFERENCES `_pu_users`(`UID`)
67 ON DELETE CASCADE
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `ALTERNATIVE_SPELLING`
74--
75
76CREATE TABLE `_pu_alternative_spelling` (
77 `USER_UID` int(20) NOT NULL,
78 `ALTERNATIVE_SPELLING` varchar(255) NOT NULL,
79 primary key (`USER_UID`, `ALTERNATIVE_SPELLING`),
80 FOREIGN KEY (`USER_UID`)
81 REFERENCES `_pu_users`(`UID`)
82 ON DELETE CASCADE
83) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84
85-- --------------------------------------------------------
86
87--
88-- Table structure for table `PASSPORTS`
89--
90
91CREATE TABLE `_pu_passports` (
92 `USER_UID` int(20) NOT NULL,
93 `PASSPORT` varchar(255) NOT NULL,
94 primary key (`USER_UID`, `PASSPORT`),
95 FOREIGN KEY (`USER_UID`)
96 REFERENCES `_pu_users`(`UID`)
97 ON DELETE CASCADE
98) ENGINE=InnoDB DEFAULT CHARSET=utf8;
99
100
101-- --------------------------------------------------------
102
103--
104-- Table structure for table `LOCATIONS`
105--
106
107CREATE TABLE `_pu_locations` (
108 `USER_UID` int(20) NOT NULL,
109 `CITY` varchar(100) NOT NULL,
110 `STATE` varchar(100) NOT NULL,
111 `COUNTRY` varchar(100) NOT NULL,
112 primary key (`USER_UID`, `CITY`, `STATE`, `COUNTRY`),
113 FOREIGN KEY (`USER_UID`)
114 REFERENCES `_pu_users`(`UID`)
115 ON DELETE CASCADE
116) ENGINE=InnoDB DEFAULT CHARSET=utf8;
117
118-- --------------------------------------------------------
119
120--
121-- Table structure for table `COUNTIRES`
122--
123
124CREATE TABLE `_pu_countries` (
125 `USER_UID` int(20) NOT NULL,
126 `COUNTRY` varchar(100) NOT NULL,
127 primary key (`USER_UID`, `COUNTRY`),
128 FOREIGN KEY (`USER_UID`)
129 REFERENCES `_pu_users`(`UID`)
130 ON DELETE CASCADE
131) ENGINE=InnoDB DEFAULT CHARSET=utf8;
132
133-- --------------------------------------------------------
134
135--
136-- Table structure for table `COMPANIES`
137--
138
139CREATE TABLE `_pu_companies` (
140 `USER_UID` int(20) NOT NULL,
141 `COMPANY` int(8) NOT NULL,
142 primary key (`USER_UID`, `COMPANY`),
143 FOREIGN KEY (`USER_UID`)
144 REFERENCES `_pu_users`(`UID`)
145 ON DELETE CASCADE
146) ENGINE=InnoDB DEFAULT CHARSET=utf8;
147
148-- --------------------------------------------------------
149
150--
151-- Table structure for table `LINKED_TO`
152--
153
154CREATE TABLE `_pu_linked_to` (
155 `USER_UID` int(20) NOT NULL,
156 `LINKED_TO` int(10) NOT NULL,
157 primary key (`USER_UID`, `LINKED_TO`),
158 FOREIGN KEY (`USER_UID`)
159 REFERENCES `_pu_users`(`UID`)
160 ON DELETE CASCADE
161) ENGINE=InnoDB DEFAULT CHARSET=utf8;
162
163-- --------------------------------------------------------
164
165--
166-- Table structure for table `KEYWORDS`
167--
168
169CREATE TABLE `_pu_keywords` (
170 `USER_UID` int(20) NOT NULL,
171 `KEYWORD` varchar(255) NOT NULL,
172 primary key (`USER_UID`, `KEYWORD`),
173 FOREIGN KEY (`USER_UID`)
174 REFERENCES `_pu_users`(`UID`)
175 ON DELETE CASCADE
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177
178-- --------------------------------------------------------
179
180--
181-- Table structure for table `EXTERNAL SOURCES`
182--
183
184CREATE TABLE `_pu_external_sources` (
185 `USER_UID` int(20) NOT NULL,
186 `URI` varchar(500) NOT NULL,
187 primary key (`USER_UID`, `URI`),
188 FOREIGN KEY (`USER_UID`)
189 REFERENCES `_pu_users`(`UID`)
190 ON DELETE CASCADE
191) ENGINE=InnoDB DEFAULT CHARSET=utf8;
192
193
194
195
196--
197-- Table structure for table `_pu_logs`
198--
199
200CREATE TABLE `_pu_logs` (
201 `id` bigint(20) NOT NULL UNIQUE auto_increment,
202 `message` varchar(255) DEFAULT NULL,
203 `created` bigint(20) DEFAULT NULL
204) ENGINE=InnoDB DEFAULT CHARSET=utf8;
205
206COMMIT;