Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.7.7
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost:3306
- -- Generation Time: 15 фев 2018 в 19:49
- -- Версия на сървъра: 10.1.31-MariaDB
- -- PHP Version: 5.6.30
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- 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: `eliteser_2`
- --
- -- --------------------------------------------------------
- --
- -- Структура на таблица `banners`
- --
- CREATE TABLE `banners` (
- `id` int(11) NOT NULL,
- `img` text NOT NULL,
- `url` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Схема на данните от таблица `banners`
- --
- INSERT INTO `banners` (`id`, `img`, `url`) VALUES
- (10, 'https://i.imgur.com/ZkUwoWO.png', 'http://amxx-bg.info');
- -- --------------------------------------------------------
- --
- -- Структура на таблица `ips`
- --
- CREATE TABLE `ips` (
- `id_vapros` int(12) NOT NULL,
- `ip` varchar(30) NOT NULL,
- `timestamp` int(15) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Схема на данните от таблица `ips`
- --
- INSERT INTO `ips` (`id_vapros`, `ip`, `timestamp`) VALUES
- (2, '87.120.124.41', 0),
- (2, '95.87.223.162', 0),
- (2, '87.247.251.187', 0),
- (2, '176.12.50.138', 0),
- (2, '213.91.131.56', 0),
- (2, '94.139.208.114', 0),
- (2, '87.120.1.202', 0),
- (2, '93.93.14.129', 0),
- (2, '130.204.210.177', 0),
- (2, '46.65.108.25', 0),
- (2, '84.54.154.29', 0),
- (2, '78.90.3.157', 0),
- (2, '78.40.139.6', 0),
- (2, '77.85.228.196', 0),
- (2, '93.93.14.164', 0),
- (2, '93.155.129.165', 0),
- (2, '84.54.154.246', 0),
- (2, '83.222.183.215', 0),
- (2, '84.40.119.240', 0),
- (2, '84.40.106.153', 0),
- (2, '84.201.193.207', 0),
- (2, '109.199.242.193', 0),
- (2, '78.90.200.203', 0),
- (2, '93.152.150.154', 0),
- (2, '78.90.232.108', 0),
- (2, '77.85.214.4', 0);
- -- --------------------------------------------------------
- --
- -- Структура на таблица `news`
- --
- CREATE TABLE `news` (
- `id` int(11) NOT NULL,
- `title` longtext CHARACTER SET utf8 NOT NULL,
- `new` longtext CHARACTER SET utf8 NOT NULL,
- `author` longtext CHARACTER SET utf8 NOT NULL,
- `date` varchar(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Схема на данните от таблица `news`
- --
- INSERT INTO `news` (`id`, `title`, `new`, `author`, `date`) VALUES
- (8, 'Нова система', 'яж ми кура,лека', 'Shady', '02.15.18 / 04:51');
- -- --------------------------------------------------------
- --
- -- Структура на таблица `otgovori`
- --
- CREATE TABLE `otgovori` (
- `id` int(12) NOT NULL,
- `id_vapros` int(12) NOT NULL,
- `otgovor` varchar(255) CHARACTER SET utf8 NOT NULL,
- `broi` int(5) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Схема на данните от таблица `otgovori`
- --
- INSERT INTO `otgovori` (`id`, `id_vapros`, `otgovor`, `broi`) VALUES
- (5, 3, 'Да', 0),
- (6, 3, 'ами да', 0);
- -- --------------------------------------------------------
- --
- -- Структура на таблица `shoutbox`
- --
- CREATE TABLE `shoutbox` (
- `id` int(11) NOT NULL,
- `chat` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `avtor` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `user_id` int(11) NOT NULL,
- `user_group` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
- `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
- --
- -- Схема на данните от таблица `shoutbox`
- --
- INSERT INTO `shoutbox` (`id`, `chat`, `avtor`, `user_id`, `user_group`, `date`, `ip`) VALUES
- (1855, 'Вече сме с нова система (beer)', 'Warsong', 0, '5', '16.Mar.2013 в 9:10 pm', '87.120.124.41'),
- (1856, 'Добро утро :)', 'Admin', 0, '5', '17.Mar.2013 в 8:22 am', '87.247.251.187'),
- (1857, 'Здравеите (Welcome)', 'Lsd', 0, '2', '17.Mar.2013 в 1:34 pm', '82.137.96.71'),
- (1858, 'Здравеи :)', 'Admin', 0, '5', '17.Mar.2013 в 1:42 pm', '87.247.251.187'),
- (1859, 'Здравей!', 'caNdy', 0, '2', '17.Mar.2013 в 8:38 pm', '130.204.210.177'),
- (1860, 'Сайта е хубав!', 'caNdy', 0, '2', '17.Mar.2013 в 8:38 pm', '130.204.210.177'),
- (1861, 'Нали :)', 'Warsong', 0, '5', '17.Mar.2013 в 8:45 pm', '87.120.124.41'),
- (1862, 'Мс :)', 'Admin', 0, '5', '18.Mar.2013 в 5:36 pm', '87.247.251.187'),
- (1863, 'unikalen e :) ', 'Sadface', 0, '2', '18.Mar.2013 в 7:45 pm', '109.199.242.193'),
- (1864, 'Пиши на кирилица !!!!!', 'Admin', 0, '5', '18.Mar.2013 в 7:51 pm', '87.247.251.187'),
- (1865, '233 посещения! Браво на нас (beer)', 'Warsong', 0, '5', '18.Mar.2013 в 11:17 pm', '87.120.124.41'),
- (1866, 'Само аз ли немога да вляза във форума ? ', 'caNdy', 0, '2', '19.Mar.2013 в 7:26 pm', '130.204.210.177'),
- (1867, ':)', 'caNdy', 0, '2', '19.Mar.2013 в 7:26 pm', '130.204.210.177'),
- (1868, 'Майче да ', 'Admin', 0, '5', '19.Mar.2013 в 7:26 pm', '87.247.251.187'),
- (1869, '\r\nТова ми пише:Forbidden\r\n\r\nYou don\\\'t have permission', 'caNdy', 0, '2', '19.Mar.2013 в 7:30 pm', '130.204.210.177'),
- (1870, 'CaNd, проблема е оправен!', 'Warsong', 0, '5', '19.Mar.2013 в 7:39 pm', '87.120.124.41'),
- (1871, 'Пак не ме пуска :D', 'caNdy', 0, '2', '19.Mar.2013 в 7:41 pm', '130.204.210.177'),
- (1872, 'Да, сега мисля, че те пуска (oops)', 'Warsong', 0, '5', '19.Mar.2013 в 7:51 pm', '87.120.124.41'),
- (1873, 'Да вече ме пуска. Благодаря!', 'caNdy', 0, '2', '19.Mar.2013 в 7:53 pm', '130.204.210.177'),
- (1874, 'Да дам ли ник и парола? ', 'caNdy', 0, '4', '20.Mar.2013 в 2:35 pm', '130.204.210.177'),
- (1875, 'Дай скайп :)', 'Admin', 0, '5', '20.Mar.2013 в 4:15 pm', '87.247.251.187'),
- (1876, 'bobsan_992', 'caNdy', 0, '4', '20.Mar.2013 в 4:24 pm', '130.204.210.177'),
- (1877, 'ок', 'Admin', 0, '5', '20.Mar.2013 в 7:33 pm', '87.247.251.187');
- -- --------------------------------------------------------
- --
- -- Структура на таблица `sitebanners`
- --
- CREATE TABLE `sitebanners` (
- `id` int(11) NOT NULL,
- `img` longtext CHARACTER SET utf8 NOT NULL,
- `url` longtext CHARACTER SET utf8 NOT NULL,
- `size` longtext CHARACTER SET utf8 NOT NULL,
- `author` longtext CHARACTER SET utf8 NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Структура на таблица `team`
- --
- CREATE TABLE `team` (
- `id` int(11) NOT NULL,
- `name` longtext CHARACTER SET utf8 NOT NULL,
- `post` longtext CHARACTER SET utf8 NOT NULL,
- `skype` longtext CHARACTER SET utf8 NOT NULL,
- `nick` longtext CHARACTER SET utf8 NOT NULL,
- `date` longtext CHARACTER SET utf8 NOT NULL,
- `img` longtext CHARACTER SET utf8 NOT NULL,
- `city` longtext CHARACTER SET utf8 NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Схема на данните от таблица `team`
- --
- INSERT INTO `team` (`id`, `name`, `post`, `skype`, `nick`, `date`, `img`, `city`) VALUES
- (4, 'Тайна', 'Администратор', 'vip_game_vip', 'Smok3Pot', '', 'http://eliteserv.info/forum/download/file.php?avatar=2_1518494427.jpg', '');
- -- --------------------------------------------------------
- --
- -- Структура на таблица `vaprosi`
- --
- CREATE TABLE `vaprosi` (
- `id` int(12) NOT NULL,
- `vapros` varchar(255) CHARACTER SET utf8 NOT NULL,
- `br_otgovori` int(5) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Схема на данните от таблица `vaprosi`
- --
- INSERT INTO `vaprosi` (`id`, `vapros`, `br_otgovori`) VALUES
- (3, 'Гей ли си', 0);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `banners`
- --
- ALTER TABLE `banners`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `news`
- --
- ALTER TABLE `news`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `otgovori`
- --
- ALTER TABLE `otgovori`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `shoutbox`
- --
- ALTER TABLE `shoutbox`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `sitebanners`
- --
- ALTER TABLE `sitebanners`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `team`
- --
- ALTER TABLE `team`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `vaprosi`
- --
- ALTER TABLE `vaprosi`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `banners`
- --
- ALTER TABLE `banners`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
- --
- -- AUTO_INCREMENT for table `news`
- --
- ALTER TABLE `news`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
- --
- -- AUTO_INCREMENT for table `otgovori`
- --
- ALTER TABLE `otgovori`
- MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
- --
- -- AUTO_INCREMENT for table `shoutbox`
- --
- ALTER TABLE `shoutbox`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1878;
- --
- -- AUTO_INCREMENT for table `sitebanners`
- --
- ALTER TABLE `sitebanners`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
- --
- -- AUTO_INCREMENT for table `team`
- --
- ALTER TABLE `team`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `vaprosi`
- --
- ALTER TABLE `vaprosi`
- MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
- COMMIT;
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement