-- https://www.phpmyadmin.net/
--




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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `title`, `description`, `modified`) VALUES
(2, 'My New Category', 'This is a temporary description for my new category', '2017-04-22 14:27:56'),
(3, 'Another Category', 'And another temporary desc', '2017-04-22 14:49:30');

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

--
-- Table structure for table `difficulty_levels`
--

CREATE TABLE `difficulty_levels` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `difficulty_levels`
--

INSERT INTO `difficulty_levels` (`id`, `title`, `modified`) VALUES
(1, 'Beginner', '2017-05-02 23:01:10');

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

--
-- Table structure for table `guides`
--

CREATE TABLE `guides` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text,
  `slug` varchar(255) DEFAULT NULL,
  `header_image` text,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `guides`
--

INSERT INTO `guides` (`id`, `title`, `content`, `slug`, `header_image`, `modified`) VALUES
(1, 'sadfasdfa', '<p>asdfasdfasdfttttttt</p>\r\n', 'asdfasdfasdf', 'project2.jpg', '2017-06-16 02:45:53');

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` text,
  `rare` tinyint(1) NOT NULL DEFAULT '1',
  `shop_buyable` tinyint(1) NOT NULL DEFAULT '1',
  `uses` text,
  `energy` text,
  `energy_regeneration` text,
  `lore` text,
  `notes` text,
  `credit` text,
  `category_id` int(11) NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `title`, `image`, `rare`, `shop_buyable`, `uses`, `energy`, `energy_regeneration`, `lore`, `notes`, `credit`, `category_id`, `modified`) VALUES
(2, 'Orange', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, '2017-04-22 15:00:07'),
(3, 'My new Item', 'im.jpg', 1, 1, 'asdasdf', 'asdfasdf', 'asdfasdf', 'asdfasdf', 'asdfasdf', 'asdfasdfas', 3, '2017-05-18 17:11:33'),
(4, 'VNBNB', 'save thing.png', 0, 0, 'VBNVNB', 'VNBVBNNVB', 'VBNNVB', 'VBNVNB', 'VBNBN', 'VBNVNB', 3, '2017-06-16 04:16:19');

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

--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `header_image` text,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `name`, `slug`, `header_image`, `modified`) VALUES
(2, 'My Location', 'My new Location Slug', 'Admin-Panel-Dashboard.jpg', '2017-06-16 01:55:42'),
(3, 'New location test', '<p>This is my slug</p>\r\n', 'admin-dashboard-panel-free-template-ui-psd-11.png', '2017-06-09 02:21:44');

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

--
-- Table structure for table `minigames`
--

CREATE TABLE `minigames` (
  `id` int(11) NOT NULL,
  `name` text,
  `image` varchar(500) DEFAULT NULL,
  `reward` text,
  `difficulty_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `removed` tinyint(1) NOT NULL DEFAULT '0',
  `credits` text,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `minigames`
--

INSERT INTO `minigames` (`id`, `name`, `image`, `reward`, `difficulty_id`, `location_id`, `category_id`, `description`, `removed`, `credits`, `modified`) VALUES
(5, 'My first minigame', '12992965_1159413194093184_2146338217_n.png', 'asdasd', 1, 2, 1, 'asdasd', 0, 'asdasdasd', '2017-05-24 16:19:13');

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

--
-- Table structure for table `minigame_types`
--

CREATE TABLE `minigame_types` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `minigame_types`
--

INSERT INTO `minigame_types` (`id`, `title`, `modified`) VALUES
(1, 'My first type', '2017-05-01 13:04:02'),
(2, 'Second type', '2017-05-01 13:18:52');

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

--
-- Table structure for table `monsters`
--

CREATE TABLE `monsters` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `attack_type` text,
  `location_id` int(11) NOT NULL,
  `difficulty_id` int(11) NOT NULL,
  `image` varchar(500) DEFAULT NULL,
  `characteristics` text,
  `drops` text,
  `weakness` text,
  `notes` text,
  `credits` text,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `monsters`
--

INSERT INTO `monsters` (`id`, `name`, `attack_type`, `location_id`, `difficulty_id`, `image`, `characteristics`, `drops`, `weakness`, `notes`, `credits`, `is_deleted`, `modified`) VALUES
(3, 'Koala', 'Default attack', 2, 1, '18052521_760388120788555_6161351_n.jpg', 'fdghfdgh', 'dfghdfg', 'dfghdfgh', 'dfghfdgh', 'fdghfgh', 1, '2017-05-04 12:53:40'),
(4, 'rrrr', 'rrrrr', 2, 1, '18072659_760388060788561_1984161970_n.jpg', 'rrrrr', 'rrrr', 'rrrr', 'rrrrr', 'rrrrrr', 0, '2017-05-04 12:00:25'),
(5, 'ytuityui', 'tyuityui', 2, 1, '18072659_760388060788561_1984161970_n.jpg', 'tyuiytui', 'tyuiytu', 'tyuiytu', 'ytuiytui', 'ytuyuiyui', 0, '2017-05-04 12:01:19');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `header_image` varchar(500) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `header_image`, `modified`) VALUES
(4, 'adfasdfasdf', 'asdfasdfasdf', '12992965_1159413194093184_2146338217_n.png', '2017-05-24 16:40:38');

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

