Информация

-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Хост: 192.168.125.21
-- Время создания: Мар 18 2008 г., 05:30
-- Версия сервера: 5.2.3
-- Версия PHP: 5.2.0
--
-- База данных: `tituskz_price`
--

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

--
-- Структура таблицы `comm`
--

CREATE TABLE `comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`previd` int(18) NOT NULL,
`name` varchar(20) NOT NULL DEFAULT '',
`mail` varchar(20) DEFAULT NULL,
`comm` text NOT NULL,
`data` datetime NOT NULL,
`ip` varchar(15) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id` (`previd`),
KEY `data` (`data`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1854 ;

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

--
-- Структура таблицы `golos_otvet`
--

CREATE TABLE `golos_otvet` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news_id` int(11) DEFAULT NULL,
`variant_id` int(11) DEFAULT NULL,
`ip_external` varchar(15) DEFAULT NULL,
`ip_internal` varchar(15) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`data` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `variant_id` (`variant_id`),
KEY `ip_external` (`ip_external`),
KEY `ip_internal` (`ip_internal`),
KEY `user_id` (`user_id`),
KEY `news_id` (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=140 ;

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

--
-- Структура таблицы `golos_variant`
--

CREATE TABLE `golos_variant` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news_id` int(11) DEFAULT NULL,
`variant` text,
PRIMARY KEY (`id`),
KEY `golos_id` (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=20 ;

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

--
-- Структура таблицы `images`
--

CREATE TABLE `images` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_theme` varchar(18) NOT NULL DEFAULT '',
`image` varchar(50) NOT NULL,
`smallimage` varchar(50) DEFAULT NULL,
`title` text,
UNIQUE KEY `id` (`id`),
KEY `image` (`image`),
KEY `smallimage` (`smallimage`),
KEY `id_theme` (`id_theme`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4308 ;

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

--
-- Структура таблицы `images_u`
--

CREATE TABLE `images_u` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_theme` varchar(18) NOT NULL DEFAULT '',
`image` varchar(30) NOT NULL DEFAULT '',
UNIQUE KEY `id` (`id`),
KEY `id_theme` (`id_theme`,`image`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=7 ;

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

--
-- Структура таблицы `menu`
--

CREATE TABLE `menu` (
`id` varchar(10) NOT NULL DEFAULT '',
`derevo` varchar(20) DEFAULT NULL,
`razdel` varchar(20) NOT NULL,
`menu_rus` varchar(255) NOT NULL DEFAULT '',
`ismenu` char(1) NOT NULL DEFAULT '',
`vid` varchar(10) NOT NULL DEFAULT '',
`data` int(11) NOT NULL AUTO_INCREMENT,
`kol_page` varchar(4) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL DEFAULT '',
`kol_glav` varchar(4) NOT NULL DEFAULT '',
`show_data` char(1) NOT NULL DEFAULT '',
`sort` varchar(4) DEFAULT NULL,
`sortcomm` varchar(4) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `razdel` (`razdel`),
KEY `menu_rus` (`menu_rus`),
KEY `ismenu` (`ismenu`),
KEY `kol_page` (`kol_page`),
KEY `kol_glav` (`kol_glav`),
KEY `data` (`data`) USING BTREE,
KEY `show_data` (`show_data`),
KEY `derevo` (`derevo`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=52 ;

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

--
-- Структура таблицы `menu2`
--

CREATE TABLE `menu2` (
`id` varchar(10) NOT NULL DEFAULT '',
`parent` varchar(20) DEFAULT NULL,
`razdel` varchar(5) NOT NULL DEFAULT '',
`menu_rus` varchar(255) NOT NULL DEFAULT '',
`ismenu` char(1) NOT NULL DEFAULT '',
`vid` varchar(10) NOT NULL DEFAULT '',
`position` int(11) NOT NULL AUTO_INCREMENT,
`kol_page` varchar(4) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL DEFAULT '',
`kol_glav` varchar(4) NOT NULL DEFAULT '',
`show_data` char(1) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `razdel` (`razdel`),
KEY `menu_rus` (`menu_rus`),
KEY `ismenu` (`ismenu`),
KEY `kol_page` (`kol_page`),
KEY `kol_glav` (`kol_glav`),
KEY `data` (`position`) USING BTREE,
KEY `show_data` (`show_data`),
KEY `derevo` (`parent`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=24 ;

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

--
-- Структура таблицы `menu_en`
--

CREATE TABLE `menu_en` (
`id` varchar(10) NOT NULL DEFAULT '',
`razdel` varchar(5) NOT NULL DEFAULT '',
`menu_rus` varchar(255) NOT NULL DEFAULT '',
`ismenu` char(1) NOT NULL DEFAULT '',
`vid` varchar(10) NOT NULL DEFAULT '',
`data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `razdel` (`razdel`),
KEY `menu_rus` (`menu_rus`),
KEY `ismenu` (`ismenu`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `menu_kz`
--

CREATE TABLE `menu_kz` (
`id` varchar(10) NOT NULL DEFAULT '',
`razdel` varchar(5) NOT NULL DEFAULT '',
`menu_rus` varchar(255) NOT NULL DEFAULT '',
`ismenu` char(1) NOT NULL DEFAULT '',
`vid` varchar(10) NOT NULL DEFAULT '',
`data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `razdel` (`razdel`),
KEY `menu_rus` (`menu_rus`),
KEY `ismenu` (`ismenu`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `messages`
--

CREATE TABLE `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`to_user_id` int(11) NOT NULL,
`from_user_id` int(11) NOT NULL,
`mess` text,
PRIMARY KEY (`id`),
KEY `to_user_id` (`to_user_id`),
KEY `from_user_id` (`from_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `metal`
--

CREATE TABLE `metal` (
`id` varchar(10) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`cena` varchar(10) NOT NULL DEFAULT '',
`cena2` varchar(10) NOT NULL DEFAULT '',
`data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `news`
--

CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`data` datetime DEFAULT NULL,
`zag` text,
`prev` text NOT NULL,
`text` mediumtext NOT NULL,
`author` varchar(15) DEFAULT NULL,
`type` varchar(10) NOT NULL DEFAULT '',
`kol` int(11) NOT NULL DEFAULT '0',
`del` varchar(1) NOT NULL DEFAULT '0',
KEY `id` (`id`),
KEY `data` (`data`),
KEY `author` (`author`),
KEY `type` (`type`),
KEY `kol` (`kol`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4167 ;

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

--
-- Структура таблицы `news_en`
--

CREATE TABLE `news_en` (
`id` varchar(10) NOT NULL DEFAULT '',
`data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`prev` text NOT NULL,
`text` text NOT NULL,
`author` varchar(15) DEFAULT NULL,
`image` varchar(200) DEFAULT NULL,
`type` varchar(10) NOT NULL DEFAULT '',
UNIQUE KEY `id` (`id`) USING BTREE,
KEY `data` (`data`),
KEY `type` (`type`),
KEY `author` (`author`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `news_kz`
--

CREATE TABLE `news_kz` (
`id` varchar(10) NOT NULL DEFAULT '',
`data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`prev` text NOT NULL,
`text` text NOT NULL,
`author` varchar(15) DEFAULT NULL,
`image` varchar(200) DEFAULT NULL,
`type` varchar(10) NOT NULL DEFAULT '',
KEY `id` (`id`),
KEY `data` (`data`),
KEY `type` (`type`),
KEY `author` (`author`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `prava`
--

CREATE TABLE `prava` (
`id` varchar(10) NOT NULL DEFAULT '',
`user_id` varchar(10) NOT NULL DEFAULT '',
`name` varchar(15) NOT NULL DEFAULT '',
`razdel` varchar(20) NOT NULL,
KEY `id` (`id`),
KEY `user_id` (`user_id`),
KEY `name` (`name`),
KEY `razdel` (`razdel`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `price`
--

CREATE TABLE `price` (
`id` varchar(10) NOT NULL DEFAULT '',
`vid` varchar(20) NOT NULL DEFAULT '',
`name_tov` varchar(255) NOT NULL DEFAULT '',
`cena_rozn` mediumint(9) DEFAULT NULL,
`cena_opt` mediumint(9) DEFAULT NULL,
`mag` varchar(200) NOT NULL DEFAULT '',
KEY `vid` (`vid`),
KEY `name_tov` (`name_tov`),
KEY `mag` (`mag`),
KEY `cena_rozn` (`cena_rozn`),
KEY `cena_opt` (`cena_opt`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

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

--
-- Структура таблицы `smiles`
--

CREATE TABLE `smiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`src` varchar(20) NOT NULL,
`kod` varchar(20) NOT NULL,
`alt` varchar(20) CHARACTER SET cp1251 COLLATE cp1251_general_cs NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=47 ;

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

--
-- Структура таблицы `stat`
--

CREATE TABLE `stat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(15) DEFAULT NULL,
`adres` varchar(50) CHARACTER SET latin7 DEFAULT NULL,
`data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
KEY `id` (`id`),
KEY `ip` (`ip`),
KEY `data` (`data`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2955 ;

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

--
-- Структура таблицы `users`
--

CREATE TABLE `users` (
`id` varchar(10) NOT NULL DEFAULT '',
`name` varchar(15) NOT NULL DEFAULT '',
`gorod` varchar(20) DEFAULT NULL,
`mail` varchar(20) DEFAULT NULL,
`icq` varchar(20) DEFAULT NULL,
`url` varchar(30) DEFAULT NULL,
`sex` char(1) NOT NULL DEFAULT '',
`text` text,
`data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`pass` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `name` (`name`,`gorod`,`mail`,`icq`,`url`,`sex`,`data`,`pass`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;