Мониторинг доступности базы mySQL

Материал из 1GbWiki.

(Различия между версиями)
Перейти к: навигация, поиск
Версия 12:12, 19 июня 2008 (править)
81.177.24.120 (Обсуждение)
(→Проблемы ?)
← К предыдущему изменению		 Версия 19:08, 16 ноября 2008 (править) (отменить)
85.140.66.213 (Обсуждение)

К следующему изменению →
Строка 1: Строка 1:
-Поле «Активно» в состоянии «да» обозначает, что при генерации страницы системе удалось подсоединиться к mySQL серверу с указанными в данный момент на странице «пароли на ресурсы» реквизитами.+-- phpMyAdmin SQL Dump
 +-- version 2.11.3
 +-- http://www.phpmyadmin.net
 +--
 +-- Host: localhost
 +-- Generation Time: Jan 23, 2008 at 12:58 AM
 +-- Server version: 5.0.51
 +-- PHP Version: 5.2.5
-В случае, если поле «активно» - «да», вы можете быть уверены, что сервер работает (т.е. никаких ошибок и неисправностей конфигурации нет). В случае проблем подключения еще раз обратитесь к странице «начало», «пароли на ресурсы».+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-== Проблемы ? ==+--
-«Активно» - «нет» обозначает, что база действительно не работает. Это может означать следующее:+-- Database: `pro`
-* Отключение вашей БД администратором хостинга по причине перегрузок (см. процедуру http://www.1gb.ru/critical_stop.php). Для того, чтобы проверить такую версию, посмотрите первую страницу личного кабинета («начало»), нижнюю часть – об этом будет сообщено в сообщении, которое вы там увидите.+--
-* Вы установили собственный пароль на БД (данная операция возможна в редких случаях).+
-* Сбой сервера БД – такая возможность остается в том случае, если никаких сообщений вы там не нашли и поводов подозревать нарушение с вашей стороны нет. Придется обратиться в службу поддержки.+
-[[Категория:MySQL]]+-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_ads`
 +--
 + 
 +CREATE TABLE `tb_ads` (
 + `id` int(11) NOT NULL auto_increment,
 + `user` varchar(150) collate cp1251_general_ci NOT NULL,
 + `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 + `tipo` varchar(150) collate cp1251_general_ci NOT NULL,
 + `visitime` varchar(150) collate cp1251_general_ci NOT NULL,
 + `ident` varchar(150) collate cp1251_general_ci NOT NULL,
 + `fechainicia` varchar(150) collate cp1251_general_ci NOT NULL,
 + `paypalname` varchar(150) collate cp1251_general_ci NOT NULL,
 + `paypalemail` varchar(150) collate cp1251_general_ci NOT NULL,
 + `plan` varchar(150) collate cp1251_general_ci NOT NULL,
 + `bold` varchar(150) collate cp1251_general_ci NOT NULL,
 + `highlight` varchar(150) collate cp1251_general_ci NOT NULL,
 + `url` varchar(150) collate cp1251_general_ci NOT NULL,
 + `description` varchar(150) collate cp1251_general_ci NOT NULL,
 + `category` varchar(150) collate cp1251_general_ci NOT NULL,
 + `members` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 + `outside` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 + `total` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=29 ;
 + 
 +--
 +-- Dumping data for table `tb_ads`
 +--
 + 
 +INSERT INTO `tb_ads` (`id`, `user`, `ip`, `tipo`, `visitime`, `ident`, `fechainicia`, `paypalname`, `paypalemail`, `plan`, `bold`, `highlight`, `url`, `description`, `category`, `members`, `outside`, `total`) VALUES
 +(1, '', '', 'ads', '', '', '1195231256', '', '2dmain@admin.com', '10000', '1', '1', 'http://wmseller.info', 'Categoria 1', '1', '5', '1', '0'),
 +(3, '', '', 'ads', '', '', '1195231395', '', 'nico@nico.c0m', '1000', '1', '1', 'http://wmseller.info', 'Categoria 2', '1', '1', '0', '0'),
 +(6, '', '', 'ads', '', '', '1195493883', '', 'admin', '1000', '', '', 'http://wmseller.info', 'Categoria 3', '1', '0', '0', '0'),
 +(22, 'sol', '', 'visit', '1195673371', '21', '', '', '', '', '', '', '', '', '', '0', '0', '0'),
 +(23, 'admin', '', 'visit', '1196562956', '1', '', '', '', '', '', '', '', '', '', '0', '0', '0'),
 +(25, 'sol', '', 'visit', '1197057471', '1', '', '', '', '', '', '', '', '', '', '0', '0', '0'),
 +(28, 'admin', '', 'visit', '1200639022', '27', '', '', '', '', '', '', '', '', '', '0', '0', '0');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_ads_categories`
 +--
 + 
 +CREATE TABLE `tb_ads_categories` (
 + `id` int(11) NOT NULL,
 + `catname` varchar(50) collate cp1251_general_ci NOT NULL,
 + PRIMARY KEY (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;
 + 
 +--
 +-- Dumping data for table `tb_ads_categories`
 +--
 + 
 +INSERT INTO `tb_ads_categories` (`id`, `catname`) VALUES
 +(1, 'Arts & Entertainment'),
 +(5, 'Shopping & Free Offers'),
 +(2, 'Earn Money'),
 +(3, 'YourOwnBux Offers'),
 +(6, 'Society, Family & Relationships'),
 +(7, 'Charity &amp Non-profit Organisations'),
 +(8, 'Travelling'),
 +(10, 'Other');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_advertisers`
 +--
 + 
 +CREATE TABLE `tb_advertisers` (
 + `id` int(11) NOT NULL auto_increment,
 + `pname` varchar(150) collate cp1251_general_ci NOT NULL,
 + `pemail` varchar(150) collate cp1251_general_ci NOT NULL,
 + `plan` varchar(150) collate cp1251_general_ci NOT NULL,
 + `url` varchar(150) collate cp1251_general_ci NOT NULL,
 + `description` varchar(150) collate cp1251_general_ci NOT NULL,
 + `category` varchar(150) collate cp1251_general_ci NOT NULL,
 + `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 + `bold` varchar(150) collate cp1251_general_ci NOT NULL,
 + `highlight` varchar(150) collate cp1251_general_ci NOT NULL,
 + `tipo` varchar(150) collate cp1251_general_ci NOT NULL,
 + `money` varchar(150) collate cp1251_general_ci NOT NULL,
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=40 ;
 + 
 +--
 +-- Dumping data for table `tb_advertisers`
 +--
 + 
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_buyref`
 +--
 + 
 +CREATE TABLE `tb_buyref` (
 + `id` int(11) NOT NULL auto_increment,
 + `refnum` varchar(15) NOT NULL,
 + `sets` varchar(150) NOT NULL,
 + `customer` varchar(150) NOT NULL,
 + `amount` varchar(150) NOT NULL,
 + `refset` varchar(20) NOT NULL,
 + `pemail` varchar(150) NOT NULL,
 + `ip` varchar(15) NOT NULL,
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=43 ;
 + 
 +--
 +-- Dumping data for table `tb_buyref`
 +--
 + 
 +INSERT INTO `tb_buyref` (`id`, `refnum`, `sets`, `customer`, `amount`, `refset`, `pemail`, `ip`) VALUES
 +(1, '10', '18', 'admin', '', '', '', ''),
 +(1, '15', '2', 'admin', '', '', '', ''),
 +(1, '20', '1', 'admin', '', '', '', ''),
 +(1, '50', '1', 'admin', '', '', '', '');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_clickpack`
 +--
 + 
 +CREATE TABLE `tb_clickpack` (
 + `id` int(11) NOT NULL,
 + `item` varchar(150) collate cp1251_general_ci NOT NULL,
 + `howmany` varchar(150) collate cp1251_general_ci NOT NULL,
 + `price` varchar(150) collate cp1251_general_ci NOT NULL,
 + PRIMARY KEY (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;
 + 
 +--
 +-- Dumping data for table `tb_clickpack`
 +--
 + 
 +INSERT INTO `tb_clickpack` (`id`, `item`, `howmany`, `price`) VALUES
 +(1, 'hits', '1000', '1');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_config`
 +--
 + 
 +CREATE TABLE `tb_config` (
 + `id` int(11) NOT NULL auto_increment,
 + `item` varchar(15) collate cp1251_general_ci NOT NULL,
 + `howmany` varchar(15) collate cp1251_general_ci NOT NULL,
 + `price` varchar(150) collate cp1251_general_ci NOT NULL,
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=7 ;
 + 
 +--
 +-- Dumping data for table `tb_config`
 +--
 + 
 +INSERT INTO `tb_config` (`id`, `item`, `howmany`, `price`) VALUES
 +(1, 'click', '1', '0.01'),
 +(1, 'referalclick', '1', '0.01'),
 +(1, 'premiumclick', '1', '10'),
 +(1, 'premiumreferalc', '1', '25'),
 +(1, 'hits', '1000', '1'),
 +(1, 'hits', '2000', '2'),
 +(1, 'hits', '3000', '3'),
 +(1, 'hits', '5000', '5'),
 +(1, 'hits', '10000', '10'),
 +(1, 'payment', '1', '10.00'),
 +(1, 'upgrade', '1', '45.99'),
 +(1, 'hits', '500', '0.5'),
 +(1, 'hits', '20000', '20'),
 +(1, 'hits', '30000', '10'),
 +(1, 'hits', '50000', '50'),
 +(1, 'hits', '100000', '100');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_contact`
 +--
 + 
 +CREATE TABLE `tb_contact` (
 + `id` int(11) NOT NULL auto_increment,
 + `name` varchar(150) collate cp1251_general_ci NOT NULL,
 + `email` varchar(150) collate cp1251_general_ci NOT NULL,
 + `topic` varchar(150) collate cp1251_general_ci NOT NULL,
 + `subject` varchar(150) collate cp1251_general_ci NOT NULL,
 + `comments` varchar(200) collate cp1251_general_ci NOT NULL,
 + `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=6 ;
 + 
 +--
 +-- Dumping data for table `tb_contact`
 +--
 + 
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_history`
 +--
 + 
 +CREATE TABLE `tb_history` (
 + `id` int(11) NOT NULL auto_increment,
 + `user` varchar(150) collate cp1251_general_ci NOT NULL,
 + `date` varchar(150) collate cp1251_general_ci NOT NULL,
 + `amount` int(150) NOT NULL,
 + `method` varchar(150) collate cp1251_general_ci NOT NULL,
 + `status` varchar(150) collate cp1251_general_ci NOT NULL,
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=8 ;
 + 
 +--
 +-- Dumping data for table `tb_history`
 +--
 + 
 +INSERT INTO `tb_history` (`id`, `user`, `date`, `amount`, `method`, `status`) VALUES
 +(1, 'admin', '', 0, 'paypal', ''),
 +(7, 'admin', '23 Jan 2008 00:55', 10, 'PayPal', 'Payment Sent');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_messenger`
 +--
 + 
 +CREATE TABLE `tb_messenger` (
 + `id` int(11) NOT NULL auto_increment,
 + `sendfrom` varchar(11) collate cp1251_general_ci NOT NULL,
 + `sendto` varchar(11) collate cp1251_general_ci NOT NULL,
 + `date` varchar(35) collate cp1251_general_ci NOT NULL,
 + `comments` varchar(150) collate cp1251_general_ci NOT NULL,
 + `status` varchar(11) collate cp1251_general_ci NOT NULL default 'unread',
 + PRIMARY KEY (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=29 ;
 + 
 +--
 +-- Dumping data for table `tb_messenger`
 +--
 + 
 +INSERT INTO `tb_messenger` (`id`, `sendfrom`, `sendto`, `date`, `comments`, `status`) VALUES
 +(23, 'refadmin', 'admin', '09-01-08 03:24', 'hola mi amor', 'read');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_payme`
 +--
 + 
 +CREATE TABLE `tb_payme` (
 + `id` int(11) NOT NULL auto_increment,
 + `username` varchar(150) collate cp1251_general_ci NOT NULL,
 + `pasword` varchar(150) collate cp1251_general_ci NOT NULL,
 + `email` varchar(150) collate cp1251_general_ci NOT NULL,
 + `pemail` varchar(150) collate cp1251_general_ci NOT NULL,
 + `country` varchar(150) collate cp1251_general_ci NOT NULL,
 + `money` varchar(150) collate cp1251_general_ci NOT NULL,
 + `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=8 ;
 + 
 +--
 +-- Dumping data for table `tb_payme`
 +--
 + 
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_refset`
 +--
 + 
 +CREATE TABLE `tb_refset` (
 + `id` int(11) NOT NULL,
 + `howmany` int(5) NOT NULL,
 + `price` varchar(5) collate cp1251_general_ci NOT NULL,
 + PRIMARY KEY (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;
 + 
 +--
 +-- Dumping data for table `tb_refset`
 +--
 + 
 +INSERT INTO `tb_refset` (`id`, `howmany`, `price`) VALUES
 +(4, 50, '35'),
 +(3, 20, '15'),
 +(2, 15, '11'),
 +(1, 10, '8');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_site`
 +--
 + 
 +CREATE TABLE `tb_site` (
 + `id` varchar(11) collate cp1251_general_ci NOT NULL,
 + `sitename` varchar(30) collate cp1251_general_ci NOT NULL,
 + `sitepp` varchar(30) collate cp1251_general_ci NOT NULL,
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;
 + 
 +--
 +-- Dumping data for table `tb_site`
 +--
 + 
 +INSERT INTO `tb_site` (`id`, `sitename`, `sitepp`) VALUES
 +('1', 'WMseller', 'admin@admin.ru');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_upgrade`
 +--
 + 
 +CREATE TABLE `tb_upgrade` (
 + `id` int(11) NOT NULL auto_increment,
 + `username` varchar(150) NOT NULL,
 + `pemail` varchar(150) NOT NULL,
 + `email` varchar(150) NOT NULL,
 + `status` varchar(150) NOT NULL,
 + `date` varchar(150) NOT NULL,
 + `end` varchar(150) NOT NULL,
 + `ip` varchar(15) NOT NULL,
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=25 ;
 + 
 +--
 +-- Dumping data for table `tb_upgrade`
 +--
 + 
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `tb_users`
 +--
 + 
 +CREATE TABLE `tb_users` (
 + `id` int(11) NOT NULL auto_increment,
 + `username` varchar(15) collate cp1251_general_ci NOT NULL,
 + `password` varchar(100) collate cp1251_general_ci NOT NULL,
 + `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 + `email` varchar(150) collate cp1251_general_ci NOT NULL,
 + `pemail` varchar(150) collate cp1251_general_ci NOT NULL,
 + `referer` varchar(15) collate cp1251_general_ci NOT NULL,
 + `country` varchar(150) collate cp1251_general_ci NOT NULL,
 + `visits` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 + `referals` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 + `referalvisits` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 + `money` varchar(150) collate cp1251_general_ci NOT NULL default '0.00',
 + `paid` varchar(150) collate cp1251_general_ci NOT NULL default '0.00',
 + `joindate` varchar(150) collate cp1251_general_ci NOT NULL,
 + `lastlogdate` varchar(150) collate cp1251_general_ci NOT NULL,
 + `lastiplog` varchar(150) collate cp1251_general_ci NOT NULL,
 + `account` varchar(150) collate cp1251_general_ci NOT NULL,
 + `user_status` varchar(15) collate cp1251_general_ci NOT NULL default 'user',
 + KEY `id` (`id`)
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=20 ;
 + 
 +--
 +-- Dumping data for table `tb_users`
 +--
 + 
 +INSERT INTO `tb_users` (`id`, `username`, `password`, `ip`, `email`, `pemail`, `referer`, `country`, `visits`, `referals`, `referalvisits`, `money`, `paid`, `joindate`, `lastlogdate`, `lastiplog`, `account`, `user_status`) VALUES
 +(1, 'admin', 'admin', '127.0.0.1', 'admin@admin.ru', 'admin@admin.ru', '', 'Admin', '0', '0', '0', '-10', '10', '1184512264', '1201045992', '127.0.0.1', 'premium', 'admin');
 + 
 +-- --------------------------------------------------------
 + 
 +--
 +-- Table structure for table `users_online`
 +--
 + 
 +CREATE TABLE `users_online` (
 + `visitor` varchar(15) collate cp1251_general_ci NOT NULL,
 + `lastvisit` int(14) NOT NULL
 +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;
 + 
 +--
 +-- Dumping data for table `users_online`
 +--
 + 
 +INSERT INTO `users_online` (`visitor`, `lastvisit`) VALUES
 +('127.0.0.1', 1201045993);

Версия 19:08, 16 ноября 2008

-- phpMyAdmin SQL Dump -- version 2.11.3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 23, 2008 at 12:58 AM -- Server version: 5.0.51 -- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- -- Database: `pro` --

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

-- -- Table structure for table `tb_ads` --

CREATE TABLE `tb_ads` ( 

 `id` int(11) NOT NULL auto_increment,
 `user` varchar(150) collate cp1251_general_ci NOT NULL,
 `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 `tipo` varchar(150) collate cp1251_general_ci NOT NULL,
 `visitime` varchar(150) collate cp1251_general_ci NOT NULL,
 `ident` varchar(150) collate cp1251_general_ci NOT NULL,
 `fechainicia` varchar(150) collate cp1251_general_ci NOT NULL,
 `paypalname` varchar(150) collate cp1251_general_ci NOT NULL,
 `paypalemail` varchar(150) collate cp1251_general_ci NOT NULL,
 `plan` varchar(150) collate cp1251_general_ci NOT NULL,
 `bold` varchar(150) collate cp1251_general_ci NOT NULL,
 `highlight` varchar(150) collate cp1251_general_ci NOT NULL,
 `url` varchar(150) collate cp1251_general_ci NOT NULL,
 `description` varchar(150) collate cp1251_general_ci NOT NULL,
 `category` varchar(150) collate cp1251_general_ci NOT NULL,
 `members` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 `outside` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 `total` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=29 ;

-- -- Dumping data for table `tb_ads` --

INSERT INTO `tb_ads` (`id`, `user`, `ip`, `tipo`, `visitime`, `ident`, `fechainicia`, `paypalname`, `paypalemail`, `plan`, `bold`, `highlight`, `url`, `description`, `category`, `members`, `outside`, `total`) VALUES (1, , , 'ads', , , '1195231256', , '2dmain@admin.com', '10000', '1', '1', 'http://wmseller.info', 'Categoria 1', '1', '5', '1', '0'), (3, , , 'ads', , , '1195231395', , 'nico@nico.c0m', '1000', '1', '1', 'http://wmseller.info', 'Categoria 2', '1', '1', '0', '0'), (6, , , 'ads', , , '1195493883', , 'admin', '1000', , , 'http://wmseller.info', 'Categoria 3', '1', '0', '0', '0'), (22, 'sol', , 'visit', '1195673371', '21', , , , , , , , , , '0', '0', '0'), (23, 'admin', , 'visit', '1196562956', '1', , , , , , , , , , '0', '0', '0'), (25, 'sol', , 'visit', '1197057471', '1', , , , , , , , , , '0', '0', '0'), (28, 'admin', , 'visit', '1200639022', '27', , , , , , , , , , '0', '0', '0');

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

-- -- Table structure for table `tb_ads_categories` --

CREATE TABLE `tb_ads_categories` ( 

 `id` int(11) NOT NULL,
 `catname` varchar(50) collate cp1251_general_ci NOT NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;

-- -- Dumping data for table `tb_ads_categories` --

INSERT INTO `tb_ads_categories` (`id`, `catname`) VALUES (1, 'Arts & Entertainment'), (5, 'Shopping & Free Offers'), (2, 'Earn Money'), (3, 'YourOwnBux Offers'), (6, 'Society, Family & Relationships'), (7, 'Charity &amp Non-profit Organisations'), (8, 'Travelling'), (10, 'Other');

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

-- -- Table structure for table `tb_advertisers` --

CREATE TABLE `tb_advertisers` ( 

 `id` int(11) NOT NULL auto_increment,
 `pname` varchar(150) collate cp1251_general_ci NOT NULL,
 `pemail` varchar(150) collate cp1251_general_ci NOT NULL,
 `plan` varchar(150) collate cp1251_general_ci NOT NULL,
 `url` varchar(150) collate cp1251_general_ci NOT NULL,
 `description` varchar(150) collate cp1251_general_ci NOT NULL,
 `category` varchar(150) collate cp1251_general_ci NOT NULL,
 `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 `bold` varchar(150) collate cp1251_general_ci NOT NULL,
 `highlight` varchar(150) collate cp1251_general_ci NOT NULL,
 `tipo` varchar(150) collate cp1251_general_ci NOT NULL,
 `money` varchar(150) collate cp1251_general_ci NOT NULL,
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=40 ;

-- -- Dumping data for table `tb_advertisers` --


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

-- -- Table structure for table `tb_buyref` --

CREATE TABLE `tb_buyref` ( 

 `id` int(11) NOT NULL auto_increment,
 `refnum` varchar(15) NOT NULL,
 `sets` varchar(150) NOT NULL,
 `customer` varchar(150) NOT NULL,
 `amount` varchar(150) NOT NULL,
 `refset` varchar(20) NOT NULL,
 `pemail` varchar(150) NOT NULL,
 `ip` varchar(15) NOT NULL,
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=43 ;

-- -- Dumping data for table `tb_buyref` --

INSERT INTO `tb_buyref` (`id`, `refnum`, `sets`, `customer`, `amount`, `refset`, `pemail`, `ip`) VALUES (1, '10', '18', 'admin', , , , ), (1, '15', '2', 'admin', , , , ), (1, '20', '1', 'admin', , , , ), (1, '50', '1', 'admin', , , , );

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

-- -- Table structure for table `tb_clickpack` --

CREATE TABLE `tb_clickpack` ( 

 `id` int(11) NOT NULL,
 `item` varchar(150) collate cp1251_general_ci NOT NULL,
 `howmany` varchar(150) collate cp1251_general_ci NOT NULL,
 `price` varchar(150) collate cp1251_general_ci NOT NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;

-- -- Dumping data for table `tb_clickpack` --

INSERT INTO `tb_clickpack` (`id`, `item`, `howmany`, `price`) VALUES (1, 'hits', '1000', '1');

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

-- -- Table structure for table `tb_config` --

CREATE TABLE `tb_config` ( 

 `id` int(11) NOT NULL auto_increment,
 `item` varchar(15) collate cp1251_general_ci NOT NULL,
 `howmany` varchar(15) collate cp1251_general_ci NOT NULL,
 `price` varchar(150) collate cp1251_general_ci NOT NULL,
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=7 ;

-- -- Dumping data for table `tb_config` --

INSERT INTO `tb_config` (`id`, `item`, `howmany`, `price`) VALUES (1, 'click', '1', '0.01'), (1, 'referalclick', '1', '0.01'), (1, 'premiumclick', '1', '10'), (1, 'premiumreferalc', '1', '25'), (1, 'hits', '1000', '1'), (1, 'hits', '2000', '2'), (1, 'hits', '3000', '3'), (1, 'hits', '5000', '5'), (1, 'hits', '10000', '10'), (1, 'payment', '1', '10.00'), (1, 'upgrade', '1', '45.99'), (1, 'hits', '500', '0.5'), (1, 'hits', '20000', '20'), (1, 'hits', '30000', '10'), (1, 'hits', '50000', '50'), (1, 'hits', '100000', '100');

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

-- -- Table structure for table `tb_contact` --

CREATE TABLE `tb_contact` ( 

 `id` int(11) NOT NULL auto_increment,
 `name` varchar(150) collate cp1251_general_ci NOT NULL,
 `email` varchar(150) collate cp1251_general_ci NOT NULL,
 `topic` varchar(150) collate cp1251_general_ci NOT NULL,
 `subject` varchar(150) collate cp1251_general_ci NOT NULL,
 `comments` varchar(200) collate cp1251_general_ci NOT NULL,
 `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=6 ;

-- -- Dumping data for table `tb_contact` --


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

-- -- Table structure for table `tb_history` --

CREATE TABLE `tb_history` ( 

 `id` int(11) NOT NULL auto_increment,
 `user` varchar(150) collate cp1251_general_ci NOT NULL,
 `date` varchar(150) collate cp1251_general_ci NOT NULL,
 `amount` int(150) NOT NULL,
 `method` varchar(150) collate cp1251_general_ci NOT NULL,
 `status` varchar(150) collate cp1251_general_ci NOT NULL,
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=8 ;

-- -- Dumping data for table `tb_history` --

INSERT INTO `tb_history` (`id`, `user`, `date`, `amount`, `method`, `status`) VALUES (1, 'admin', , 0, 'paypal', ), (7, 'admin', '23 Jan 2008 00:55', 10, 'PayPal', 'Payment Sent');

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

-- -- Table structure for table `tb_messenger` --

CREATE TABLE `tb_messenger` ( 

 `id` int(11) NOT NULL auto_increment,
 `sendfrom` varchar(11) collate cp1251_general_ci NOT NULL,
 `sendto` varchar(11) collate cp1251_general_ci NOT NULL,
 `date` varchar(35) collate cp1251_general_ci NOT NULL,
 `comments` varchar(150) collate cp1251_general_ci NOT NULL,
 `status` varchar(11) collate cp1251_general_ci NOT NULL default 'unread',
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=29 ;

-- -- Dumping data for table `tb_messenger` --

INSERT INTO `tb_messenger` (`id`, `sendfrom`, `sendto`, `date`, `comments`, `status`) VALUES (23, 'refadmin', 'admin', '09-01-08 03:24', 'hola mi amor', 'read');

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

-- -- Table structure for table `tb_payme` --

CREATE TABLE `tb_payme` ( 

 `id` int(11) NOT NULL auto_increment,
 `username` varchar(150) collate cp1251_general_ci NOT NULL,
 `pasword` varchar(150) collate cp1251_general_ci NOT NULL,
 `email` varchar(150) collate cp1251_general_ci NOT NULL,
 `pemail` varchar(150) collate cp1251_general_ci NOT NULL,
 `country` varchar(150) collate cp1251_general_ci NOT NULL,
 `money` varchar(150) collate cp1251_general_ci NOT NULL,
 `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=8 ;

-- -- Dumping data for table `tb_payme` --


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

-- -- Table structure for table `tb_refset` --

CREATE TABLE `tb_refset` ( 

 `id` int(11) NOT NULL,
 `howmany` int(5) NOT NULL,
 `price` varchar(5) collate cp1251_general_ci NOT NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;

-- -- Dumping data for table `tb_refset` --

INSERT INTO `tb_refset` (`id`, `howmany`, `price`) VALUES (4, 50, '35'), (3, 20, '15'), (2, 15, '11'), (1, 10, '8');

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

-- -- Table structure for table `tb_site` --

CREATE TABLE `tb_site` ( 

 `id` varchar(11) collate cp1251_general_ci NOT NULL,
 `sitename` varchar(30) collate cp1251_general_ci NOT NULL,
 `sitepp` varchar(30) collate cp1251_general_ci NOT NULL,
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;

-- -- Dumping data for table `tb_site` --

INSERT INTO `tb_site` (`id`, `sitename`, `sitepp`) VALUES ('1', 'WMseller', 'admin@admin.ru');

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

-- -- Table structure for table `tb_upgrade` --

CREATE TABLE `tb_upgrade` ( 

 `id` int(11) NOT NULL auto_increment,
 `username` varchar(150) NOT NULL,
 `pemail` varchar(150) NOT NULL,
 `email` varchar(150) NOT NULL,
 `status` varchar(150) NOT NULL,
 `date` varchar(150) NOT NULL,
 `end` varchar(150) NOT NULL,
 `ip` varchar(15) NOT NULL,
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=25 ;

-- -- Dumping data for table `tb_upgrade` --


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

-- -- Table structure for table `tb_users` --

CREATE TABLE `tb_users` ( 

 `id` int(11) NOT NULL auto_increment,
 `username` varchar(15) collate cp1251_general_ci NOT NULL,
 `password` varchar(100) collate cp1251_general_ci NOT NULL,
 `ip` varchar(15) collate cp1251_general_ci NOT NULL,
 `email` varchar(150) collate cp1251_general_ci NOT NULL,
 `pemail` varchar(150) collate cp1251_general_ci NOT NULL,
 `referer` varchar(15) collate cp1251_general_ci NOT NULL,
 `country` varchar(150) collate cp1251_general_ci NOT NULL,
 `visits` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 `referals` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 `referalvisits` varchar(150) collate cp1251_general_ci NOT NULL default '0',
 `money` varchar(150) collate cp1251_general_ci NOT NULL default '0.00',
 `paid` varchar(150) collate cp1251_general_ci NOT NULL default '0.00',
 `joindate` varchar(150) collate cp1251_general_ci NOT NULL,
 `lastlogdate` varchar(150) collate cp1251_general_ci NOT NULL,
 `lastiplog` varchar(150) collate cp1251_general_ci NOT NULL,
 `account` varchar(150) collate cp1251_general_ci NOT NULL,
 `user_status` varchar(15) collate cp1251_general_ci NOT NULL default 'user',
 KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci AUTO_INCREMENT=20 ;

-- -- Dumping data for table `tb_users` --

INSERT INTO `tb_users` (`id`, `username`, `password`, `ip`, `email`, `pemail`, `referer`, `country`, `visits`, `referals`, `referalvisits`, `money`, `paid`, `joindate`, `lastlogdate`, `lastiplog`, `account`, `user_status`) VALUES (1, 'admin', 'admin', '127.0.0.1', 'admin@admin.ru', 'admin@admin.ru', , 'Admin', '0', '0', '0', '-10', '10', '1184512264', '1201045992', '127.0.0.1', 'premium', 'admin');

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

-- -- Table structure for table `users_online` --

CREATE TABLE `users_online` ( 

 `visitor` varchar(15) collate cp1251_general_ci NOT NULL,
 `lastvisit` int(14) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_ci;

-- -- Dumping data for table `users_online` --

INSERT INTO `users_online` (`visitor`, `lastvisit`) VALUES ('127.0.0.1', 1201045993);

Получено с http://1gb.ua/wiki/index.php?title=%D0%9C%D0%BE%D0%BD%D0%B8%D1%82%D0%BE%D1%80%D0%B8%D0%BD%D0%B3_%D0%B4%D0%BE%D1%81%D1%82%D1%83%D0%BF%D0%BD%D0%BE%D1%81%D1%82%D0%B8_%D0%B1%D0%B0%D0%B7%D1%8B_mySQL
Личные инструменты