--
-- Table structure for table `page_fields`
--

CREATE TABLE `page_fields` (
  `id` int(11) NOT NULL,
  `page_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `field_key` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `value` text NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_fields`
--

INSERT INTO `page_fields` (`id`, `page_id`, `name`, `field_key`, `type`, `value`, `modified`) VALUES
(1, 2, 'Title', 'title', 'text', '<p>Hey there</p>', '2017-05-18 15:18:48'),
(2, 2, 'Paragraph 1', 'paragraph_1', 'text', '<p>Here is my paragraph</p>', '2017-05-18 15:18:48'),
(4, 4, 'Title', 'title', NULL, '', '2017-06-09 01:52:20');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `title`, `modified`) VALUES
(1, 'Super Admin', '2017-05-18 15:47:22'),
(3, 'New role', '2017-05-18 15:53:00');

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

--
-- Table structure for table `shops`
--

CREATE TABLE `shops` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `location_id` int(11) NOT NULL,
  `shopkeeper` varchar(255) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shops`
--

INSERT INTO `shops` (`id`, `title`, `location_id`, `shopkeeper`, `modified`) VALUES
(1, 'First shop updated', 2, 'Ahmed', '2017-05-10 12:56:23');

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

--
-- Table structure for table `shop_items`
--

CREATE TABLE `shop_items` (
  `id` int(11) NOT NULL,
  `shop_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `price` varchar(50) NOT NULL DEFAULT '0',
  `qty` int(11) NOT NULL DEFAULT '0',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `shop_items`
--

INSERT INTO `shop_items` (`id`, `shop_id`, `item_id`, `price`, `qty`, `modified`) VALUES
(7, 1, 2, '25', 5, '2017-06-09 02:03:14');

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

--
-- Table structure for table `spells`
--

CREATE TABLE `spells` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `icon` varchar(500) DEFAULT NULL,
  `type` text,
  `year_id` int(11) DEFAULT NULL,
  `description` text,
  `lore` text,
  `cooldown` text,
  `duration` varchar(255) DEFAULT NULL,
  `cost` varchar(255) DEFAULT NULL,
  `spell_range` text,
  `price` varchar(255) DEFAULT NULL,
  `credits` text,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `spells`
--

INSERT INTO `spells` (`id`, `name`, `icon`, `type`, `year_id`, `description`, `lore`, `cooldown`, `duration`, `cost`, `spell_range`, `price`, `credits`, `modified`) VALUES
(1, 'My first spell', '214b07e1e4c19ad1c500ba022a4ad8cf.jpeg', 'adasd', 2, 'asdasd', 'asdasd', 'asdasd', 'asdad', 'asdasd', 'asdasd', 'adasdad', 'asdad', '2017-05-10 15:01:58');

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

--
-- Table structure for table `spell_years`
--

CREATE TABLE `spell_years` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `spell_years`
--

INSERT INTO `spell_years` (`id`, `title`, `modified`) VALUES
(2, 'Year 2', '2017-05-10 14:12:56'),
(3, 'Year 1', '2017-05-10 14:19:41'),
(4, 'Year 3', '2017-05-10 14:19:46'),
(5, 'Graduate', '2017-05-10 14:19:49');

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `difficulty_levels`
--
ALTER TABLE `difficulty_levels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `guides`
--
ALTER TABLE `guides`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `locations`
--
ALTER TABLE `locations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `minigames`
--
ALTER TABLE `minigames`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `minigame_types`
--
ALTER TABLE `minigame_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `monsters`
--
ALTER TABLE `monsters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `page_fields`
--
ALTER TABLE `page_fields`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `shops`
--
ALTER TABLE `shops`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `shop_items`
--
ALTER TABLE `shop_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `spells`
--
ALTER TABLE `spells`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `spell_years`
--
ALTER TABLE `spell_years`
  ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `difficulty_levels`
--
ALTER TABLE `difficulty_levels`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `guides`
--
ALTER TABLE `guides`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `locations`
--
ALTER TABLE `locations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `minigames`
--
ALTER TABLE `minigames`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `minigame_types`
--
ALTER TABLE `minigame_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `monsters`
--
ALTER TABLE `monsters`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `page_fields`
--
ALTER TABLE `page_fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `shops`
--
ALTER TABLE `shops`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `shop_items`
--
ALTER TABLE `shop_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `spells`
--
ALTER TABLE `spells`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `spell_years`
--
ALTER TABLE `spell_years`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
