/*
Navicat MySQL Data Transfer

Source Server         : datebase
Source Server Version : 50133
Source Host           : localhost:3306
Source Database       : website

Target Server Type    : MYSQL
Target Server Version : 50133
File Encoding         : 65001

Date: 2010-11-11 20:43:38
*/

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
CREATE TABLE `users` (
  `user_id` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `password` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `password_md5` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `name` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `secondname` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `skype` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `email` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `mgroup` int(5) NOT NULL DEFAULT '1',
  `avatar` varchar(250) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `country` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `about_me` varchar(250) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `signature` varchar(500) COLLATE utf8_bin NOT NULL DEFAULT 'N/A',
  `nick` varchar(25) COLLATE utf8_bin NOT NULL,
  `reg_date` varchar(25) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO users VALUES ('1', 'heartless', 'x2y5v3', '589800a4b2ca19fb687dad8384dc17a6', 'N/A', 'N/A', 'N/A', 'dem0nman@live.ru', '1', 'N/A', 'N/A', 'N/A', 'N/A', 'Heartless', '1289499134');
