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