--
-- Структура таблицы `db_serfing`
--
CREATE TABLE IF NOT EXISTS `db_serfing` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(30) NOT NULL,
`time_add` int(11) NOT NULL DEFAULT '0',
`title` varchar(55) NOT NULL,
`desc` varchar(55) NOT NULL,
`url` varchar(255) NOT NULL,
`timer` enum('20','30','40','50','60') NOT NULL DEFAULT '20',
`move` enum('0','1','','') NOT NULL DEFAULT '0',
`high` enum('0','1','','') NOT NULL DEFAULT '0',
`speed` enum('1','2','3','4','5','6','7') NOT NULL DEFAULT '1',
`baner` enum('0','1','','') NOT NULL,
`baner_url` varchar(250) NOT NULL,
`crev` enum('0','1','','') NOT NULL DEFAULT '0',
`view` int(11) NOT NULL DEFAULT '0',
`price` double(10,2) NOT NULL DEFAULT '0.00',
`money` double(10,2) NOT NULL DEFAULT '0.00',
`status` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
-- ---------СКРИПТЫ -----ХАЙПЫ ---------ФЕРМЫ---------------------------------
--
-- Структура таблицы `db_serfing_view`
--
CREATE TABLE IF NOT EXISTS `db_serfing_view` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ident` int(11) NOT NULL DEFAULT '0',
`time_add` datetime NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;