Guest User

Joomla 3.8.1 Tables SQL Kunena 5

a guest
Oct 23rd, 2017
174
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.0
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Hôte : localhost
  6. -- Généré le :  lun. 23 oct. 2017 à 21:43
  7. -- Version du serveur :  10.1.25-MariaDB
  8. -- Version de PHP :  7.1.7
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Base de données :  `joomla`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Structure de la table `jv3_kunena_aliases`
  29. --
  30.  
  31. CREATE TABLE `jv3_kunena_aliases` (
  32.   `alias` varchar(190) NOT NULL,
  33.   `type` varchar(10) NOT NULL,
  34.   `item` varchar(32) NOT NULL,
  35.   `state` tinyint(4) NOT NULL DEFAULT '0'
  36. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  37.  
  38. --
  39. -- Déchargement des données de la table `jv3_kunena_aliases`
  40. --
  41.  
  42. INSERT INTO `jv3_kunena_aliases` (`alias`, `type`, `item`, `state`) VALUES
  43. ('announcement', 'view', 'announcement', 1),
  44. ('bienvenue', 'catid', '2', 1),
  45. ('boite-a-idee', 'catid', '3', 1),
  46. ('category', 'view', 'category', 1),
  47. ('category/create', 'layout', 'category.create', 1),
  48. ('category/default', 'layout', 'category.default', 1),
  49. ('category/edit', 'layout', 'category.edit', 1),
  50. ('category/manage', 'layout', 'category.manage', 1),
  51. ('category/moderate', 'layout', 'category.moderate', 1),
  52. ('category/user', 'layout', 'category.user', 1),
  53. ('common', 'view', 'common', 1),
  54. ('create', 'layout', 'category.create', 0),
  55. ('credits', 'view', 'credits', 1),
  56. ('default', 'layout', 'category.default', 0),
  57. ('edit', 'layout', 'category.edit', 0),
  58. ('forum-principal', 'catid', '1', 1),
  59. ('home', 'view', 'home', 1),
  60. ('manage', 'layout', 'category.manage', 0),
  61. ('misc', 'view', 'misc', 1),
  62. ('moderate', 'layout', 'category.moderate', 0),
  63. ('search', 'view', 'search', 1),
  64. ('statistics', 'view', 'statistics', 1),
  65. ('topic', 'view', 'topic', 1),
  66. ('topics', 'view', 'topics', 1),
  67. ('user', 'view', 'user', 1);
  68.  
  69. -- --------------------------------------------------------
  70.  
  71. --
  72. -- Structure de la table `jv3_kunena_announcement`
  73. --
  74.  
  75. CREATE TABLE `jv3_kunena_announcement` (
  76.   `id` int(3) NOT NULL,
  77.   `title` tinytext NOT NULL,
  78.   `created_by` int(11) NOT NULL DEFAULT '0',
  79.   `sdescription` text NOT NULL,
  80.   `description` text NOT NULL,
  81.   `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  82.   `published` tinyint(1) NOT NULL DEFAULT '0',
  83.   `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  84.   `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  85.   `ordering` tinyint(4) NOT NULL DEFAULT '0',
  86.   `showdate` tinyint(1) NOT NULL DEFAULT '1'
  87. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  88.  
  89. -- --------------------------------------------------------
  90.  
  91. --
  92. -- Structure de la table `jv3_kunena_attachments`
  93. --
  94.  
  95. CREATE TABLE `jv3_kunena_attachments` (
  96.   `id` int(11) NOT NULL,
  97.   `mesid` int(11) NOT NULL DEFAULT '0',
  98.   `userid` int(11) NOT NULL DEFAULT '0',
  99.   `protected` tinyint(4) NOT NULL DEFAULT '0',
  100.   `hash` char(32) DEFAULT NULL,
  101.   `size` int(11) DEFAULT NULL,
  102.   `folder` varchar(255) NOT NULL,
  103.   `filetype` varchar(20) NOT NULL,
  104.   `filename` varchar(255) NOT NULL,
  105.   `filename_real` varchar(255) NOT NULL DEFAULT '',
  106.   `caption` varchar(255) NOT NULL DEFAULT ''
  107. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  108.  
  109. -- --------------------------------------------------------
  110.  
  111. --
  112. -- Structure de la table `jv3_kunena_categories`
  113. --
  114.  
  115. CREATE TABLE `jv3_kunena_categories` (
  116.   `id` int(11) NOT NULL,
  117.   `parent_id` int(11) DEFAULT '0',
  118.   `name` tinytext,
  119.   `alias` varchar(255) NOT NULL,
  120.   `icon` varchar(60) NOT NULL,
  121.   `icon_id` tinyint(4) NOT NULL DEFAULT '0',
  122.   `locked` tinyint(4) NOT NULL DEFAULT '0',
  123.   `accesstype` varchar(20) NOT NULL DEFAULT 'joomla.level',
  124.   `access` int(11) NOT NULL DEFAULT '0',
  125.   `pub_access` int(11) NOT NULL DEFAULT '1',
  126.   `pub_recurse` tinyint(4) DEFAULT '1',
  127.   `admin_access` int(11) NOT NULL DEFAULT '0',
  128.   `admin_recurse` tinyint(4) DEFAULT '1',
  129.   `ordering` smallint(6) NOT NULL DEFAULT '0',
  130.   `published` tinyint(4) NOT NULL DEFAULT '0',
  131.   `channels` text,
  132.   `checked_out` tinyint(4) NOT NULL DEFAULT '0',
  133.   `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  134.   `review` tinyint(4) NOT NULL DEFAULT '0',
  135.   `allow_anonymous` tinyint(4) NOT NULL DEFAULT '0',
  136.   `post_anonymous` tinyint(4) NOT NULL DEFAULT '0',
  137.   `hits` int(11) NOT NULL DEFAULT '0',
  138.   `description` text NOT NULL,
  139.   `headerdesc` text NOT NULL,
  140.   `class_sfx` varchar(20) NOT NULL,
  141.   `allow_polls` tinyint(4) NOT NULL DEFAULT '0',
  142.   `topic_ordering` varchar(16) NOT NULL DEFAULT 'lastpost',
  143.   `iconset` varchar(255) NOT NULL DEFAULT 'default',
  144.   `numTopics` mediumint(8) NOT NULL DEFAULT '0',
  145.   `numPosts` mediumint(8) NOT NULL DEFAULT '0',
  146.   `last_topic_id` int(11) NOT NULL DEFAULT '0',
  147.   `last_post_id` int(11) NOT NULL DEFAULT '0',
  148.   `last_post_time` int(11) NOT NULL DEFAULT '0',
  149.   `params` text NOT NULL,
  150.   `allow_ratings` tinyint(4) NOT NULL DEFAULT '0'
  151. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  152.  
  153. --
  154. -- Déchargement des données de la table `jv3_kunena_categories`
  155. --
  156.  
  157. INSERT INTO `jv3_kunena_categories` (`id`, `parent_id`, `name`, `alias`, `icon`, `icon_id`, `locked`, `accesstype`, `access`, `pub_access`, `pub_recurse`, `admin_access`, `admin_recurse`, `ordering`, `published`, `channels`, `checked_out`, `checked_out_time`, `review`, `allow_anonymous`, `post_anonymous`, `hits`, `description`, `headerdesc`, `class_sfx`, `allow_polls`, `topic_ordering`, `iconset`, `numTopics`, `numPosts`, `last_topic_id`, `last_post_id`, `last_post_time`, `params`, `allow_ratings`) VALUES
  158. (1, 0, 'Forum Principal', 'forum-principal', '', 0, 0, 'joomla.group', 0, 1, 1, 0, 1, 1, 1, 'THIS', 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'Ceci est la section principale du forum. Étant donnée que c\'est est une section de premier niveau, elle sert de conteneur pour des sous-catégories. Celles-ci doivent être créées pour la conception des catégories du forum.', 'Pour fournir des informations supplémentaires à vos membres et invités, l\'en-tête du forum peut-être utilisée pour afficher du texte tout au sommet d\'une catégorie particulière.', '', 0, 'lastpost', 'default', 0, 0, 0, 0, 0, '', 0),
  159. (2, 1, 'Bienvenue', 'bienvenue', '', 0, 0, 'joomla.group', 0, 1, 1, 0, 1, 1, 1, 'THIS', 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'Nous encourageons les nouveaux membres à écrire une courte présentation d\'eux-mêmes dans cette catégorie du forum. Pour mieux se connaitre et partager des intêrets communs.', '[b]Bienvenue dans le forum Kunena![/b] ', '', 0, 'lastpost', 'default', 0, 0, 0, 0, 0, '', 0),
  160. (3, 1, 'Boîte à idée', 'boite-a-idee', '', 0, 0, 'joomla.group', 0, 1, 1, 0, 1, 2, 1, 'THIS', 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'Vous avez des retours à faire ou des choses à partager? ', 'Ceci est une en-tête optionnelle pour la Boîte à idée.', '', 1, 'lastpost', 'default', 0, 0, 0, 0, 0, '', 0);
  161.  
  162. -- --------------------------------------------------------
  163.  
  164. --
  165. -- Structure de la table `jv3_kunena_configuration`
  166. --
  167.  
  168. CREATE TABLE `jv3_kunena_configuration` (
  169.   `id` int(11) NOT NULL DEFAULT '0',
  170.   `params` text
  171. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  172.  
  173. --
  174. -- Déchargement des données de la table `jv3_kunena_configuration`
  175. --
  176.  
  177. INSERT INTO `jv3_kunena_configuration` (`id`, `params`) VALUES
  178. (1, '{\"board_title\":\"Kunena\",\"email\":\"\",\"board_offline\":\"0\",\"offline_message\":\"The Forum is currently offline for maintenance.\\r\\nCheck back soon!\",\"enablerss\":\"1\",\"threads_per_page\":\"20\",\"messages_per_page\":\"6\",\"messages_per_page_search\":\"15\",\"showhistory\":\"1\",\"historylimit\":\"6\",\"shownew\":\"1\",\"disemoticons\":\"0\",\"template\":\"jf_simone\",\"showannouncement\":\"1\",\"avataroncat\":\"0\",\"catimagepath\":\"category_images\",\"showchildcaticon\":\"1\",\"rtewidth\":450,\"rteheight\":300,\"enableforumjump\":\"1\",\"reportmsg\":\"1\",\"username\":\"1\",\"askemail\":\"0\",\"showemail\":\"0\",\"showuserstats\":\"1\",\"showkarma\":\"1\",\"useredit\":\"1\",\"useredittime\":\"0\",\"useredittimegrace\":\"600\",\"editmarkup\":\"1\",\"allowsubscriptions\":\"1\",\"subscriptionschecked\":\"1\",\"allowfavorites\":\"1\",\"maxsubject\":50,\"maxsig\":300,\"regonly\":\"0\",\"pubwrite\":\"0\",\"floodprotection\":\"0\",\"mailmod\":\"0\",\"mailadmin\":\"0\",\"captcha\":\"0\",\"mailfull\":\"1\",\"allowavatarupload\":\"1\",\"allowavatargallery\":\"1\",\"avatarquality\":\"75\",\"avatarsize\":\"2048\",\"imageheight\":\"800\",\"imagewidth\":\"800\",\"imagesize\":\"150\",\"filetypes\":\"txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2\",\"filesize\":\"120\",\"showranking\":\"1\",\"rankimages\":\"1\",\"userlist_rows\":\"30\",\"userlist_online\":\"1\",\"userlist_avatar\":\"1\",\"userlist_posts\":\"1\",\"userlist_karma\":\"1\",\"userlist_email\":\"0\",\"userlist_joindate\":\"1\",\"userlist_lastvisitdate\":\"1\",\"userlist_userhits\":\"1\",\"latestcategory\":\"\",\"showstats\":\"1\",\"showwhoisonline\":\"1\",\"showgenstats\":\"1\",\"showpopuserstats\":\"1\",\"popusercount\":\"5\",\"showpopsubjectstats\":\"1\",\"popsubjectcount\":\"5\",\"showspoilertag\":\"1\",\"showvideotag\":\"1\",\"showebaytag\":\"1\",\"trimlongurls\":\"1\",\"trimlongurlsfront\":\"40\",\"trimlongurlsback\":\"20\",\"autoembedyoutube\":\"1\",\"autoembedebay\":\"1\",\"ebaylanguagecode\":\"en-us\",\"sessiontimeout\":\"1800\",\"highlightcode\":\"0\",\"rss_type\":\"topic\",\"rss_timelimit\":\"month\",\"rss_limit\":\"100\",\"rss_included_categories\":\"\",\"rss_excluded_categories\":\"\",\"rss_specification\":\"rss2.0\",\"rss_allow_html\":\"1\",\"rss_author_format\":\"name\",\"rss_author_in_title\":\"1\",\"rss_word_count\":\"0\",\"rss_old_titles\":\"0\",\"rss_cache\":\"900\",\"defaultpage\":\"recent\",\"default_sort\":\"asc\",\"sef\":\"1\",\"showimgforguest\":\"1\",\"showfileforguest\":\"1\",\"pollnboptions\":\"4\",\"pollallowvoteone\":\"1\",\"pollenabled\":\"1\",\"poppollscount\":\"5\",\"showpoppollstats\":\"1\",\"polltimebtvotes\":\"00:15:00\",\"pollnbvotesbyuser\":\"100\",\"pollresultsuserslist\":\"1\",\"maxpersotext\":50,\"ordering_system\":\"mesid\",\"post_dateformat\":\"ago\",\"post_dateformat_hover\":\"datetime\",\"hide_ip\":\"1\",\"imagetypes\":\"jpg,jpeg,gif,png\",\"checkmimetypes\":\"1\",\"imagemimetypes\":\"image\\/jpeg,image\\/jpg,image\\/gif,image\\/png\",\"imagequality\":\"50\",\"thumbheight\":\"32\",\"thumbwidth\":\"32\",\"hideuserprofileinfo\":\"put_empty\",\"boxghostmessage\":\"0\",\"userdeletetmessage\":\"0\",\"latestcategory_in\":\"1\",\"topicicons\":\"1\",\"debug\":\"0\",\"catsautosubscribed\":0,\"showbannedreason\":\"0\",\"showthankyou\":\"1\",\"showpopthankyoustats\":\"1\",\"popthankscount\":\"5\",\"mod_see_deleted\":\"0\",\"bbcode_img_secure\":\"text\",\"listcat_show_moderators\":\"1\",\"lightbox\":\"1\",\"show_list_time\":\"720\",\"show_session_type\":\"2\",\"show_session_starttime\":\"1800\",\"userlist_allowed\":\"1\",\"userlist_count_users\":\"1\",\"enable_threaded_layouts\":0,\"category_subscriptions\":\"post\",\"topic_subscriptions\":\"every\",\"pubprofile\":\"1\",\"thankyou_max\":\"10\",\"email_recipient_count\":\"0\",\"email_recipient_privacy\":\"bcc\",\"email_visible_address\":\"\",\"captcha_post_limit\":\"0\",\"image_upload\":\"registered\",\"file_upload\":\"registered\",\"topic_layout\":\"flat\",\"time_to_create_page\":\"1\",\"show_imgfiles_manage_profile\":\"1\",\"hold_newusers_posts\":\"0\",\"hold_guest_posts\":\"0\",\"attachment_limit\":\"8\",\"pickup_category\":\"0\",\"article_display\":\"intro\",\"send_emails\":\"1\",\"fallback_english\":\"1\",\"cache\":\"1\",\"cache_time\":\"60\",\"ebay_affiliate_id\":\"5337089937\",\"iptracking\":\"1\",\"stopforumspam_key\":\"\",\"rss_feedburner_url\":\"\",\"autolink\":\"1\",\"access_component\":\"1\",\"statslink_allowed\":\"1\",\"superadmin_userlist\":\"0\",\"legacy_urls\":\"1\",\"attachment_protection\":\"0\",\"categoryicons\":1,\"avatarresizemethod\":\"1\",\"avatarcrop\":\"0\",\"user_report\":\"1\",\"searchtime\":\"365\",\"teaser\":\"0\",\"ebay_language\":\"0\",\"ebay_api_key\":\"\",\"twitter_consumer_key\":\"\",\"twitter_consumer_secret\":\"\",\"allow_change_subject\":\"1\",\"max_links\":\"6\",\"read_only\":\"0\",\"ratingenabled\":\"0\",\"url_subject_topic\":\"0\",\"log_moderation\":\"0\",\"attach_start\":\"0\",\"attach_end\":\"14\",\"google_map_api_key\":\"\",\"attachment_utf8\":\"1\",\"autoembedsoundcloud\":\"1\",\"emailheader\":\"\\/media\\/kunena\\/email\\/hero-wide.png\",\"user_status\":\"1\",\"plain_email\":\"0\",\"plugins\":{\"plg_system_kunena\":{\"jcontentevents\":\"0\",\"jcontentevent_target\":\"body\"}}}');
  179.  
  180. -- --------------------------------------------------------
  181.  
  182. --
  183. -- Structure de la table `jv3_kunena_logs`
  184. --
  185.  
  186. CREATE TABLE `jv3_kunena_logs` (
  187.   `id` int(11) NOT NULL,
  188.   `type` tinyint(4) NOT NULL DEFAULT '0',
  189.   `user_id` int(11) NOT NULL DEFAULT '0',
  190.   `category_id` int(11) NOT NULL DEFAULT '0',
  191.   `topic_id` int(11) NOT NULL DEFAULT '0',
  192.   `target_user` int(11) NOT NULL DEFAULT '0',
  193.   `ip` varchar(40) NOT NULL DEFAULT '',
  194.   `time` int(11) NOT NULL DEFAULT '0',
  195.   `operation` varchar(40) NOT NULL,
  196.   `data` mediumtext NOT NULL
  197. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  198.  
  199. -- --------------------------------------------------------
  200.  
  201. --
  202. -- Structure de la table `jv3_kunena_messages`
  203. --
  204.  
  205. CREATE TABLE `jv3_kunena_messages` (
  206.   `id` int(11) NOT NULL,
  207.   `parent` int(11) DEFAULT '0',
  208.   `thread` int(11) DEFAULT '0',
  209.   `catid` int(11) NOT NULL DEFAULT '0',
  210.   `name` tinytext,
  211.   `userid` int(11) NOT NULL DEFAULT '0',
  212.   `email` tinytext,
  213.   `subject` tinytext,
  214.   `time` int(11) NOT NULL DEFAULT '0',
  215.   `ip` varchar(128) DEFAULT NULL,
  216.   `topic_emoticon` int(11) NOT NULL DEFAULT '0',
  217.   `locked` tinyint(4) NOT NULL DEFAULT '0',
  218.   `hold` tinyint(4) NOT NULL DEFAULT '0',
  219.   `ordering` int(11) DEFAULT '0',
  220.   `hits` int(11) DEFAULT '0',
  221.   `moved` tinyint(4) DEFAULT '0',
  222.   `modified_by` int(7) DEFAULT NULL,
  223.   `modified_time` int(11) DEFAULT NULL,
  224.   `modified_reason` tinytext
  225. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  226.  
  227. -- --------------------------------------------------------
  228.  
  229. --
  230. -- Structure de la table `jv3_kunena_messages_text`
  231. --
  232.  
  233. CREATE TABLE `jv3_kunena_messages_text` (
  234.   `mesid` int(11) NOT NULL DEFAULT '0',
  235.   `message` text NOT NULL
  236. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  237.  
  238. -- --------------------------------------------------------
  239.  
  240. --
  241. -- Structure de la table `jv3_kunena_polls`
  242. --
  243.  
  244. CREATE TABLE `jv3_kunena_polls` (
  245.   `id` int(11) NOT NULL,
  246.   `title` varchar(100) NOT NULL,
  247.   `threadid` int(11) NOT NULL,
  248.   `polltimetolive` datetime DEFAULT NULL
  249. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  250.  
  251. -- --------------------------------------------------------
  252.  
  253. --
  254. -- Structure de la table `jv3_kunena_polls_options`
  255. --
  256.  
  257. CREATE TABLE `jv3_kunena_polls_options` (
  258.   `id` int(11) NOT NULL,
  259.   `pollid` int(11) DEFAULT NULL,
  260.   `text` varchar(100) DEFAULT NULL,
  261.   `votes` int(11) DEFAULT NULL
  262. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  263.  
  264. -- --------------------------------------------------------
  265.  
  266. --
  267. -- Structure de la table `jv3_kunena_polls_users`
  268. --
  269.  
  270. CREATE TABLE `jv3_kunena_polls_users` (
  271.   `pollid` int(11) DEFAULT NULL,
  272.   `userid` int(11) DEFAULT NULL,
  273.   `votes` int(11) DEFAULT NULL,
  274.   `lasttime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  275.   `lastvote` int(11) DEFAULT NULL
  276. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  277.  
  278. -- --------------------------------------------------------
  279.  
  280. --
  281. -- Structure de la table `jv3_kunena_ranks`
  282. --
  283.  
  284. CREATE TABLE `jv3_kunena_ranks` (
  285.   `rank_id` mediumint(8) UNSIGNED NOT NULL,
  286.   `rank_title` varchar(255) NOT NULL DEFAULT '',
  287.   `rank_min` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  288.   `rank_special` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  289.   `rank_image` varchar(255) NOT NULL DEFAULT ''
  290. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  291.  
  292. --
  293. -- Déchargement des données de la table `jv3_kunena_ranks`
  294. --
  295.  
  296. INSERT INTO `jv3_kunena_ranks` (`rank_id`, `rank_title`, `rank_min`, `rank_special`, `rank_image`) VALUES
  297. (1, 'Fresh Boarder', 0, 0, 'rank1.gif'),
  298. (2, 'Junior Boarder', 20, 0, 'rank2.gif'),
  299. (3, 'Senior Boarder', 40, 0, 'rank3.gif'),
  300. (4, 'Expert Boarder', 80, 0, 'rank4.gif'),
  301. (5, 'Gold Boarder', 160, 0, 'rank5.gif'),
  302. (6, 'Platinum Boarder', 320, 0, 'rank6.gif'),
  303. (7, 'Administrateur', 0, 1, 'rankadmin.gif'),
  304. (8, 'Modérateur', 0, 1, 'rankmod.gif'),
  305. (9, 'Spammer', 0, 1, 'rankspammer.gif'),
  306. (10, 'Bannis', 0, 1, 'rankbanned.gif');
  307.  
  308. -- --------------------------------------------------------
  309.  
  310. --
  311. -- Structure de la table `jv3_kunena_rate`
  312. --
  313.  
  314. CREATE TABLE `jv3_kunena_rate` (
  315.   `id` int(11) NOT NULL,
  316.   `topic_id` int(11) NOT NULL,
  317.   `userid` int(11) NOT NULL,
  318.   `rate` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  319.   `time` datetime NOT NULL
  320. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  321.  
  322. -- --------------------------------------------------------
  323.  
  324. --
  325. -- Structure de la table `jv3_kunena_sessions`
  326. --
  327.  
  328. CREATE TABLE `jv3_kunena_sessions` (
  329.   `userid` int(11) NOT NULL DEFAULT '0',
  330.   `allowed` text,
  331.   `lasttime` int(11) NOT NULL DEFAULT '0',
  332.   `readtopics` text,
  333.   `currvisit` int(11) NOT NULL DEFAULT '0'
  334. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  335.  
  336. --
  337. -- Déchargement des données de la table `jv3_kunena_sessions`
  338. --
  339.  
  340. INSERT INTO `jv3_kunena_sessions` (`userid`, `allowed`, `lasttime`, `readtopics`, `currvisit`) VALUES
  341. (339, 'na', 1508586753, '0', 1508591874);
  342.  
  343. -- --------------------------------------------------------
  344.  
  345. --
  346. -- Structure de la table `jv3_kunena_smileys`
  347. --
  348.  
  349. CREATE TABLE `jv3_kunena_smileys` (
  350.   `id` int(4) NOT NULL,
  351.   `code` varchar(12) NOT NULL DEFAULT '',
  352.   `location` varchar(50) NOT NULL DEFAULT '',
  353.   `greylocation` varchar(60) NOT NULL DEFAULT '',
  354.   `emoticonbar` tinyint(4) NOT NULL DEFAULT '0'
  355. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  356.  
  357. --
  358. -- Déchargement des données de la table `jv3_kunena_smileys`
  359. --
  360.  
  361. INSERT INTO `jv3_kunena_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) VALUES
  362. (1, 'B)', 'cool.png', 'cool-grey.png', 1),
  363. (2, '8)', 'cool.png', 'cool-grey.png', 0),
  364. (3, '8-)', 'cool.png', 'cool-grey.png', 0),
  365. (4, ':-(', 'sad.png', 'sad-grey.png', 0),
  366. (5, ':(', 'sad.png', 'sad-grey.png', 1),
  367. (6, ':sad:', 'sad.png', 'sad-grey.png', 0),
  368. (7, ':cry:', 'sad.png', 'sad-grey.png', 0),
  369. (8, ':)', 'smile.png', 'smile-grey.png', 1),
  370. (9, ':-)', 'smile.png', 'smile-grey.png', 0),
  371. (10, ':cheer:', 'cheerful.png', 'cheerful-grey.png', 1),
  372. (11, ';)', 'wink.png', 'wink-grey.png', 1),
  373. (12, ';-)', 'wink.png', 'wink-grey.png', 0),
  374. (13, ':wink:', 'wink.png', 'wink-grey.png', 0),
  375. (14, ';-)', 'wink.png', 'wink-grey.png', 0),
  376. (15, ':P', 'tongue.png', 'tongue-grey.png', 1),
  377. (16, ':p', 'tongue.png', 'tongue-grey.png', 0),
  378. (17, ':-p', 'tongue.png', 'tongue-grey.png', 0),
  379. (18, ':-P', 'tongue.png', 'tongue-grey.png', 0),
  380. (19, ':razz:', 'tongue.png', 'tongue-grey.png', 0),
  381. (20, ':angry:', 'angry.png', 'angry-grey.png', 1),
  382. (21, ':mad:', 'angry.png', 'angry-grey.png', 0),
  383. (22, ':unsure:', 'unsure.png', 'unsure-grey.png', 1),
  384. (23, ':o', 'shocked.png', 'shocked-grey.png', 0),
  385. (24, ':-o', 'shocked.png', 'shocked-grey.png', 0),
  386. (25, ':O', 'shocked.png', 'shocked-grey.png', 0),
  387. (26, ':-O', 'shocked.png', 'shocked-grey.png', 0),
  388. (27, ':eek:', 'shocked.png', 'shocked-grey.png', 0),
  389. (28, ':ohmy:', 'shocked.png', 'shocked-grey.png', 1),
  390. (29, ':huh:', 'wassat.png', 'wassat-grey.png', 1),
  391. (30, ':?', 'confused.png', 'confused-grey.png', 0),
  392. (31, ':-?', 'confused.png', 'confused-grey.png', 0),
  393. (32, ':???', 'confused.png', 'confused-grey.png', 0),
  394. (33, ':dry:', 'ermm.png', 'ermm-grey.png', 1),
  395. (34, ':ermm:', 'ermm.png', 'ermm-grey.png', 0),
  396. (35, ':lol:', 'grin.png', 'grin-grey.png', 1),
  397. (36, ':X', 'sick.png', 'sick-grey.png', 0),
  398. (37, ':x', 'sick.png', 'sick-grey.png', 0),
  399. (38, ':sick:', 'sick.png', 'sick-grey.png', 1),
  400. (39, ':silly:', 'silly.png', 'silly-grey.png', 1),
  401. (40, ':y32b4:', 'silly.png', 'silly-grey.png', 0),
  402. (41, ':blink:', 'blink.png', 'blink-grey.png', 1),
  403. (42, ':blush:', 'blush.png', 'blush-grey.png', 1),
  404. (43, ':oops:', 'blush.png', 'blush-grey.png', 1),
  405. (44, ':kiss:', 'kissing.png', 'kissing-grey.png', 1),
  406. (45, ':rolleyes:', 'blink.png', 'blink-grey.png', 0),
  407. (46, ':roll:', 'blink.png', 'blink-grey.png', 0),
  408. (47, ':woohoo:', 'w00t.png', 'w00t-grey.png', 1),
  409. (48, ':side:', 'sideways.png', 'sideways-grey.png', 1),
  410. (49, ':S', 'dizzy.png', 'dizzy-grey.png', 1),
  411. (50, ':s', 'dizzy.png', 'dizzy-grey.png', 0),
  412. (51, ':evil:', 'devil.png', 'devil-grey.png', 1),
  413. (52, ':twisted:', 'devil.png', 'devil-grey.png', 0),
  414. (53, ':whistle:', 'whistling.png', 'whistling-grey.png', 1),
  415. (54, ':pinch:', 'pinch.png', 'pinch-grey.png', 1),
  416. (55, ':D', 'laughing.png', 'laughing-grey.png', 0),
  417. (56, ':-D', 'laughing.png', 'laughing-grey.png', 0),
  418. (57, ':grin:', 'laughing.png', 'laughing-grey.png', 0),
  419. (58, ':laugh:', 'laughing.png', 'laughing-grey.png', 0),
  420. (59, ':|', 'neutral.png', 'neutral-grey.png', 0),
  421. (60, ':-|', 'neutral.png', 'neutral-grey.png', 0),
  422. (61, ':neutral:', 'neutral.png', 'neutral-grey.png', 0),
  423. (62, ':mrgreen:', 'mrgreen.png', 'mrgreen-grey.png', 0),
  424. (63, ':?:', 'question.png', 'question-grey.png', 0),
  425. (64, ':!:', 'exclamation.png', 'exclamation-grey.png', 0),
  426. (65, ':arrow:', 'arrow.png', 'arrow-grey.png', 0),
  427. (66, ':idea:', 'idea.png', 'idea-grey.png', 0);
  428.  
  429. -- --------------------------------------------------------
  430.  
  431. --
  432. -- Structure de la table `jv3_kunena_thankyou`
  433. --
  434.  
  435. CREATE TABLE `jv3_kunena_thankyou` (
  436.   `postid` int(11) NOT NULL,
  437.   `userid` int(11) NOT NULL,
  438.   `targetuserid` int(11) NOT NULL,
  439.   `time` datetime NOT NULL
  440. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  441.  
  442. -- --------------------------------------------------------
  443.  
  444. --
  445. -- Structure de la table `jv3_kunena_topics`
  446. --
  447.  
  448. CREATE TABLE `jv3_kunena_topics` (
  449.   `id` int(11) NOT NULL,
  450.   `category_id` int(11) NOT NULL DEFAULT '0',
  451.   `subject` tinytext,
  452.   `icon_id` int(11) NOT NULL DEFAULT '0',
  453.   `label_id` int(11) NOT NULL DEFAULT '0',
  454.   `locked` tinyint(4) NOT NULL DEFAULT '0',
  455.   `hold` tinyint(4) NOT NULL DEFAULT '0',
  456.   `ordering` int(11) NOT NULL DEFAULT '0',
  457.   `posts` int(11) NOT NULL DEFAULT '0',
  458.   `hits` int(11) NOT NULL DEFAULT '0',
  459.   `attachments` int(11) NOT NULL DEFAULT '0',
  460.   `poll_id` int(11) NOT NULL DEFAULT '0',
  461.   `moved_id` int(11) NOT NULL DEFAULT '0',
  462.   `first_post_id` int(11) NOT NULL DEFAULT '0',
  463.   `first_post_time` int(11) NOT NULL DEFAULT '0',
  464.   `first_post_userid` int(11) NOT NULL DEFAULT '0',
  465.   `first_post_message` text,
  466.   `first_post_guest_name` tinytext,
  467.   `last_post_id` int(11) NOT NULL DEFAULT '0',
  468.   `last_post_time` int(11) NOT NULL DEFAULT '0',
  469.   `last_post_userid` int(11) NOT NULL DEFAULT '0',
  470.   `last_post_message` text,
  471.   `last_post_guest_name` tinytext,
  472.   `rating` tinyint(4) NOT NULL,
  473.   `params` text NOT NULL
  474. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  475.  
  476. -- --------------------------------------------------------
  477.  
  478. --
  479. -- Structure de la table `jv3_kunena_users`
  480. --
  481.  
  482. CREATE TABLE `jv3_kunena_users` (
  483.   `userid` int(11) NOT NULL DEFAULT '0',
  484.   `status` tinyint(1) NOT NULL DEFAULT '0',
  485.   `status_text` varchar(255) NOT NULL,
  486.   `view` varchar(8) NOT NULL DEFAULT '',
  487.   `signature` text,
  488.   `moderator` int(11) DEFAULT '0',
  489.   `banned` datetime DEFAULT NULL,
  490.   `ordering` int(11) DEFAULT '0',
  491.   `posts` int(11) DEFAULT '0',
  492.   `avatar` varchar(255) DEFAULT NULL,
  493.   `karma` int(11) DEFAULT '0',
  494.   `karma_time` int(11) DEFAULT '0',
  495.   `group_id` int(4) DEFAULT '1',
  496.   `uhits` int(11) DEFAULT '0',
  497.   `personalText` tinytext,
  498.   `gender` tinyint(4) NOT NULL DEFAULT '0',
  499.   `birthdate` date NOT NULL DEFAULT '0001-01-01',
  500.   `location` varchar(50) DEFAULT NULL,
  501.   `aim` varchar(50) DEFAULT NULL,
  502.   `friendfeed` varchar(50) DEFAULT NULL,
  503.   `bebo` varchar(50) DEFAULT NULL,
  504.   `digg` varchar(50) DEFAULT NULL,
  505.   `icq` varchar(50) DEFAULT NULL,
  506.   `telegram` varchar(50) DEFAULT NULL,
  507.   `vk` varchar(50) DEFAULT NULL,
  508.   `microsoft` varchar(50) DEFAULT NULL,
  509.   `skype` varchar(50) DEFAULT NULL,
  510.   `twitter` varchar(50) DEFAULT NULL,
  511.   `facebook` varchar(50) DEFAULT NULL,
  512.   `google` varchar(50) DEFAULT NULL,
  513.   `myspace` varchar(50) DEFAULT NULL,
  514.   `linkedin` varchar(50) DEFAULT NULL,
  515.   `delicious` varchar(50) DEFAULT NULL,
  516.   `instagram` varchar(50) DEFAULT NULL,
  517.   `qq` varchar(50) DEFAULT NULL,
  518.   `blogspot` varchar(50) DEFAULT NULL,
  519.   `flickr` varchar(50) DEFAULT NULL,
  520.   `apple` varchar(50) DEFAULT NULL,
  521.   `qzone` varchar(50) DEFAULT NULL,
  522.   `weibo` varchar(50) DEFAULT NULL,
  523.   `wechat` varchar(50) DEFAULT NULL,
  524.   `yim` varchar(50) DEFAULT NULL,
  525.   `websitename` varchar(50) DEFAULT NULL,
  526.   `websiteurl` varchar(50) DEFAULT NULL,
  527.   `rank` tinyint(4) NOT NULL DEFAULT '0',
  528.   `hideEmail` tinyint(1) NOT NULL DEFAULT '1',
  529.   `showOnline` tinyint(1) NOT NULL DEFAULT '1',
  530.   `canSubscribe` tinyint(1) NOT NULL DEFAULT '-1',
  531.   `userListtime` int(11) DEFAULT '-2',
  532.   `thankyou` int(11) DEFAULT '0',
  533.   `ip` varchar(13) NOT NULL DEFAULT ''
  534. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  535.  
  536. --
  537. -- Déchargement des données de la table `jv3_kunena_users`
  538. --
  539.  
  540. INSERT INTO `jv3_kunena_users` (`userid`, `status`, `status_text`, `view`, `signature`, `moderator`, `banned`, `ordering`, `posts`, `avatar`, `karma`, `karma_time`, `group_id`, `uhits`, `personalText`, `gender`, `birthdate`, `location`, `aim`, `friendfeed`, `bebo`, `digg`, `icq`, `telegram`, `vk`, `microsoft`, `skype`, `twitter`, `facebook`, `google`, `myspace`, `linkedin`, `delicious`, `instagram`, `qq`, `blogspot`, `flickr`, `apple`, `qzone`, `weibo`, `wechat`, `yim`, `websitename`, `websiteurl`, `rank`, `hideEmail`, `showOnline`, `canSubscribe`, `userListtime`, `thankyou`, `ip`) VALUES
  541. (339, 0, '', '', NULL, 0, NULL, 0, 1, NULL, 0, 0, 1, 0, NULL, 0, '0001-01-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 1, -1, -2, 0, '');
  542.  
  543. -- --------------------------------------------------------
  544.  
  545. --
  546. -- Structure de la table `jv3_kunena_users_banned`
  547. --
  548.  
  549. CREATE TABLE `jv3_kunena_users_banned` (
  550.   `id` int(11) NOT NULL,
  551.   `userid` int(11) DEFAULT NULL,
  552.   `ip` varchar(128) DEFAULT NULL,
  553.   `blocked` tinyint(4) NOT NULL DEFAULT '0',
  554.   `expiration` datetime DEFAULT NULL,
  555.   `created_by` int(11) NOT NULL,
  556.   `created_time` datetime NOT NULL,
  557.   `reason_private` text,
  558.   `reason_public` text,
  559.   `modified_by` int(11) DEFAULT NULL,
  560.   `modified_time` datetime DEFAULT NULL,
  561.   `comments` text,
  562.   `params` text
  563. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  564.  
  565. -- --------------------------------------------------------
  566.  
  567. --
  568. -- Structure de la table `jv3_kunena_user_categories`
  569. --
  570.  
  571. CREATE TABLE `jv3_kunena_user_categories` (
  572.   `user_id` int(11) NOT NULL,
  573.   `category_id` int(11) NOT NULL,
  574.   `role` tinyint(4) NOT NULL DEFAULT '0',
  575.   `allreadtime` int(11) NOT NULL DEFAULT '0',
  576.   `subscribed` tinyint(4) NOT NULL DEFAULT '0',
  577.   `params` text NOT NULL
  578. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  579.  
  580. --
  581. -- Déchargement des données de la table `jv3_kunena_user_categories`
  582. --
  583.  
  584. INSERT INTO `jv3_kunena_user_categories` (`user_id`, `category_id`, `role`, `allreadtime`, `subscribed`, `params`) VALUES
  585. (339, 0, 0, 1507332723, 0, '');
  586.  
  587. -- --------------------------------------------------------
  588.  
  589. --
  590. -- Structure de la table `jv3_kunena_user_read`
  591. --
  592.  
  593. CREATE TABLE `jv3_kunena_user_read` (
  594.   `user_id` int(11) NOT NULL,
  595.   `topic_id` int(11) NOT NULL,
  596.   `category_id` int(11) NOT NULL,
  597.   `message_id` int(11) NOT NULL,
  598.   `time` int(11) NOT NULL
  599. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  600.  
  601. -- --------------------------------------------------------
  602.  
  603. --
  604. -- Structure de la table `jv3_kunena_user_topics`
  605. --
  606.  
  607. CREATE TABLE `jv3_kunena_user_topics` (
  608.   `user_id` int(11) NOT NULL DEFAULT '0',
  609.   `topic_id` int(11) NOT NULL DEFAULT '0',
  610.   `category_id` int(11) NOT NULL,
  611.   `posts` mediumint(8) NOT NULL DEFAULT '0',
  612.   `last_post_id` int(11) NOT NULL DEFAULT '0',
  613.   `owner` tinyint(4) NOT NULL DEFAULT '0',
  614.   `favorite` tinyint(4) NOT NULL DEFAULT '0',
  615.   `subscribed` tinyint(4) NOT NULL DEFAULT '0',
  616.   `params` text NOT NULL
  617. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  618.  
  619. -- --------------------------------------------------------
  620.  
  621. --
  622. -- Structure de la table `jv3_kunena_version`
  623. --
  624.  
  625. CREATE TABLE `jv3_kunena_version` (
  626.   `id` int(11) NOT NULL,
  627.   `version` varchar(20) NOT NULL,
  628.   `versiondate` date NOT NULL,
  629.   `installdate` date NOT NULL,
  630.   `build` varchar(20) NOT NULL,
  631.   `versionname` varchar(40) DEFAULT NULL,
  632.   `state` text NOT NULL
  633. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  634.  
  635. --
  636. -- Déchargement des données de la table `jv3_kunena_version`
  637. --
  638.  
  639. INSERT INTO `jv3_kunena_version` (`id`, `version`, `versiondate`, `installdate`, `build`, `versionname`, `state`) VALUES
  640. (1, '5.0.11', '2017-09-02', '2017-10-20', '', 'Kinkajou', '');
  641.  
  642. --
  643. -- Index pour les tables déchargées
  644. --
  645.  
  646. --
  647. -- Index pour la table `jv3_kunena_aliases`
  648. --
  649. ALTER TABLE `jv3_kunena_aliases`
  650.   ADD UNIQUE KEY `alias` (`alias`),
  651.   ADD KEY `state` (`state`),
  652.   ADD KEY `item` (`item`),
  653.   ADD KEY `type` (`type`);
  654.  
  655. --
  656. -- Index pour la table `jv3_kunena_announcement`
  657. --
  658. ALTER TABLE `jv3_kunena_announcement`
  659.   ADD PRIMARY KEY (`id`);
  660.  
  661. --
  662. -- Index pour la table `jv3_kunena_attachments`
  663. --
  664. ALTER TABLE `jv3_kunena_attachments`
  665.   ADD PRIMARY KEY (`id`),
  666.   ADD KEY `mesid` (`mesid`),
  667.   ADD KEY `userid` (`userid`),
  668.   ADD KEY `hash` (`hash`),
  669.   ADD KEY `filename` (`filename`),
  670.   ADD KEY `filename_real` (`filename_real`);
  671.  
  672. --
  673. -- Index pour la table `jv3_kunena_categories`
  674. --
  675. ALTER TABLE `jv3_kunena_categories`
  676.   ADD PRIMARY KEY (`id`),
  677.   ADD KEY `parent_id` (`parent_id`),
  678.   ADD KEY `category_access` (`accesstype`,`access`),
  679.   ADD KEY `published_pubaccess_id` (`published`,`pub_access`,`id`);
  680.  
  681. --
  682. -- Index pour la table `jv3_kunena_configuration`
  683. --
  684. ALTER TABLE `jv3_kunena_configuration`
  685.   ADD PRIMARY KEY (`id`);
  686.  
  687. --
  688. -- Index pour la table `jv3_kunena_logs`
  689. --
  690. ALTER TABLE `jv3_kunena_logs`
  691.   ADD PRIMARY KEY (`id`),
  692.   ADD KEY `type` (`type`),
  693.   ADD KEY `category_id` (`category_id`),
  694.   ADD KEY `topic_id` (`topic_id`),
  695.   ADD KEY `target_user` (`target_user`),
  696.   ADD KEY `user_id` (`user_id`);
  697.  
  698. --
  699. -- Index pour la table `jv3_kunena_messages`
  700. --
  701. ALTER TABLE `jv3_kunena_messages`
  702.   ADD PRIMARY KEY (`id`),
  703.   ADD KEY `thread` (`thread`),
  704.   ADD KEY `ip` (`ip`),
  705.   ADD KEY `userid` (`userid`),
  706.   ADD KEY `time` (`time`),
  707.   ADD KEY `locked` (`locked`),
  708.   ADD KEY `hold_time` (`hold`,`time`),
  709.   ADD KEY `parent_hits` (`parent`,`hits`),
  710.   ADD KEY `catid_parent` (`catid`,`parent`);
  711.  
  712. --
  713. -- Index pour la table `jv3_kunena_messages_text`
  714. --
  715. ALTER TABLE `jv3_kunena_messages_text`
  716.   ADD PRIMARY KEY (`mesid`);
  717.  
  718. --
  719. -- Index pour la table `jv3_kunena_polls`
  720. --
  721. ALTER TABLE `jv3_kunena_polls`
  722.   ADD PRIMARY KEY (`id`),
  723.   ADD KEY `threadid` (`threadid`);
  724.  
  725. --
  726. -- Index pour la table `jv3_kunena_polls_options`
  727. --
  728. ALTER TABLE `jv3_kunena_polls_options`
  729.   ADD PRIMARY KEY (`id`),
  730.   ADD KEY `pollid` (`pollid`);
  731.  
  732. --
  733. -- Index pour la table `jv3_kunena_polls_users`
  734. --
  735. ALTER TABLE `jv3_kunena_polls_users`
  736.   ADD UNIQUE KEY `pollid` (`pollid`,`userid`);
  737.  
  738. --
  739. -- Index pour la table `jv3_kunena_ranks`
  740. --
  741. ALTER TABLE `jv3_kunena_ranks`
  742.   ADD PRIMARY KEY (`rank_id`);
  743.  
  744. --
  745. -- Index pour la table `jv3_kunena_rate`
  746. --
  747. ALTER TABLE `jv3_kunena_rate`
  748.   ADD PRIMARY KEY (`id`);
  749.  
  750. --
  751. -- Index pour la table `jv3_kunena_sessions`
  752. --
  753. ALTER TABLE `jv3_kunena_sessions`
  754.   ADD PRIMARY KEY (`userid`),
  755.   ADD KEY `currvisit` (`currvisit`);
  756.  
  757. --
  758. -- Index pour la table `jv3_kunena_smileys`
  759. --
  760. ALTER TABLE `jv3_kunena_smileys`
  761.   ADD PRIMARY KEY (`id`);
  762.  
  763. --
  764. -- Index pour la table `jv3_kunena_thankyou`
  765. --
  766. ALTER TABLE `jv3_kunena_thankyou`
  767.   ADD UNIQUE KEY `postid` (`postid`,`userid`),
  768.   ADD KEY `userid` (`userid`),
  769.   ADD KEY `targetuserid` (`targetuserid`);
  770.  
  771. --
  772. -- Index pour la table `jv3_kunena_topics`
  773. --
  774. ALTER TABLE `jv3_kunena_topics`
  775.   ADD PRIMARY KEY (`id`),
  776.   ADD KEY `category_id` (`category_id`),
  777.   ADD KEY `locked` (`locked`),
  778.   ADD KEY `hold` (`hold`),
  779.   ADD KEY `posts` (`posts`),
  780.   ADD KEY `hits` (`hits`),
  781.   ADD KEY `first_post_userid` (`first_post_userid`),
  782.   ADD KEY `last_post_userid` (`last_post_userid`),
  783.   ADD KEY `first_post_time` (`first_post_time`),
  784.   ADD KEY `last_post_time` (`last_post_time`),
  785.   ADD KEY `last_post_id` (`last_post_id`);
  786.  
  787. --
  788. -- Index pour la table `jv3_kunena_users`
  789. --
  790. ALTER TABLE `jv3_kunena_users`
  791.   ADD PRIMARY KEY (`userid`),
  792.   ADD KEY `group_id` (`group_id`),
  793.   ADD KEY `posts` (`posts`),
  794.   ADD KEY `uhits` (`uhits`),
  795.   ADD KEY `banned` (`banned`),
  796.   ADD KEY `moderator` (`moderator`);
  797.  
  798. --
  799. -- Index pour la table `jv3_kunena_users_banned`
  800. --
  801. ALTER TABLE `jv3_kunena_users_banned`
  802.   ADD PRIMARY KEY (`id`),
  803.   ADD KEY `userid` (`userid`),
  804.   ADD KEY `ip` (`ip`),
  805.   ADD KEY `expiration` (`expiration`),
  806.   ADD KEY `created_time` (`created_time`);
  807.  
  808. --
  809. -- Index pour la table `jv3_kunena_user_categories`
  810. --
  811. ALTER TABLE `jv3_kunena_user_categories`
  812.   ADD PRIMARY KEY (`user_id`,`category_id`),
  813.   ADD KEY `category_subscribed` (`category_id`,`subscribed`),
  814.   ADD KEY `role` (`role`);
  815.  
  816. --
  817. -- Index pour la table `jv3_kunena_user_read`
  818. --
  819. ALTER TABLE `jv3_kunena_user_read`
  820.   ADD UNIQUE KEY `user_topic_id` (`user_id`,`topic_id`),
  821.   ADD KEY `category_user_id` (`category_id`,`user_id`),
  822.   ADD KEY `time` (`time`);
  823.  
  824. --
  825. -- Index pour la table `jv3_kunena_user_topics`
  826. --
  827. ALTER TABLE `jv3_kunena_user_topics`
  828.   ADD UNIQUE KEY `user_topic_id` (`user_id`,`topic_id`),
  829.   ADD KEY `topic_id` (`topic_id`),
  830.   ADD KEY `posts` (`posts`),
  831.   ADD KEY `owner` (`owner`),
  832.   ADD KEY `favorite` (`favorite`),
  833.   ADD KEY `subscribed` (`subscribed`);
  834.  
  835. --
  836. -- Index pour la table `jv3_kunena_version`
  837. --
  838. ALTER TABLE `jv3_kunena_version`
  839.   ADD PRIMARY KEY (`id`);
  840.  
  841. --
  842. -- AUTO_INCREMENT pour les tables déchargées
  843. --
  844.  
  845. --
  846. -- AUTO_INCREMENT pour la table `jv3_kunena_announcement`
  847. --
  848. ALTER TABLE `jv3_kunena_announcement`
  849.   MODIFY `id` int(3) NOT NULL AUTO_INCREMENT;
  850. --
  851. -- AUTO_INCREMENT pour la table `jv3_kunena_attachments`
  852. --
  853. ALTER TABLE `jv3_kunena_attachments`
  854.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  855. --
  856. -- AUTO_INCREMENT pour la table `jv3_kunena_categories`
  857. --
  858. ALTER TABLE `jv3_kunena_categories`
  859.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  860. --
  861. -- AUTO_INCREMENT pour la table `jv3_kunena_logs`
  862. --
  863. ALTER TABLE `jv3_kunena_logs`
  864.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  865. --
  866. -- AUTO_INCREMENT pour la table `jv3_kunena_messages`
  867. --
  868. ALTER TABLE `jv3_kunena_messages`
  869.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  870. --
  871. -- AUTO_INCREMENT pour la table `jv3_kunena_polls`
  872. --
  873. ALTER TABLE `jv3_kunena_polls`
  874.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  875. --
  876. -- AUTO_INCREMENT pour la table `jv3_kunena_polls_options`
  877. --
  878. ALTER TABLE `jv3_kunena_polls_options`
  879.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  880. --
  881. -- AUTO_INCREMENT pour la table `jv3_kunena_ranks`
  882. --
  883. ALTER TABLE `jv3_kunena_ranks`
  884.   MODIFY `rank_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  885. --
  886. -- AUTO_INCREMENT pour la table `jv3_kunena_rate`
  887. --
  888. ALTER TABLE `jv3_kunena_rate`
  889.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  890. --
  891. -- AUTO_INCREMENT pour la table `jv3_kunena_smileys`
  892. --
  893. ALTER TABLE `jv3_kunena_smileys`
  894.   MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
  895. --
  896. -- AUTO_INCREMENT pour la table `jv3_kunena_topics`
  897. --
  898. ALTER TABLE `jv3_kunena_topics`
  899.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  900. --
  901. -- AUTO_INCREMENT pour la table `jv3_kunena_users_banned`
  902. --
  903. ALTER TABLE `jv3_kunena_users_banned`
  904.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  905. --
  906. -- AUTO_INCREMENT pour la table `jv3_kunena_version`
  907. --
  908. ALTER TABLE `jv3_kunena_version`
  909.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;COMMIT;
  910.  
  911. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  912. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  913. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
RAW Paste Data