/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50141
Source Host           : localhost:3306
Source Database       : chopdb

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

Date: 2010-08-30 16:00:45
*/

-- ----------------------------
-- Table structure for `bans`
-- ----------------------------
CREATE TABLE `bans` (
  `habboid` int(10) NOT NULL,
  `ip` varchar(40) NOT NULL,
  `message` varchar(50) NOT NULL,
  `expires` varchar(10) NOT NULL,
  PRIMARY KEY (`habboid`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of bans
-- ----------------------------

-- ----------------------------
-- Table structure for `habbos`
-- ----------------------------
CREATE TABLE `habbos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL,
  `figure` varchar(30) NOT NULL,
  `poolfigure` varchar(30) NOT NULL,
  `gender` char(1) NOT NULL,
  `motto` varchar(25) NOT NULL,
  `mail` varchar(40) NOT NULL,
  `birth` varchar(10) NOT NULL,
  `password` varchar(10) NOT NULL,
  `credits` int(7) NOT NULL,
  `tickets` int(7) NOT NULL,
  `films` int(7) NOT NULL,
  PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of habbos
-- ----------------------------
INSERT INTO `habbos` VALUES ('1', 'AWA', '1050119001280013000121501', '', 'M', 'Project Chop!', 'a@a.com', '01.01.1990', 'audun1', '1000', '0', '0');
