Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.7.0
- -- https://www.phpmyadmin.net/
- --
- -- Hôte : localhost
- -- Généré le : lun. 23 oct. 2017 à 21:43
- -- Version du serveur : 10.1.25-MariaDB
- -- Version de PHP : 7.1.7
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Base de données : `joomla`
- --
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_aliases`
- --
- CREATE TABLE `jv3_kunena_aliases` (
- `alias` varchar(190) NOT NULL,
- `type` varchar(10) NOT NULL,
- `item` varchar(32) NOT NULL,
- `state` tinyint(4) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_aliases`
- --
- INSERT INTO `jv3_kunena_aliases` (`alias`, `type`, `item`, `state`) VALUES
- ('announcement', 'view', 'announcement', 1),
- ('bienvenue', 'catid', '2', 1),
- ('boite-a-idee', 'catid', '3', 1),
- ('category', 'view', 'category', 1),
- ('category/create', 'layout', 'category.create', 1),
- ('category/default', 'layout', 'category.default', 1),
- ('category/edit', 'layout', 'category.edit', 1),
- ('category/manage', 'layout', 'category.manage', 1),
- ('category/moderate', 'layout', 'category.moderate', 1),
- ('category/user', 'layout', 'category.user', 1),
- ('common', 'view', 'common', 1),
- ('create', 'layout', 'category.create', 0),
- ('credits', 'view', 'credits', 1),
- ('default', 'layout', 'category.default', 0),
- ('edit', 'layout', 'category.edit', 0),
- ('forum-principal', 'catid', '1', 1),
- ('home', 'view', 'home', 1),
- ('manage', 'layout', 'category.manage', 0),
- ('misc', 'view', 'misc', 1),
- ('moderate', 'layout', 'category.moderate', 0),
- ('search', 'view', 'search', 1),
- ('statistics', 'view', 'statistics', 1),
- ('topic', 'view', 'topic', 1),
- ('topics', 'view', 'topics', 1),
- ('user', 'view', 'user', 1);
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_announcement`
- --
- CREATE TABLE `jv3_kunena_announcement` (
- `id` int(3) NOT NULL,
- `title` tinytext NOT NULL,
- `created_by` int(11) NOT NULL DEFAULT '0',
- `sdescription` text NOT NULL,
- `description` text NOT NULL,
- `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `published` tinyint(1) NOT NULL DEFAULT '0',
- `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `ordering` tinyint(4) NOT NULL DEFAULT '0',
- `showdate` tinyint(1) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_attachments`
- --
- CREATE TABLE `jv3_kunena_attachments` (
- `id` int(11) NOT NULL,
- `mesid` int(11) NOT NULL DEFAULT '0',
- `userid` int(11) NOT NULL DEFAULT '0',
- `protected` tinyint(4) NOT NULL DEFAULT '0',
- `hash` char(32) DEFAULT NULL,
- `size` int(11) DEFAULT NULL,
- `folder` varchar(255) NOT NULL,
- `filetype` varchar(20) NOT NULL,
- `filename` varchar(255) NOT NULL,
- `filename_real` varchar(255) NOT NULL DEFAULT '',
- `caption` varchar(255) NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_categories`
- --
- CREATE TABLE `jv3_kunena_categories` (
- `id` int(11) NOT NULL,
- `parent_id` int(11) DEFAULT '0',
- `name` tinytext,
- `alias` varchar(255) NOT NULL,
- `icon` varchar(60) NOT NULL,
- `icon_id` tinyint(4) NOT NULL DEFAULT '0',
- `locked` tinyint(4) NOT NULL DEFAULT '0',
- `accesstype` varchar(20) NOT NULL DEFAULT 'joomla.level',
- `access` int(11) NOT NULL DEFAULT '0',
- `pub_access` int(11) NOT NULL DEFAULT '1',
- `pub_recurse` tinyint(4) DEFAULT '1',
- `admin_access` int(11) NOT NULL DEFAULT '0',
- `admin_recurse` tinyint(4) DEFAULT '1',
- `ordering` smallint(6) NOT NULL DEFAULT '0',
- `published` tinyint(4) NOT NULL DEFAULT '0',
- `channels` text,
- `checked_out` tinyint(4) NOT NULL DEFAULT '0',
- `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `review` tinyint(4) NOT NULL DEFAULT '0',
- `allow_anonymous` tinyint(4) NOT NULL DEFAULT '0',
- `post_anonymous` tinyint(4) NOT NULL DEFAULT '0',
- `hits` int(11) NOT NULL DEFAULT '0',
- `description` text NOT NULL,
- `headerdesc` text NOT NULL,
- `class_sfx` varchar(20) NOT NULL,
- `allow_polls` tinyint(4) NOT NULL DEFAULT '0',
- `topic_ordering` varchar(16) NOT NULL DEFAULT 'lastpost',
- `iconset` varchar(255) NOT NULL DEFAULT 'default',
- `numTopics` mediumint(8) NOT NULL DEFAULT '0',
- `numPosts` mediumint(8) NOT NULL DEFAULT '0',
- `last_topic_id` int(11) NOT NULL DEFAULT '0',
- `last_post_id` int(11) NOT NULL DEFAULT '0',
- `last_post_time` int(11) NOT NULL DEFAULT '0',
- `params` text NOT NULL,
- `allow_ratings` tinyint(4) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_categories`
- --
- 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
- (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),
- (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),
- (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);
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_configuration`
- --
- CREATE TABLE `jv3_kunena_configuration` (
- `id` int(11) NOT NULL DEFAULT '0',
- `params` text
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_configuration`
- --
- INSERT INTO `jv3_kunena_configuration` (`id`, `params`) VALUES
- (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\"}}}');
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_logs`
- --
- CREATE TABLE `jv3_kunena_logs` (
- `id` int(11) NOT NULL,
- `type` tinyint(4) NOT NULL DEFAULT '0',
- `user_id` int(11) NOT NULL DEFAULT '0',
- `category_id` int(11) NOT NULL DEFAULT '0',
- `topic_id` int(11) NOT NULL DEFAULT '0',
- `target_user` int(11) NOT NULL DEFAULT '0',
- `ip` varchar(40) NOT NULL DEFAULT '',
- `time` int(11) NOT NULL DEFAULT '0',
- `operation` varchar(40) NOT NULL,
- `data` mediumtext NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_messages`
- --
- CREATE TABLE `jv3_kunena_messages` (
- `id` int(11) NOT NULL,
- `parent` int(11) DEFAULT '0',
- `thread` int(11) DEFAULT '0',
- `catid` int(11) NOT NULL DEFAULT '0',
- `name` tinytext,
- `userid` int(11) NOT NULL DEFAULT '0',
- `email` tinytext,
- `subject` tinytext,
- `time` int(11) NOT NULL DEFAULT '0',
- `ip` varchar(128) DEFAULT NULL,
- `topic_emoticon` int(11) NOT NULL DEFAULT '0',
- `locked` tinyint(4) NOT NULL DEFAULT '0',
- `hold` tinyint(4) NOT NULL DEFAULT '0',
- `ordering` int(11) DEFAULT '0',
- `hits` int(11) DEFAULT '0',
- `moved` tinyint(4) DEFAULT '0',
- `modified_by` int(7) DEFAULT NULL,
- `modified_time` int(11) DEFAULT NULL,
- `modified_reason` tinytext
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_messages_text`
- --
- CREATE TABLE `jv3_kunena_messages_text` (
- `mesid` int(11) NOT NULL DEFAULT '0',
- `message` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_polls`
- --
- CREATE TABLE `jv3_kunena_polls` (
- `id` int(11) NOT NULL,
- `title` varchar(100) NOT NULL,
- `threadid` int(11) NOT NULL,
- `polltimetolive` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_polls_options`
- --
- CREATE TABLE `jv3_kunena_polls_options` (
- `id` int(11) NOT NULL,
- `pollid` int(11) DEFAULT NULL,
- `text` varchar(100) DEFAULT NULL,
- `votes` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_polls_users`
- --
- CREATE TABLE `jv3_kunena_polls_users` (
- `pollid` int(11) DEFAULT NULL,
- `userid` int(11) DEFAULT NULL,
- `votes` int(11) DEFAULT NULL,
- `lasttime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `lastvote` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_ranks`
- --
- CREATE TABLE `jv3_kunena_ranks` (
- `rank_id` mediumint(8) UNSIGNED NOT NULL,
- `rank_title` varchar(255) NOT NULL DEFAULT '',
- `rank_min` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `rank_special` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `rank_image` varchar(255) NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_ranks`
- --
- INSERT INTO `jv3_kunena_ranks` (`rank_id`, `rank_title`, `rank_min`, `rank_special`, `rank_image`) VALUES
- (1, 'Fresh Boarder', 0, 0, 'rank1.gif'),
- (2, 'Junior Boarder', 20, 0, 'rank2.gif'),
- (3, 'Senior Boarder', 40, 0, 'rank3.gif'),
- (4, 'Expert Boarder', 80, 0, 'rank4.gif'),
- (5, 'Gold Boarder', 160, 0, 'rank5.gif'),
- (6, 'Platinum Boarder', 320, 0, 'rank6.gif'),
- (7, 'Administrateur', 0, 1, 'rankadmin.gif'),
- (8, 'Modérateur', 0, 1, 'rankmod.gif'),
- (9, 'Spammer', 0, 1, 'rankspammer.gif'),
- (10, 'Bannis', 0, 1, 'rankbanned.gif');
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_rate`
- --
- CREATE TABLE `jv3_kunena_rate` (
- `id` int(11) NOT NULL,
- `topic_id` int(11) NOT NULL,
- `userid` int(11) NOT NULL,
- `rate` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `time` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_sessions`
- --
- CREATE TABLE `jv3_kunena_sessions` (
- `userid` int(11) NOT NULL DEFAULT '0',
- `allowed` text,
- `lasttime` int(11) NOT NULL DEFAULT '0',
- `readtopics` text,
- `currvisit` int(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_sessions`
- --
- INSERT INTO `jv3_kunena_sessions` (`userid`, `allowed`, `lasttime`, `readtopics`, `currvisit`) VALUES
- (339, 'na', 1508586753, '0', 1508591874);
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_smileys`
- --
- CREATE TABLE `jv3_kunena_smileys` (
- `id` int(4) NOT NULL,
- `code` varchar(12) NOT NULL DEFAULT '',
- `location` varchar(50) NOT NULL DEFAULT '',
- `greylocation` varchar(60) NOT NULL DEFAULT '',
- `emoticonbar` tinyint(4) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_smileys`
- --
- INSERT INTO `jv3_kunena_smileys` (`id`, `code`, `location`, `greylocation`, `emoticonbar`) VALUES
- (1, 'B)', 'cool.png', 'cool-grey.png', 1),
- (2, '8)', 'cool.png', 'cool-grey.png', 0),
- (3, '8-)', 'cool.png', 'cool-grey.png', 0),
- (4, ':-(', 'sad.png', 'sad-grey.png', 0),
- (5, ':(', 'sad.png', 'sad-grey.png', 1),
- (6, ':sad:', 'sad.png', 'sad-grey.png', 0),
- (7, ':cry:', 'sad.png', 'sad-grey.png', 0),
- (8, ':)', 'smile.png', 'smile-grey.png', 1),
- (9, ':-)', 'smile.png', 'smile-grey.png', 0),
- (10, ':cheer:', 'cheerful.png', 'cheerful-grey.png', 1),
- (11, ';)', 'wink.png', 'wink-grey.png', 1),
- (12, ';-)', 'wink.png', 'wink-grey.png', 0),
- (13, ':wink:', 'wink.png', 'wink-grey.png', 0),
- (14, ';-)', 'wink.png', 'wink-grey.png', 0),
- (15, ':P', 'tongue.png', 'tongue-grey.png', 1),
- (16, ':p', 'tongue.png', 'tongue-grey.png', 0),
- (17, ':-p', 'tongue.png', 'tongue-grey.png', 0),
- (18, ':-P', 'tongue.png', 'tongue-grey.png', 0),
- (19, ':razz:', 'tongue.png', 'tongue-grey.png', 0),
- (20, ':angry:', 'angry.png', 'angry-grey.png', 1),
- (21, ':mad:', 'angry.png', 'angry-grey.png', 0),
- (22, ':unsure:', 'unsure.png', 'unsure-grey.png', 1),
- (23, ':o', 'shocked.png', 'shocked-grey.png', 0),
- (24, ':-o', 'shocked.png', 'shocked-grey.png', 0),
- (25, ':O', 'shocked.png', 'shocked-grey.png', 0),
- (26, ':-O', 'shocked.png', 'shocked-grey.png', 0),
- (27, ':eek:', 'shocked.png', 'shocked-grey.png', 0),
- (28, ':ohmy:', 'shocked.png', 'shocked-grey.png', 1),
- (29, ':huh:', 'wassat.png', 'wassat-grey.png', 1),
- (30, ':?', 'confused.png', 'confused-grey.png', 0),
- (31, ':-?', 'confused.png', 'confused-grey.png', 0),
- (32, ':???', 'confused.png', 'confused-grey.png', 0),
- (33, ':dry:', 'ermm.png', 'ermm-grey.png', 1),
- (34, ':ermm:', 'ermm.png', 'ermm-grey.png', 0),
- (35, ':lol:', 'grin.png', 'grin-grey.png', 1),
- (36, ':X', 'sick.png', 'sick-grey.png', 0),
- (37, ':x', 'sick.png', 'sick-grey.png', 0),
- (38, ':sick:', 'sick.png', 'sick-grey.png', 1),
- (39, ':silly:', 'silly.png', 'silly-grey.png', 1),
- (40, ':y32b4:', 'silly.png', 'silly-grey.png', 0),
- (41, ':blink:', 'blink.png', 'blink-grey.png', 1),
- (42, ':blush:', 'blush.png', 'blush-grey.png', 1),
- (43, ':oops:', 'blush.png', 'blush-grey.png', 1),
- (44, ':kiss:', 'kissing.png', 'kissing-grey.png', 1),
- (45, ':rolleyes:', 'blink.png', 'blink-grey.png', 0),
- (46, ':roll:', 'blink.png', 'blink-grey.png', 0),
- (47, ':woohoo:', 'w00t.png', 'w00t-grey.png', 1),
- (48, ':side:', 'sideways.png', 'sideways-grey.png', 1),
- (49, ':S', 'dizzy.png', 'dizzy-grey.png', 1),
- (50, ':s', 'dizzy.png', 'dizzy-grey.png', 0),
- (51, ':evil:', 'devil.png', 'devil-grey.png', 1),
- (52, ':twisted:', 'devil.png', 'devil-grey.png', 0),
- (53, ':whistle:', 'whistling.png', 'whistling-grey.png', 1),
- (54, ':pinch:', 'pinch.png', 'pinch-grey.png', 1),
- (55, ':D', 'laughing.png', 'laughing-grey.png', 0),
- (56, ':-D', 'laughing.png', 'laughing-grey.png', 0),
- (57, ':grin:', 'laughing.png', 'laughing-grey.png', 0),
- (58, ':laugh:', 'laughing.png', 'laughing-grey.png', 0),
- (59, ':|', 'neutral.png', 'neutral-grey.png', 0),
- (60, ':-|', 'neutral.png', 'neutral-grey.png', 0),
- (61, ':neutral:', 'neutral.png', 'neutral-grey.png', 0),
- (62, ':mrgreen:', 'mrgreen.png', 'mrgreen-grey.png', 0),
- (63, ':?:', 'question.png', 'question-grey.png', 0),
- (64, ':!:', 'exclamation.png', 'exclamation-grey.png', 0),
- (65, ':arrow:', 'arrow.png', 'arrow-grey.png', 0),
- (66, ':idea:', 'idea.png', 'idea-grey.png', 0);
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_thankyou`
- --
- CREATE TABLE `jv3_kunena_thankyou` (
- `postid` int(11) NOT NULL,
- `userid` int(11) NOT NULL,
- `targetuserid` int(11) NOT NULL,
- `time` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_topics`
- --
- CREATE TABLE `jv3_kunena_topics` (
- `id` int(11) NOT NULL,
- `category_id` int(11) NOT NULL DEFAULT '0',
- `subject` tinytext,
- `icon_id` int(11) NOT NULL DEFAULT '0',
- `label_id` int(11) NOT NULL DEFAULT '0',
- `locked` tinyint(4) NOT NULL DEFAULT '0',
- `hold` tinyint(4) NOT NULL DEFAULT '0',
- `ordering` int(11) NOT NULL DEFAULT '0',
- `posts` int(11) NOT NULL DEFAULT '0',
- `hits` int(11) NOT NULL DEFAULT '0',
- `attachments` int(11) NOT NULL DEFAULT '0',
- `poll_id` int(11) NOT NULL DEFAULT '0',
- `moved_id` int(11) NOT NULL DEFAULT '0',
- `first_post_id` int(11) NOT NULL DEFAULT '0',
- `first_post_time` int(11) NOT NULL DEFAULT '0',
- `first_post_userid` int(11) NOT NULL DEFAULT '0',
- `first_post_message` text,
- `first_post_guest_name` tinytext,
- `last_post_id` int(11) NOT NULL DEFAULT '0',
- `last_post_time` int(11) NOT NULL DEFAULT '0',
- `last_post_userid` int(11) NOT NULL DEFAULT '0',
- `last_post_message` text,
- `last_post_guest_name` tinytext,
- `rating` tinyint(4) NOT NULL,
- `params` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_users`
- --
- CREATE TABLE `jv3_kunena_users` (
- `userid` int(11) NOT NULL DEFAULT '0',
- `status` tinyint(1) NOT NULL DEFAULT '0',
- `status_text` varchar(255) NOT NULL,
- `view` varchar(8) NOT NULL DEFAULT '',
- `signature` text,
- `moderator` int(11) DEFAULT '0',
- `banned` datetime DEFAULT NULL,
- `ordering` int(11) DEFAULT '0',
- `posts` int(11) DEFAULT '0',
- `avatar` varchar(255) DEFAULT NULL,
- `karma` int(11) DEFAULT '0',
- `karma_time` int(11) DEFAULT '0',
- `group_id` int(4) DEFAULT '1',
- `uhits` int(11) DEFAULT '0',
- `personalText` tinytext,
- `gender` tinyint(4) NOT NULL DEFAULT '0',
- `birthdate` date NOT NULL DEFAULT '0001-01-01',
- `location` varchar(50) DEFAULT NULL,
- `aim` varchar(50) DEFAULT NULL,
- `friendfeed` varchar(50) DEFAULT NULL,
- `bebo` varchar(50) DEFAULT NULL,
- `digg` varchar(50) DEFAULT NULL,
- `icq` varchar(50) DEFAULT NULL,
- `telegram` varchar(50) DEFAULT NULL,
- `vk` varchar(50) DEFAULT NULL,
- `microsoft` varchar(50) DEFAULT NULL,
- `skype` varchar(50) DEFAULT NULL,
- `twitter` varchar(50) DEFAULT NULL,
- `facebook` varchar(50) DEFAULT NULL,
- `google` varchar(50) DEFAULT NULL,
- `myspace` varchar(50) DEFAULT NULL,
- `linkedin` varchar(50) DEFAULT NULL,
- `delicious` varchar(50) DEFAULT NULL,
- `instagram` varchar(50) DEFAULT NULL,
- `qq` varchar(50) DEFAULT NULL,
- `blogspot` varchar(50) DEFAULT NULL,
- `flickr` varchar(50) DEFAULT NULL,
- `apple` varchar(50) DEFAULT NULL,
- `qzone` varchar(50) DEFAULT NULL,
- `weibo` varchar(50) DEFAULT NULL,
- `wechat` varchar(50) DEFAULT NULL,
- `yim` varchar(50) DEFAULT NULL,
- `websitename` varchar(50) DEFAULT NULL,
- `websiteurl` varchar(50) DEFAULT NULL,
- `rank` tinyint(4) NOT NULL DEFAULT '0',
- `hideEmail` tinyint(1) NOT NULL DEFAULT '1',
- `showOnline` tinyint(1) NOT NULL DEFAULT '1',
- `canSubscribe` tinyint(1) NOT NULL DEFAULT '-1',
- `userListtime` int(11) DEFAULT '-2',
- `thankyou` int(11) DEFAULT '0',
- `ip` varchar(13) NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_users`
- --
- 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
- (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, '');
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_users_banned`
- --
- CREATE TABLE `jv3_kunena_users_banned` (
- `id` int(11) NOT NULL,
- `userid` int(11) DEFAULT NULL,
- `ip` varchar(128) DEFAULT NULL,
- `blocked` tinyint(4) NOT NULL DEFAULT '0',
- `expiration` datetime DEFAULT NULL,
- `created_by` int(11) NOT NULL,
- `created_time` datetime NOT NULL,
- `reason_private` text,
- `reason_public` text,
- `modified_by` int(11) DEFAULT NULL,
- `modified_time` datetime DEFAULT NULL,
- `comments` text,
- `params` text
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_user_categories`
- --
- CREATE TABLE `jv3_kunena_user_categories` (
- `user_id` int(11) NOT NULL,
- `category_id` int(11) NOT NULL,
- `role` tinyint(4) NOT NULL DEFAULT '0',
- `allreadtime` int(11) NOT NULL DEFAULT '0',
- `subscribed` tinyint(4) NOT NULL DEFAULT '0',
- `params` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_user_categories`
- --
- INSERT INTO `jv3_kunena_user_categories` (`user_id`, `category_id`, `role`, `allreadtime`, `subscribed`, `params`) VALUES
- (339, 0, 0, 1507332723, 0, '');
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_user_read`
- --
- CREATE TABLE `jv3_kunena_user_read` (
- `user_id` int(11) NOT NULL,
- `topic_id` int(11) NOT NULL,
- `category_id` int(11) NOT NULL,
- `message_id` int(11) NOT NULL,
- `time` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_user_topics`
- --
- CREATE TABLE `jv3_kunena_user_topics` (
- `user_id` int(11) NOT NULL DEFAULT '0',
- `topic_id` int(11) NOT NULL DEFAULT '0',
- `category_id` int(11) NOT NULL,
- `posts` mediumint(8) NOT NULL DEFAULT '0',
- `last_post_id` int(11) NOT NULL DEFAULT '0',
- `owner` tinyint(4) NOT NULL DEFAULT '0',
- `favorite` tinyint(4) NOT NULL DEFAULT '0',
- `subscribed` tinyint(4) NOT NULL DEFAULT '0',
- `params` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- -- --------------------------------------------------------
- --
- -- Structure de la table `jv3_kunena_version`
- --
- CREATE TABLE `jv3_kunena_version` (
- `id` int(11) NOT NULL,
- `version` varchar(20) NOT NULL,
- `versiondate` date NOT NULL,
- `installdate` date NOT NULL,
- `build` varchar(20) NOT NULL,
- `versionname` varchar(40) DEFAULT NULL,
- `state` text NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- --
- -- Déchargement des données de la table `jv3_kunena_version`
- --
- INSERT INTO `jv3_kunena_version` (`id`, `version`, `versiondate`, `installdate`, `build`, `versionname`, `state`) VALUES
- (1, '5.0.11', '2017-09-02', '2017-10-20', '', 'Kinkajou', '');
- --
- -- Index pour les tables déchargées
- --
- --
- -- Index pour la table `jv3_kunena_aliases`
- --
- ALTER TABLE `jv3_kunena_aliases`
- ADD UNIQUE KEY `alias` (`alias`),
- ADD KEY `state` (`state`),
- ADD KEY `item` (`item`),
- ADD KEY `type` (`type`);
- --
- -- Index pour la table `jv3_kunena_announcement`
- --
- ALTER TABLE `jv3_kunena_announcement`
- ADD PRIMARY KEY (`id`);
- --
- -- Index pour la table `jv3_kunena_attachments`
- --
- ALTER TABLE `jv3_kunena_attachments`
- ADD PRIMARY KEY (`id`),
- ADD KEY `mesid` (`mesid`),
- ADD KEY `userid` (`userid`),
- ADD KEY `hash` (`hash`),
- ADD KEY `filename` (`filename`),
- ADD KEY `filename_real` (`filename_real`);
- --
- -- Index pour la table `jv3_kunena_categories`
- --
- ALTER TABLE `jv3_kunena_categories`
- ADD PRIMARY KEY (`id`),
- ADD KEY `parent_id` (`parent_id`),
- ADD KEY `category_access` (`accesstype`,`access`),
- ADD KEY `published_pubaccess_id` (`published`,`pub_access`,`id`);
- --
- -- Index pour la table `jv3_kunena_configuration`
- --
- ALTER TABLE `jv3_kunena_configuration`
- ADD PRIMARY KEY (`id`);
- --
- -- Index pour la table `jv3_kunena_logs`
- --
- ALTER TABLE `jv3_kunena_logs`
- ADD PRIMARY KEY (`id`),
- ADD KEY `type` (`type`),
- ADD KEY `category_id` (`category_id`),
- ADD KEY `topic_id` (`topic_id`),
- ADD KEY `target_user` (`target_user`),
- ADD KEY `user_id` (`user_id`);
- --
- -- Index pour la table `jv3_kunena_messages`
- --
- ALTER TABLE `jv3_kunena_messages`
- ADD PRIMARY KEY (`id`),
- ADD KEY `thread` (`thread`),
- ADD KEY `ip` (`ip`),
- ADD KEY `userid` (`userid`),
- ADD KEY `time` (`time`),
- ADD KEY `locked` (`locked`),
- ADD KEY `hold_time` (`hold`,`time`),
- ADD KEY `parent_hits` (`parent`,`hits`),
- ADD KEY `catid_parent` (`catid`,`parent`);
- --
- -- Index pour la table `jv3_kunena_messages_text`
- --
- ALTER TABLE `jv3_kunena_messages_text`
- ADD PRIMARY KEY (`mesid`);
- --
- -- Index pour la table `jv3_kunena_polls`
- --
- ALTER TABLE `jv3_kunena_polls`
- ADD PRIMARY KEY (`id`),
- ADD KEY `threadid` (`threadid`);
- --
- -- Index pour la table `jv3_kunena_polls_options`
- --
- ALTER TABLE `jv3_kunena_polls_options`
- ADD PRIMARY KEY (`id`),
- ADD KEY `pollid` (`pollid`);
- --
- -- Index pour la table `jv3_kunena_polls_users`
- --
- ALTER TABLE `jv3_kunena_polls_users`
- ADD UNIQUE KEY `pollid` (`pollid`,`userid`);
- --
- -- Index pour la table `jv3_kunena_ranks`
- --
- ALTER TABLE `jv3_kunena_ranks`
- ADD PRIMARY KEY (`rank_id`);
- --
- -- Index pour la table `jv3_kunena_rate`
- --
- ALTER TABLE `jv3_kunena_rate`
- ADD PRIMARY KEY (`id`);
- --
- -- Index pour la table `jv3_kunena_sessions`
- --
- ALTER TABLE `jv3_kunena_sessions`
- ADD PRIMARY KEY (`userid`),
- ADD KEY `currvisit` (`currvisit`);
- --
- -- Index pour la table `jv3_kunena_smileys`
- --
- ALTER TABLE `jv3_kunena_smileys`
- ADD PRIMARY KEY (`id`);
- --
- -- Index pour la table `jv3_kunena_thankyou`
- --
- ALTER TABLE `jv3_kunena_thankyou`
- ADD UNIQUE KEY `postid` (`postid`,`userid`),
- ADD KEY `userid` (`userid`),
- ADD KEY `targetuserid` (`targetuserid`);
- --
- -- Index pour la table `jv3_kunena_topics`
- --
- ALTER TABLE `jv3_kunena_topics`
- ADD PRIMARY KEY (`id`),
- ADD KEY `category_id` (`category_id`),
- ADD KEY `locked` (`locked`),
- ADD KEY `hold` (`hold`),
- ADD KEY `posts` (`posts`),
- ADD KEY `hits` (`hits`),
- ADD KEY `first_post_userid` (`first_post_userid`),
- ADD KEY `last_post_userid` (`last_post_userid`),
- ADD KEY `first_post_time` (`first_post_time`),
- ADD KEY `last_post_time` (`last_post_time`),
- ADD KEY `last_post_id` (`last_post_id`);
- --
- -- Index pour la table `jv3_kunena_users`
- --
- ALTER TABLE `jv3_kunena_users`
- ADD PRIMARY KEY (`userid`),
- ADD KEY `group_id` (`group_id`),
- ADD KEY `posts` (`posts`),
- ADD KEY `uhits` (`uhits`),
- ADD KEY `banned` (`banned`),
- ADD KEY `moderator` (`moderator`);
- --
- -- Index pour la table `jv3_kunena_users_banned`
- --
- ALTER TABLE `jv3_kunena_users_banned`
- ADD PRIMARY KEY (`id`),
- ADD KEY `userid` (`userid`),
- ADD KEY `ip` (`ip`),
- ADD KEY `expiration` (`expiration`),
- ADD KEY `created_time` (`created_time`);
- --
- -- Index pour la table `jv3_kunena_user_categories`
- --
- ALTER TABLE `jv3_kunena_user_categories`
- ADD PRIMARY KEY (`user_id`,`category_id`),
- ADD KEY `category_subscribed` (`category_id`,`subscribed`),
- ADD KEY `role` (`role`);
- --
- -- Index pour la table `jv3_kunena_user_read`
- --
- ALTER TABLE `jv3_kunena_user_read`
- ADD UNIQUE KEY `user_topic_id` (`user_id`,`topic_id`),
- ADD KEY `category_user_id` (`category_id`,`user_id`),
- ADD KEY `time` (`time`);
- --
- -- Index pour la table `jv3_kunena_user_topics`
- --
- ALTER TABLE `jv3_kunena_user_topics`
- ADD UNIQUE KEY `user_topic_id` (`user_id`,`topic_id`),
- ADD KEY `topic_id` (`topic_id`),
- ADD KEY `posts` (`posts`),
- ADD KEY `owner` (`owner`),
- ADD KEY `favorite` (`favorite`),
- ADD KEY `subscribed` (`subscribed`);
- --
- -- Index pour la table `jv3_kunena_version`
- --
- ALTER TABLE `jv3_kunena_version`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT pour les tables déchargées
- --
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_announcement`
- --
- ALTER TABLE `jv3_kunena_announcement`
- MODIFY `id` int(3) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_attachments`
- --
- ALTER TABLE `jv3_kunena_attachments`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_categories`
- --
- ALTER TABLE `jv3_kunena_categories`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_logs`
- --
- ALTER TABLE `jv3_kunena_logs`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_messages`
- --
- ALTER TABLE `jv3_kunena_messages`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_polls`
- --
- ALTER TABLE `jv3_kunena_polls`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_polls_options`
- --
- ALTER TABLE `jv3_kunena_polls_options`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_ranks`
- --
- ALTER TABLE `jv3_kunena_ranks`
- MODIFY `rank_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_rate`
- --
- ALTER TABLE `jv3_kunena_rate`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_smileys`
- --
- ALTER TABLE `jv3_kunena_smileys`
- MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_topics`
- --
- ALTER TABLE `jv3_kunena_topics`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_users_banned`
- --
- ALTER TABLE `jv3_kunena_users_banned`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT pour la table `jv3_kunena_version`
- --
- ALTER TABLE `jv3_kunena_version`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;COMMIT;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement