-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Czas wygenerowania: 10 Gru 2013, 17:46
-- Wersja serwera: 5.5.27
-- Wersja PHP: 5.4.7

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

--
-- Baza danych: `scms`
--

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

--
-- Struktura tabeli dla tabeli `adverts`
--

CREATE TABLE IF NOT EXISTS `adverts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `text` text NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

--
-- Zrzut danych tabeli `adverts`
--

INSERT INTO `adverts` (`id`, `title`, `text`, `active`) VALUES
(1, 'Home page - top', '&lt;p&gt;INSERT HTML/JAVASCRIPT CODE HERE&lt;/p&gt;', 0),
(2, 'Home page - right', '&lt;p&gt;INSERT HTML/JAVASCRIPT CODE HERE&lt;/p&gt;', 0);

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

--
-- Struktura tabeli dla tabeli `boxes`
--

CREATE TABLE IF NOT EXISTS `boxes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order` int(10) unsigned DEFAULT NULL,
  `title` text NOT NULL,
  `text` text NOT NULL,
  `static` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

--
-- Zrzut danych tabeli `boxes`
--

INSERT INTO `boxes` (`id`, `order`, `title`, `text`, `static`) VALUES
(14, 14, 'DOWNLOAD TEST', '&lt;p style=&quot;text-align: center;&quot;&gt;Download test tells you how fast you can get data (files, movies, music) from the Internet. The result is shown in Mbps (megabits per second).&lt;/p&gt;\r\n', 1),
(15, 15, 'UPLOAD TEST', '&lt;p style=&quot;text-align: center;&quot;&gt;Upload test tells you how fast you can send data (files, movies, music) to the Internet. The result is shown in Mbps (megabits per second).&lt;br&gt;&lt;/p&gt;\r\n', 1),
(16, 16, 'IP ADDRESS', '&lt;p style=&quot;text-align: center;&quot;&gt;IP Address is the server or client Internet address for a communication. There are local IP addresses and public IP addresses. The public IPs are unique.&lt;br&gt;&lt;/p&gt;\r\n', 1),
(17, 17, 'GET or UPGRADE', '&lt;p style=&quot;text-align: center;&quot;&gt;Do you want to get the Speed Test website or upgrade to the new functions? Visit Cloud Speed Test site on &lt;a href=&quot;https://www.v-speed.eu&quot;&gt;https://www.v-speed.eu&lt;/a&gt;&lt;br&gt;&lt;/p&gt;\r\n', 1);

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

--
-- Struktura tabeli dla tabeli `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `user` varchar(256) NOT NULL,
  `pass` varchar(256) NOT NULL,
  `perpage` int(10) unsigned NOT NULL DEFAULT '10',
  `title` varchar(256) DEFAULT NULL,
  `description` varchar(256) DEFAULT NULL,
  `keywords` varchar(256) DEFAULT NULL,
  `maxw` int(10) unsigned NOT NULL DEFAULT '800',
  `maxh` int(10) unsigned NOT NULL DEFAULT '600',
  `quality` int(10) unsigned NOT NULL DEFAULT '97',
  `maxhm` int(10) unsigned NOT NULL DEFAULT '100',
  `qualitym` int(10) unsigned NOT NULL DEFAULT '97',
  `maximgsize` int(10) unsigned NOT NULL DEFAULT '8',
  `maxfilesize` int(10) unsigned NOT NULL DEFAULT '8',
  `control` tinyint(1) DEFAULT '1',
  `slogan` text NOT NULL,
  `template` varchar(255) NOT NULL DEFAULT 'blue'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Zrzut danych tabeli `config`
--

INSERT INTO `config` (`user`, `pass`, `perpage`, `title`, `description`, `keywords`, `maxw`, `maxh`, `quality`, `maxhm`, `qualitym`, `maximgsize`, `maxfilesize`, `control`, `slogan`, `template`) VALUES
('admin', '2360796e4ba6fb2d2de890bda93f9a57', 50, 'Cloud Speed Test', 'The Cloud Speed Test - check your Internet speed and quality', 'speed test', 800, 600, 97, 100, 97, 8, 8, 1, '&lt;p style=&quot;text-align: center;&quot;&gt;IS YOUR INTERNET SPEED AS GOOD AS YOU PAY FOR?&lt;/p&gt;&lt;p style=&quot;text-align: center;&quot;&gt;&lt;span class=&quot;color&quot;&gt;&lt;b&gt;CHECK IT WITH OUR SPEED TEST!&lt;/b&gt;&lt;/span&gt;&lt;/p&gt;\r\n', 'blue');

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

--
-- Struktura tabeli dla tabeli `download`
--

CREATE TABLE IF NOT EXISTS `download` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order` int(10) unsigned DEFAULT NULL,
  `static` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- Zrzut danych tabeli `download`
--

INSERT INTO `download` (`id`, `order`, `static`, `name`) VALUES
(5, 5, 1, 'Redactor - files');

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

--
-- Struktura tabeli dla tabeli `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `download` int(10) unsigned NOT NULL,
  `order` int(10) unsigned DEFAULT NULL,
  `filename` varchar(64) NOT NULL,
  `filetitle` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

--
-- Struktura tabeli dla tabeli `galleries`
--

CREATE TABLE IF NOT EXISTS `galleries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order` int(10) unsigned DEFAULT NULL,
  `static` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- Zrzut danych tabeli `galleries`
--

INSERT INTO `galleries` (`id`, `order`, `static`, `name`) VALUES
(5, 5, 1, 'Redactor - images');

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

--
-- Struktura tabeli dla tabeli `images`
--

CREATE TABLE IF NOT EXISTS `images` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gallery` int(10) unsigned NOT NULL,
  `order` int(10) unsigned DEFAULT NULL,
  `filename` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

--
-- Struktura tabeli dla tabeli `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order` int(10) unsigned DEFAULT NULL,
  `static` tinyint(1) NOT NULL DEFAULT '0',
  `title` text NOT NULL,
  `description` varchar(256) DEFAULT NULL,
  `keywords` varchar(256) DEFAULT NULL,
  `text` text NOT NULL,
  `link` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

--
-- Zrzut danych tabeli `pages`
--

INSERT INTO `pages` (`id`, `order`, `static`, `title`, `description`, `keywords`, `text`, `link`) VALUES
(14, 14, 0, 'Speed Test', 'Why measure the Internet Speed?', '', '&lt;p&gt;You can modify the content of this article and/or add new articles in the Admin Panel available at /admin.&lt;br&gt;&lt;/p&gt;', 'speed_test'),
(15, 15, 0, 'About us', 'Learn about our company', '', '&lt;p&gt;You can modify the content of this article and/or add new articles in the Admin Panel available at /admin.&lt;/p&gt;', 'about_us'),
(18, 18, 0, 'Contact us', '', '', '&lt;p&gt;You can modify the content of this article and/or add new articles in the Admin Panel available at /admin.&lt;br&gt;&lt;/p&gt;', 'contact_us');

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