1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
/*
SQLyog - Free MySQL GUI v5.0
Host - 5.5.5-10.1.16-MariaDB : Database - mvcdb
*********************************************************************
Server version : 5.5.5-10.1.16-MariaDB
*/
create database if not exists `mvcdb`;
USE `mvcdb`;
/*Table structure for table `client` */
DROP TABLE IF EXISTS `client`;
CREATE TABLE `client` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`fullnames` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sex` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`birthdate` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`idcard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`province` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`district` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`sector` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `client` */
insert into `client` values
(2,'reus.jpg','sam;','kljkj','kj;d','j;dj',';j',';j','d','2016-11-25 06:59:23','2016-11-25 07:48:06'),
(3,'gambar.jpg','asdnasn','as;nd;','d',';n',';md;',';l','dmd','2016-11-25 07:31:14','2016-11-25 07:31:14'),
(4,'gambar.jpg','as;jak;','DJSE;KF','W;M','F;LF;',';L','m m,','F;LM;m','2016-11-25 07:41:54','2016-11-25 07:41:54'),
(5,'gambar.jpg','as;jak;','DJSE;KF','W;M','F;LF;',';L','m m,','F;LM;m','2016-11-25 07:45:30','2016-11-25 07:45:30'),
(6,'gambar.jpg','asmd;.','as;,','asdm;','asmd;','asmdn;','aslnk;asm d;','dlsank;l','2016-11-25 07:46:50','2016-11-25 07:46:50');
/*Table structure for table `migrations` */
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `migrations` */
insert into `migrations` values
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_resets_table',1),
(3,'2016_11_24_220305_client',2),
(4,'2016_11_24_221043_clients',3);