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

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

Перейти к: навигация, поиск

-- 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 fo