| Server IP : 213.186.33.4 / Your IP : 216.73.216.193 Web Server : Apache System : Linux webm006.cluster103.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 : awebpaca ( 35430) PHP Version : 8.5.0 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/awebpaca/blog/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=""/> <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="tinyint(4)" 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="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"/> <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="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="aim" 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="delicious" type="varchar(50)" null="1"/> <field name="instagram" type="varchar(50)" null="1"/> <field name="qq" 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="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(13)" null="0" default=""/> <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"/> <field name="versionname" type="varchar(40)" null="1"/> <field name="state" type="text" null="0"/> <key name="PRIMARY" unique="1" columns="id"/> </table> </schema>