CREATE DATABASE `bets`;

USE `bets`;

CREATE TABLE `bets` (
  `id` int(20) NOT NULL auto_increment,
  `sender` varchar(20) NOT NULL,
  `originalmsg` varchar(160) NOT NULL,
  `formatted_msg` varchar(160) NOT NULL,
  `match_number` int(5) NOT NULL,
  `team1` varchar(30) NOT NULL,
  `team2` varchar(20) NOT NULL,
  `time_of_bet` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `msgid` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
);


CREATE TABLE `matches` (
  `id` int(10) NOT NULL auto_increment,
  `match_number` varchar(10) NOT NULL,
  `match_begin` bigint(15) NOT NULL,
  `team1` varchar(30) NOT NULL,
  `team2` varchar(30) NOT NULL,
  `bet_begin` bigint(15) NOT NULL,
  `bet_end` bigint(15) NOT NULL,
  `final_result` varchar(40) NOT NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `settings` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(10) NOT NULL,
  `value` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
);


INSERT INTO `settings` VALUES (1, 'restrict', 1);