/*
BloonOldSchool database by Burak
MySQL Data Transfer
Source Host: localhost
Source Database: bloonoldschool
Target Host: localhost
Target Database: bloonoldschool
Date: 01/04/2012 21:32:45
*/

-- ----------------------------
-- Table structure for rooms
-- ----------------------------
CREATE TABLE `rooms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('public','private') NOT NULL DEFAULT 'private',
  `name` text NOT NULL,
  `description` text NOT NULL,
  `ownerid` int(11) NOT NULL,
  `maxuser` int(11) NOT NULL,
  `score` int(11) NOT NULL,
  `userin` int(11) NOT NULL,
  `rights` text NOT NULL,
  `showname` int(11) NOT NULL,
  `paper` int(11) NOT NULL,
  `floor` int(11) NOT NULL,
  `model` text NOT NULL,
  `opentype` enum('open','closed','password') NOT NULL DEFAULT 'open',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for users
-- ----------------------------
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `pass` text NOT NULL,
  `email` text NOT NULL,
  `ip_last` text NOT NULL,
  `rank` text NOT NULL,
  `mission` text NOT NULL,
  `sso_ticket` text NOT NULL,
  `figure` text NOT NULL,
  `rooms` int(11) NOT NULL,
  `app` bigint(32) NOT NULL,
  `badges` text NOT NULL,
  `badgeonoff` text NOT NULL,
  `birth` text NOT NULL,
  `sex` text NOT NULL,
  `lastonline` text NOT NULL,
  `tickets` int(11) NOT NULL,
  `num` int(11) NOT NULL,
  `hand` text NOT NULL,
  `curbadge` text NOT NULL,
  `transactions` text NOT NULL,
  `roomlist` text NOT NULL,
  `showexpire` int(11) NOT NULL,
  `credits` bigint(11) NOT NULL,
  `consolemission` text NOT NULL,
  `periods` bigint(11) NOT NULL,
  `favourites` text NOT NULL,
  `film` int(11) NOT NULL,
  `friendlist` int(11) NOT NULL,
  `hcdays` int(11) NOT NULL,
  `inquiries` text NOT NULL,
  `hcupdate` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `rooms` VALUES ('1', 'private', 'Test', 'testtest', '1', '25', '10', '20', ';', '1', '0', '0', 'model_a', 'password');
INSERT INTO `rooms` VALUES ('2', 'private', 'test2', 'testt', '1', '30', '15', '15', ';', '1', '0', '0', 'mode_a', 'closed');
INSERT INTO `users` VALUES ('1', 'Burak', 'lolifun', 'test@test.te', '127.0.0.1', '7', 'Bloon', 'test', 'ch=s02/53,51,44', '0', '0', '', '', '', 'M', '', '0', '0', '', '', '', '', '0', '5000', 'BloonConsole', '0', '', '0', '0', '0', '', '');
