Файловый менеджер - Редактировать - /var/www/html/administrator/components/com_kunena/sql/install/schema/install.xml
Ðазад
<?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="parentid" 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="pubAccess" type="int(11)" null="0" default="1"/> <field name="pubRecurse" type="tinyint(4)" null="1" default="1"/> <field name="adminAccess" type="int(11)" null="0" default="0"/> <field name="adminRecurse" 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="allowAnonymous" type="tinyint(4)" null="0" default="0"/> <field name="postAnonymous" 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="allowPolls" type="tinyint(4)" null="0" default="0"/> <field name="topicOrdering" 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="allowRatings" type="tinyint(4)" null="0" default="0"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="parentid" columns="parentid"/> <key name="category_access" columns="accesstype,access"/> <key name="published_pubaccess_id" columns="published,pubAccess,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_private"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="parent_id" type="int(11)" null="0" default="0"/> <field name="author_id" type="int(11)" null="0" default="0"/> <field name="created_at" type="datetime" null="0"/> <field name="attachments" type="tinyint(4)" null="0" default="0"/> <field name="subject" type="tinytext" null="0"/> <field name="body" type="text" null="0"/> <field name="params" type="text" null="0"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="parent_id" columns="parent_id"/> <key name="author_id" columns="author_id"/> <key name="created_at" columns="created_at"/> </table> <table name="kunena_private_attachment_map"> <field primary_key="yes" name="private_id" type="int(11)" null="0"/> <field primary_key="yes" name="attachment_id" type="int(11)" null="0"/> <key name="PRIMARY" unique="1" columns="private_id,attachment_id"/> <key name="attachment_id" columns="attachment_id"/> </table> <table name="kunena_private_post_map"> <field primary_key="yes" name="private_id" type="int(11)" null="0"/> <field primary_key="yes" name="message_id" type="int(11)" null="0"/> <key name="PRIMARY" unique="1" columns="private_id,message_id"/> <key name="message_id" columns="message_id"/> </table> <table name="kunena_private_user_map"> <field primary_key="yes" name="private_id" type="int(11)" null="0"/> <field primary_key="yes" name="user_id" type="int(11)" null="0"/> <field name="read_at" type="datetime" null="0" default="1000-01-01 00:00:00"/> <field name="replied_at" type="datetime" null="0" default="1000-01-01 00:00:00"/> <field name="deleted_at" type="datetime" null="0" default="1000-01-01 00:00:00"/> <key name="PRIMARY" unique="1" columns="private_id,user_id"/> <key name="user_id" columns="user_id"/> </table> <table name="kunena_ranks"> <field primary_key="yes" name="rankId" type="mediumint(8) unsigned" null="0" extra="auto_increment"/> <field name="rankTitle" type="varchar(255)" null="0" default=""/> <field name="rankMin" type="mediumint(8) unsigned" null="0" default="0"/> <field name="rankSpecial" type="tinyint(1) unsigned" null="0" default="0"/> <field name="rankImage" type="varchar(255)" null="0" default=""/> <key name="PRIMARY" unique="1" columns="rankId"/> </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="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" default="1000-01-01 00:00:00"/> <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="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="1000-01-01"/> <field name="location" 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="socials" type="text" null="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"/> <field name="sampleData" type="boolean" null="0"/> <key name="PRIMARY" unique="1" columns="id"/> </table> </schema>
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка