-- phpMyAdmin SQL Dump
-- version 4.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2015 at 02:12 PM
-- Server version: 5.0.67-community-nt
-- PHP Version: 5.3.27

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: `perak_po2`
--

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

--
-- Table structure for table `t_user_draft`
--

DROP TABLE IF EXISTS `t_user_draft`;
CREATE TABLE `t_user_draft` (
  `usd_id` int(11) NOT NULL auto_increment COMMENT 'Unique ID',
  `usd_name` varchar(255) default NULL COMMENT 'User fullname',
  `usd_status` varchar(10) default NULL COMMENT 't_ref_pemohonan_status',
  `usd_email` varchar(32) default NULL COMMENT 'User email address',
  `usd_dun` varchar(10) default NULL COMMENT 'User dun from table t_ref_dun',
  `usd_no_kadpengenalan` varchar(30) default NULL,
  `usd_telefon_pejabat` varchar(30) default NULL,
  `usd_telefon_bimbit` varchar(30) default NULL,
  `usd_faks` varchar(30) default NULL,
  `usd_phone_office` varchar(20) default NULL COMMENT 'Office phone',
  `usd_phone_mobile` varchar(20) default NULL COMMENT 'Mobile phone',
  `usd_date_created` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Date & time record created.',
  `usd_date_modified` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Date & time record last modified.',
  `usd_userid_created` varchar(32) default NULL COMMENT 'UserID who creates the record, from t_user.usr_userid',
  `usd_userid_modified` varchar(32) default NULL COMMENT 'UserID who last modified the record, from t_user.usr_userid',
  PRIMARY KEY  (`usd_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='System users';

/*!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 */;
