estructura

/*Table structure for table `account_type` */

DROP TABLE IF EXISTS `account_type`;

CREATE TABLE `account_type` (
  `type` VARCHAR(10) DEFAULT 'Base',
  `bonus` INT(2) DEFAULT '5'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `chat` */

DROP TABLE IF EXISTS `chat`;

CREATE TABLE `chat` (
  `chat_id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(15) NOT NULL,
  `message` VARCHAR(140) NOT NULL,
  `ip` VARCHAR(18) NOT NULL,
  `time` INT(11) NOT NULL,
  `delete` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`chat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `friends` */

DROP TABLE IF EXISTS `friends`;

CREATE TABLE `friends` (
  `friendID` INT(11) NOT NULL COMMENT 'Child',
  `userID` INT(11) DEFAULT NULL COMMENT 'Parent',
  `total` INT(11) DEFAULT '0',
  `cashed_month1` INT(1) DEFAULT '0',
  `cashed_month2` INT(1) DEFAULT '0',
  `cashed_month3` INT(1) DEFAULT '0',
  `cashed_month4` INT(1) DEFAULT '0',
  `cashed_month5` INT(1) DEFAULT '0',
  `cashed_month6` INT(1) DEFAULT '0',
  `cashed_month7` INT(1) DEFAULT '0',
  `cashed_month8` INT(1) DEFAULT '0',
  `cashed_month9` INT(1) DEFAULT '0',
  `cashed_month10` INT(1) DEFAULT '0',
  `cashed_month11` INT(1) DEFAULT '0',
  `cashed_month12` INT(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `login_attempts` */

DROP TABLE IF EXISTS `login_attempts`;

CREATE TABLE `login_attempts` (
  `user_id` INT(11) NOT NULL,
  `time` VARCHAR(50) NOT NULL,
  `login_time` VARCHAR(60) DEFAULT NULL,
  `access_address` VARCHAR(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Table structure for table `members` */

DROP TABLE IF EXISTS `members`;

CREATE TABLE `members` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `acc_type` VARCHAR(10) DEFAULT 'Base',
  `status` INT(1) DEFAULT '0',
  `username` VARCHAR(30),
  `email` VARCHAR(50),
  `facebook` VARCHAR(50) DEFAULT NULL,
  `password` CHAR(128) DEFAULT NULL,
  `salt` CHAR(128) DEFAULT NULL,
  `pwd_changed` INT(1) DEFAULT '0',
  `phone` VARCHAR(9),
  `mobile` VARCHAR(9),
  `zipcode` VARCHAR(5),
  `saddress` VARCHAR(60),
  `name` VARCHAR(60) DEFAULT NULL,
  `logotipo` VARCHAR(60) DEFAULT 'no-photo.png',
  `reg_time` VARCHAR(60) DEFAULT NULL,
  `last_updated` VARCHAR(60) DEFAULT '0000-00-00 00:00:00',
  `reg_ip` VARCHAR(45) DEFAULT NULL,
  `last_ip` VARCHAR(45) DEFAULT '0.0.0.0',
  `last_updated_ip` VARCHAR(45) DEFAULT '0.0.0.0',
  `month1` INT(1) DEFAULT '0',
  `month2` INT(1) DEFAULT '0',
  `month3` INT(1) DEFAULT '0',
  `month4` INT(1) DEFAULT '0',
  `month5` INT(1) DEFAULT '0',
  `month6` INT(1) DEFAULT '0',
  `month7` INT(1) DEFAULT '0',
  `month8` INT(1) DEFAULT '0',
  `month9` INT(1) DEFAULT '0',
  `month10` INT(1) DEFAULT '0',
  `month11` INT(1) DEFAULT '0',
  `month12` INT(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8;