member

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 16, 2014 at 05:28 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `huawei`
--

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

--
-- Table structure for table `member`
--

CREATE TABLE `member` (
  `UserID` int(3) unsigned zerofill NOT NULL auto_increment,
  `Username` varchar(20) NOT NULL,
  `Password` varchar(20) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Type` varchar(10) NOT NULL,
  `LoginCount` int(2) NOT NULL default '0',
  `FlagLock` enum('Yes','No') NOT NULL default 'No',
  `BanExpire` datetime NOT NULL,
  PRIMARY KEY  (`UserID`),
  UNIQUE KEY `Username` (`Username`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `member`
--

INSERT INTO `member` VALUES (001, 'king', 'king', 'Channarong Krongyat', 'Admin', 1, 'No', '2014-04-16 17:30:52');
INSERT INTO `member` VALUES (002, 'testuser', 'testuser', 'name surname', 'User', 0, 'No', '0000-00-00 00:00:00');