Файл: Database SQL/SQL.sql
Строк: 362
-- phpMyAdmin SQL Dump
-- version 4.0.10.7
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 07,
2015 at 05:03 PM
-- Server version: 5.5.40-cll
-- PHP Version: 5.4.23
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: `andreyst_points4`
--
--
--------------------------------------------------------
--
-- Table
structure for table `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE
utf8_unicode_ci NOT NULL,
`avatar` varchar(255) COLLATE utf8_unicode_ci
NOT NULL,
`password` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`mail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=2 ;
--
-- Dumping data for table `admin`
--
INSERT INTO
`admin` (`id`, `name`, `avatar`, `password`, `mail`) VALUES
(1, 'admin',
'http://andreyst.eu/ban2/admin/img/avatar.png',
'21232f297a57a5a743894a0e4a801fc3', 'admin@abv.bg');
--
--------------------------------------------------------
--
-- Table
structure for table `chesto_zadavani_vaprosi`
--
CREATE TABLE IF NOT
EXISTS `chesto_zadavani_vaprosi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vapros` text NOT NULL,
`pital` varchar(255) NOT NULL,
`otgovor` text
NOT NULL,
`otnosno` varchar(255) NOT NULL,
`date` varchar(255) NOT
NULL,
`active` varchar(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `chzv`
--
CREATE TABLE IF NOT EXISTS `chzv` (
`id`
int(255) NOT NULL AUTO_INCREMENT,
`ip` varchar(255) NOT NULL,
`time`
int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `gifts_images`
--
CREATE TABLE IF NOT EXISTS
`gifts_images` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`icon`
varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=latin1 AUTO_INCREMENT=22 ;
--
-- Dumping data for table
`gifts_images`
--
INSERT INTO `gifts_images` (`id`, `icon`) VALUES
(1,
'uploads/games/gift/1.png'),
(2, 'uploads/games/gift/2.png'),
(3,
'uploads/games/gift/3.png'),
(4, 'uploads/games/gift/4.png'),
(5,
'uploads/games/gift/5.png'),
(6, 'uploads/games/gift/6.png'),
(7,
'uploads/games/gift/7.png'),
(8, 'uploads/games/gift/8.png'),
(9,
'uploads/games/gift/9.png'),
(10, 'uploads/games/gift/10.png'),
--
--------------------------------------------------------
--
-- Table
structure for table `messages`
--
CREATE TABLE IF NOT EXISTS `messages` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`forw` varchar(20) NOT NULL,
`fromw` varchar(20) NOT NULL,
`title` varchar(255) NOT NULL,
`message`
text NOT NULL,
`time` int(255) NOT NULL,
`ip` varchar(50) NOT NULL,
`readed` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `otgovori`
--
CREATE TABLE IF NOT EXISTS `otgovori` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`v_id` int(10) NOT NULL DEFAULT
'0',
`otgovor` tinytext,
`veren` int(10) DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `pages`
--
CREATE TABLE IF NOT EXISTS `pages` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`content` text NOT NULL,
`title`
varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=57 ;
--
-- Dumping data for table
`pages`
--
INSERT INTO `pages` (`id`, `content`, `title`) VALUES
(54,
'<p>rbrtbrtbrtbrbt</p>\r\n',
'rbrtbrtbtrbt'),
(55, '<p><strong>Lorem
Ipsum</strong> is simply dummy text of the printing and
typesetting industry. Lorem Ipsum has been the industry&#39;s
standard dummy text ever since the 1500s, when an unknown printer took a
galley of type and scrambled it to make a type specimen book. It has
survived not only five centuries, but also the leap into electronic
typesetting, remaining essentially unchanged. It was popularised in the
1960s with the release of Letraset sheets containing Lorem Ipsum passages,
and more recently with desktop publishing software like Aldus PageMaker
including versions of Lorem Ipsum.</p>\r\n', 'welcome'),
(56,
'<table class="blue"
style="width:100%">\r\n <thead>\r\n <tr>\r\n <th>\r\n <p
style="text-align: left;"><span
style="color:#FFFFFF"><span
style="background-color:#256193">Text</span></span></p>\r\n </th>\r\n <th>\r\n <p
style="text-align: left;"><span
style="color:#FFFFFF"><span
style="background-color:#256193">Number</span></span></p>\r\n </th>\r\n <th>\r\n <p
style="text-align: left;"><span
style="color:#FFFFFF"><span
style="background-color:#256193">Price</span></span></p>\r\n </th>\r\n <th>\r\n <p
style="text-align: left;"><span
style="color:#FFFFFF"><span
style="background-color:#256193">Points</span></span></p>\r\n </th>\r\n </tr>\r\n </thead>\r\n <tbody>\r\n <tr>\r\n <td><strong>&nbsp;
winget
{username}</strong></td>\r\n <td>\r\n <p><strong>1985</strong></p>\r\n </td>\r\n <td>\r\n <p>3.00
EUR</p>\r\n </td>\r\n <td>\r\n <p><strong>899</strong></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td><strong>&nbsp;
winget
{username}</strong></td>\r\n <td>\r\n <p><strong>1978</strong></p>\r\n </td>\r\n <td>\r\n <p>2.40
EUR</p>\r\n </td>\r\n <td>\r\n <p><strong>444</strong></p>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td><strong>&nbsp;
winget
{username}</strong></td>\r\n <td>\r\n <p><strong>1935</strong></p>\r\n </td>\r\n <td>\r\n <p>1.20
EUR</p>\r\n </td>\r\n <td>\r\n <p><strong>222</strong></p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n',
'smspoints');
--
--------------------------------------------------------
--
-- Table
structure for table `podaraci`
--
CREATE TABLE IF NOT EXISTS `podaraci` (
`uid` int(255) NOT NULL,
`points` int(255) NOT NULL,
`time` int(255)
NOT NULL,
`timef` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `sa_users`
--
CREATE TABLE IF NOT EXISTS `sa_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT
NULL,
`password` varchar(50) DEFAULT NULL,
`email` varchar(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_awarded`
--
CREATE TABLE IF NOT EXISTS
`vn_awarded` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(255)
NOT NULL,
`prizeid` int(255) NOT NULL,
`f_name` varchar(20) CHARACTER
SET utf8 NOT NULL,
`m_name` varchar(20) CHARACTER SET utf8 NOT NULL,
`l_name` varchar(20) CHARACTER SET utf8 NOT NULL,
`phone` varchar(20)
CHARACTER SET utf8 NOT NULL,
`postcode` varchar(20) NOT NULL,
`city`
text CHARACTER SET utf8 NOT NULL,
`obstina` text CHARACTER SET utf8 NOT
NULL,
`oblast` text CHARACTER SET utf8 NOT NULL,
`address` text
CHARACTER SET utf8 NOT NULL,
`ip` varchar(50) NOT NULL,
`date` int(255)
NOT NULL,
`dok` mediumtext CHARACTER SET utf8 NOT NULL,
`status`
int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_blocked`
--
CREATE TABLE IF NOT EXISTS
`vn_blocked` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid` int(255)
NOT NULL,
`reason` varchar(255) NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
-- Table
structure for table `vn_changeemail`
--
CREATE TABLE IF NOT EXISTS
`vn_changeemail` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid`
int(255) NOT NULL,
`oldemail` varchar(40) NOT NULL,
`newemail`
varchar(40) NOT NULL,
`time` int(255) NOT NULL,
`ip` varchar(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_changepassword`
--
CREATE TABLE IF NOT EXISTS
`vn_changepassword` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid`
int(255) NOT NULL,
`oldpassword` varchar(255) NOT NULL,
`newpassword`
varchar(255) NOT NULL,
`time` int(255) NOT NULL,
`ip` varchar(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_gold`
--
CREATE TABLE IF NOT EXISTS `vn_gold` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid` int(255) NOT NULL,
`timeon` bigint(255) NOT NULL,
`timeoff` bigint(255) NOT NULL,
`times`
int(255) NOT NULL,
`status` int(2) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_lostpassword`
--
CREATE TABLE IF NOT EXISTS
`vn_lostpassword` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user`
varchar(20) NOT NULL,
`email` varchar(40) NOT NULL,
`oldpass`
varchar(255) NOT NULL,
`ip` varchar(50) NOT NULL,
`time` int(255) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_messages`
--
CREATE TABLE IF NOT EXISTS
`vn_messages` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`forw`
varchar(20) NOT NULL,
`fromw` varchar(20) NOT NULL,
`title`
varchar(255) NOT NULL,
`message` text NOT NULL,
`time` int(255) NOT
NULL,
`ip` varchar(50) NOT NULL,
`readed` int(2) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_prizes`
--
CREATE TABLE IF NOT EXISTS `vn_prizes`
(
`id` int(255) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT
NULL,
`description` text NOT NULL,
`image` varchar(255) NOT NULL,
`image2` varchar(255) NOT NULL,
`image3` varchar(255) NOT NULL,
`points` int(255) NOT NULL,
`quantity` int(20) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_referals`
--
CREATE TABLE IF NOT EXISTS
`vn_referals` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`referalid`
int(255) NOT NULL,
`userid` int(255) NOT NULL,
`status` int(2) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_sms`
--
CREATE TABLE IF NOT EXISTS `vn_sms` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid` int(255) NOT NULL,
`code` varchar(255) NOT NULL,
`sms` varchar(255) NOT NULL,
`points`
int(255) NOT NULL,
`date` int(255) NOT NULL,
`ip` varchar(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_tops`
--
CREATE TABLE IF NOT EXISTS `vn_tops` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid` int(255) NOT NULL,
`top` varchar(255) NOT NULL,
`time` int(255) NOT NULL,
`points`
int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_users`
--
CREATE TABLE IF NOT EXISTS `vn_users` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` varchar(20) NOT NULL,
`user_id` int(11) NOT NULL,
`email` varchar(40) NOT NULL,
`password`
varchar(255) NOT NULL,
`avatar` varchar(255) NOT NULL,
`about` text NOT
NULL,
`votemessage` varchar(150) NOT NULL,
`points` int(255) NOT NULL,
`wonprizes` int(255) NOT NULL,
`vip` int(2) NOT NULL,
`regip`
varchar(50) NOT NULL,
`regtime` int(255) NOT NULL,
`lastip` varchar(50)
NOT NULL,
`lastact` int(255) NOT NULL,
`loged` int(2) NOT NULL,
`active` varchar(255) NOT NULL DEFAULT 'yes',
`network_name` varchar(255)
NOT NULL,
`identifier` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vn_votes`
--
CREATE TABLE IF NOT EXISTS `vn_votes` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`userid` int(255) NOT NULL,
`fromw` varchar(20) NOT NULL,
`ip` varchar(255) NOT NULL,
`time`
int(255) NOT NULL,
`points` int(255) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB 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 */;