Dumpign Data User

-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 25, 2014 at 03:12 PM
-- Server version: 5.5.36
-- PHP Version: 5.4.27


--
-- Table structure for table `tbl_user`
--

CREATE TABLE IF NOT EXISTS `tbl_user` (
  `iduser` bigint(8) NOT NULL AUTO_INCREMENT,
  `password` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `gender` enum('L','P') NOT NULL DEFAULT 'P',
  `tgl_lahir` date NOT NULL,
  `idfacebook` varchar(30) NOT NULL,
  `lastlogin_time` datetime NOT NULL,
  `lastlogin_ip` varchar(30) NOT NULL,
  `cookie_cache` varchar(100) NOT NULL,
  `levelnum` enum('1','2','3','4','5') NOT NULL DEFAULT '5' COMMENT '1=Developer 2=Administrator 3=Pengelola 4=Admin 5=Customer',
  `aktif` enum('1','0') NOT NULL DEFAULT '0',
  PRIMARY KEY (`iduser`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`iduser`, `password`, `email`, `gender`, `tgl_lahir`, `idfacebook`, `lastlogin_time`, `lastlogin_ip`, `cookie_cache`, `levelnum`, `aktif`) VALUES
(1, 'ar148807251f893bf3fd4987853f1cb5cbbf45798a', 'arijulianto@programmer.net', 'L', '1988-07-31', '10203076479616747', '2014-11-24 17:20:19', '127.0.0.1', '', '1', '1'),
(2, 'ar148807251f893bf3fd4987853f1cb5cbbf45798a', 'admin@bloomoze.com', 'P', '0000-00-00', '', '0000-00-00 00:00:00', '', '', '2', '1'),
(3, 'ar148807251f893bf3fd4987853f1cb5cbbf45798a', 'regga@advess.net', 'L', '0000-00-00', '', '2014-11-14 11:00:20', '127.0.0.1', '', '5', '0'),
(5, 'ZHkJUgCbrx1f893bf3fd4987853f1cb5cbbf45798a', 'arijulianto@gmail.com', 'P', '0000-00-00', '', '2014-11-20 12:31:42', '127.0.0.1', '', '5', '0');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user_alamat`
--

CREATE TABLE IF NOT EXISTS `tbl_user_alamat` (
  `idalamat` bigint(8) NOT NULL AUTO_INCREMENT,
  `iduser` int(8) NOT NULL,
  `nama` varchar(50) NOT NULL DEFAULT '0',
  `telp` varchar(25) NOT NULL,
  `alamat` text NOT NULL,
  `idkota` int(8) NOT NULL,
  `idkecamatan` int(8) NOT NULL,
  `kode_pos` varchar(5) NOT NULL,
  `utama` enum('1','0') NOT NULL DEFAULT '0',
  PRIMARY KEY (`idalamat`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tbl_user_alamat`
--

INSERT INTO `tbl_user_alamat` (`idalamat`, `iduser`, `nama`, `telp`, `alamat`, `idkota`, `idkecamatan`, `kode_pos`, `utama`) VALUES
(1, 1, 'Ari Julianto', '089657206089', 'Abdi Negara Rancaekek Blok H4 No. 14 Rancaekek', 3204, 369, '40394', '1'),
(2, 2, 'Administrator', '089657206089', 'Bandung Kulons', 3273, 347, '11255', '1'),
(3, 3, 'Rega Dilla', '08123456', 'Dagoan 12345', 3273, 334, '44253', '1'),
(4, 5, 'Ari Yulianto', '089657206089', 'Abdi negara Rancaekek', 3204, 350, '40394', '1');