| Server IP : 54.36.91.62 / Your IP : 216.73.217.117 Web Server : Apache System : Linux webm013.cluster127.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : coopiak ( 151928) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/coopiak/www/cj79373/administrator/components/com_kunena/install/ |
Upload File : |
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE schema>
<schema>
<table name="kunena_aliases">
<field primary_key="yes"
name="alias"
type="varchar(190)"
null="0"/>
<field name="type"
type="varchar(10)"
null="0"/>
<field name="item"
type="varchar(32)"
null="0"/>
<field name="state"
type="tinyint(4)"
null="0"
default="0"/>
<key name="alias"
unique="1"
columns="alias"/>
<key name="state"
columns="state"/>
<key name="item"
columns="item"/>
<key name="type"
columns="type"/>
</table>
<table name="kunena_announcement">
<field primary_key="yes"
name="id"
type="int(3)"
null="0"
extra="auto_increment"/>
<field name="title"
type="tinytext"
null="0"/>
<field name="created_by"
type="int(11)"
null="0"
default="0"/>
<field name="sdescription"
type="text"
null="0"/>
<field name="description"
type="text"
null="0"/>
<field name="created"
type="datetime"
null="0"
default="0000-00-00 00:00:00"/>
<field name="published"
type="tinyint(1)"
null="0"
default="0"/>
<field name="publish_up"
type="datetime"
null="0"
default="0000-00-00 00:00:00"/>
<field name="publish_down"
type="datetime"
null="0"
default="0000-00-00 00:00:00"/>
<field name="ordering"
type="tinyint(4)"
null="0"
default="0"/>
<field name="showdate"
type="tinyint(1)"
null="0"
default="1"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
</table>
<table name="kunena_attachments">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field name="mesid"
type="int(11)"
null="0"
default="0"/>
<field name="userid"
type="int(11)"
null="0"
default="0"/>
<field name="protected"
type="tinyint(4)"
null="0"
default="0"/>
<field name="hash"
type="char(32)"
null="1"/>
<field name="size"
type="int(11)"
null="1"/>
<field name="folder"
type="varchar(255)"
null="0"/>
<field name="filetype"
type="varchar(20)"
null="0"/>
<field name="filename"
type="varchar(255)"
null="0"/>
<field name="filename_real"
type="varchar(255)"
null="0"
default=""/>
<field name="caption"
type="varchar(255)"
null="0"
default=""/>
<field name="inline"
type="tinyint(4)"
null="0"
default="0"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
<key name="mesid"
columns="mesid"/>
<key name="userid"
columns="userid"/>
<key name="hash"
columns="hash"/>
<key name="filename"
columns="filename"/>
<key name="filename_real"
columns="filename_real"/>
</table>
<table name="kunena_categories">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field name="parent_id"
type="int(11)"
null="1"
default="0"/>
<field name="name"
type="tinytext"
null="1"/>
<field name="alias"
type="varchar(255)"
null="0"/>
<field name="icon"
type="varchar(60)"
null="0"/>
<field name="icon_id"
type="tinyint(4)"
null="0"
default="0"/>
<field name="locked"
type="tinyint(4)"
null="0"
default="0"/>
<field name="accesstype"
type="varchar(20)"
null="0"
default="joomla.level"/>
<field name="access"
type="int(11)"
null="0"
default="0"/>
<field name="pub_access"
type="int(11)"
null="0"
default="1"/>
<field name="pub_recurse"
type="tinyint(4)"
null="1"
default="1"/>
<field name="admin_access"
type="int(11)"
null="0"
default="0"/>
<field name="admin_recurse"
type="tinyint(4)"
null="1"
default="1"/>
<field name="ordering"
type="smallint(6)"
null="0"
default="0"/>
<field name="published"
type="tinyint(4)"
null="0"
default="0"/>
<field name="channels"
type="text"
null="1"/>
<field name="checked_out"
type="int(11)"
null="0"
default="0"/>
<field name="checked_out_time"
type="datetime"
null="0"
default="0000-00-00 00:00:00"/>
<field name="review"
type="tinyint(4)"
null="0"
default="0"/>
<field name="allow_anonymous"
type="tinyint(4)"
null="0"
default="0"/>
<field name="post_anonymous"
type="tinyint(4)"
null="0"
default="0"/>
<field name="hits"
type="int(11)"
null="0"
default="0"/>
<field name="description"
type="text"
null="0"/>
<field name="headerdesc"
type="text"
null="0"/>
<field name="topictemplate"
type="text"
null="0"/>
<field name="class_sfx"
type="varchar(20)"
null="0"/>
<field name="allow_polls"
type="tinyint(4)"
null="0"
default="0"/>
<field name="topic_ordering"
type="varchar(16)"
null="0"
default="lastpost"/>
<field name="iconset"
type="varchar(255)"
null="0"
default="default"/>
<field name="numTopics"
type="mediumint(8)"
null="0"
default="0"/>
<field name="numPosts"
type="mediumint(8)"
null="0"
default="0"/>
<field name="last_topic_id"
type="int(11)"
null="0"
default="0"/>
<field name="last_post_id"
type="int(11)"
null="0"
default="0"/>
<field name="last_post_time"
type="int(11)"
null="0"
default="0"/>
<field name="params"
type="text"
null="0"/>
<field name="allow_ratings"
type="tinyint(4)"
null="0"
default="0"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
<key name="parent_id"
columns="parent_id"/>
<key name="category_access"
columns="accesstype,access"/>
<key name="published_pubaccess_id"
columns="published,pub_access,id"/>
</table>
<table name="kunena_configuration">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
default="0"/>
<field name="params"
type="text"
null="1"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
</table>
<table name="kunena_topics">
<field name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field name="category_id"
type="int(11)"
null="0"
default="0"/>
<field name="subject"
type="tinytext"
null="1"/>
<field name="icon_id"
type="int(11)"
null="0"
default="0"/>
<field name="label_id"
type="int(11)"
null="0"
default="0"/>
<field name="locked"
type="tinyint(4)"
null="0"
default="0"/>
<field name="hold"
type="tinyint(4)"
null="0"
default="0"/>
<field name="ordering"
type="int(11)"
null="0"
default="0"/>
<field name="posts"
type="int(11)"
null="0"
default="0"/>
<field name="hits"
type="int(11)"
null="0"
default="0"/>
<field name="attachments"
type="int(11)"
null="0"
default="0"/>
<field name="poll_id"
type="int(11)"
null="0"
default="0"/>
<field name="moved_id"
type="int(11)"
null="0"
default="0"/>
<field name="first_post_id"
type="int(11)"
null="0"
default="0"/>
<field name="first_post_time"
type="int(11)"
null="0"
default="0"/>
<field name="first_post_userid"
type="int(11)"
null="0"
default="0"/>
<field name="first_post_message"
type="text"
null="1"/>
<field name="first_post_guest_name"
type="tinytext"
null="1"/>
<field name="last_post_id"
type="int(11)"
null="0"
default="0"/>
<field name="last_post_time"
type="int(11)"
null="0"
default="0"/>
<field name="last_post_userid"
type="int(11)"
null="0"
default="0"/>
<field name="last_post_message"
type="text"
null="1"/>
<field name="last_post_guest_name"
type="tinytext"
null="1"/>
<field name="rating"
type="tinyint"
null="6"/>
<field name="params"
type="text"
null="0"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
<key name="category_id"
columns="category_id"/>
<key name="locked"
columns="locked"/>
<key name="hold"
columns="hold"/>
<key name="posts"
columns="posts"/>
<key name="hits"
columns="hits"/>
<key name="first_post_userid"
columns="first_post_userid"/>
<key name="last_post_userid"
columns="last_post_userid"/>
<key name="first_post_time"
columns="first_post_time"/>
<key name="last_post_time"
columns="last_post_time"/>
<key name="last_post_id"
columns="last_post_id"/>
</table>
<table name="kunena_messages">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field name="parent"
type="int(11)"
null="1"
default="0"/>
<field name="thread"
type="int(11)"
null="1"
default="0"/>
<field name="catid"
type="int(11)"
null="0"
default="0"/>
<field name="name"
type="tinytext"
null="1"/>
<field name="userid"
type="int(11)"
null="0"
default="0"/>
<field name="email"
type="tinytext"
null="1"/>
<field name="subject"
type="tinytext"
null="1"/>
<field name="time"
type="int(11)"
null="0"
default="0"/>
<field name="ip"
type="varchar(128)"
null="1"/>
<field name="topic_emoticon"
type="int(11)"
null="0"
default="0"/>
<field name="locked"
type="tinyint(4)"
null="0"
default="0"/>
<field name="hold"
type="tinyint(4)"
null="0"
default="0"/>
<field name="ordering"
type="int(11)"
null="1"
default="0"/>
<field name="hits"
type="int(11)"
null="1"
default="0"/>
<field name="moved"
type="tinyint(4)"
null="1"
default="0"/>
<field name="modified_by"
type="int(7)"
null="1"/>
<field name="modified_time"
type="int(11)"
null="1"/>
<field name="modified_reason"
type="tinytext"
null="1"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
<key name="thread"
columns="thread"/>
<key name="ip"
columns="ip"/>
<key name="userid"
columns="userid"/>
<key name="time"
columns="time"/>
<key name="locked"
columns="locked"/>
<key name="hold_time"
columns="hold,time"/>
<key name="parent_hits"
columns="parent,hits"/>
<key name="catid_parent"
columns="catid,parent"/>
</table>
<table name="kunena_messages_text">
<field primary_key="yes"
name="mesid"
type="int(11)"
null="0"
default="0"/>
<field name="message"
type="text"
null="0"/>
<key name="PRIMARY"
unique="1"
columns="mesid"/>
</table>
<table name="kunena_polls">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field name="title"
type="varchar(100)"
null="0"/>
<field name="threadid"
type="int(11)"
null="0"/>
<field name="polltimetolive"
type="datetime"
null="1"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
<key name="threadid"
columns="threadid"/>
</table>
<table name="kunena_polls_options">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field name="pollid"
type="int(11)"
null="1"/>
<field name="text"
type="varchar(100)"
null="1"/>
<field name="votes"
type="int(11)"
null="1"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
<key name="pollid"
columns="pollid"/>
</table>
<table name="kunena_polls_users">
<field name="pollid"
type="int(11)"
null="1"/>
<field name="userid"
type="int(11)"
null="1"/>
<field name="votes"
type="int(11)"
null="1"/>
<field name="lasttime"
type="timestamp"
null="0"
default="0000-00-00 00:00:00"/>
<field name="lastvote"
type="int(11)"
null="1"/>
<key name="pollid"
unique="1"
columns="pollid,userid"/>
</table>
<table name="kunena_ranks">
<field primary_key="yes"
name="rank_id"
type="mediumint(8) unsigned"
null="0"
extra="auto_increment"/>
<field name="rank_title"
type="varchar(255)"
null="0"
default=""/>
<field name="rank_min"
type="mediumint(8) unsigned"
null="0"
default="0"/>
<field name="rank_special"
type="tinyint(1) unsigned"
null="0"
default="0"/>
<field name="rank_image"
type="varchar(255)"
null="0"
default=""/>
<key name="PRIMARY"
unique="1"
columns="rank_id"/>
</table>
<table name="kunena_rate">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field primary_key="yes"
name="topic_id"
type="int(11)"
null="0"/>
<field name="userid"
type="int(11)"
null="0"/>
<field name="rate"
type="mediumint(8) unsigned"
null="0"
default="0"/>
<field name="time"
type="DATETIME"
null="0"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
</table>
<table name="kunena_sessions">
<field primary_key="yes"
name="userid"
type="int(11)"
null="0"
default="0"/>
<field name="allowed"
type="text"
null="1"/>
<field name="lasttime"
type="int(11)"
null="0"
default="0"/>
<field name="readtopics"
type="text"
null="1"/>
<field name="currvisit"
type="int(11)"
null="0"
default="0"/>
<key name="PRIMARY"
unique="1"
columns="userid"/>
<key name="currvisit"
columns="currvisit"/>
</table>
<table name="kunena_smileys">
<field primary_key="yes"
name="id"
type="int(4)"
null="0"
extra="auto_increment"/>
<field name="code"
type="varchar(12)"
null="0"
default=""/>
<field name="location"
type="varchar(50)"
null="0"
default=""/>
<field name="greylocation"
type="varchar(60)"
null="0"
default=""/>
<field name="emoticonbar"
type="tinyint(4)"
null="0"
default="0"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
</table>
<table name="kunena_thankyou">
<field primary_key="yes"
name="postid"
type="int(11)"
null="0"/>
<field primary_key="yes"
name="userid"
type="int(11)"
null="0"/>
<field name="targetuserid"
type="int(11)"
null="0"/>
<field name="time"
type="datetime"
null="0"/>
<key name="postid"
unique="1"
columns="postid,userid"/>
<key name="userid"
columns="userid"/>
<key name="targetuserid"
columns="targetuserid"/>
</table>
<table name="kunena_user_categories">
<field primary_key="yes"
name="user_id"
type="int(11)"
null="0"/>
<field primary_key="yes"
name="category_id"
type="int(11)"
null="0"/>
<field name="role"
type="tinyint(4)"
null="0"
default="0"/>
<field name="allreadtime"
type="int(11)"
null="0"
default="0"/>
<field name="subscribed"
type="tinyint(4)"
null="0"
default="0"/>
<field name="params"
type="text"
null="0"/>
<key name="PRIMARY"
unique="1"
columns="user_id,category_id"/>
<key name="category_subscribed"
columns="category_id,subscribed"/>
<key name="role"
columns="role"/>
</table>
<table name="kunena_user_read">
<field primary_key="yes"
name="user_id"
type="int(11)"
null="0"/>
<field primary_key="yes"
name="topic_id"
type="int(11)"
null="0"/>
<field name="category_id"
type="int(11)"
null="0"/>
<field name="message_id"
type="int(11)"
null="0"/>
<field name="time"
type="int(11)"
null="0"/>
<key name="user_topic_id"
unique="1"
columns="user_id,topic_id"/>
<key name="category_user_id"
columns="category_id,user_id"/>
<key name="time"
columns="time"/>
</table>
<table name="kunena_user_topics">
<field primary_key="yes"
name="user_id"
type="int(11)"
null="0"
default="0"/>
<field primary_key="yes"
name="topic_id"
type="int(11)"
null="0"
default="0"/>
<field name="category_id"
type="int(11)"
null="0"/>
<field name="posts"
type="mediumint(8)"
null="0"
default="0"/>
<field name="last_post_id"
type="int(11)"
null="0"
default="0"/>
<field name="owner"
type="tinyint(4)"
null="0"
default="0"/>
<field name="favorite"
type="tinyint(4)"
null="0"
default="0"/>
<field name="subscribed"
type="tinyint(4)"
null="0"
default="0"/>
<field name="params"
type="text"
null="0"/>
<key name="user_topic_id"
unique="1"
columns="user_id,topic_id"/>
<key name="topic_id"
columns="topic_id"/>
<key name="posts"
columns="posts"/>
<key name="owner"
columns="owner"/>
<key name="favorite"
columns="favorite"/>
<key name="subscribed"
columns="subscribed"/>
</table>
<table name="kunena_users">
<field primary_key="yes"
name="userid"
type="int(11)"
null="0"
default="0"/>
<field name="status"
type="tinyint(1)"
null="0"
default="0"/>
<field name="status_text"
type="varchar(255)"
null="0"
default="0"/>
<field name="view"
type="varchar(8)"
null="0"
default=""/>
<field name="signature"
type="text"
null="1"/>
<field name="moderator"
type="int(11)"
null="1"
default="0"/>
<field name="banned"
type="datetime"
null="1"/>
<field name="ordering"
type="int(11)"
null="1"
default="0"/>
<field name="posts"
type="int(11)"
null="1"
default="0"/>
<field name="avatar"
type="varchar(255)"
null="1"/>
<field name="timestamp"
type="int(11)"
null="1"/>
<field name="karma"
type="int(11)"
null="1"
default="0"/>
<field name="karma_time"
type="int(11)"
null="1"
default="0"/>
<field name="group_id"
type="int(4)"
null="1"
default="1"/>
<field name="uhits"
type="int(11)"
null="1"
default="0"/>
<field name="personalText"
type="tinytext"
null="1"/>
<field name="gender"
type="tinyint(4)"
null="0"
default="0"/>
<field name="birthdate"
type="date"
null="0"
default="0001-01-01"/>
<field name="location"
type="varchar(50)"
null="1"/>
<field name="friendfeed"
type="varchar(50)"
null="1"/>
<field name="bebo"
type="varchar(50)"
null="1"/>
<field name="digg"
type="varchar(50)"
null="1"/>
<field name="icq"
type="varchar(50)"
null="1"/>
<field name="telegram"
type="varchar(50)"
null="1"/>
<field name="vk"
type="varchar(50)"
null="1"/>
<field name="microsoft"
type="varchar(50)"
null="1"/>
<field name="skype"
type="varchar(50)"
null="1"/>
<field name="twitter"
type="varchar(50)"
null="1"/>
<field name="facebook"
type="varchar(50)"
null="1"/>
<field name="google"
type="varchar(50)"
null="1"/>
<field name="myspace"
type="varchar(50)"
null="1"/>
<field name="linkedin"
type="varchar(50)"
null="1"/>
<field name="linkedin_company"
type="varchar(50)"
null="1"/>
<field name="delicious"
type="varchar(50)"
null="1"/>
<field name="instagram"
type="varchar(50)"
null="1"/>
<field name="qqsocial"
type="varchar(50)"
null="1"/>
<field name="blogspot"
type="varchar(50)"
null="1"/>
<field name="flickr"
type="varchar(50)"
null="1"/>
<field name="apple"
type="varchar(50)"
null="1"/>
<field name="qzone"
type="varchar(50)"
null="1"/>
<field name="weibo"
type="varchar(50)"
null="1"/>
<field name="wechat"
type="varchar(50)"
null="1"/>
<field name="yim"
type="varchar(50)"
null="1"/>
<field name="whatsapp"
type="varchar(50)"
null="1"/>
<field name="youtube"
type="varchar(50)"
null="1"/>
<field name="ok"
type="varchar(50)"
null="1"/>
<field name="websitename"
type="varchar(50)"
null="1"/>
<field name="websiteurl"
type="varchar(50)"
null="1"/>
<field name="rank"
type="tinyint(4)"
null="0"
default="0"/>
<field name="hideEmail"
type="tinyint(1)"
null="0"
default="1"/>
<field name="showOnline"
type="tinyint(1)"
null="0"
default="1"/>
<field name="canSubscribe"
type="tinyint(1)"
null="0"
default="-1"/>
<field name="userListtime"
type="int(11)"
null="1"
default="-2"/>
<field name="thankyou"
type="int(11)"
null="1"
default="0"/>
<field name="ip"
type="varchar(128)"
null="0"
default=""/>
<field name="socialshare"
type="tinyint(1)"
null="0"
default="1"/>
<key name="PRIMARY"
unique="1"
columns="userid"/>
<key name="group_id"
columns="group_id"/>
<key name="posts"
columns="posts"/>
<key name="uhits"
columns="uhits"/>
<key name="banned"
columns="banned"/>
<key name="moderator"
columns="moderator"/>
</table>
<table name="kunena_users_banned">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field name="userid"
type="int(11)"
null="1"/>
<field name="ip"
type="varchar(128)"
null="1"/>
<field name="blocked"
type="tinyint(4)"
null="0"
default="0"/>
<field name="expiration"
type="datetime"
null="1"/>
<field name="created_by"
type="int(11)"
null="0"/>
<field name="created_time"
type="datetime"
null="0"/>
<field name="reason_private"
type="text"
null="1"/>
<field name="reason_public"
type="text"
null="1"/>
<field name="modified_by"
type="int(11)"
null="1"/>
<field name="modified_time"
type="datetime"
null="1"/>
<field name="comments"
type="text"
null="1"/>
<field name="params"
type="text"
null="1"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
<key name="userid"
columns="userid"/>
<key name="ip"
columns="ip"/>
<key name="expiration"
columns="expiration"/>
<key name="created_time"
columns="created_time"/>
</table>
<table name="kunena_logs">
<field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/>
<field name="type" type="tinyint(4)" null="0" default="0"/>
<field name="user_id" type="int(11)" null="0" default="0"/>
<field name="category_id" type="int(11)" null="0" default="0"/>
<field name="topic_id" type="int(11)" null="0" default="0"/>
<field name="target_user" type="int(11)" null="0" default="0"/>
<field name="ip" type="varchar(40)" null="0" default=""/>
<field name="time" type="int(11)" null="0" default="0"/>
<field name="operation" type="varchar(40)" null="0"/>
<field name="data" type="mediumtext" null="0"/>
<key name="PRIMARY" unique="1" columns="id"/>
<key name="type" columns="type"/>
<key name="category_id" columns="category_id"/>
<key name="topic_id" columns="topic_id"/>
<key name="target_user" columns="target_user"/>
<key name="user_id" columns="user_id"/>
</table>
<table name="kunena_version">
<field primary_key="yes"
name="id"
type="int(11)"
null="0"
extra="auto_increment"/>
<field name="version"
type="varchar(20)"
null="0"/>
<field name="versiondate"
type="date"
null="0"/>
<field name="installdate"
type="date"
null="0"/>
<field name="build"
type="varchar(20)"
null="0"
default="0"/>
<field name="versionname"
type="varchar(40)"
null="1"/>
<field name="state"
type="text"
null="0"/>
<key name="PRIMARY"
unique="1"
columns="id"/>
</table>
</schema>