SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- База данных: `XXXXXXXXXXX`
--
-- --------------------------------------------------------
--
-- Структура таблицы `jos_PhocaGallery`
--
CREATE TABLE IF NOT EXISTS `jos_PhocaGallery` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`filename` varchar(250) NOT NULL default '',
`description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`geotitle` varchar(255) NOT NULL default '',
`videocode` text,
`vmproductid` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text,
`extlink1` text,
`extlink2` text,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Структура таблицы `jos_PhocaGallery_categories`
--
CREATE TABLE IF NOT EXISTS `jos_PhocaGallery_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`accessuserid` text,
`uploaduserid` text,
`deleteuserid` text,
`userfolder` text,
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`geotitle` varchar(255) NOT NULL default '',
`params` text,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
-- --------------------------------------------------------
--
-- Структура таблицы `jos_PhocaGallery_comments`
--
CREATE TABLE IF NOT EXISTS `jos_PhocaGallery_comments` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL default '',
`comment` text,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `jos_PhocaGallery_img_votes`
--
CREATE TABLE IF NOT EXISTS `jos_PhocaGallery_img_votes` (
`id` int(11) NOT NULL auto_increment,
`imgid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`rating` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `jos_PhocaGallery_img_votes_statistics`
--
CREATE TABLE IF NOT EXISTS `jos_PhocaGallery_img_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`imgid` int(11) NOT NULL default '0',
`count` tinyint(11) NOT NULL default '0',
`average` float(8,6) NOT NULL default '0.000000',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `jos_PhocaGallery_user_category`
--
CREATE TABLE IF NOT EXISTS `jos_PhocaGallery_user_category` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `jos_PhocaGallery_votes`
--
CREATE TABLE IF NOT EXISTS `jos_PhocaGallery_votes` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`rating` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Структура таблицы `jos_PhocaGallery_votes_statistics`
--
CREATE TABLE IF NOT EXISTS `jos_PhocaGallery_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`count` tinyint(11) NOT NULL default '0',
`average` float(8,6) NOT NULL default '0.000000',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;