-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 28, 2013 at 10:24 PM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `telmanik_press`
--

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

--
-- Table structure for table `content`
--

CREATE TABLE IF NOT EXISTS `content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `block_content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `page_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `date_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `content`
--

INSERT INTO `content` (`id`, `title`, `block_content`, `page_name`, `date_time`) VALUES
(14, 'Welcome', '<pre id="line1" style="text-align: center;">\r\n<strong><span style="font-size:28px;">\r\nTelmanik CMS Press is in 10 different languages.\r\n\r\n<span style="font-family: verdana,geneva,sans-serif;">Welcome! </span></span></strong></pre>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="ar"><span class="hps">Ø£Ù‡Ù„Ø§ ÙˆØ³Ù‡Ù„Ø§!</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="bn"><span class="hps">à¦¸à§à¦¬à¦¾à¦—à¦¤à¦®!</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="zh-CN"><span>æ¬¢è¿Žï¼</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="de"><span class="hps">Herzlich Willkommen!</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="es"><span class="hps">&iexcl;Bienvenido!</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="hi"><span class="hps">à¤†à¤ªà¤•à¤¾ à¤¸à¥à¤µà¤¾à¤—à¤¤ à¤¹à¥ˆ!</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="ja"><span>ã‚ˆã†ã“ãï¼</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="pt"><span class="hps">Bem-vindo!</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:28px;"><span class="short_text" id="result_box" lang="ru"><span class="hps">Ð”Ð¾Ð±Ñ€Ð¾ Ð¿Ð¾Ð¶Ð°Ð»Ð¾Ð²Ð°Ñ‚ÑŒ!</span></span></span></strong></p>\r\n<p style="text-align: center;">\r\n	&nbsp;</p>\r\n<p>\r\n	&nbsp;</p>\r\n<p style="text-align: center;">\r\n	<strong><span style="font-size:26px;"><span style="font-family:verdana,geneva,sans-serif;">you are on the homepage.</span></span></strong></p>\r\n', 'Home', '0000-00-00 00:00:00');

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

--
-- Table structure for table `gallerys`
--

CREATE TABLE IF NOT EXISTS `gallerys` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `gallery_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `gallerys`
--

INSERT INTO `gallerys` (`id`, `gallery_name`) VALUES
(7, 'my first gallery');

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

--
-- Table structure for table `info`
--

CREATE TABLE IF NOT EXISTS `info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state_provence` varchar(255) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `open_hours` varchar(255) DEFAULT NULL,
  `other_info_footer` text,
  `website` varchar(255) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `info`
--

INSERT INTO `info` (`id`, `address`, `address2`, `city`, `state_provence`, `zipcode`, `country`, `open_hours`, `other_info_footer`, `website`, `company`) VALUES
(1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Built by Telmanik Technologies', 'http://localhost/telmanik_press', 'River Mountain Default Theme');

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

--
-- Table structure for table `logo`
--

CREATE TABLE IF NOT EXISTS `logo` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `image_name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `logo`
--

INSERT INTO `logo` (`id`, `image_name`, `title`, `description`) VALUES
(1, 'river_mountain_logo.png', 'Default Theme by Telmanik Technologies', 'Default Theme by Telmanik Technologies');

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

--
-- Table structure for table `members`
--

CREATE TABLE IF NOT EXISTS `members` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `level` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `name`, `username`, `password`, `email`, `level`) VALUES
(1, 'person111', 'admin', 'admin', 'youremail@example.com', 'administrator');

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

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

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `page_name` varchar(255) NOT NULL,
  `page_title` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

INSERT INTO `pages` (`id`, `page_name`, `page_title`) VALUES
(1, 'Home', 'Yoursite.com - River Mountain Theme Designed by Telmanik'),
(2, 'About', 'About - Tennessee Default Theme');

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

--
-- Table structure for table `photos`
--

CREATE TABLE IF NOT EXISTS `photos` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `gallery` varchar(255) NOT NULL,
  `image_name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` (`id`, `gallery`, `image_name`, `title`, `description`) VALUES
(21, 'my first gallery', 'telmanik_cms_press_baby_limousin_cow.jpg', 'baby limousin cow', 'baby limousin cow'),
(19, 'my first gallery', 'telmanik_cms_press_gas_can.jpg', 'Plastic Gas Can', 'Plastic Gas Can'),
(20, 'my first gallery', 'telmanik_cms_press_pontiac_gto.jpg', 'pontiac gto', 'pontiac gto');

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

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

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `gallery_selected` varchar(255) NOT NULL,
  `enable_disable` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `gallery_selected`, `enable_disable`) VALUES
(1, 'my first gallery', '1');

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

--
-- Table structure for table `theme`
--

CREATE TABLE IF NOT EXISTS `theme` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `theme` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `theme`
--

INSERT INTO `theme` (`id`, `theme`) VALUES
(1, 'RiverMountain');
