text: 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;
  