-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 18, 2017 at 09:38 PM
-- Server version: 10.1.19-MariaDB
-- PHP Version: 7.0.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `serverside`
--

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

--
-- Table structure for table `codes`
--

CREATE TABLE `codes` (
  `CodeID` int(11) NOT NULL,
  `codeNumber` varchar(10) DEFAULT NULL,
  `ClearanceLevel` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `codes`
--

INSERT INTO `codes` (`CodeID`, `codeNumber`, `ClearanceLevel`) VALUES
(63, '8240168511', 1);

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `imageID` int(11) NOT NULL,
  `targetID` int(20) NOT NULL,
  `imageName` varchar(200) NOT NULL DEFAULT 'default.jpg'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`imageID`, `targetID`, `imageName`) VALUES
(1, 1, '5084104-john-wick-03.jpg'),
(5, 32, '880210-ss14fin.jpg'),
(27, 7, 'joker_1.jpg'),
(28, 7, '8622ae3e39fbb2b2ebf9afa6b12befa5.jpg'),
(29, 2, 'Bossk.png'),
(30, 3, 'terminator-52.jpg'),
(31, 3, 't-800-1024x592.jpg'),
(32, 4, 'Urdnot_Wrex.jpg'),
(33, 4, 'urdnot_wrex_07_by_johntesh-d4tcn73.jpg'),
(34, 47, '3c403e947b34e531982ee6616213738c.jpg'),
(35, 48, 'boba-fett-helmet1.jpg'),
(36, 48, '3050681-poster-p-2-boba-fett-trailer.jpg'),
(37, 47, 'thumb-1920-715968.jpg'),
(38, 50, 'photo_2017-04-18_10-38-40.jpg'),
(39, 52, '0cfff10ea92df345e629f3ba81941839.png'),
(40, 52, '9937b8448104ee0f1239cf7cf30bc029.jpg'),
(41, 53, 'doom.jpg'),
(42, 53, 'dr-doom.jpg');

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `tagID` int(11) NOT NULL,
  `targetID` int(11) NOT NULL,
  `tagText` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`tagID`, `targetID`, `tagText`) VALUES
(2, 32, 'Murderer'),
(4, 1, 'Murderer'),
(5, 12, 'Thief'),
(8, 12, 'Stalker'),
(9, 47, 'Assassin'),
(10, 47, 'Hitman'),
(11, 3, 'Robot'),
(12, 2, 'Bounty Hunter'),
(13, 7, 'Murderer'),
(14, 7, 'Sociopath'),
(15, 1, 'Hitman'),
(16, 47, 'Murderer'),
(17, 48, 'Bounty Hunter'),
(18, 52, 'Murderer'),
(21, 52, 'Magical'),
(22, 53, 'Magical'),
(23, 53, 'Genius');

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

--
-- Table structure for table `targets`
--

