%PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/11585/cwd/html/old/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(255)" 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="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="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" /> <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" /> </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_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="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" /> <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_keywords"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment" /> <field name="name" type="varchar(40)" null="0" /> <field name="public_count" type="int(11)" null="0" /> <field name="total_count" type="int(11)" null="0" /> <key name="PRIMARY" unique="1" columns="id" /> <key name="name" unique="1" columns="name" /> <key name="public_count" columns="public_count" /> <key name="total_count" columns="total_count" /> </table> <table name="kunena_keywords_map"> <field name="keyword_id" type="int(11)" null="0" /> <field name="user_id" type="int(11)" null="0" /> <field name="topic_id" type="int(11)" null="0" /> <key name="keyword_user_topic" unique="1" columns="keyword_id,user_id,topic_id" /> <key name="user_id" columns="user_id" /> <key name="topic_user" columns="topic_id,user_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="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="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" /> </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_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="datetime" null="1" /> <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="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="icq" type="varchar(50)" null="1" /> <field name="aim" type="varchar(50)" null="1" /> <field name="yim" type="varchar(50)" null="1" /> <field name="msn" 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="gtalk" 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="friendfeed" type="varchar(50)" null="1" /> <field name="digg" type="varchar(50)" null="1" /> <field name="blogspot" type="varchar(50)" null="1" /> <field name="flickr" type="varchar(50)" null="1" /> <field name="bebo" 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="thankyou" type="int(11)" null="1" default="0" /> <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_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>