Добрый день!
Решил познакомиться с Кобальтом поближе, скачал и установил pkg_cobalt.j3.v.8.633 на локальной машине, после установке мне выдало следующее сообщение, так и должно быть?
Сообщение
Table created: CREATE TABLE IF NOT EXISTS ok6pv_js_ip_2_country
(ip_from
INT(10) NOT NULL DEFAULT '0' COMMENT '', ip_to
INT(10) NOT NULL DEFAULT '0' COMMENT '', short_code
VARCHAR(2) NOT NULL DEFAULT '' COMMENT '', code
VARCHAR(3) NOT NULL DEFAULT '' COMMENT '', country
VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', KEY 0
(ip_from), KEY 1
(ip_to)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Table created: CREATE TABLE IF NOT EXISTS ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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
TINYINT(1) 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 ok6pv_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 ok6pv_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 ok6pv_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 '', category_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 '', 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 ok6pv_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 ok6pv_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 ok6pv_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_user
(user_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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 ok6pv_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;
Установка пакета успешно завершена.
Добрый день! Решил познакомиться с Кобальтом поближе, скачал и установил pkg_cobalt.j3.v.8.633 на локальной машине, после установке мне выдало следующее сообщение, так и должно быть?
Сообщение Table created: CREATE TABLE IF NOT EXISTS
ok6pv_js_ip_2_country
(ip_from
INT(10) NOT NULL DEFAULT '0' COMMENT '',ip_to
INT(10) NOT NULL DEFAULT '0' COMMENT '',short_code
VARCHAR(2) NOT NULL DEFAULT '' COMMENT '',code
VARCHAR(3) NOT NULL DEFAULT '' COMMENT '',country
VARCHAR(100) NOT NULL DEFAULT '' COMMENT '', KEY0
(ip_from), KEY1
(ip_to)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_record
(record_id
), KEYidx_section
(section_id
), KEYidx_type
(type_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_record
(record_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_rec
(record_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYcat_idx
(published
,access
), KEYidx_access
(access
), KEYidx_checkout
(checked_out
), KEYidx_path
(path
), KEYidx_left_right
(lft
,rgt
), KEYidx_alias
(alias
), KEYidx_language
(language
), KEYidx_parent
(parent_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
ok6pv_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
), KEYuser
(user_id
,section_id
), KEYpublish
(published
), KEYclient_id
(client_id
), KEYclient
(client
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_publish
(published
), KEYidx_record
(record_id
), KEYidx_user
(user_id
), KEYidx_section
(section_id
), KEYidx_lr
(lft
,rgt
), KEYidx_access
(access
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
ok6pv_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
), KEYidx_user
(user_id
), KEYidx_record
(record_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_sect
(section_id
), KEYidx_key
(field_key
), KEYidx_fid
(field_id
)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_field
(field_id
), KEYidx_lr
(lft
,rgt
), KEYidx_parent
(parent_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_user
(user_id
), KEYidx_record
(record_id
), KEYidx_field
(field_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
ok6pv_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
), KEYidx_type
(type_id
), KEYidx_access
(access
), KEYidx_publish
(published
,type_id
,filter
,key
), KEYidx_group
(group_id
), KEYidx_filter
(filter
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_type
(type_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_name
(filename
), KEYidx_record
(record_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_record
(record_id
), KEYidex_user
(section_id
,user_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
ok6pv_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
), KEYidx_import
(import
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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 KEYind
(user_id
,section_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_r_1
(ref_1
), KEYidx_r_2
(ref_2
), KEYidx_ruser
(user_id
)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
ok6pv_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
ok6pv_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
), KEYrecord
(record_id
), KEYuser
(user_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
TINYINT(1) 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
), KEYidx_type
(type_id
), KEYidx_section
(section_id
), KEYidx_published
(published
), KEYidx_user
(user_id
), KEYidx_access
(access
), KEYidx_ctime
(ctime
), KEYidx_extime
(extime
), KEYidx_featured
(featured
), KEYidx_ucat
(ucatid
), KEYidx_lang
(langs
), KEYidx_parent
(parent_id
), KEYidx_mtime
(mtime
), KEYidx_name
(title
), KEYidx_comment
(comments
), KEYidx_vote
(votes_result
), FULLTEXT KEYfull
(fieldsdata
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYrec
(record_id
), KEYidx_cat
(section_id
,catid
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_record
(record_id
), KEYidx_host
(host_id
)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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 '',category_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 '', PRIMARY KEY (id
), KEYidx_values
(field_value
(333)), KEYidx_key
(field_key
), KEYidx_record
(record_id
), KEYidx_field
(field_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_saler
(saler_id
), KEYidx_buyer
(user_id
), KEYidx_rec
(record_id
), KEYidx_sec
(section_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
ok6pv_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
), KEYidx_user
(user_id
), KEYidx_rf
(ref_id
), KEYidx_us
(user_id
,section_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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 KEYidx_u
(cat_id
,section_id
,user_id
), KEYidx_sec
(section_id
), KEYidx_cat
(cat_id
)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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 KEYidx_u
(u_id
,section_id
,user_id
), KEYidx_sec
(section_id
), KEYidx_cat
(u_id
)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
ok6pv_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
), KEYrecord
(record_id
), KEYtag
(tag_id
), KEYuser
(user_id
), KEYsection
(section_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYpublished
(published
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_sch
(schedule
), KEYidx_sent
(lastsend
), KEYidx_user
(user_id
)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_sec
(section_id
)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYidx_us
(user_id
,section_id
)) ENGINE=InnoDB DEFAULT CHARSET=utf8;Table created: CREATE TABLE IF NOT EXISTS
ok6pv_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
), KEYrecord
(ref_id
), KEYuser
(user_id
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;Установка пакета успешно завершена.