/*
MySQL Data Transfer
Source Host: localhost
Source Database: psamember
Target Host: localhost
Target Database: psamember
Date: 2015/9/11 �W�� 12:56:58
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for psajob
-- ----------------------------
CREATE TABLE `psajob` (
  `id` int(11) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `press` varchar(255) DEFAULT NULL,
  `ink` varchar(255) DEFAULT NULL,
  `paper` varchar(255) DEFAULT NULL,
  `target` varchar(255) DEFAULT NULL,
  `mod` varchar(255) DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for registered_users
-- ----------------------------
CREATE TABLE `registered_users` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(55) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'Inactive',
  `ldate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `registered_users` VALUES ('8', 'FredKuo', 'Fred', 'kuo', 'e10adc3949ba59abbe56e057f20f883e', '[email protected]', '', 'active', null);
INSERT INTO `registered_users` VALUES ('7', 'FredKuo', 'Fred', 'Kuo', 'e10adc3949ba59abbe56e057f20f883e', '[email protected]', '', 'active', '2015-08-20 01:11:51');