Файл: sql.txt
Строк: 40
-- phpMyAdmin SQL Dump
-- version 2.6.1
--
http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время
создания: Янв 07 2012 г., 11:24
-- Версия
сервера: 5.0.45
-- Версия PHP: 5.2.4
--
-- БД:
`litewupsu`
--
--
--------------------------------------------------------
--
--
Структура таблицы `fish_objects`
--
CREATE TABLE
`fish_objects` (
`id` int(11) NOT NULL auto_increment,
`name`
varchar(64) default NULL,
`patch` varchar(128) default NULL,
`type`
varchar(64) default NULL,
`ptype` varchar(64) default NULL,
`level`
smallint(3) NOT NULL,
`or_price` float NOT NULL,
`dolg` smallint(3)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT
CHARSET=utf8 AUTO_INCREMENT=44 ;
--
-- Дамп данных
таблицы `fish_objects`
--
INSERT INTO `fish_objects` VALUES (7,
'Бамбуковая удочка', '/fishmaster/res/1.gif', 'udilo',
NULL, 0, 75, 25);
INSERT INTO `fish_objects` VALUES (8,
'Телескопическая удочка', '/fishmaster/res/2.gif',
'udilo', NULL, 3, 30, 30);
INSERT INTO `fish_objects` VALUES (9,
'Катушечная удочка', '/fishmaster/res/3.gif', 'udilo',
NULL, 5, 50, 50);
INSERT INTO `fish_objects` VALUES (10, 'Матчевая
удочка', '/fishmaster/res/4.gif', 'udilo', NULL, 7, 70, 70);
INSERT
INTO `fish_objects` VALUES (11, 'Болонская удочка',
'/fishmaster/res/5.gif', 'udilo', NULL, 9, 90, 90);
INSERT INTO
`fish_objects` VALUES (12, 'Червяк',
'/fishmaster/res/13249066734ef878b1a46d28410875181.gif', 'najivka', NULL,
0, 0.5, 1);
INSERT INTO `fish_objects` VALUES (13, 'Мотыль',
'/fishmaster/res/13249067114ef878d77ee6d8124404282.gif', 'najivka', NULL,
3, 0.7, 1);
INSERT INTO `fish_objects` VALUES (14, 'Опарыш',
'/fishmaster/res/13249067734ef879157012c3899356633.gif', 'najivka', NULL,
5, 1.5, 1);
INSERT INTO `fish_objects` VALUES (15, 'Пахучая
наживка', '/fishmaster/res/13249068174ef87941964fa0490771984.gif',
'najivka', NULL, 7, 2, 1);
INSERT INTO `fish_objects` VALUES (16,
'Мясная наживка',
'/fishmaster/res/13249068734ef879793213c3476103495.gif', 'najivka', NULL,
9, 2.5, 1);
INSERT INTO `fish_objects` VALUES (17, 'Озеро',
'/fishmaster/res/i0000007.jpg', 'ozero', NULL, 0, 0, 1);
INSERT INTO
`fish_objects` VALUES (38, 'Топор древних',
'/fishmaster/res/623.gif', 'starie', NULL, 0, 5, 1);
INSERT INTO
`fish_objects` VALUES (19, 'Гальян', '/fishmaster/res/0golian.gif',
'rbIba', NULL, 0, 2, 1);
INSERT INTO `fish_objects` VALUES (20,
'Окунь', '/fishmaster/res/0okun.gif', 'rbIba', NULL, 0, 2.2,
1);
INSERT INTO `fish_objects` VALUES (21, 'Елец',
'/fishmaster/res/1elets.gif', 'rbIba', NULL, 1, 2.7, 1);
INSERT INTO
`fish_objects` VALUES (22, 'Вобла', '/fishmaster/res/1vobla.gif',
'rbIba', NULL, 1, 3, 1);
INSERT INTO `fish_objects` VALUES (23,
'Голавль', '/fishmaster/res/2golavl.gif', 'rbIba', NULL, 2, 3.3,
1);
INSERT INTO `fish_objects` VALUES (24, 'Востробрюшка',
'/fishmaster/res/2vostrobrushka.gif', 'rbIba', NULL, 2, 3.5, 1);
INSERT
INTO `fish_objects` VALUES (25, 'Быстрянка',
'/fishmaster/res/3bustrianka jpg.gif', 'rbIba', NULL, 3, 3.7, 1);
INSERT
INTO `fish_objects` VALUES (26, 'Варезуб',
'/fishmaster/res/3vyrezub.gif', 'rbIba', NULL, 3, 4, 1);
INSERT INTO
`fish_objects` VALUES (27, 'Белоголов',
'/fishmaster/res/4belogl.gif', 'rbIba', NULL, 4, 4.6, 1);
INSERT INTO
`fish_objects` VALUES (28, 'Щука', '/fishmaster/res/4schuka.gif',
'rbIba', NULL, 4, 4.9, 1);
INSERT INTO `fish_objects` VALUES (29,
'Шиповка', '/fishmaster/res/5schipovka.gif', 'rbIba', NULL, 5, 5,
1);
INSERT INTO `fish_objects` VALUES (30, 'Таран',
'/fishmaster/res/5taran.gif', 'rbIba', NULL, 5, 5.2, 1);
INSERT INTO
`fish_objects` VALUES (31, 'Гастера',
'/fishmaster/res/6gustera.gif', 'rbIba', NULL, 6, 5.3, 1);
INSERT INTO
`fish_objects` VALUES (32, 'Верховка',
'/fishmaster/res/6verhovka.gif', 'rbIba', NULL, 6, 5.5, 1);
INSERT INTO
`fish_objects` VALUES (33, 'Горчак', '/fishmaster/res/7gorchak.gif',
'rbIba', NULL, 7, 5.7, 1);
INSERT INTO `fish_objects` VALUES (34,
'Желтощек', '/fishmaster/res/7zeltoschek.gif', 'rbIba', NULL, 7,
5.9, 1);
INSERT INTO `fish_objects` VALUES (35, 'Амур',
'/fishmaster/res/8amur.gif', 'rbIba', NULL, 8, 6, 1);
INSERT INTO
`fish_objects` VALUES (36, 'Чоп', '/fishmaster/res/9chop.gif', 'rbIba',
NULL, 9, 7, 1);
INSERT INTO `fish_objects` VALUES (37,
'Верхогляд', '/fishmaster/res/10verhogliad.gif', 'rbIba', NULL,
10, 8, 1);
INSERT INTO `fish_objects` VALUES (39, 'Старый
ботинок', '/fishmaster/res/1214953_m60.gif', 'starie', NULL, 0, 3.3,
1);
INSERT INTO `fish_objects` VALUES (40, 'Медное кольцо',
'/fishmaster/res/13250914904efb4aa2614076571474712.gif', 'starie', NULL, 1,
7, 1);
INSERT INTO `fish_objects` VALUES (43, 'Серебрянное
кольцо', '/fishmaster/res/21.gif', 'surp', NULL, 5, 15, 1);
--
--------------------------------------------------------
--
--
Структура таблицы `fish_rukzak`
--
CREATE TABLE
`fish_rukzak` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11)
NOT NULL,
`name` varchar(64) default NULL,
`patch` varchar(128)
default NULL,
`type` varchar(64) default NULL,
`ptype` varchar(64)
default NULL,
`level` smallint(3) NOT NULL,
`or_price` float NOT
NULL,
`dolg` smallint(3) NOT NULL,
`maxdolg` smallint(3) default
NULL,
`slot` smallint(1) default NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;
--
-- Структура таблицы `fish_user`
--
CREATE TABLE `fish_user` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11) default NULL,
`nick` varchar(32) NOT NULL,
`opit`
int(11) default NULL,
`ulevel` smallint(3) NOT NULL,
`balance` float
NOT NULL,
`c_fish` int(11) NOT NULL,
`c_surp` int(11) NOT NULL,
`c_starie` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;