CREATE TABLE `targets` (
  `TargetID` int(20) NOT NULL,
  `FirstName` varchar(30) NOT NULL DEFAULT 'Unknown',
  `LastName` varchar(30) NOT NULL DEFAULT 'Unknown',
  `Nickname` varchar(50) DEFAULT NULL,
  `ThreatLevel` int(1) NOT NULL DEFAULT '0',
  `LastKnownLocation` varchar(100) NOT NULL DEFAULT 'Unknown',
  `ForensicData` varchar(4) NOT NULL DEFAULT 'None',
  `Height` varchar(7) NOT NULL DEFAULT 'Unknown',
  `HairColour` varchar(10) NOT NULL DEFAULT 'Unknown',
  `EyeColour` varchar(10) NOT NULL DEFAULT 'Unknown',
  `Description` varchar(10000) NOT NULL DEFAULT 'No description provided',
  `LastUpdated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `targets`
--

INSERT INTO `targets` (`TargetID`, `FirstName`, `LastName`, `Nickname`, `ThreatLevel`, `LastKnownLocation`, `ForensicData`, `Height`, `HairColour`, `EyeColour`, `Description`, `LastUpdated`) VALUES
(1, 'John', 'Wick', 'Baba Yaga', 6, 'Unknown', 'None', '', 'Black', 'Brown', 'No description provided', '2017-04-17 18:25:59'),
(2, 'Bossk', 'Unknown', 'None', 6, 'Unknown', 'None', '', 'None', 'Orange', 'No description provided', '2017-04-17 18:23:00'),
(3, 'Unknown', 'Unknown', 'T-800', 8, 'Unknown', 'None', '', 'Brown', 'Blue/Red', 'No description provided', '2017-04-17 18:22:50'),
(4, 'Urdnot', 'Wrex', 'None', 7, 'Unknown', 'Some', '', 'None', 'Red', 'No description provided', '2017-04-17 18:15:55'),
(6, 'Terry', 'Ortega', 'None', 1, '7-11', 'All', 'Unknown', 'Unknown', 'Unknown', 'No description provided', '2017-03-22 22:10:44'),
(7, 'Unknown', 'Unknown', 'Joker', 5, 'Gotham, NJ', 'None', '', 'Green', 'Green', 'No description provided', '2017-04-17 18:25:41'),
(8, 'Bob', 'Fredrock', 'The Destroyer', 9, '7-11', 'All', '0.4m', 'Orange', 'Red', 'No description provided', '2017-03-27 19:09:56'),
(11, 'Bob', 'Fredrock', 'The Devestator', 9, '7-11', 'All', '0.4m', 'Orange', 'Red', 'No description provided', '2017-04-04 19:03:33'),
(12, 'Bob', 'Underwood', 'Xander', 7, 'Here', 'All', '', 'Red', 'Orange', 'No description provided', '2017-04-17 18:00:45'),
(32, 'Unknown', 'Unknown', 'Bane', 7, 'Gothan, NJ', 'Some', '2.03m', 'Brown', 'Brown', 'No description provided', '2017-04-17 15:30:49'),
(47, 'Unknown', 'Unknown', 'Agent 47', 7, 'Unknown', 'None', '', 'None', 'Blue', 'No description provided', '2017-04-17 18:32:36'),
(48, 'Boba', 'Fett', 'None', 7, 'Unknown', 'Some', '', 'Black', 'Brown', 'No description provided', '2017-04-18 10:09:03'),
(50, 'Michael', 'Loewen', 'None', 3, 'Red River College', 'Some', '1.70m', 'Brown', 'Brown', 'Needs no introduction', '2017-04-18 11:22:46'),
(52, 'Loki', 'Laufeyson', 'None', 8, 'Unknown', 'None', 'Unknown', 'Black', 'Green', '<p>Many years ago, when Bor, ruler of Asgard, was battling frost giants, he followed a wounded giant to a powerful sorcerer that was waiting for him. The sorcerer caught him unaware, turning Bor into snow. Bor&#39;s son, Odin, found his father as he was blowing away; Bor begged Odin to find a sorcerer to free him, but Odin made no attempt to save his father. Bor cursed Odin saying that he would take in the son of a fallen king and raise it as his own. Not a week later, Odin himself led the Asgardians into battle against the Frost Giants and killed Laufey, who was the King, in personal combat. After slaying Laufey, Odin found a small Asgardian-sized child hidden within the primary stronghold of the Frost Giants. The child was Loki and Laufey had kept him hidden from his people due to his shame over his son&#39;s small size. Odin took the boy, out of a combination of pity, to appease his father, and because he was the son of a worthy adversary slain in honorable combat, and raised him as his son alongside his biological son Thor.[9] Throughout their childhood and into adolescence, Loki was resentful of the differences in which he and Thor were treated by the citizens of Asgard. The Asgardians valued great strength, tenacity, and bravery in battle above all things, and Loki was clearly inferior to his foster brother Thor in those areas. What he lacked in size and strength, however, he made up for in power and skill, particularly as a sorcerer. As Loki grew to adulthood, his natural talent for causing mischief would make itself manifest and earned him a nickname as the &quot;God of Lies and Mischief&quot;; his mischievousness eventually became malice as his hunger for power and revenge grew stronger. Several times he tried to use tricks to get rid of Thor, like telling him to guard a hole in the wall he had made. In time, his reputation grew from being a playful and mischievous trickster to the &quot;God of Evil&quot;. Over the centuries, Loki attempted on many occasions to seize rulership of Asgard and to destroy Thor. He even helped the Storm giant Ghan to escape Thor planning to get a debt from him later, and aided other enemies of Asgard, planning to take over. Odin, who had grown weary of Loki&#39;s mischief, magically imprisoned him within a tree until someone would shed a tear for him. Loki eventually freed himself by causing a leaf to strike Heimdall, the guardian of Bifrost, in the eye, which made him shed a tear. Loki compiled an extensive criminal record in Asgard, and was frequently exiled.[10] He met the Sorcerer Eldred, who taught him black magic. He repaid Eldred by later giving him to the Fire demon Surtur.</p>', '2017-04-18 14:08:52'),
(53, 'Victor', 'von Doom', 'Dr. Doom', 8, 'Unknown', 'Some', '', 'Brown', 'Brown', 'Victor Von Doom was born decades ago to a tribe of Latverian Romani people under the rule of an unnamed nobleman called the Baron. Victor&#039;s mother was witch Cynthia Von Doom who died by Mephisto&#039;s hand while Von Doom was young. His father, Werner, was the leader of the tribe and a renowned medicine man who kept his wife&#039;s sorceress life quiet in order to protect Victor from a similar fate. Soon after Cynthia&#039;s death, the Baron&#039;s wife grew incurably ill from cancer and Werner was called to the capitol to heal her. When she succumbed to illness, the Baron labeled Werner a murderer and called for his death. Werner escaped with young Victor, having realized the night before the woman would die. He goes on to die of exposure on the mountainside, cradling the boy in a final embrace and giving him his garments to keep him warm. Victor survived and, on return to the Romani camp, discovered his mother&#039;s occult instruments and swore revenge on the Baron. Victor grew into a headstrong and brilliant man, combining sorcery and technology to create fantastic devices which would keep the Baron&#039;s men at bay and protect the Roma people. His exploits attracted the attention of the dean of Empire State University, who sent someone to the camp.[40] Offered the chance to study in the United States, Von Doom chooses to leave his homeland and his love, Valeria, behind.  Once in the United States, Victor met fellow student and future nemesis Reed Richards, who was intended to be his roommate, but Von Doom disliked him and asked for another roommate. After a time, Victor constructed a machine intended to communicate with the dead. Though Richards tried to warn him about a flaw in the machine, seeing his calculations were a few decimals off, Victor continued on with disastrous results. The machine violently failed and the resulting explosion seemingly severely damaged his face.[40] It is later revealed that Ben Grimm, a friend of Richards who despised Victor for his superior attitude, tampered with the machine. He would later blame himself for Doctor Doom&#039;s eventual rise to power, but never revealed this information to anyone.[41] Expelled after the accident, Victor traveled the world until he collapsed on a Tibetan mountainside. Rescued by a clan of monks, Victor quickly mastered the monks&#039; disciplines as well as the monks themselves. Victor then forged himself a suit of armor, complete with a scowling mask, and took the name Doctor Doom.[40] As Doctor Doom, he would go on to menace those he felt responsible for his accident&mdash;primarily, Reed Richards of the Fantastic Four. He succeeded in taking over Latveria, taking an interest in the welfare of the Roma.', '2017-04-18 11:16:49');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `UserID` int(20) NOT NULL,
  `Username` varchar(30) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `Clearance` int(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`UserID`, `Username`, `Password`, `Email`, `Clearance`) VALUES
(23, 'admin', '$2a$10$FAphG4GJ5MURrRB3Z09tTO/O8REPyaj1M.efGaqAV1rlK02WxQDgy', 'admin@gmail.com', 5),
(26, 'scrub', '$2a$10$AFFa/a6sAg0n91K.uu7.kO7ICzwWX.tky0TkJGPE5BxE14M6TbnNe', 'scrub@gmail.com', 1),
(27, 'editor', '$2a$10$693WLhd6su7JmViNVrv1wuy4CSGxtPQwfoxdouAtkCiR/DAtO2W72', 'editor@gmail.com', 2),
(28, 'creator', '$2a$10$UkRJ1/2drM3AgrJ44ga2HuzN00vQ8.IqYxDj1Otsc37e5iXzbYtyK', 'creator@gmail.com', 3),
(29, 'deleter', '$2a$10$Yt3zYuy/EJWo3vddaleqLea./ZxsR6QmLpSndffNO1UAuTJMnCyZC', 'deleter@gmail.com', 4),
(30, 'TestUser', '$2a$10$EArm4f3X4wgrMk7U4H2/PuWs79i.BMsGyhsoPdiA/Z9EfOgS1aM/q', 's@no.com', 5);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `codes`
--
ALTER TABLE `codes`
  ADD PRIMARY KEY (`CodeID`);

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`imageID`),
  ADD KEY `targetID` (`targetID`);

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`tagID`);

--
-- Indexes for table `targets`
--
ALTER TABLE `targets`
  ADD PRIMARY KEY (`TargetID`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`UserID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `codes`
--
ALTER TABLE `codes`
  MODIFY `CodeID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `imageID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
  MODIFY `tagID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `targets`
--
ALTER TABLE `targets`
  MODIFY `TargetID` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `UserID` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `images`
--
ALTER TABLE `images`
  ADD CONSTRAINT `targetID_Constraint` FOREIGN KEY (`targetID`) REFERENCES `targets` (`TargetID`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;