File: /home/confeduphaar/backip-old-files/administrator/components/com_virtuemart/install/joomla2.sql
CREATE TABLE IF NOT EXISTS `#__assets` (
`id` int(1) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`parent_id` int(1) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.',
`lft` int(1) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
`rgt` int(1) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
`level` int(1) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
`name` varchar(50) NOT NULL COMMENT 'The unique name for the asset.',
`title` varchar(100) NOT NULL COMMENT 'The descriptive title for the asset.',
`rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_asset_name` (`name`),
KEY `idx_lft_rgt` (`lft`,`rgt`),
KEY `idx_parent_id` (`parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__associations` (
`id` VARCHAR(50) NOT NULL COMMENT 'A reference to the associated item.',
`context` VARCHAR(50) NOT NULL COMMENT 'The context of the associated item.',
`key` CHAR(32) NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.',
PRIMARY KEY `idx_context_id` (`context`, `id`),
INDEX `idx_key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__banners` (
`id` INTEGER NOT NULL auto_increment,
`cid` INTEGER NOT NULL DEFAULT '0',
`type` INTEGER NOT NULL DEFAULT '0',
`name` VARCHAR(255) NOT NULL DEFAULT '',
`alias` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`imptotal` INTEGER NOT NULL DEFAULT '0',
`impmade` INTEGER NOT NULL DEFAULT '0',
`clicks` INTEGER NOT NULL DEFAULT '0',
`clickurl` VARCHAR(200) NOT NULL DEFAULT '',
`state` TINYINT(3) NOT NULL DEFAULT '0',
`catid` INTEGER UNSIGNED NOT NULL DEFAULT 0,
`description` TEXT NOT NULL,
`custombannercode` VARCHAR(2048) NOT NULL,
`sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`ordering` INTEGER NOT NULL DEFAULT 0,
`metakey` TEXT NOT NULL,
`params` TEXT NOT NULL,
`own_prefix` TINYINT(1) NOT NULL DEFAULT '0',
`metakey_prefix` VARCHAR(255) NOT NULL DEFAULT '',
`purchase_type` TINYINT NOT NULL DEFAULT '-1',
`track_clicks` TINYINT NOT NULL DEFAULT '-1',
`track_impressions` TINYINT NOT NULL DEFAULT '-1',
`checked_out` INTEGER UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`reset` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`language` char(7) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
INDEX `idx_state` (`state`),
INDEX `idx_own_prefix` (`own_prefix`),
INDEX `idx_metakey_prefix` (`metakey_prefix`),
INDEX `idx_banner_catid`(`catid`),
INDEX `idx_language` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__banner_clients` (
`id` INTEGER NOT NULL auto_increment,
`name` VARCHAR(255) NOT NULL DEFAULT '',
`contact` VARCHAR(255) NOT NULL DEFAULT '',
`email` VARCHAR(255) NOT NULL DEFAULT '',
`extrainfo` TEXT NOT NULL,
`state` TINYINT(3) NOT NULL DEFAULT '0',
`checked_out` INTEGER UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL default '0000-00-00 00:00:00',
`metakey` TEXT NOT NULL,
`own_prefix` TINYINT NOT NULL DEFAULT '0',
`metakey_prefix` VARCHAR(255) NOT NULL default '',
`purchase_type` TINYINT NOT NULL DEFAULT '-1',
`track_clicks` TINYINT NOT NULL DEFAULT '-1',
`track_impressions` TINYINT NOT NULL DEFAULT '-1',
PRIMARY KEY (`id`),
INDEX `idx_own_prefix` (`own_prefix`),
INDEX `idx_metakey_prefix` (`metakey_prefix`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__banner_tracks` (
`track_date` DATETIME NOT NULL,
`track_type` INTEGER UNSIGNED NOT NULL,
`banner_id` INTEGER UNSIGNED NOT NULL,
`count` INTEGER UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`track_date`, `track_type`, `banner_id`),
INDEX `idx_track_date` (`track_date`),
INDEX `idx_track_type` (`track_type`),
INDEX `idx_banner_id` (`banner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__categories` (
`id` int(1) NOT NULL auto_increment,
`asset_id` INTEGER UNSIGNED NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
`parent_id` int(1) unsigned NOT NULL default '0',
`lft` int(1) NOT NULL default '0',
`rgt` int(1) NOT NULL default '0',
`level` int(1) unsigned NOT NULL default '0',
`path` varchar(255) NOT NULL default '',
`extension` varchar(50) NOT NULL default '',
`title` varchar(255) NOT NULL,
`alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
`note` varchar(255) NOT NULL default '',
`description` mediumtext NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(1) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`access` int(1) unsigned NOT NULL default '0',
`params` TEXT NOT NULL,
`metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.',
`metakey` varchar(1024) NOT NULL COMMENT 'The meta keywords for the page.',
`metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.',
`created_user_id` int(1) unsigned NOT NULL default '0',
`created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_user_id` int(1) unsigned NOT NULL default '0',
`modified_time` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(1) unsigned NOT NULL default '0',
`language` char(7) NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`extension`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_path` (`path`),
KEY `idx_left_right` (`lft`,`rgt`),
KEY `idx_alias` (`alias`),
INDEX `idx_language` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__contact_details` (
`id` int(1) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
`con_position` varchar(255) default NULL,
`address` text,
`suburb` varchar(100) default NULL,
`state` varchar(100) default NULL,
`country` varchar(100) default NULL,
`postcode` varchar(100) default NULL,
`telephone` varchar(255) default NULL,
`fax` varchar(255) default NULL,
`misc` mediumtext,
`image` varchar(255) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(255) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(1) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(1) NOT NULL default '0',
`params` text NOT NULL,
`user_id` int(1) NOT NULL default '0',
`catid` int(1) NOT NULL default '0',
`access` int(1) unsigned NOT NULL default '0',
`mobile` varchar(255) NOT NULL default '',
`webpage` varchar(255) NOT NULL default '',
`sortname1` varchar(255) NOT NULL,
`sortname2` varchar(255) NOT NULL,
`sortname3` varchar(255) NOT NULL,
`language` char(7) NOT NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(1) unsigned NOT NULL default '0',
`created_by_alias` varchar(255) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(1) unsigned NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`metadata` text NOT NULL,
`featured` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Set if article is featured.',
`xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`published`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`),
KEY `idx_featured_catid` (`featured`,`catid`),
KEY `idx_language` (`language`),
KEY `idx_xreference` (`xreference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__content` (
`id` int(1) unsigned NOT NULL auto_increment,
`asset_id` INTEGER UNSIGNED NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
`title` varchar(255) NOT NULL default '',
`alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
`title_alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '' COMMENT 'Deprecated in Joomla! 3.0',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(1) unsigned NOT NULL default '0',
`mask` int(1) unsigned NOT NULL default '0',
`catid` int(1) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(1) unsigned NOT NULL default '0',
`created_by_alias` varchar(255) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(1) unsigned NOT NULL default '0',
`checked_out` int(1) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` varchar(5120) NOT NULL,
`version` int(1) unsigned NOT NULL default '1',
`parentid` int(1) unsigned NOT NULL default '0',
`ordering` int(1) NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(1) unsigned NOT NULL default '0',
`hits` int(1) unsigned NOT NULL default '0',
`metadata` text NOT NULL,
`featured` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Set if article is featured.',
`language` char(7) NOT NULL COMMENT 'The language code for the article.',
`xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
PRIMARY KEY (`id`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`),
KEY `idx_featured_catid` (`featured`,`catid`),
KEY `idx_language` (`language`),
KEY `idx_xreference` (`xreference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__content_frontpage` (
`content_id` int(1) NOT NULL default '0',
`ordering` int(1) NOT NULL default '0',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__content_rating` (
`content_id` int(1) NOT NULL default '0',
`rating_sum` int(1) unsigned NOT NULL default '0',
`rating_count` int(1) unsigned NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
PRIMARY KEY (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(1) unsigned NOT NULL default '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__extensions` (
`extension_id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(100) NOT NULL,
`type` VARCHAR(20) NOT NULL,
`element` VARCHAR(100) NOT NULL,
`folder` VARCHAR(100) NOT NULL,
`client_id` TINYINT(3) NOT NULL,
`enabled` TINYINT(3) NOT NULL DEFAULT '1',
`access` int(1) UNSIGNED NOT NULL DEFAULT '1',
`protected` TINYINT(3) NOT NULL DEFAULT '0',
`manifest_cache` TEXT NOT NULL,
`params` TEXT NOT NULL,
`custom_data` text NOT NULL,
`system_data` text NOT NULL,
`checked_out` int(1) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(1) default '0',
`state` int(1) default '0',
PRIMARY KEY (`extension_id`),
INDEX `element_clientid`(`element`, `client_id`),
INDEX `element_folder_clientid`(`element`, `folder`, `client_id`),
INDEX `extension`(`type`,`element`,`folder`,`client_id`),
KEY `access_enabled`(`access`,`enabled`)
) Engine=MyISAM AUTO_INCREMENT=10000 CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_filters` (
`filter_id` int(1) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`alias` varchar(255) NOT NULL,
`state` tinyint(1) NOT NULL default '1',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(1) unsigned NOT NULL,
`created_by_alias` varchar(255) NOT NULL,
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(1) unsigned NOT NULL default '0',
`checked_out` int(1) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`map_count` int(1) unsigned NOT NULL default '0',
`data` text NOT NULL,
`params` mediumtext,
PRIMARY KEY (`filter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links` (
`link_id` int(1) unsigned NOT NULL auto_increment,
`url` varchar(255) NOT NULL,
`route` varchar(255) NOT NULL,
`title` varchar(255),
`description` varchar(255),
`indexdate` datetime NOT NULL default '0000-00-00 00:00:00',
`md5sum` varchar(32),
`published` tinyint(1) NOT NULL default '1',
`state` int(5) default '1',
`access` int(5) default '0',
`language` varchar(8) NOT NULL,
`publish_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_end_date` datetime NOT NULL default '0000-00-00 00:00:00',
`start_date` datetime NOT NULL default '0000-00-00 00:00:00',
`end_date` datetime NOT NULL default '0000-00-00 00:00:00',
`list_price` double unsigned NOT NULL default '0',
`sale_price` double unsigned NOT NULL default '0',
`type_id` int(1) NOT NULL,
`object` mediumblob NOT NULL,
PRIMARY KEY (`link_id`),
KEY `idx_type` (`type_id`),
KEY `idx_title` (`title`),
KEY `idx_md5` (`md5sum`),
KEY `idx_url` (`url`(75)),
KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms0` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms1` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms2` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms3` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms4` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms5` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms6` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms7` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms8` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_terms9` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsa` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsb` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsc` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsd` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termse` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_links_termsf` (
`link_id` int(1) unsigned NOT NULL,
`term_id` int(1) unsigned NOT NULL,
`weight` float unsigned NOT NULL,
PRIMARY KEY (`link_id`,`term_id`),
KEY `idx_term_weight` (`term_id`,`weight`),
KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_taxonomy` (
`id` int(1) unsigned NOT NULL auto_increment,
`parent_id` int(1) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL,
`state` tinyint(1) unsigned NOT NULL default '1',
`access` tinyint(1) unsigned NOT NULL default '0',
`ordering` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `state` (`state`),
KEY `ordering` (`ordering`),
KEY `access` (`access`),
KEY `idx_parent_published` (`parent_id`,`state`,`access`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_taxonomy_map` (
`link_id` int(1) unsigned NOT NULL,
`node_id` int(1) unsigned NOT NULL,
PRIMARY KEY (`link_id`,`node_id`),
KEY `link_id` (`link_id`),
KEY `node_id` (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_terms` (
`term_id` int(1) unsigned NOT NULL auto_increment,
`term` varchar(75) NOT NULL,
`stem` varchar(75) NOT NULL,
`common` tinyint(1) unsigned NOT NULL default '0',
`phrase` tinyint(1) unsigned NOT NULL default '0',
`weight` float unsigned NOT NULL default '0',
`soundex` varchar(75) NOT NULL,
`links` int(1) NOT NULL default '0',
PRIMARY KEY (`term_id`),
UNIQUE KEY `idx_term` (`term`),
KEY `idx_term_phrase` (`term`,`phrase`),
KEY `idx_stem_phrase` (`stem`,`phrase`),
KEY `idx_soundex_phrase` (`soundex`,`phrase`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_terms_common` (
`term` varchar(75) NOT NULL,
`language` varchar(3) NOT NULL,
KEY `idx_word_lang` (`term`,`language`),
KEY `idx_lang` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_tokens` (
`term` varchar(75) NOT NULL,
`stem` varchar(75) NOT NULL,
`common` tinyint(1) unsigned NOT NULL default '0',
`phrase` tinyint(1) unsigned NOT NULL default '0',
`weight` float unsigned NOT NULL default '1',
`context` tinyint(1) unsigned NOT NULL default '2',
KEY `idx_word` (`term`),
KEY `idx_context` (`context`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_tokens_aggregate` (
`term_id` int(1) unsigned NOT NULL,
`map_suffix` char(1) NOT NULL,
`term` varchar(75) NOT NULL,
`stem` varchar(75) NOT NULL,
`common` tinyint(1) unsigned NOT NULL default '0',
`phrase` tinyint(1) unsigned NOT NULL default '0',
`term_weight` float unsigned NOT NULL,
`context` tinyint(1) unsigned NOT NULL default '2',
`context_weight` float unsigned NOT NULL,
`total_weight` float unsigned NOT NULL,
KEY `token` (`term`),
KEY `keyword_id` (`term_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__finder_types` (
`id` int(1) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL,
`mime` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__languages` (
`lang_id` int(1) unsigned NOT NULL auto_increment,
`lang_code` char(7) NOT NULL,
`title` varchar(50) NOT NULL,
`title_native` varchar(50) NOT NULL,
`sef` varchar(50) NOT NULL,
`image` varchar(50) NOT NULL,
`description` varchar(512) NOT NULL,
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`sitename` varchar(1024) NOT NULL default '',
`published` int(1) NOT NULL default '0',
`access` int(1) unsigned NOT NULL DEFAULT '0',
`ordering` int(1) NOT NULL default '0',
PRIMARY KEY (`lang_id`),
UNIQUE `idx_sef` (`sef`),
UNIQUE `idx_image` (`image`),
UNIQUE `idx_langcode` (`lang_code`),
KEY `idx_access` (`access`),
INDEX `idx_ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__menu` (
`id` int(1) NOT NULL AUTO_INCREMENT,
`menutype` varchar(24) NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype',
`title` varchar(255) NOT NULL COMMENT 'The display title of the menu item.',
`alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The SEF alias of the menu item.',
`note` varchar(255) NOT NULL DEFAULT '',
`path` varchar(1024) NOT NULL COMMENT 'The computed path of the menu item based on the alias field.',
`link` varchar(1024) NOT NULL COMMENT 'The actually link the menu item refers to.',
`type` varchar(16) NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator',
`published` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The published state of the menu link.',
`parent_id` int(1) unsigned NOT NULL DEFAULT '1' COMMENT 'The parent menu item in the menu tree.',
`level` int(1) unsigned NOT NULL DEFAULT '0' COMMENT 'The relative level in the tree.',
`component_id` int(1) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__extensions.id',
`ordering` int(1) NOT NULL DEFAULT '0' COMMENT 'The relative ordering of the menu item in the tree.',
`checked_out` int(1) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__users.id',
`checked_out_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the menu item was checked out.',
`browserNav` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The click behaviour of the link.',
`access` int(1) unsigned NOT NULL DEFAULT '0' COMMENT 'The access level required to view the menu item.',
`img` varchar(255) NOT NULL COMMENT 'The image of the menu item.',
`template_style_id` int(1) unsigned NOT NULL DEFAULT '0',
`params` TEXT NOT NULL COMMENT 'JSON encoded data for the menu item.',
`lft` int(1) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
`rgt` int(1) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
`home` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Indicates if this menu item is the home or default page.',
`language` char(7) NOT NULL DEFAULT '',
`client_id` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`, `language`),
KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`),
KEY `idx_menutype` (`menutype`),
KEY `idx_left_right` (`lft`,`rgt`),
KEY `idx_alias` (`alias`),
KEY `idx_path` (`path`(333)),
KEY `idx_language` (`language`),
KEY `home` (`home`),
KEY `client_id` (`client_id`),
KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__menu_types` (
`id` int(1) unsigned NOT NULL auto_increment,
`menutype` varchar(24) NOT NULL,
`title` varchar(48) NOT NULL,
`description` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE `idx_menutype` (`menutype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__messages` (
`message_id` int(1) unsigned NOT NULL auto_increment,
`user_id_from` int(1) unsigned NOT NULL default '0',
`user_id_to` int(1) unsigned NOT NULL default '0',
`folder_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`state` tinyint(1) NOT NULL DEFAULT '0',
`priority` tinyint(1) unsigned NOT NULL DEFAULT '0',
`subject` varchar(255) NOT NULL DEFAULT '',
`message` text NOT NULL,
PRIMARY KEY (`message_id`),
KEY `useridto_state` (`user_id_to`, `state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__messages_cfg` (
`user_id` int(1) unsigned NOT NULL default '0',
`cfg_name` varchar(100) NOT NULL default '',
`cfg_value` varchar(255) NOT NULL default '',
UNIQUE `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__modules` (
`id` int(1) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL DEFAULT '',
`note` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`ordering` int(1) NOT NULL DEFAULT '0',
`position` varchar(50) NOT NULL DEFAULT '',
`checked_out` int(1) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL DEFAULT '0',
`module` varchar(50) DEFAULT NULL,
`access` int(1) unsigned NOT NULL DEFAULT '0',
`showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
`params` TEXT NOT NULL,
`client_id` tinyint(4) NOT NULL DEFAULT '0',
`language` char(7) NOT NULL,
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`),
KEY `idx_language` (`language`),
KEY `ordering` (`ordering`),
KEY `client_id` (`client_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__modules_menu` (
`moduleid` int(1) NOT NULL default '0',
`menuid` int(1) NOT NULL default '0',
PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__newsfeeds` (
`catid` int(1) NOT NULL default '0',
`id` integer(10) UNSIGNED NOT NULL auto_increment,
`name` varchar(100) NOT NULL DEFAULT '',
`alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
`link` varchar(200) NOT NULL DEFAULT '',
`filename` varchar(200) default NULL,
`published` tinyint(1) NOT NULL default '0',
`numarticles` int(1) unsigned NOT NULL default '1',
`cache_time` int(1) unsigned NOT NULL default '3600',
`checked_out` integer(10) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(1) NOT NULL default '0',
`rtl` tinyint(4) NOT NULL default '0',
`access` int(1) UNSIGNED NOT NULL DEFAULT '0',
`language` char(7) NOT NULL DEFAULT '',
`params` text NOT NULL,
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(1) unsigned NOT NULL default '0',
`created_by_alias` varchar(255) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(1) unsigned NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`metadata` text NOT NULL,
`xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`published`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`),
KEY `idx_language` (`language`),
KEY `idx_xreference` (`xreference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__overrider` (
`id` int(1) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`constant` varchar(255) NOT NULL,
`string` text NOT NULL,
`file` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__redirect_links` (
`id` int(1) unsigned NOT NULL auto_increment,
`old_url` varchar(255) NOT NULL,
`new_url` varchar(255) NOT NULL,
`referer` varchar(150) NOT NULL,
`comment` varchar(255) NOT NULL,
`hits` int(1) unsigned NOT NULL default '0',
`published` tinyint(4) NOT NULL,
`created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_link_old` (`old_url`),
KEY `idx_link_modifed` (`modified_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__schemas` (
`extension_id` int(1) NOT NULL,
`version_id` varchar(20) NOT NULL,
PRIMARY KEY (`extension_id`, `version_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__session` (
`session_id` varchar(200) NOT NULL default '',
`client_id` tinyint(3) unsigned NOT NULL default '0',
`guest` tinyint(4) unsigned default '1',
`time` varchar(14) default '',
`data` text default NULL,
`userid` int(1) default '0',
`username` varchar(150) default '',
`usertype` varchar(50) default '',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `#__updates` (
`update_id` int(1) NOT NULL auto_increment,
`update_site_id` int(1) default '0',
`extension_id` int(1) default '0',
`categoryid` int(1) default '0',
`name` varchar(100) default '',
`description` text NOT NULL,
`element` varchar(100) default '',
`type` varchar(20) default '',
`folder` varchar(20) default '',
`client_id` tinyint(3) default '0',
`version` varchar(10) default '',
`data` text NOT NULL,
`detailsurl` text NOT NULL,
`infourl` text NOT NULL,
PRIMARY KEY (`update_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Available Updates';
CREATE TABLE `#__update_sites` (
`update_site_id` int(1) NOT NULL auto_increment,
`name` varchar(100) default '',
`type` varchar(20) default '',
`location` text NOT NULL,
`enabled` int(1) default '0',
`last_check_timestamp` bigint(20) DEFAULT '0',
PRIMARY KEY (`update_site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Update Sites';
CREATE TABLE `#__update_sites_extensions` (
`update_site_id` INT DEFAULT 0,
`extension_id` INT DEFAULT 0,
PRIMARY KEY(`update_site_id`, `extension_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT = 'Links extensions to update sites';
CREATE TABLE `#__update_categories` (
`categoryid` int(1) NOT NULL auto_increment,
`name` varchar(20) default '',
`description` text NOT NULL,
`parent` int(1) default '0',
`updatesite` int(1) default '0',
PRIMARY KEY (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Update Categories';
CREATE TABLE IF NOT EXISTS `#__template_styles` (
`id` int(1) unsigned NOT NULL AUTO_INCREMENT,
`template` varchar(50) NOT NULL DEFAULT '',
`client_id` tinyint(1) unsigned NOT NULL DEFAULT '0',
`home` tinyint(1) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`params` TEXT NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_template` (`template`),
KEY `idx_home` (`home`),
KEY `client_id` (`client_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
CREATE TABLE IF NOT EXISTS `#__user_usergroup_map` (
`user_id` int(1) unsigned NOT NULL default '0' COMMENT 'Foreign Key to #__users.id',
`group_id` int(1) unsigned NOT NULL default '0' COMMENT 'Foreign Key to #__usergroups.id',
PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__usergroups` (
`id` int(1) unsigned NOT NULL auto_increment COMMENT 'Primary Key',
`parent_id` int(1) unsigned NOT NULL default '0' COMMENT 'Adjacency List Reference Id',
`lft` int(1) NOT NULL default '0' COMMENT 'Nested set lft.',
`rgt` int(1) NOT NULL default '0' COMMENT 'Nested set rgt.',
`title` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
KEY `idx_usergroup_title_lookup` (`title`),
KEY `idx_usergroup_adjacency_lookup` (`parent_id`),
KEY `idx_usergroup_nested_set_lookup` USING BTREE (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `#__users` (
`id` int(1) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`username` varchar(150) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '0',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
`lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset',
`resetCount` int(1) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime',
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`),
KEY `idx_block` (`block`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__user_notes` (
`id` int(1) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(1) unsigned NOT NULL DEFAULT '0',
`catid` int(1) unsigned NOT NULL DEFAULT '0',
`subject` varchar(100) NOT NULL DEFAULT '',
`body` text NOT NULL,
`state` tinyint(3) NOT NULL DEFAULT '0',
`checked_out` int(1) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_user_id` int(1) unsigned NOT NULL DEFAULT '0',
`created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_user_id` int(1) unsigned NOT NULL,
`modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`),
KEY `idx_category_id` (`catid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__user_profiles` (
`user_id` int(1) NOT NULL,
`profile_key` varchar(100) NOT NULL,
`profile_value` varchar(16384) NOT NULL,
`ordering` int(1) NOT NULL default '0',
UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Simple user profile storage table';
CREATE TABLE `#__weblinks` (
`id` int(1) unsigned NOT NULL auto_increment,
`catid` int(1) NOT NULL default '0',
`sid` int(1) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '',
`url` varchar(250) NOT NULL default '',
`description` TEXT NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(1) NOT NULL default '0',
`state` tinyint(1) NOT NULL default '0',
`checked_out` int(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(1) NOT NULL default '0',
`archived` tinyint(1) NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '1',
`access` int(1) NOT NULL default '1',
`params` text NOT NULL,
`language` char(7) NOT NULL DEFAULT '',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(1) unsigned NOT NULL default '0',
`created_by_alias` varchar(255) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(1) unsigned NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`metadata` text NOT NULL,
`featured` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Set if link is featured.',
`xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`),
KEY `idx_featured_catid` (`featured`,`catid`),
KEY `idx_language` (`language`),
KEY `idx_xreference` (`xreference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__viewlevels` (
`id` int(1) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`title` varchar(100) NOT NULL DEFAULT '',
`ordering` int(1) NOT NULL DEFAULT '0',
`rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_assetgroup_title_lookup` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;