 /*!40101 SET NAMES utf8mb4 */;
 
 --
--- Database: `atton`
+-- Database: `attack`
 --
 
 -- --------------------------------------------------------

-- --------------------------------------------------------

--
-- Table structure for table `dice`
--

CREATE TABLE `dice` (
  `id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `abbr` varchar(40) NOT NULL,
  `effect` text,
  `id_type` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dice`
--

INSERT INTO `dice` (`id`, `name`, `abbr`, `effect`, `id_type`) VALUES
(1, 'Landkampf', 'LK', 'infantry 1\r\nartillery 1\r\ntanks 1\r\naircraft 2\r\nmiss 1\r\n6sided die', 1),
(2, 'Leichte Gesch&uuml;tze', 'LG', '3 misses\r\n2 light\r\n1 heavy\r\n6 sided', 2),
(3, 'Flieger Staffeln', 'FS', '2 light\r\n2 heavy\r\n2 total\r\n6 sided', 2),
(4, 'Schwere Gesch&uuml;tze', 'SG', '2 misses\r\n2 light\r\n2 heavy\r\n6 sided', 2),
(5, 'Torpedos', 'T', '2 misses\r\n1 light\r\n2 heavy\r\n1 total\r\n6 sided', 2);

-- --------------------------------------------------------

--
-- Table structure for table `games`
--

CREATE TABLE `games` (
  `id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `id_game_mode` int(40) NOT NULL,
  `players` int(11) NOT NULL,
  `id_creator` int(11) NOT NULL,
  `password` varchar(40) DEFAULT NULL,

  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `z_moves`
--
ALTER TABLE `z_moves`
