-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 06, 2015 at 05:51 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `violet-viettel`
--

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

--
-- Table structure for table `tblcollaborator`
--

CREATE TABLE IF NOT EXISTS `tblcollaborator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(45) NOT NULL,
  `login_name` varchar(45) NOT NULL,
  `cellphone` varchar(15) NOT NULL,
  `passwd` varchar(65) NOT NULL,
  `activated` tinyint(4) NOT NULL DEFAULT '1',
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  `author` int(11) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `district` varchar(15) NOT NULL,
  `email` varchar(255) NOT NULL,
  `precinct` varchar(15) NOT NULL,
  `province` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20536706 ;

--
-- Dumping data for table `tblcollaborator`
--

INSERT INTO `tblcollaborator` (`id`, `full_name`, `login_name`, `cellphone`, `passwd`, `activated`, `created_time`, `updated_time`, `author`, `address`, `code`, `district`, `email`, `precinct`, `province`) VALUES
(1, 'Truong Hoang Anh', '0982124899', '0982124899', '', 1, NULL, NULL, NULL, '', '', '', '', '', ''),
(2, 'Namta', '01689925260', '01689925260', 'c4ca4238a0b923820dcc509a6f75849b', 1, '2014-11-19 10:21:15', '2014-11-19 10:21:15', NULL, '', '', '', '', '', ''),
(5, 'dungnv', '0988568786', '0988568786', 'c4ca4238a0b923820dcc509a6f75849b', 1, '2014-11-19 18:45:27', '2014-11-19 18:45:27', NULL, '', '', '', '', '', ''),
(20513478, 'V? Th? Luy?n', '', '', '', 1, NULL, '2015-01-06 11:49:31', NULL, 'S? nh� null ???ng Null Khu?i Thu?m Huy?n T?ng B?c K?n B?c K?n', '1000004001_00001_CTVTMDT', '001', '', '004', 'B281'),
(20519414, 'Ho�ng C�ng Minh', '', '0983532981', '', 1, NULL, '2015-01-06 11:49:32', NULL, 'S? nh� 186 ???ng Nguy?n Th? Minh Khai T? 8 Nguy?n Th? Minh Khai B?c K?n B?c K?n', '1000004001_00003_CTVTMDT', '001', '', '004', 'B281'),
(20536705, 'Chu ?�nh Anh', '', '962143096', '', 1, NULL, '2015-01-06 11:49:32', NULL, 'S? nh� 01 ???ng 01  ??c Xu�n B?c K?n B?c K?n', '1000004001_00002_GPKHDN', '001', '', '004', 'B281');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;