Warning
JInstaller: :Install: Can't find XML setup file.
×
Message
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_audit_log` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `record_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `type_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `comment_id` INT(11) NULL DEFAULT '0' COMMENT '', `field_id` INT(11) NULL DEFAULT '0' COMMENT '', `event` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `ip` VARCHAR(16) NOT NULL DEFAULT 'Not detected' COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', PRIMARY KEY (`id`), KEY `idx_record` (`record_id`), KEY `idx_section` (`section_id`), KEY `idx_type` (`type_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_audit_restore` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_id` INT(11) NULL DEFAULT '0' COMMENT '', `dtime` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `comments` LONGTEXT NULL DEFAULT NULL COMMENT '', `favorites` TEXT NULL DEFAULT NULL COMMENT '', `files` TEXT NULL DEFAULT NULL COMMENT '', `hits` TEXT NULL DEFAULT NULL COMMENT '', `subscriptions` TEXT NULL DEFAULT NULL COMMENT '', `votes` TEXT NULL DEFAULT NULL COMMENT '', `notifications` TEXT NULL DEFAULT NULL COMMENT '', `type_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_record` (`record_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_audit_versions` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `record_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `type_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `username` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `ctime` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `version` INT(10) NOT NULL DEFAULT '0' COMMENT '', `record_serial` LONGTEXT NOT NULL DEFAULT '' COMMENT '', `values_serial` LONGTEXT NOT NULL DEFAULT '' COMMENT '', `category_serial` LONGTEXT NOT NULL DEFAULT '' COMMENT '', `tags_serial` LONGTEXT NULL DEFAULT NULL COMMENT '', `ip` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY (`id`), KEY `idx_rec` (`record_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_categories` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `asset_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `parent_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `lft` INT(11) NOT NULL DEFAULT '0' COMMENT '', `rgt` INT(11) NOT NULL DEFAULT '0' COMMENT '', `level` INT(10) NOT NULL DEFAULT '0' COMMENT '', `path` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `alias` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `note` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `description` VARCHAR(5120) NOT NULL DEFAULT '' COMMENT '', `image` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `checked_out` INT(11) NOT NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `access` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NOT NULL DEFAULT '' COMMENT '', `metadesc` VARCHAR(1024) NOT NULL DEFAULT '' COMMENT '', `metakey` VARCHAR(1024) NOT NULL DEFAULT '' COMMENT '', `metadata` VARCHAR(2048) NOT NULL DEFAULT '' COMMENT '', `created_user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `created_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `modified_user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `modified_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `hits` INT(10) NOT NULL DEFAULT '0' COMMENT '', `language` CHAR(7) NOT NULL DEFAULT '' COMMENT '', `num_current` INT(11) NOT NULL DEFAULT '0' COMMENT '', `num_all` INT(11) NOT NULL DEFAULT '0' COMMENT '', `relative_cats` TEXT NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY (`id`), KEY `cat_idx` (`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`), KEY `idx_language` (`language`), KEY `idx_parent` (`parent_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_category_filters` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `field_id` INT(11) NULL DEFAULT '0' COMMENT '', `category_id` INT(11) NULL DEFAULT '0' COMMENT '', `record_id` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_category_user` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `params` TEXT NOT NULL DEFAULT '' COMMENT '', `name` VARCHAR(150) NOT NULL DEFAULT '' COMMENT '', `ordering` INT(10) NOT NULL DEFAULT '0' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `access` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `description` TEXT NOT NULL DEFAULT '' COMMENT '', `checked_out` INT(10) NOT NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `hits` INT(10) NOT NULL DEFAULT '0' COMMENT '', `rate` INT(10) NOT NULL DEFAULT '0' COMMENT '', `rate_count` INT(10) NOT NULL DEFAULT '0' COMMENT '', `icon` VARCHAR(45) NOT NULL DEFAULT '' COMMENT '', `mtime` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `alias` VARCHAR(250) NOT NULL DEFAULT '' COMMENT '', `client_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `client` VARCHAR(200) NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY (`id`), KEY `user` (`user_id`,`section_id`), KEY `publish` (`published`), KEY `client_id` (`client_id`), KEY `client` (`client`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_comments` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `comment` TEXT NOT NULL DEFAULT '' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `email` VARCHAR(200) NOT NULL DEFAULT '' COMMENT '', `name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '', `langs` VARCHAR(10) NOT NULL DEFAULT 'en-GB' COMMENT '', `access` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `rate` INT(11) NOT NULL DEFAULT '0' COMMENT '', `parent_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `root_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `level` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '', `hide` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', `attachment` TEXT NOT NULL DEFAULT '' COMMENT '', `attach_hit` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ip` VARCHAR(16) NOT NULL DEFAULT '' COMMENT '', `lft` INT(11) NOT NULL DEFAULT '0' COMMENT '', `rgt` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `private` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `rate_num` INT(11) NOT NULL DEFAULT '0' COMMENT '', `type_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_publish` (`published`), KEY `idx_record` (`record_id`), KEY `idx_user` (`user_id`), KEY `idx_section` (`section_id`), KEY `idx_lr` (`lft`,`rgt`), KEY `idx_access` (`access`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_country` (`id` VARCHAR(2) NOT NULL DEFAULT '' COMMENT '', `name` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '') ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_favorite` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `record_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `type_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_record` (`record_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_field_geo` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `country` CHAR(2) NULL DEFAULT NULL COMMENT '', `state` VARCHAR(150) NULL DEFAULT NULL COMMENT '', `city` VARCHAR(200) NULL DEFAULT NULL COMMENT '', `zip` VARCHAR(15) NULL DEFAULT NULL COMMENT '', `lat` FLOAT(18,15) NULL DEFAULT NULL COMMENT '', `lng` FLOAT(18,15) NULL DEFAULT NULL COMMENT '', `state_trans` VARCHAR(150) NULL DEFAULT NULL COMMENT '', `city_trans` VARCHAR(200) NULL DEFAULT NULL COMMENT '', `section_id` INT(11) NULL DEFAULT '0' COMMENT '', `field_id` INT(11) NULL DEFAULT '0' COMMENT '', `field_key` VARCHAR(38) NULL DEFAULT NULL COMMENT '', `record_id` INT(11) NULL DEFAULT '0' COMMENT '', `user_id` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_sect` (`section_id`), KEY `idx_key` (`field_key`), KEY `idx_fid` (`field_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_field_multilevelselect` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NULL DEFAULT NULL COMMENT '', `field_id` INT(11) NULL DEFAULT '0' COMMENT '', `parent_id` INT(11) NULL DEFAULT '0' COMMENT '', `level` INT(11) NULL DEFAULT '0' COMMENT '', `lft` INT(11) NULL DEFAULT '0' COMMENT '', `rgt` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_field` (`field_id`), KEY `idx_lr` (`lft`,`rgt`), KEY `idx_parent` (`parent_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_field_stepaccess` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `record_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `field_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_record` (`record_id`), KEY `idx_field` (`field_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_field_telephone` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `code2` VARCHAR(2) NOT NULL DEFAULT '' COMMENT '', `code3` VARCHAR(3) NOT NULL DEFAULT '' COMMENT '', `phone_code` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_fields` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `key` VARCHAR(45) NULL DEFAULT NULL COMMENT '', `label` VARCHAR(250) NOT NULL DEFAULT '' COMMENT '', `type_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `field_type` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '', `params` LONGTEXT NOT NULL DEFAULT '' COMMENT '', `checked_out` INT(10) NOT NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `ordering` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '', `access` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `group_id` INT(11) NULL DEFAULT '0' COMMENT '', `asset_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `filter` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_type` (`type_id`), KEY `idx_access` (`access`), KEY `idx_publish` (`published`,`type_id`,`filter`,`key`), KEY `idx_group` (`group_id`), KEY `idx_filter` (`filter`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_fields_group` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` VARCHAR(250) NOT NULL DEFAULT '' COMMENT '', `type_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ordering` INT(10) NOT NULL DEFAULT '0' COMMENT '', `description` TEXT NOT NULL DEFAULT '' COMMENT '', `checked_out` INT(11) NOT NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `icon` VARCHAR(100) NULL DEFAULT NULL COMMENT '', PRIMARY KEY (`id`), KEY `idx_type` (`type_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_files` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `filename` VARCHAR(55) NOT NULL DEFAULT '' COMMENT '', `realname` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `saved` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', `section_id` INT(11) NULL DEFAULT '0' COMMENT '', `record_id` INT(11) NULL DEFAULT '0' COMMENT '', `type_id` INT(11) NULL DEFAULT '0' COMMENT '', `field_id` INT(11) NULL DEFAULT '0' COMMENT '', `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `ext` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '', `fullpath` TEXT NOT NULL DEFAULT '' COMMENT '', `hits` INT(11) NOT NULL DEFAULT '0' COMMENT '', `size` INT(11) NOT NULL DEFAULT '0' COMMENT '', `ip` VARCHAR(20) NOT NULL DEFAULT 'Not detected' COMMENT '', `width` INT(11) NULL DEFAULT '0' COMMENT '', `height` INT(11) NULL DEFAULT '0' COMMENT '', `rating` DOUBLE NULL DEFAULT NULL COMMENT '', `rating_nums` INT(11) NULL DEFAULT '0' COMMENT '', `comments` TEXT NULL DEFAULT NULL COMMENT '', `comment_num` INT(11) NULL DEFAULT '0' COMMENT '', `title` TEXT NULL DEFAULT NULL COMMENT '', `description` TEXT NULL DEFAULT NULL COMMENT '', `views` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_name` (`filename`), KEY `idx_record` (`record_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_hits` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ip` VARCHAR(16) NOT NULL DEFAULT '' COMMENT '', `section_id` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_record` (`record_id`), KEY `idex_user` (`section_id`,`user_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_import` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` VARCHAR(40) NULL DEFAULT NULL COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', `user_id` INT(11) NULL DEFAULT '0' COMMENT '', `crossids` TEXT NULL DEFAULT NULL COMMENT '', `section_id` INT(11) NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_import_rows` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `import` INT(11) NULL DEFAULT '0' COMMENT '', `text` TEXT NULL DEFAULT NULL COMMENT '', `ctime` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', PRIMARY KEY (`id`), KEY `idx_import` (`import`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_moderators` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `description` TEXT NULL DEFAULT NULL COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `checked_out` INT(11) NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `icon` VARCHAR(20) NULL DEFAULT NULL COMMENT '', `is_moderator` TINYINT(1) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), UNIQUE KEY `ind` (`user_id`,`section_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_notifications` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `option` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', `type` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `notified` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `alerted` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NOT NULL DEFAULT '' COMMENT '', `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `ref_1` INT(11) NULL DEFAULT '0' COMMENT '', `ref_2` INT(11) NULL DEFAULT '0' COMMENT '', `ref_3` INT(11) NULL DEFAULT '0' COMMENT '', `ref_4` INT(11) NULL DEFAULT '0' COMMENT '', `ref_5` INT(11) NULL DEFAULT '0' COMMENT '', `html` TEXT NOT NULL DEFAULT '' COMMENT '', `num` INT(11) NULL DEFAULT '0' COMMENT '', `state_new` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '', `eventer` INT(11) NOT NULL DEFAULT '1' COMMENT '', PRIMARY KEY (`id`), KEY `idx_r_1` (`ref_1`), KEY `idx_r_2` (`ref_2`), KEY `idx_ruser` (`user_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_packs` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `description` TEXT NULL DEFAULT NULL COMMENT '', `key` CHAR(10) NOT NULL DEFAULT '' COMMENT '', `addkey` TINYINT(2) NOT NULL DEFAULT '1' COMMENT '', `add_files` TEXT NULL DEFAULT NULL COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `mtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `btime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `version` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '', `checked_out` INT(11) NOT NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `users` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '', `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `author_name` TEXT NULL DEFAULT NULL COMMENT '', `author_email` TEXT NULL DEFAULT NULL COMMENT '', `author_url` TEXT NULL DEFAULT NULL COMMENT '', `demo` TINYINT(1) NULL DEFAULT '0' COMMENT '', `copyright` VARCHAR(255) NULL DEFAULT NULL COMMENT '', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_packs_sections` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pack_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NOT NULL DEFAULT '' COMMENT '', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_polls` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `question` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `answer` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `record_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `record` (`record_id`), KEY `user` (`user_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_record` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `access` INT(10) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NOT NULL DEFAULT '' COMMENT '', `user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `checked_out` INT(10) NOT NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `extime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `mtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `inittime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `ftime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `pubtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `type_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `hits` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ordering` INT(10) NOT NULL DEFAULT '0' COMMENT '', `meta_descr` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `meta_key` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `meta_index` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '', `alias` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `featured` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `archive` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `ucatid` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ucatname` VARCHAR(150) NULL DEFAULT NULL COMMENT '', `langs` VARCHAR(10) NOT NULL DEFAULT '' COMMENT '', `asset_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `ip` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '', `votes` INT(10) NOT NULL DEFAULT '0' COMMENT '', `favorite_num` INT(10) NOT NULL DEFAULT '0' COMMENT '', `hidden` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '', `votes_result` INT(10) NOT NULL DEFAULT '0' COMMENT '', `exalert` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `access_key` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '', `categories` MEDIUMTEXT NULL DEFAULT NULL COMMENT '', `fieldsdata` LONGTEXT NULL DEFAULT NULL COMMENT '', `fields` LONGTEXT NOT NULL DEFAULT '' COMMENT '', `comments` INT(11) NULL DEFAULT '0' COMMENT '', `tags` TEXT NOT NULL DEFAULT '' COMMENT '', `multirating` TEXT NULL DEFAULT NULL COMMENT '', `subscriptions_num` INT(11) NULL DEFAULT '0' COMMENT '', `version` INT(10) NOT NULL DEFAULT '1' COMMENT '', `parent_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `parent` VARCHAR(45) NOT NULL DEFAULT 'com_cobalt' COMMENT '', `whorepost` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `repostedby` TEXT NULL DEFAULT NULL COMMENT '', `newTags` VARCHAR(45) NULL DEFAULT NULL COMMENT '', PRIMARY KEY (`id`), KEY `idx_type` (`type_id`), KEY `idx_section` (`section_id`), KEY `idx_published` (`published`), KEY `idx_user` (`user_id`), KEY `idx_access` (`access`), KEY `idx_ctime` (`ctime`), KEY `idx_extime` (`extime`), KEY `idx_featured` (`featured`), KEY `idx_ucat` (`ucatid`), KEY `idx_lang` (`langs`), KEY `idx_parent` (`parent_id`), KEY `idx_mtime` (`mtime`), KEY `idx_name` (`title`), KEY `idx_comment` (`comments`), KEY `idx_vote` (`votes_result`), FULLTEXT KEY `full` (`fieldsdata`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_record_category` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `catid` INT(10) NOT NULL DEFAULT '0' COMMENT '', `record_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ordering` INT(10) NOT NULL DEFAULT '0' COMMENT '', `otime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '', `access` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '', PRIMARY KEY (`id`), KEY `rec` (`record_id`), KEY `idx_cat` (`section_id`,`catid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_record_repost` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `host_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `record_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `is_reposted` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `category` VARCHAR(100) NULL DEFAULT NULL COMMENT '', PRIMARY KEY (`id`), KEY `idx_record` (`record_id`), KEY `idx_host` (`host_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_record_values` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `field_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `field_key` VARCHAR(45) NOT NULL DEFAULT '' COMMENT '', `field_type` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', `field_label` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', `field_value` LONGTEXT NOT NULL DEFAULT '' COMMENT '', `record_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `type_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', `ip` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `value_index` VARCHAR(40) NOT NULL DEFAULT '0' COMMENT '', `value_num` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_values` (`field_value`(333)), KEY `idx_key` (`field_key`), KEY `idx_record` (`record_id`), KEY `idx_field` (`field_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_sales` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `saler_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `record_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `field_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `type_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `num` INT(11) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', `status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `comment` VARCHAR(255) NULL DEFAULT NULL COMMENT '', `name` VARCHAR(250) NULL DEFAULT NULL COMMENT '', `amount` FLOAT NULL DEFAULT NULL COMMENT '', `gateway_id` VARCHAR(45) NOT NULL DEFAULT '' COMMENT '', `gateway` VARCHAR(45) NOT NULL DEFAULT '' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `mtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `currency` VARCHAR(10) NULL DEFAULT NULL COMMENT '', PRIMARY KEY (`id`), KEY `idx_saler` (`saler_id`), KEY `idx_buyer` (`user_id`), KEY `idx_rec` (`record_id`), KEY `idx_sec` (`section_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_sections` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `asset_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `alias` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `description` TEXT NOT NULL DEFAULT '' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `ordering` INT(10) NOT NULL DEFAULT '0' COMMENT '', `image` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `image_position` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '', `params` TEXT NOT NULL DEFAULT '' COMMENT '', `checked_out` INT(11) NOT NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `access` INT(11) NOT NULL DEFAULT '0' COMMENT '', `categories` INT(11) NULL DEFAULT '0' COMMENT '', `language` CHAR(7) NOT NULL DEFAULT '*' COMMENT '', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_subscribe` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `ref_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `type` VARCHAR(20) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', `section_id` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_rf` (`ref_id`), KEY `idx_us` (`user_id`,`section_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_subscribe_cat` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `cat_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `exclude` TINYINT(1) NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', PRIMARY KEY (`id`), UNIQUE KEY `idx_u` (`cat_id`,`section_id`,`user_id`), KEY `idx_sec` (`section_id`), KEY `idx_cat` (`cat_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_subscribe_user` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `u_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `exclude` TINYINT(1) NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', PRIMARY KEY (`id`), UNIQUE KEY `idx_u` (`u_id`,`section_id`,`user_id`), KEY `idx_sec` (`section_id`), KEY `idx_cat` (`u_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_tags` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `tag` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `slug` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '', `language` VARCHAR(10) NULL DEFAULT 'en-GB' COMMENT '', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_tags_history` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `record_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `tag_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `section_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `hits` INT(10) NOT NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `record` (`record_id`), KEY `tag` (`tag_id`), KEY `user` (`user_id`), KEY `section` (`section_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_types` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', `params` TEXT NOT NULL DEFAULT '' COMMENT '', `checked_out` INT(10) NOT NULL DEFAULT '0' COMMENT '', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `published` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', `description` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '', `form` VARCHAR(45) NULL DEFAULT NULL COMMENT '', `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `asset_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `language` CHAR(7) NOT NULL DEFAULT '*' COMMENT '', PRIMARY KEY (`id`), KEY `published` (`published`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_user_options` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `params` TEXT NULL DEFAULT NULL COMMENT '', `lastsend` DATETIME NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `schedule` TINYINT(1) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_sch` (`schedule`), KEY `idx_sent` (`lastsend`), KEY `idx_user` (`user_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_user_options_autofollow` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_sec` (`section_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_user_post_map` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `section_id` INT(11) NOT NULL DEFAULT '0' COMMENT '', `whopost` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `idx_us` (`user_id`,`section_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS `Sp1959_js_res_vote` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ref_id` INT(10) NOT NULL DEFAULT '0' COMMENT '', `vote` INT(10) NOT NULL DEFAULT '0' COMMENT '', `ctime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '', `ip` VARCHAR(16) NOT NULL DEFAULT '' COMMENT '', `ref_type` VARCHAR(25) NOT NULL DEFAULT '' COMMENT '', `section_id` INT(11) NULL DEFAULT '0' COMMENT '', `idx` INT(11) NULL DEFAULT '0' COMMENT '', PRIMARY KEY (`id`), KEY `record` (`ref_id`), KEY `user` (`user_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Installation of the package was successful.
Warning
JInstaller: :Install: Can't find XML setup file. × Message
Installation of the package was successful.