-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 07, 2013 at 01:17 AM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.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 utf8 */;

--
-- Database: `profiler`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` varchar(1) NOT NULL,
  `admin` varchar(40) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `admin` (`id`, `admin`, `password`) VALUES
('1', 'admin', '8ed358a7da3cc760364909d4aaf7321e');

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

--
-- Table structure for table `analytics`
--

CREATE TABLE IF NOT EXISTS `analytics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` int(20) NOT NULL,
  `datetime` int(11) NOT NULL,
  `browser` varchar(255) NOT NULL,
  `browser_version` varchar(10) NOT NULL,
  `day` int(2) NOT NULL,
  `month` int(2) NOT NULL,
  `year` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `message_id` int(12) NOT NULL AUTO_INCREMENT,
  `message_sender_name` varchar(255) NOT NULL,
  `message_sender_email` varchar(255) NOT NULL,
  `message_title` varchar(255) NOT NULL,
  `message_content` text NOT NULL,
  `message_datetime` int(12) NOT NULL,
  `message_readed` int(1) NOT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE IF NOT EXISTS `portfolio` (
  `work_id` int(12) NOT NULL AUTO_INCREMENT,
  `work_title` varchar(255) NOT NULL,
  `work_details` text NOT NULL,
  `work_url` varchar(255) NOT NULL,
  `work_thumbnail` varchar(255) NOT NULL,
  `work_category_id` varchar(255) NOT NULL,
  PRIMARY KEY (`work_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `portfolio_categories`
--

CREATE TABLE IF NOT EXISTS `portfolio_categories` (
  `category_id` int(12) NOT NULL AUTO_INCREMENT,
  `category_title` varchar(100) NOT NULL,
  `category_order` int(12) NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `setting`
--

CREATE TABLE IF NOT EXISTS `setting` (
  `id` int(1) NOT NULL,
  `social_networks` text NOT NULL,
  `general_setting` text NOT NULL,
  `avatar_image` varchar(255) NOT NULL,
  `banner_image` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `social_networks`, `general_setting`, `avatar_image`, `banner_image`) VALUES
(1, 'a:15:{s:7:"blogger";s:29:"http://profiler.blogspot.com/";s:10:"deviantart";s:0:"";s:4:"digg";s:0:"";s:8:"dribbble";s:0:"";s:8:"facebook";s:32:"http://www.facebook.com/profiler";s:6:"flickr";s:0:"";s:11:"google_plus";s:0:"";s:8:"linkedin";s:0:"";s:8:"mobileme";s:0:"";s:6:"tumblr";s:0:"";s:7:"twitter";s:27:"http://twitter.com/profiler";s:5:"vimeo";s:0:"";s:9:"wordpress";s:0:"";s:7:"youtube";s:36:"http://www.youtube.com/user/profiler";s:6:"submit";s:12:"Save Setting";}', 'a:22:{s:10:"script_url";s:37:"";s:10:"site_title";s:8:"profiler";s:16:"site_description";s:68:"profiler is a script that help you build your online cv and profile ";s:17:"site_keywords_old";s:0:"";s:13:"site_keywords";s:15:"profiler,script";s:13:"profile_title";s:7:"PlusCSS";s:13:"profile_about";s:38:"web-developer and php geek";s:19:"contact_information";s:83:"Aleppo, Syria\r\n21st street\r\nluhamu Building\r\ntel : +96611223344\r\nfax : +96611223344";s:16:"send_mail_method";s:1:"0";s:9:"smtp_host";s:0:"";s:9:"smtp_port";s:0:"";s:13:"smtp_username";s:0:"";s:13:"smtp_password";s:0:"";s:11:"sender_mail";s:23:"test@test.com";s:13:"site_template";s:7:"default";s:12:"blog_rss_url";s:28:"http://www.pluscss.com/feed/";s:17:"blog_posts_number";s:2:"10";s:14:"envato_api_key";s:32:"";s:15:"envato_username";s:7:"pluscss";s:19:"envato_items_number";s:2:"10";s:10:"copyrights";s:13:"Profiler v1.0";s:6:"submit";s:12:"Save Setting";}', '61191375145908.jpg', '86271375316553.png');

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

--
-- Table structure for table `skills`
--

CREATE TABLE IF NOT EXISTS `skills` (
  `skill_id` int(12) NOT NULL AUTO_INCREMENT,
  `skill_title` varchar(100) NOT NULL,
  `skill_range` int(3) NOT NULL,
  PRIMARY KEY (`skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `slider_id` int(12) NOT NULL AUTO_INCREMENT,
  `slider_title` varchar(255) NOT NULL,
  `slider_url` varchar(255) NOT NULL,
  `slider_thumbnail` varchar(255) NOT NULL,
  `slider_order` int(12) NOT NULL,
  PRIMARY KEY (`slider_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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