/*
Navicat MySQL Data Transfer

Source Server         : teste
Source Server Version : 50711
Source Host           : localhost:3306
Source Database       : poker

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

Date: 2017-03-07 01:55:57
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for casa
-- ----------------------------
DROP TABLE IF EXISTS `casa`;
CREATE TABLE `casa` (
  `loc_id` int(11) NOT NULL,
  `loc_nome` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`loc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of casa
-- ----------------------------
INSERT INTO `casa` VALUES ('1', 'Casa do Brenno');
INSERT INTO `casa` VALUES ('2', 'Casa do Geninho');
INSERT INTO `casa` VALUES ('3', 'Casa do Herik');
INSERT INTO `casa` VALUES ('4', 'Casa do Luciano');
INSERT INTO `casa` VALUES ('5', 'Casa do Françóis');

-- ----------------------------
-- Table structure for despesa
-- ----------------------------
DROP TABLE IF EXISTS `despesa`;
CREATE TABLE `despesa` (
  `des_id` int(11) NOT NULL,
  `des_nome` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `des_data` date NOT NULL,
  `des_valor` double(10,2) NOT NULL,
  `des_observacoes` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `des_status` varchar(10) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`des_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of despesa
-- ----------------------------
INSERT INTO `despesa` VALUES ('1', 'Baralhos', '2017-01-05', '160.00', '4 Baralhos Oficiais', 'Finalizada');
INSERT INTO `despesa` VALUES ('2', 'Mesa', '2017-02-08', '162.50', '1ª Parcela entra dia 10/03/2017 (Compra em 10 Parcelas)', 'Pendende');

-- ----------------------------
-- Table structure for mensalidade
-- ----------------------------
DROP TABLE IF EXISTS `mensalidade`;
CREATE TABLE `mensalidade` (
  `usu_id` int(11) NOT NULL,
  `men_valor` double(10,2) DEFAULT NULL,
  `men_referencia` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `men_dataPagamento` date DEFAULT NULL,
  `men_observacao` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `men_status` varchar(255) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`usu_id`,`men_referencia`),
  CONSTRAINT `mensalidade_ibfk_1` FOREIGN KEY (`usu_id`) REFERENCES `usuario` (`usu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of mensalidade
-- ----------------------------
INSERT INTO `mensalidade` VALUES ('2', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('2', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('3', '0.00', '01/2017', null, 'Comprou 1 mesa', 'Isento');
INSERT INTO `mensalidade` VALUES ('3', '0.00', '02/2017', null, 'Comprou 1 mesa', 'Isento');
INSERT INTO `mensalidade` VALUES ('4', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('4', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('5', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('5', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('6', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('6', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('7', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('7', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('8', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('8', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('9', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('9', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('10', '15.00', '01/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('10', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('11', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('11', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('12', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('12', '15.00', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('13', '7.50', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('13', '7.50', '02/2017', '2017-02-20', null, 'OK');
INSERT INTO `mensalidade` VALUES ('15', '15.00', '01/2017', '2017-01-10', null, 'OK');
INSERT INTO `mensalidade` VALUES ('15', '15.00', '02/2017', '2017-02-20', null, 'OK');

-- ----------------------------
-- Table structure for torneio
-- ----------------------------
DROP TABLE IF EXISTS `torneio`;
CREATE TABLE `torneio` (
  `tor_id` int(11) NOT NULL,
  `loc_id` int(11) DEFAULT NULL,
  `tor_data` date DEFAULT NULL,
  PRIMARY KEY (`tor_id`),
  KEY `loc_id` (`loc_id`),
  CONSTRAINT `torneio_ibfk_1` FOREIGN KEY (`loc_id`) REFERENCES `casa` (`loc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of torneio
-- ----------------------------
INSERT INTO `torneio` VALUES ('1', '1', '2016-03-01');
INSERT INTO `torneio` VALUES ('2', '2', '2016-03-15');
INSERT INTO `torneio` VALUES ('3', '1', '2016-03-29');
INSERT INTO `torneio` VALUES ('4', '2', '2016-04-05');
INSERT INTO `torneio` VALUES ('5', '4', '2016-04-19');
INSERT INTO `torneio` VALUES ('6', '1', '2016-05-03');
INSERT INTO `torneio` VALUES ('7', '3', '2016-05-17');
INSERT INTO `torneio` VALUES ('8', '1', '2016-05-31');
INSERT INTO `torneio` VALUES ('9', '2', '2016-06-14');
INSERT INTO `torneio` VALUES ('10', '1', '2016-06-28');
INSERT INTO `torneio` VALUES ('11', '1', '2016-07-13');
INSERT INTO `torneio` VALUES ('12', '5', '2016-07-27');
INSERT INTO `torneio` VALUES ('13', '2', '2016-08-09');
INSERT INTO `torneio` VALUES ('14', '3', '2016-08-23');
INSERT INTO `torneio` VALUES ('15', '1', '2016-09-06');
INSERT INTO `torneio` VALUES ('16', '4', '2016-09-20');
INSERT INTO `torneio` VALUES ('17', '1', '2016-10-04');
INSERT INTO `torneio` VALUES ('18', '2', '2016-10-18');
INSERT INTO `torneio` VALUES ('19', '4', '2016-11-01');
INSERT INTO `torneio` VALUES ('20', '1', '2016-11-15');
INSERT INTO `torneio` VALUES ('21', '2', '2016-11-29');
INSERT INTO `torneio` VALUES ('22', '2', '2016-12-13');
INSERT INTO `torneio` VALUES ('23', '1', '2016-12-27');
INSERT INTO `torneio` VALUES ('24', '1', '2017-01-10');
INSERT INTO `torneio` VALUES ('25', '2', '2017-01-24');
INSERT INTO `torneio` VALUES ('26', '2', '2017-02-07');
INSERT INTO `torneio` VALUES ('27', '2', '2017-02-20');
INSERT INTO `torneio` VALUES ('28', '2', '2017-03-06');

-- ----------------------------
-- Table structure for torneio_estatisticas
-- ----------------------------
DROP TABLE IF EXISTS `torneio_estatisticas`;
CREATE TABLE `torneio_estatisticas` (
  `tor_id` int(11) NOT NULL,
  `usu_id` int(11) NOT NULL,
  `torest_posicao` int(11) NOT NULL,
  `torest_pontos` int(11) DEFAULT NULL,
  `torest_titulo` int(11) DEFAULT NULL,
  `torest_premiacao` double(10,2) DEFAULT NULL,
  `torest_rebuy` int(11) DEFAULT NULL,
  `torest_buyinValor` double(10,2) DEFAULT NULL,
  `torest_rebuyValor` double(10,2) DEFAULT NULL,
  `torest_addon` int(11) DEFAULT NULL,
  `torest_addonValor` double(10,2) DEFAULT NULL,
  PRIMARY KEY (`usu_id`,`tor_id`),
  KEY `tor_id` (`tor_id`) USING BTREE,
  CONSTRAINT `torneio_estatisticas_ibfk_1` FOREIGN KEY (`usu_id`) REFERENCES `usuario` (`usu_id`),
  CONSTRAINT `torneio_estatisticas_ibfk_2` FOREIGN KEY (`tor_id`) REFERENCES `torneio` (`tor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of torneio_estatisticas
-- ----------------------------
INSERT INTO `torneio_estatisticas` VALUES ('1', '2', '3', '13', '0', '0.00', '0', '10.00', '0.00', '0', '0.00');
INSERT INTO `torneio_estatisticas` VALUES ('2', '2', '1', '25', '1', '50.00', null, '10.00', null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('3', '2', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('4', '2', '3', '13', null, '10.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('5', '2', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('6', '2', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('7', '2', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('8', '2', '3', '13', null, '10.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('9', '2', '1', '25', '1', '40.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('10', '2', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '2', '2', '18', null, '45.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '2', '3', '13', null, '32.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('13', '2', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('14', '2', '2', '18', null, '43.50', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '2', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '2', '8', '2', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('17', '2', '2', '18', null, '39.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '2', '2', '18', null, '60.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '2', '2', '18', null, '48.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '2', '1', '25', '1', '100.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '2', '2', '18', null, '63.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '2', '3', '13', null, '38.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '2', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '2', '9', '3', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '2', '11', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '2', '6', '6', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '2', '6', '6', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '2', '5', '10', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('1', '3', '1', '25', '1', '30.00', '0', '10.00', '0.00', '0', '0.00');
INSERT INTO `torneio_estatisticas` VALUES ('2', '3', '2', '18', null, '30.00', null, '10.00', null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('3', '3', '2', '18', null, '25.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('4', '3', '4', '10', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('5', '3', '3', '13', null, '10.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('6', '3', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('7', '3', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('8', '3', '1', '25', '1', '45.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('9', '3', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('10', '3', '2', '18', null, '25.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('13', '3', '4', '10', '0', null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('14', '3', '3', '13', null, '29.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '3', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '3', '6', '4', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '3', '3', '13', null, '32.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '3', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '3', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '3', '9', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '3', '8', '4', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '3', '3', '17', null, '60.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '3', '3', '17', null, '42.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '3', '12', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '3', '6', '6', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('1', '4', '5', '5', null, '0.00', '0', '10.00', '0.00', '0', '0.00');
INSERT INTO `torneio_estatisticas` VALUES ('2', '4', '8', '2', null, null, null, '10.00', null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('3', '4', '1', '25', '1', '45.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('4', '4', '6', '4', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('5', '4', '1', '25', '1', '45.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('6', '4', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('7', '4', '1', '25', '1', '60.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('8', '4', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('9', '4', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('10', '4', '1', '25', '1', '45.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '4', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '4', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('13', '4', '6', '4', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('14', '4', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '4', '9', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '4', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('17', '4', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '4', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '4', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '4', '10', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '4', '1', '25', '1', '105.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '4', '2', '18', null, '57.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '4', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '4', '1', '25', '1', '150.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '4', '12', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '4', '5', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '4', '13', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '4', '4', '13', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('1', '5', '2', '18', null, '20.00', '0', '10.00', '0.00', '0', '0.00');
INSERT INTO `torneio_estatisticas` VALUES ('2', '5', '3', '13', null, '10.00', null, '10.00', null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('3', '5', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('4', '5', '5', '5', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('5', '5', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('6', '5', '1', '25', '1', '45.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('7', '5', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('8', '5', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('9', '5', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('10', '5', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '5', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '5', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('13', '5', '2', '18', null, '39.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('14', '5', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '5', '3', '13', null, '30.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '5', '3', '13', null, '29.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('17', '5', '6', '4', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '5', '12', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '5', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '5', '3', '13', null, '42.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '5', '9', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '5', '13', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '5', '11', '1', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '5', '6', '6', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '5', '8', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '5', '9', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '5', '3', '17', null, '58.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('1', '6', '4', '10', null, '0.00', '0', '10.00', '0.00', '0', '0.00');
INSERT INTO `torneio_estatisticas` VALUES ('2', '6', '4', '10', null, null, null, '10.00', null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('3', '6', '3', '13', null, '10.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('4', '6', '1', '25', '1', '30.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('5', '6', '2', '18', null, '25.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('6', '6', '2', '18', null, '25.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('7', '6', '2', '18', null, '40.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('8', '6', '7', '3', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('9', '6', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('10', '6', '3', '13', null, '10.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '6', '3', '13', null, '30.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '6', '2', '18', null, '48.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '6', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '6', '5', '5', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('17', '6', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '6', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '6', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '6', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '6', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '6', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '6', '10', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '6', '4', '13', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '6', '13', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '6', '2', '20', null, '63.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '6', '2', '20', '0', '96.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '6', '10', '2', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('2', '7', '7', '3', null, null, null, '10.00', null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('3', '7', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('6', '7', '7', '3', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('7', '7', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('8', '7', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('10', '7', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '7', '1', '25', '1', '75.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '7', '1', '25', '1', '80.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('13', '7', '1', '25', '1', '65.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('14', '7', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '7', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '7', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('17', '7', '4', '10', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '7', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '7', '12', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '7', '10', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '7', '1', '25', '1', '95.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '7', '12', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '7', '10', '2', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '7', '10', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '7', '10', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '7', '12', '1', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('2', '8', '5', '5', null, null, null, '10.00', null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('3', '8', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('5', '8', '6', '4', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('6', '8', '3', '13', null, '10.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('7', '8', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('8', '8', '2', '18', null, '25.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('9', '8', '3', '13', null, '10.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('10', '8', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '8', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '8', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('13', '8', '7', '3', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('14', '8', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '8', '1', '25', '1', '75.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '8', '1', '25', '1', '72.50', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('17', '8', '1', '25', '1', '65.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '8', '3', '13', null, '40.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '8', '1', '25', '1', '80.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '8', '11', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '8', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '8', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '8', '14', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '8', '3', '17', '0', '60.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '8', '9', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '8', '4', '13', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '8', '8', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '8', '11', '1', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('2', '9', '9', '1', '0', '0.00', null, '10.00', null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('3', '9', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('5', '9', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('6', '9', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('7', '9', '3', '13', null, '20.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('8', '9', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('9', '9', '2', '18', null, '20.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('10', '9', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '9', '9', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '9', '9', '1', '0', '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('13', '9', '3', '13', null, '26.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('14', '9', '7', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '9', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '9', '2', '18', null, '42.50', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('17', '9', '3', '13', null, '26.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '9', '11', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '9', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '9', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '9', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '9', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '9', '11', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '9', '5', '10', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '9', '2', '20', null, '90.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '9', '1', '25', '1', '105.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '9', '3', '17', null, '64.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '9', '1', '25', '1', '116.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '10', '4', '10', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '10', '4', '10', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '10', '12', '1', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '10', '14', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '10', '11', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('15', '11', '2', '18', null, '45.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('17', '11', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '11', '1', '25', '1', '100.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '11', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '11', '9', '1', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '11', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '11', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '11', '6', '6', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '11', '8', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '11', '9', '3', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '11', '7', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '12', '5', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '12', '6', '4', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '12', '10', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '12', '9', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '12', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '12', '12', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '12', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '12', '7', '5', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '12', '7', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('26', '12', '7', '5', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '12', '14', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '12', '13', '1', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('11', '13', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('12', '13', '8', '2', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('13', '13', '8', '2', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('14', '13', '1', '25', '1', '72.50', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('16', '13', '9', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '13', '9', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('19', '13', '4', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '13', '11', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '13', '11', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '13', '2', '18', null, '120.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '13', '13', '1', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '13', '4', '13', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '13', '5', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '13', '8', '4', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('18', '14', '8', '2', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '14', '2', '18', null, '60.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '14', '13', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '14', '12', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '14', '1', '25', '1', '200.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '14', '1', '25', '1', '160.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '15', '3', '13', null, '40.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('21', '15', '8', '2', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('22', '15', '10', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '15', '3', '13', null, '80.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('24', '15', '2', '20', null, '90.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '15', '5', '10', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '15', '15', '1', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '15', '9', '3', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('2', '16', '6', '4', null, null, null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('4', '16', '2', '18', null, '20.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('5', '16', '8', '2', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '16', '9', '1', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('20', '17', '8', '2', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('23', '18', '15', '1', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('25', '19', '1', '25', '1', '150.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('27', '20', '4', '13', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '20', '7', '5', null, '0.00', null, null, null, null, null);
INSERT INTO `torneio_estatisticas` VALUES ('28', '21', '2', '20', null, '116.00', null, null, null, null, null);

-- ----------------------------
-- Table structure for usuario
-- ----------------------------
DROP TABLE IF EXISTS `usuario`;
CREATE TABLE `usuario` (
  `usu_id` int(11) NOT NULL,
  `usu_nome` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `usu_apelido` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `usu_dataFiliacao` date DEFAULT NULL,
  `usu_login` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `usu_senha` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`usu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- ----------------------------
-- Records of usuario
-- ----------------------------
INSERT INTO `usuario` VALUES ('1', 'Administrador', 'Administrador', '2017-01-12', 'admin', '123456');
INSERT INTO `usuario` VALUES ('2', 'Brenno', 'Brenno da Gama', '2016-01-01', 'brenno', '123456');
INSERT INTO `usuario` VALUES ('3', 'Luiz Eugenio', 'Geninho Neves', '2016-01-01', 'geninho', '123456');
INSERT INTO `usuario` VALUES ('4', 'Pedro', 'Pedro Bambam', '2016-01-01', 'pedro', '123456');
INSERT INTO `usuario` VALUES ('5', 'Herik', 'Herik Malafaia', '2016-01-01', 'herik', '123456');
INSERT INTO `usuario` VALUES ('6', 'Luciano', 'Luciano Cérvero', '2016-01-01', 'luciano', '123456');
INSERT INTO `usuario` VALUES ('7', 'Paulo', 'Paulo Maluf', '2016-01-01', 'paulo', '123456');
INSERT INTO `usuario` VALUES ('8', 'Eduardo', 'Eduardo Campos', '2016-01-01', 'eduardo', '123456');
INSERT INTO `usuario` VALUES ('9', 'Emersom', 'Emersom Cabaço', '2016-01-01', 'emersom', '123456');
INSERT INTO `usuario` VALUES ('10', 'Caio', 'Caio Manjula', '2017-01-01', 'caio', '123456');
INSERT INTO `usuario` VALUES ('11', 'Guilherme', 'Guilherme', '2017-01-01', 'guilherme', '123456');
INSERT INTO `usuario` VALUES ('12', 'Ian', 'Ian Kamikaze', '2017-01-01', 'ian', '123456');
INSERT INTO `usuario` VALUES ('13', 'Françóis', 'Françóis Rulssef', '2017-01-01', 'francois', '123456');
INSERT INTO `usuario` VALUES ('14', 'Márcio', 'Marcio Chiken', '2017-01-01', 'marcio', '123456');
INSERT INTO `usuario` VALUES ('15', 'Leo', 'Leo Thiaguinho', '2017-01-01', 'Leo', '123456');
INSERT INTO `usuario` VALUES ('16', 'Leonardo', 'Gigante Willys', '2017-01-01', 'Leonardo', '123456');
INSERT INTO `usuario` VALUES ('17', 'Felipe', 'Felipe', '2017-01-01', 'Felipe', '123456');
INSERT INTO `usuario` VALUES ('18', 'Amigo Guilherme', 'Amigo Guilherme', '2017-01-01', 'Amigo Guilherme', '123456');
INSERT INTO `usuario` VALUES ('19', 'Andre', 'Andre', '2017-01-01', 'Andre', '123456');
INSERT INTO `usuario` VALUES ('20', 'Ruan', 'Ruan', '2017-02-20', 'ruan', '123456');
INSERT INTO `usuario` VALUES ('21', 'Roger', 'Roger', '2017-03-06', 'roger', '123456');