File: C:/xampp/htdocs/G7CMYK/registered_users.sql
/*
MySQL Data Transfer
Source Host: localhost
Source Database: psamember
Target Host: localhost
Target Database: psamember
Date: 2015/9/11 �W�� 12:57:53
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- 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');