bHv3jt97

1-- Si apres avoir mis a jour le CMS vous n'arrivez plus a acceder a votre site veulliez exécuter les requetes sql suivantes:
2-- ==============================================
3CREATE TABLE IF NOT EXISTS cmw_conversations (
4    id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
5    pseudo1 VARCHAR(20) NOT NULL,
6    pseudo2 VARCHAR(20) NOT NULL
7) ENGINE = InnoDB;
8
9CREATE TABLE IF NOT EXISTS cmw_messages (
10  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
11  `idConversation` smallint(5) UNSIGNED NOT NULL,
12  `expediteur` varchar(20) NOT NULL,
13  `message` text NOT NULL,
14  `date_envoie` datetime NOT NULL,
15  `lu` tinyint(1) UNSIGNED NOT NULL
16) ENGINE=MyISAM DEFAULT CHARSET=latin1;
17
18CREATE TABLE IF NOT EXISTS cmw_ban (
19    `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
20    `ip` VARCHAR(20) NOT NULL,
21    `pseudo` VARCHAR(16) 
22) ENGINE=InnoDB;
23
24CREATE TABLE IF NOT EXISTS cmw_ban_config (
25    `id` TINYINT(5) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
26    `titre` VARCHAR(255) NOT NULL,
27    `texte` TEXT NOT NULL
28);
29
30CREATE TABLE IF NOT EXISTS `cmw_dedipass` (
31  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
32  `pseudo` varchar(40) NOT NULL,
33  `code` varchar(8) NOT NULL,
34  `rate` varchar(60) NOT NULL,
35  `payout` float NOT NULL,
36  `tokens` int(11) NOT NULL,
37  `date_achat` date NOT NULL,
38  PRIMARY KEY (`id`)
39) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
40
41CREATE TABLE IF NOT EXISTS `cmw_votes_temp` (
42  `id` int(10) UNSIGNED NOT NULL,
43  `pseudo` varchar(16) NOT NULL,
44  `methode` tinyint(3) UNSIGNED NOT NULL,
45  `action` varchar(100) NOT NULL,
46  `serveur` tinyint(3) UNSIGNED NOT NULL
47) ENGINE=MyISAM DEFAULT CHARSET=latin1;
48CREATE TABLE IF NOT EXISTS `cmw_votes_recompense_auto_config` (
49  `id` smallint(5) UNSIGNED NOT NULL,
50  `type` tinyint(3) UNSIGNED NOT NULL,
51  `valueType` varchar(50) NOT NULL,
52  `message` varchar(255) DEFAULT NULL,
53  `commande` varchar(255) NOT NULL,
54  `serveur` smallint(5) UNSIGNED NOT NULL
55) ENGINE=MyISAM DEFAULT CHARSET=latin1;
56
57INSERT INTO `cmw_ban_config` (`id`, `titre`, `texte`) VALUES
58(1, 'Vous êtes bannis', 'Vous avez été bannis du site, veuillez prendre contact avec l\'administration pour les raisons de votre bannissement.');
59
60ALTER TABLE cmw_forum_categorie ADD ordre INT UNSIGNED NOT NULL;
61
62ALTER TABLE cmw_forum ADD ordre INT UNSIGNED NOT NULL;