· 8 years ago · Jun 21, 2018, 04:58 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: Apr 26, 2018 at 05:03 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: `bwirejobs_db`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `tbl_academic_qualification`
27--
28
29CREATE TABLE IF NOT EXISTS `tbl_academic_qualification` (
30 `id` int(255) NOT NULL AUTO_INCREMENT,
31 `member_no` varchar(255) NOT NULL,
32 `country` varchar(255) NOT NULL,
33 `institution` varchar(255) NOT NULL,
34 `course` varchar(255) NOT NULL,
35 `level` varchar(255) NOT NULL,
36 `timeframe` varchar(255) NOT NULL,
37 `certificate` longblob NOT NULL,
38 `transcript` longblob NOT NULL,
39 PRIMARY KEY (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `tbl_alerts`
46--
47
48CREATE TABLE IF NOT EXISTS `tbl_alerts` (
49 `id` int(255) NOT NULL AUTO_INCREMENT,
50 `code` varchar(255) NOT NULL,
51 `description` varchar(255) NOT NULL,
52 `type` varchar(255) NOT NULL,
53 PRIMARY KEY (`id`),
54 UNIQUE KEY `code` (`code`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;
56
57--
58-- Dumping data for table `tbl_alerts`
59--
60
61INSERT INTO `tbl_alerts` (`id`, `code`, `description`, `type`) VALUES
62(1, '1123', 'You have been registered successfully', 'success'),
63(2, '4568', 'Unknown error occurred while performing your request', 'danger'),
64(3, '0927', 'Email address is already registered', 'warning'),
65(4, '0346', 'Invalid email or password', 'danger'),
66(5, '9837', 'Your profile have been updated successfully', 'success'),
67(6, '9564', 'Password updated successfully', 'success'),
68(9, '2305', 'Professional qualification was added successfully', 'success'),
69(11, '0521', 'Qualification was deleted successfully', 'success'),
70(13, '9367', 'language have been added', 'success'),
71(14, '0591', 'Language was deleted successfully', 'success'),
72(15, '8763', 'Language have been updated', 'success'),
73(16, '6734', 'Professional qualification was updated', 'success'),
74(17, '9843', 'Your job advertise have been posted successfully', 'success'),
75(18, '1964', 'Training / Workshop have been added successfully', 'success'),
76(20, '9210', 'working experience have been added', 'success'),
77(22, '9215', 'working experience updated successfully', 'success'),
78(24, '0593', 'working experience was deleted', 'success'),
79(26, '9522', 'Training / workshop record have been deleted', 'success'),
80(28, '2303', 'Academic qualification have been added successfully', 'success'),
81(30, '1521', 'Academic qualification was deleted', 'success'),
82(32, '3214', 'Academic qualification have been updated', 'success'),
83(34, '2380', 'Referee was added successfully', 'success'),
84(36, '7642', 'Referee information have been updated', 'success'),
85(38, '0173', 'Job Ad have been deleted', 'success'),
86(40, '0369', 'Job Ad has been updated successfully', 'success'),
87(42, '2974', 'An error occurred while sending your message', 'danger'),
88(43, '5634', 'Your message was sent successfully', 'success'),
89(44, '3091', 'You have successfully changed your password', 'success'),
90(45, '3591', 'An error occurred while updating your password', 'danger'),
91(46, '2290', 'Your certificate size must be less or equal to <strong>1MB</strong>', 'warning'),
92(47, '2490', 'Your transcript size must be less or equal to <strong>1MB</strong>', 'warning'),
93(48, '5790', 'Training information was updated', 'success'),
94(50, '3478', 'Your image size must be less or equal to <strong>1MB</strong>', 'warning'),
95(51, '6789', 'Attachment was added successfully', 'success'),
96(53, '6784', 'Attachment was deleted successfully', 'success'),
97(55, '7764', 'Attachment was updated successfully', 'success'),
98(57, '9517', 'Referee have been deleted', 'success');
99
100-- --------------------------------------------------------
101
102--
103-- Table structure for table `tbl_categories`
104--
105
106CREATE TABLE IF NOT EXISTS `tbl_categories` (
107 `id` int(255) NOT NULL AUTO_INCREMENT,
108 `category` varchar(255) NOT NULL,
109 PRIMARY KEY (`id`)
110) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
111
112--
113-- Dumping data for table `tbl_categories`
114--
115
116INSERT INTO `tbl_categories` (`id`, `category`) VALUES
117(1, 'Accounting'),
118(2, 'Auditing'),
119(3, 'Banking and Financial Services'),
120(4, 'CEO and General Management'),
121(5, 'Community and Social Devt'),
122(6, 'Creative and Design'),
123(7, 'Education and Training'),
124(8, 'Engineering and Construction'),
125(9, 'Farming and Agribusiness'),
126(10, 'Healthcare and Pharmaceutical'),
127(11, 'HR & Administration'),
128(12, 'IT and Telecoms'),
129(13, 'Legal'),
130(14, 'Manufacturing'),
131(15, 'Marketing,Media and Brand'),
132(16, 'Mining and Natural Resources'),
133(17, 'Project & Programme Mngmnt'),
134(18, 'Research,Science and Biotech'),
135(19, 'Security'),
136(20, 'Strategy and Consulting'),
137(21, 'Tourism and Travel'),
138(22, 'Trades and Services'),
139(23, 'Transport and Logistics'),
140(24, 'Other');
141
142-- --------------------------------------------------------
143
144--
145-- Table structure for table `tbl_countries`
146--
147
148CREATE TABLE IF NOT EXISTS `tbl_countries` (
149 `id` int(11) NOT NULL AUTO_INCREMENT,
150 `country_code` varchar(2) NOT NULL DEFAULT '',
151 `country_name` varchar(100) NOT NULL DEFAULT '',
152 PRIMARY KEY (`id`)
153) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=246 ;
154
155--
156-- Dumping data for table `tbl_countries`
157--
158
159INSERT INTO `tbl_countries` (`id`, `country_code`, `country_name`) VALUES
160(1, 'AF', 'Afghanistan'),
161(2, 'AL', 'Albania'),
162(3, 'DZ', 'Algeria'),
163(4, 'DS', 'American Samoa'),
164(5, 'AD', 'Andorra'),
165(6, 'AO', 'Angola'),
166(7, 'AI', 'Anguilla'),
167(8, 'AQ', 'Antarctica'),
168(9, 'AG', 'Antigua and Barbuda'),
169(10, 'AR', 'Argentina'),
170(11, 'AM', 'Armenia'),
171(12, 'AW', 'Aruba'),
172(13, 'AU', 'Australia'),
173(14, 'AT', 'Austria'),
174(15, 'AZ', 'Azerbaijan'),
175(16, 'BS', 'Bahamas'),
176(17, 'BH', 'Bahrain'),
177(18, 'BD', 'Bangladesh'),
178(19, 'BB', 'Barbados'),
179(20, 'BY', 'Belarus'),
180(21, 'BE', 'Belgium'),
181(22, 'BZ', 'Belize'),
182(23, 'BJ', 'Benin'),
183(24, 'BM', 'Bermuda'),
184(25, 'BT', 'Bhutan'),
185(26, 'BO', 'Bolivia'),
186(27, 'BA', 'Bosnia and Herzegovina'),
187(28, 'BW', 'Botswana'),
188(29, 'BV', 'Bouvet Island'),
189(30, 'BR', 'Brazil'),
190(31, 'IO', 'British Indian Ocean Territory'),
191(32, 'BN', 'Brunei Darussalam'),
192(33, 'BG', 'Bulgaria'),
193(34, 'BF', 'Burkina Faso'),
194(35, 'BI', 'Burundi'),
195(36, 'KH', 'Cambodia'),
196(37, 'CM', 'Cameroon'),
197(38, 'CA', 'Canada'),
198(39, 'CV', 'Cape Verde'),
199(40, 'KY', 'Cayman Islands'),
200(41, 'CF', 'Central African Republic'),
201(42, 'TD', 'Chad'),
202(43, 'CL', 'Chile'),
203(44, 'CN', 'China'),
204(45, 'CX', 'Christmas Island'),
205(46, 'CC', 'Cocos (Keeling) Islands'),
206(47, 'CO', 'Colombia'),
207(48, 'KM', 'Comoros'),
208(49, 'CG', 'Congo'),
209(50, 'CK', 'Cook Islands'),
210(51, 'CR', 'Costa Rica'),
211(52, 'HR', 'Croatia (Hrvatska)'),
212(53, 'CU', 'Cuba'),
213(54, 'CY', 'Cyprus'),
214(55, 'CZ', 'Czech Republic'),
215(56, 'DK', 'Denmark'),
216(57, 'DJ', 'Djibouti'),
217(58, 'DM', 'Dominica'),
218(59, 'DO', 'Dominican Republic'),
219(60, 'TP', 'East Timor'),
220(61, 'EC', 'Ecuador'),
221(62, 'EG', 'Egypt'),
222(63, 'SV', 'El Salvador'),
223(64, 'GQ', 'Equatorial Guinea'),
224(65, 'ER', 'Eritrea'),
225(66, 'EE', 'Estonia'),
226(67, 'ET', 'Ethiopia'),
227(68, 'FK', 'Falkland Islands (Malvinas)'),
228(69, 'FO', 'Faroe Islands'),
229(70, 'FJ', 'Fiji'),
230(71, 'FI', 'Finland'),
231(72, 'FR', 'France'),
232(73, 'FX', 'France, Metropolitan'),
233(74, 'GF', 'French Guiana'),
234(75, 'PF', 'French Polynesia'),
235(76, 'TF', 'French Southern Territories'),
236(77, 'GA', 'Gabon'),
237(78, 'GM', 'Gambia'),
238(79, 'GE', 'Georgia'),
239(80, 'DE', 'Germany'),
240(81, 'GH', 'Ghana'),
241(82, 'GI', 'Gibraltar'),
242(83, 'GK', 'Guernsey'),
243(84, 'GR', 'Greece'),
244(85, 'GL', 'Greenland'),
245(86, 'GD', 'Grenada'),
246(87, 'GP', 'Guadeloupe'),
247(88, 'GU', 'Guam'),
248(89, 'GT', 'Guatemala'),
249(90, 'GN', 'Guinea'),
250(91, 'GW', 'Guinea-Bissau'),
251(92, 'GY', 'Guyana'),
252(93, 'HT', 'Haiti'),
253(94, 'HM', 'Heard and Mc Donald Islands'),
254(95, 'HN', 'Honduras'),
255(96, 'HK', 'Hong Kong'),
256(97, 'HU', 'Hungary'),
257(98, 'IS', 'Iceland'),
258(99, 'IN', 'India'),
259(100, 'IM', 'Isle of Man'),
260(101, 'ID', 'Indonesia'),
261(102, 'IR', 'Iran (Islamic Republic of)'),
262(103, 'IQ', 'Iraq'),
263(104, 'IE', 'Ireland'),
264(105, 'IL', 'Israel'),
265(106, 'IT', 'Italy'),
266(107, 'CI', 'Ivory Coast'),
267(108, 'JE', 'Jersey'),
268(109, 'JM', 'Jamaica'),
269(110, 'JP', 'Japan'),
270(111, 'JO', 'Jordan'),
271(112, 'KZ', 'Kazakhstan'),
272(113, 'KE', 'Kenya'),
273(114, 'KI', 'Kiribati'),
274(115, 'KP', 'Korea, Democratic People''s Republic of'),
275(116, 'KR', 'Korea, Republic of'),
276(117, 'XK', 'Kosovo'),
277(118, 'KW', 'Kuwait'),
278(119, 'KG', 'Kyrgyzstan'),
279(120, 'LA', 'Lao People''s Democratic Republic'),
280(121, 'LV', 'Latvia'),
281(122, 'LB', 'Lebanon'),
282(123, 'LS', 'Lesotho'),
283(124, 'LR', 'Liberia'),
284(125, 'LY', 'Libyan Arab Jamahiriya'),
285(126, 'LI', 'Liechtenstein'),
286(127, 'LT', 'Lithuania'),
287(128, 'LU', 'Luxembourg'),
288(129, 'MO', 'Macau'),
289(130, 'MK', 'Macedonia'),
290(131, 'MG', 'Madagascar'),
291(132, 'MW', 'Malawi'),
292(133, 'MY', 'Malaysia'),
293(134, 'MV', 'Maldives'),
294(135, 'ML', 'Mali'),
295(136, 'MT', 'Malta'),
296(137, 'MH', 'Marshall Islands'),
297(138, 'MQ', 'Martinique'),
298(139, 'MR', 'Mauritania'),
299(140, 'MU', 'Mauritius'),
300(141, 'TY', 'Mayotte'),
301(142, 'MX', 'Mexico'),
302(143, 'FM', 'Micronesia, Federated States of'),
303(144, 'MD', 'Moldova, Republic of'),
304(145, 'MC', 'Monaco'),
305(146, 'MN', 'Mongolia'),
306(147, 'ME', 'Montenegro'),
307(148, 'MS', 'Montserrat'),
308(149, 'MA', 'Morocco'),
309(150, 'MZ', 'Mozambique'),
310(151, 'MM', 'Myanmar'),
311(152, 'NA', 'Namibia'),
312(153, 'NR', 'Nauru'),
313(154, 'NP', 'Nepal'),
314(155, 'NL', 'Netherlands'),
315(156, 'AN', 'Netherlands Antilles'),
316(157, 'NC', 'New Caledonia'),
317(158, 'NZ', 'New Zealand'),
318(159, 'NI', 'Nicaragua'),
319(160, 'NE', 'Niger'),
320(161, 'NG', 'Nigeria'),
321(162, 'NU', 'Niue'),
322(163, 'NF', 'Norfolk Island'),
323(164, 'MP', 'Northern Mariana Islands'),
324(165, 'NO', 'Norway'),
325(166, 'OM', 'Oman'),
326(167, 'PK', 'Pakistan'),
327(168, 'PW', 'Palau'),
328(169, 'PS', 'Palestine'),
329(170, 'PA', 'Panama'),
330(171, 'PG', 'Papua New Guinea'),
331(172, 'PY', 'Paraguay'),
332(173, 'PE', 'Peru'),
333(174, 'PH', 'Philippines'),
334(175, 'PN', 'Pitcairn'),
335(176, 'PL', 'Poland'),
336(177, 'PT', 'Portugal'),
337(178, 'PR', 'Puerto Rico'),
338(179, 'QA', 'Qatar'),
339(180, 'RE', 'Reunion'),
340(181, 'RO', 'Romania'),
341(182, 'RU', 'Russian Federation'),
342(183, 'RW', 'Rwanda'),
343(184, 'KN', 'Saint Kitts and Nevis'),
344(185, 'LC', 'Saint Lucia'),
345(186, 'VC', 'Saint Vincent and the Grenadines'),
346(187, 'WS', 'Samoa'),
347(188, 'SM', 'San Marino'),
348(189, 'ST', 'Sao Tome and Principe'),
349(190, 'SA', 'Saudi Arabia'),
350(191, 'SN', 'Senegal'),
351(192, 'RS', 'Serbia'),
352(193, 'SC', 'Seychelles'),
353(194, 'SL', 'Sierra Leone'),
354(195, 'SG', 'Singapore'),
355(196, 'SK', 'Slovakia'),
356(197, 'SI', 'Slovenia'),
357(198, 'SB', 'Solomon Islands'),
358(199, 'SO', 'Somalia'),
359(200, 'ZA', 'South Africa'),
360(201, 'GS', 'South Georgia South Sandwich Islands'),
361(202, 'ES', 'Spain'),
362(203, 'LK', 'Sri Lanka'),
363(204, 'SH', 'St. Helena'),
364(205, 'PM', 'St. Pierre and Miquelon'),
365(206, 'SD', 'Sudan'),
366(207, 'SR', 'Suriname'),
367(208, 'SJ', 'Svalbard and Jan Mayen Islands'),
368(209, 'SZ', 'Swaziland'),
369(210, 'SE', 'Sweden'),
370(211, 'CH', 'Switzerland'),
371(212, 'SY', 'Syrian Arab Republic'),
372(213, 'TW', 'Taiwan'),
373(214, 'TJ', 'Tajikistan'),
374(215, 'TZ', 'Tanzania, United Republic of'),
375(216, 'TH', 'Thailand'),
376(217, 'TG', 'Togo'),
377(218, 'TK', 'Tokelau'),
378(219, 'TO', 'Tonga'),
379(220, 'TT', 'Trinidad and Tobago'),
380(221, 'TN', 'Tunisia'),
381(222, 'TR', 'Turkey'),
382(223, 'TM', 'Turkmenistan'),
383(224, 'TC', 'Turks and Caicos Islands'),
384(225, 'TV', 'Tuvalu'),
385(226, 'UG', 'Uganda'),
386(227, 'UA', 'Ukraine'),
387(228, 'AE', 'United Arab Emirates'),
388(229, 'GB', 'United Kingdom'),
389(230, 'US', 'United States'),
390(231, 'UM', 'United States minor outlying islands'),
391(232, 'UY', 'Uruguay'),
392(233, 'UZ', 'Uzbekistan'),
393(234, 'VU', 'Vanuatu'),
394(235, 'VA', 'Vatican City State'),
395(236, 'VE', 'Venezuela'),
396(237, 'VN', 'Vietnam'),
397(238, 'VG', 'Virgin Islands (British)'),
398(239, 'VI', 'Virgin Islands (U.S.)'),
399(240, 'WF', 'Wallis and Futuna Islands'),
400(241, 'EH', 'Western Sahara'),
401(242, 'YE', 'Yemen'),
402(243, 'ZR', 'Zaire'),
403(244, 'ZM', 'Zambia'),
404(245, 'ZW', 'Zimbabwe');
405
406-- --------------------------------------------------------
407
408--
409-- Table structure for table `tbl_experience`
410--
411
412CREATE TABLE IF NOT EXISTS `tbl_experience` (
413 `id` int(255) NOT NULL AUTO_INCREMENT,
414 `member_no` varchar(255) NOT NULL,
415 `title` varchar(255) NOT NULL,
416 `institution` varchar(255) NOT NULL,
417 `supervisor` varchar(255) NOT NULL,
418 `supervisor_phone` varchar(255) NOT NULL,
419 `start_date` varchar(255) NOT NULL,
420 `end_date` varchar(255) NOT NULL,
421 `duties` longtext NOT NULL,
422 PRIMARY KEY (`id`)
423) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
424
425-- --------------------------------------------------------
426
427--
428-- Table structure for table `tbl_jobs`
429--
430
431CREATE TABLE IF NOT EXISTS `tbl_jobs` (
432 `job_id` varchar(255) NOT NULL,
433 `title` varchar(255) NOT NULL,
434 `city` varchar(255) NOT NULL,
435 `country` varchar(255) NOT NULL,
436 `category` varchar(255) NOT NULL,
437 `type` varchar(255) NOT NULL,
438 `experience` varchar(255) NOT NULL,
439 `description` longtext NOT NULL,
440 `responsibility` longtext NOT NULL,
441 `requirements` longtext NOT NULL,
442 `company` varchar(255) NOT NULL,
443 `date_posted` varchar(255) NOT NULL,
444 `closing_date` varchar(255) NOT NULL,
445 `enc_id` int(255) NOT NULL AUTO_INCREMENT,
446 PRIMARY KEY (`enc_id`),
447 UNIQUE KEY `job_id` (`job_id`)
448) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
449
450-- --------------------------------------------------------
451
452--
453-- Table structure for table `tbl_job_applications`
454--
455
456CREATE TABLE IF NOT EXISTS `tbl_job_applications` (
457 `id` int(255) NOT NULL AUTO_INCREMENT,
458 `member_no` varchar(255) NOT NULL,
459 `job_id` varchar(255) NOT NULL,
460 `application_date` varchar(255) NOT NULL,
461 PRIMARY KEY (`id`)
462) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
463
464-- --------------------------------------------------------
465
466--
467-- Table structure for table `tbl_language`
468--
469
470CREATE TABLE IF NOT EXISTS `tbl_language` (
471 `id` int(255) NOT NULL AUTO_INCREMENT,
472 `member_no` varchar(255) NOT NULL,
473 `language` varchar(255) NOT NULL,
474 `speak` varchar(255) NOT NULL,
475 `reading` varchar(255) NOT NULL,
476 `writing` varchar(255) NOT NULL,
477 PRIMARY KEY (`id`)
478) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
479
480-- --------------------------------------------------------
481
482--
483-- Table structure for table `tbl_other_attachments`
484--
485
486CREATE TABLE IF NOT EXISTS `tbl_other_attachments` (
487 `id` int(255) NOT NULL AUTO_INCREMENT,
488 `member_no` varchar(255) NOT NULL,
489 `title` varchar(255) NOT NULL,
490 `issuer` varchar(255) NOT NULL,
491 `attachment` longblob NOT NULL,
492 PRIMARY KEY (`id`)
493) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
494
495-- --------------------------------------------------------
496
497--
498-- Table structure for table `tbl_professional_qualification`
499--
500
501CREATE TABLE IF NOT EXISTS `tbl_professional_qualification` (
502 `id` int(255) NOT NULL AUTO_INCREMENT,
503 `member_no` varchar(255) NOT NULL,
504 `country` varchar(255) NOT NULL,
505 `institution` varchar(255) NOT NULL,
506 `title` varchar(255) NOT NULL,
507 `timeframe` varchar(255) NOT NULL,
508 `certificate` longblob NOT NULL,
509 PRIMARY KEY (`id`)
510) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
511
512-- --------------------------------------------------------
513
514--
515-- Table structure for table `tbl_referees`
516--
517
518CREATE TABLE IF NOT EXISTS `tbl_referees` (
519 `id` int(255) NOT NULL AUTO_INCREMENT,
520 `member_no` varchar(255) NOT NULL,
521 `ref_name` varchar(255) NOT NULL,
522 `ref_mail` varchar(255) NOT NULL,
523 `ref_title` varchar(255) NOT NULL,
524 `ref_phone` varchar(255) NOT NULL,
525 `institution` varchar(255) NOT NULL,
526 PRIMARY KEY (`id`)
527) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
528
529-- --------------------------------------------------------
530
531--
532-- Table structure for table `tbl_tokens`
533--
534
535CREATE TABLE IF NOT EXISTS `tbl_tokens` (
536 `id` int(255) NOT NULL AUTO_INCREMENT,
537 `email` varchar(255) NOT NULL,
538 `token` varchar(255) NOT NULL,
539 PRIMARY KEY (`id`)
540) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
541
542-- --------------------------------------------------------
543
544--
545-- Table structure for table `tbl_training`
546--
547
548CREATE TABLE IF NOT EXISTS `tbl_training` (
549 `id` int(255) NOT NULL AUTO_INCREMENT,
550 `member_no` varchar(255) NOT NULL,
551 `training` varchar(255) NOT NULL,
552 `institution` varchar(255) NOT NULL,
553 `timeframe` varchar(255) NOT NULL,
554 `certificate` longblob,
555 PRIMARY KEY (`id`)
556) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
557
558-- --------------------------------------------------------
559
560--
561-- Table structure for table `tbl_users`
562--
563
564CREATE TABLE IF NOT EXISTS `tbl_users` (
565 `first_name` varchar(255) NOT NULL,
566 `last_name` varchar(255) NOT NULL,
567 `gender` varchar(255) NOT NULL DEFAULT '-',
568 `bdate` varchar(255) NOT NULL DEFAULT '-',
569 `bmonth` varchar(255) NOT NULL DEFAULT '-',
570 `byear` varchar(255) NOT NULL DEFAULT '-',
571 `email` varchar(255) NOT NULL,
572 `education` varchar(255) NOT NULL DEFAULT '-',
573 `title` varchar(255) NOT NULL DEFAULT 'Your professional',
574 `city` varchar(255) NOT NULL DEFAULT '-',
575 `street` varchar(255) NOT NULL DEFAULT '-',
576 `zip` varchar(255) NOT NULL DEFAULT '-',
577 `country` varchar(255) NOT NULL DEFAULT '-',
578 `phone` varchar(255) NOT NULL DEFAULT '-',
579 `about` longtext,
580 `avatar` longblob,
581 `services` longtext,
582 `expertise` longtext,
583 `people` varchar(255) NOT NULL DEFAULT '-',
584 `last_login` varchar(255) NOT NULL,
585 `role` varchar(255) NOT NULL,
586 `website` varchar(255) NOT NULL DEFAULT '-',
587 `login` varchar(255) NOT NULL,
588 `member_no` varchar(255) NOT NULL,
589 PRIMARY KEY (`member_no`)
590) ENGINE=InnoDB DEFAULT CHARSET=latin1;
591
592/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
593/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
594/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;