ZUBjzJVs

1SET NAMES utf8;
2SET time_zone = '+00:00';
3SET foreign_key_checks = 0;
4SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
5
6DROP TABLE IF EXISTS `register_bd`;
7CREATE TABLE `register_bd` (
8  `id` int(5) NOT NULL AUTO_INCREMENT,
9  `name` varchar(100) DEFAULT NULL,
10  `email` varchar(100) DEFAULT NULL,
11  `gender` varchar(255) NOT NULL,
12  `tgllahir` varchar(255) NOT NULL,
13  `pass` varchar(255) NOT NULL,
14  `cpassword` varchar(255) NOT NULL,
15  `phone` varchar(16) DEFAULT NULL,
16  `idcard` varchar(15) NOT NULL,
17  `giw_info_from` varchar(25) NOT NULL,
18  `ever_buy` tinyint(1) NOT NULL,
19  `buy_from` varchar(100) NOT NULL,
20  `buy_experience` text NOT NULL,
21  `status` tinyint(1) NOT NULL,
22  `code_voucher` varchar(5) NOT NULL,
23  `created_at` datetime NOT NULL,
24  `updated_at` datetime NOT NULL,
25  `nama_belakang` varchar(100) DEFAULT NULL,
26  `responmage` text,
27  `kota` varchar(200) NOT NULL,
28  PRIMARY KEY (`id`),
29  UNIQUE KEY `email` (`email`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;