Ragebooter.net SQL dump

-- Database: `ragebooter_main`
--

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

--
-- Table structure for table `media`
--

CREATE TABLE IF NOT EXISTS `media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `media` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `media`) VALUES
(3, 'contact-img.png');

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

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

CREATE TABLE IF NOT EXISTS `pages` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_title` varchar(100) NOT NULL,
  `p_slug` varchar(100) NOT NULL,
  `p_summery` text NOT NULL,
  `p_content` text NOT NULL,
  `p_type` varchar(100) NOT NULL,
  `p_image` varchar(100) NOT NULL,
  `p_parent` int(11) NOT NULL,
  `time` varchar(50) NOT NULL,
  `u_id` int(11) NOT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

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

INSERT INTO `pages` (`p_id`, `p_title`, `p_slug`, `p_summery`, `p_content`, `p_type`, `p_image`, `p_parent`, `time`, `u_id`) VALUES
(11, 'abc', '', '', '', 'page', '', -1, '1364208568', 1),
(12, 'abc-1', '', '', '', 'page', '', -1, '1364208572', 1),
(13, 'ddddddd', '', '', '', 'page', '', -1, '1364211188', 1),
(14, 'this is your ip', '', '', '', 'page', '', -1, '1364211195', 1),
(15, 'are you there', 'are-you-there', '', '', 'page', '', -1, '1364211222', 1),
(16, 'are you there', 'are-you-there-2', '', '', 'page', '', -1, '1364211236', 1),
(17, 'this is your ip', '5', '', '', 'page', '', -1, '1364212029', 1),
(18, 'this is your ip', ', 'This is your ip', '<p>This is your ip</p>\r\n', 'page', '', -1, '1364213951', 1),
(19, '', '', '', '', 'page', '', -1, '1364276288', 1);

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

--
-- Table structure for table `porfolio`
--

CREATE TABLE IF NOT EXISTS `porfolio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `skills` varchar(150) NOT NULL,
  `work_complete` varchar(150) NOT NULL,
  `url` varchar(150) NOT NULL,
  `image` varchar(150) NOT NULL,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `porfolio`
--

INSERT INTO `porfolio` (`id`, `title`, `skills`, `work_complete`, `url`, `image`, `type`) VALUES
(3, 'Front End Development', 'html / CSS / JQuery', 'March 2010', 'http://www.ragebooter.net/', 'offer_img_12.jpg', 'portfolio'),
(4, 'Logo', 'Adobe Photoshop', 'March 2010', 'http://www.ragebooter.net/', 'logo.gif', 'Logo');

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

--
-- Table structure for table `tracking`
--

CREATE TABLE IF NOT EXISTS `tracking` (
  `session_id` int(11) NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(50) NOT NULL,
  `user_agent` varchar(150) NOT NULL,
  `last_activity` varchar(150) NOT NULL,
  `user_data` varchar(150) NOT NULL,
  PRIMARY KEY (`session_id`),
  KEY `session_id` (`session_id`),
  KEY `session_id_2` (`session_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2147483647 ;

--
-- Dumping data for table `tracking`
--

INSERT INTO `tracking` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
(0, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', '1364279719', 'a:5:{s:9:"user_data";s:0:"";s:9:"admin_uid";s:1:"1";s:10:"admin_name";s:5:"admin";s:10:"admin_role";s:5:"admin";s:9:"logged_in";b:1;}'),
(1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', '1364275991', 'a:5:{s:9:"user_data";s:0:"";s:9:"admin_uid";s:1:"1";s:10:"admin_name";s:5:"admin";s:10:"admin_role";s:5:"admin";s:9:"logged_in";b:1;}'),
(2, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', '1364276251', ''),
(3, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', '1364283455', 'a:5:{s:9:"user_data";s:0:"";s:9:"admin_uid";s:1:"1";s:10:"admin_name";s:5:"admin";s:10:"admin_role";s:5:"admin";s:9:"logged_in";b:1;}'),
(67299089, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', '1364276251', 'a:5:{s:9:"user_data";s:0:"";s:9:"admin_uid";s:1:"1";s:10:"admin_name";s:5:"admin";s:10:"admin_role";s:5:"admin";s:9:"logged_in";b:1;}'),
(67299090, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', '1364276522', ''),
(67299091, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', '1364289514', ''),
(2147483647, '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0', '1364277050', 'a:5:{s:9:"user_data";s:0:"";s:9:"admin_uid";s:1:"1";s:10:"admin_name";s:5:"admin";s:10:"admin_role";s:5:"admin";s:9:"logged_in";b:1;}');

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `u_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_name` varchar(150) NOT NULL,
  `u_fname` varchar(150) NOT NULL,
  `username` varchar(150) NOT NULL,
  `u_pass` varchar(150) NOT NULL,
  `u_email` varchar(150) NOT NULL,
  `u_role` varchar(50) NOT NULL,
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`u_id`, `u_name`, `u_fname`, `username`, `u_pass`, `u_email`, `u_role`) VALUES
(1, 'admin', 'admin', 'admin', '53511p267i50a5a343894e0e4a801fcb', 'Justin@ragebooter.net', 'admin');

/*!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 */;