· 4 years ago · Feb 04, 2021, 01:00 AM
1igrow.asia
2sample row
3
4
5DROP TABLE IF EXISTS tb_user;
6CREATE TABLE tb_user (
7 id_user int(11) NOT NULL auto_increment,
8 facebook_user_id varchar(255) NOT NULL,
9 google_user_id varchar(255) NOT NULL,
10 username varchar(255) NOT NULL,
11 password varchar(255) NOT NULL,
12 gcm_token varchar(255) NOT NULL,
13 id_user_group int(11) NOT NULL,
14 name varchar(255),
15 address varchar(255),
16 birthdate date DEFAULT '1980-01-01',
17 tempat_lahir varchar(255),
18 id_negara_domisili int(11) NOT NULL,
19 id_jenis_kelamin int(11) DEFAULT '1' NOT NULL,
20 kode_pos varchar(255),
21 id_agama int(11) DEFAULT '1' NOT NULL,
22 id_status_perkawinan int(11) DEFAULT '1' NOT NULL,
23 id_kewarganegaraan int(11) NOT NULL,
24 ktp varchar(255) NOT NULL,
25 income_source varchar(255) NOT NULL,
26 job varchar(255) NOT NULL,
27 npwp varchar(255) NOT NULL,
28 npwp_picture varchar(255) NOT NULL,
29 telephone varchar(255),
30 picture varchar(255),
31 ktp_picture varchar(255),
32 email varchar(255),
33 rating int(11),
34 email_verification varchar(255),
35 active_status int(11),
36 location varchar(255) NOT NULL,
37 is_verified tinyint(1) NOT NULL,
38 province varchar(255),
39 region varchar(255),
40 bank int(11) NOT NULL,
41 bank_branch varchar(255) NOT NULL,
42 account_number varchar(255) NOT NULL,
43 account_owner varchar(255) NOT NULL,
44 address2 varchar(255),
45 biodata text,
46 fb text,
47 twitter text,
48 portofolio int(11),
49 reviewer int(11),
50 lan varchar(255),
51 long varchar(255),
52 date_registered timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL,
53 created_at timestamp,
54 updated_at timestamp,
55 successor_name varchar(255) NOT NULL,
56 successor_phone varchar(255) NOT NULL,
57 successor_address text NOT NULL,
58 ip_address varchar(255) NOT NULL,
59 voucher_code varchar(255),
60 voucher_balance int(11) NOT NULL,
61 KEY id_user (id_user),
62 KEY id_user_group (id_user_group)
63);
64INSERT INTO tb_user VALUES('45', '', '', 'mad_iz', 'd282781fcc9c31611fde8789e592d0c0', '', '2', 'Ahmad Faiz', 'Perum BATAN CB-30 Banguntapan Bantul', '1980-01-01', NULL, '0', '1', NULL, '1', '1', '0', '', '', '', '', '', '085643060379', 'uploads/profile/dummy.png', '', 'mad_iz@yahoo.com', '0', '8206952782mad_iz226458', '1', 'id', '0', '', '', '0', '', '', '', '0', 'saya praktisi kesehatan yang tertarik dg konsep i-grow', NULL, NULL, '0', '0', '0', '0', '2014-12-05 01:00:00', NULL, '2014-12-05 01:00:00', '', '', '', '', NULL, '0');
65INSERT INTO tb_user VALUES('46', '', '', 'edreesetea', '28cd8594341fbe0a757de005c189e732', 'dAu5c9AYcps:APA91bEY0Dv2-6gHnsdE6o5ufayDc3HvzXNWcz_Jkm9ByidkgnXISqpn9jEORyY18FJX-d0ffJZZO2iZtY2XD7LGa3PRAHWUZTX2lB1kOydZtqBujN1Dg2ZdyvNQr9xV1WJeNtTcw9d6', '2', 'Idris Soleh', 'Perum gramapuri persada blok h3 no 2 , desa sukajaya, kec. CibitunG', '1980-01-01', NULL, '0', '1', NULL, '1', '1', '0', '', '', '', '', '', '082124428317', 'uploads/profile/dummy.png', '', 'edreesetea@gmail.com', '0', '89780459671edreesetea246021', '1', 'id', '0', '', '', '0', '', '', '', '0', 'Menanam pohon sebagai amal jariyah dan warisan untuk anak cucu', NULL, NULL, '0', '0', '0', '0', '2014-12-05 01:00:00', NULL, '2018-06-24 03:04:28', '', '', '', '', NULL, '0');
66INSERT INTO tb_user VALUES('47', '', '', 'cak dayat', '08268a9dfb541fe7af7f06798d2bf1c6', '', '2', 'achmad hidayat', 'jl.raya jetis 124 malang', '1980-01-01', NULL, '0', '1', NULL, '1', '1', '0', '', '', '', '', '', '085649885526', 'uploads/profile/dummy.png', '', 'cakdayat@gmail.com', '0', '35458408725cak dayat23851', '1', '', '0', '', '', '0', '', '', '', '0', 'owner www.botiashop.com\ntertarik untuk melestarikan buah-buah lokal yang sudah mulai hilang', NULL, NULL, '0', '0', '0', '0', '2014-12-05 01:00:00', NULL, '2018-10-30 07:04:18', '', '', '', '', NULL, '0');
67INSERT INTO tb_user VALUES('48', '', '', 'slamet', 'd3d3c9845e9a6bb4fc6e5e45186939e3', '', '2', 'slamet bardoyo', 'Rt 54 rw 05 randudongkal', '1980-01-01', NULL, '0', '1', NULL, '1', '1', '0', '', '', '', '', '', '082324371099', 'uploads/profile/dummy.png', '', 'randucomcenter@gmail.com', '0', '19500900739slamet237449', '1', 'id', '0', '', '', '0', '', '', '', '0', 'Lahir 3 0ktober 1976, sarjana ilmu kelautan undip semarang, ', NULL, NULL, '0', '0', '0', '0', '2014-12-05 01:00:00', NULL, '2014-12-05 01:00:00', '', '', '', '', NULL, '0');
68INSERT INTO tb_user VALUES('49', '', '', 'darmawan', '5b28905acec29cd3e001a636d7b014d6', '', '2', 'darmawan', 'Cluster grandnasya 3 no.1 jl. H agussalim ; lrg mms a rivai kotabaru jambi samping asrama haji', '1980-01-01', NULL, '0', '1', NULL, '1', '1', '0', '', '', '', '', '', '08111551154', 'uploads/profile/dummy.png', '', 'darma_bmi@yahoo.co.id', '0', '11511673181darmawan217535', '1', 'id', '0', '', '', '0', '', '', '', '0', 'Professional', NULL, NULL, '0', '0', '0', '0', '2014-12-05 01:00:00', NULL, '2014-12-05 01:00:00', '', '', '', '', NULL, '0');
69INSERT INTO tb_user VALUES('50', '', '', 'Dianms', '8211d19409b643f825b5de498089429e', '', '2', 'Dian Mulyana Saepudin', ' Jl. Sekolah III no 3 Bandung', '1980-01-01', NULL, '0', '1', NULL, '1', '1', '0', '', '', '', '', '', '081220904939', 'uploads/profile/dummy.png', '', 'dian.mulyana@gmail.com', '0', '84685896369Dianms216043', '1', '', '0', '', '', '0', '', '', '', '0', 'analis kimia', '', '', '0', '0', '0', '0', '2014-12-05 01:00:00', NULL, '2018-08-02 12:38:54', '', '', '', '', NULL, '0');
70INSERT INTO tb_user VALUES('51', '', '', 'zaenale', '3c6260e34c9335779aac6b97a8e61ecc', '', '2', 'Zaenal Arifin', 'Komp. Hankam No. 2 RT 004/011, Kebayoran Lama, Jakarta Selatan, 12220', '1976-01-10', 'Semarang', '0', '1', '12220', '1', '1', '0', '3174051001760003', '1', '1', '491352241013000', '', '08129953135', 'uploads/profile/dummy.png', 'uploads/ktp/f8924c0d436ea2176a53232bf1b43bba.jpg', 'zaenale@gmail.com', '0', '79226965252zaenale216308', '1', '', '1', '31', '3171', '451', 'PALMERAH', '7012349704', 'Zaenal Arifin', '0', 'Pekerja swasta fokus di bidang HR', NULL, NULL, '3', '0', '0', '0', '2014-12-05 01:00:00', NULL, '2018-12-26 01:04:06', 'Firda Aulya Syamani', '081317714970', 'Komp. Hankam No. 2 RT 004/011, Kebayoran Lama, Jakarta Selatan, 12220', '', 'IGWARI1976', '0');
71INSERT INTO tb_user VALUES('52', '', '', 'iwantuban', '1550ea26fc59f3d41cc62e4e7515cf35', '', '2', 'IWAN SETIAWAN', ' Jl. Desa Rt.03 Rw.03 Dusun Kejenon Desa Jenu', '1980-01-01', NULL, '0', '1', NULL, '1', '1', '0', '', '', '', '', '', '081803251318', 'uploads/profile/dummy.png', '', 'iwan.bba@gmail.com', '0', '73118886261iwantuban248424', '1', 'id', '0', '', '', '0', '', '', '', '0', ' Lahir di Sukabumi, thm 1968, kami hijrah ke Tuban Jawa Timur Thn 1995. Dan menetap di Tuban hingga sekarang.', '', '', '0', '0', '0', '0', '2014-12-05 01:00:00', NULL, '2014-12-05 01:00:00', '', '', '', '', NULL, '0');