OUTPOST Posted April 16, 2020 Share Posted April 16, 2020 Hello les amis, Ma table ps_mr_selected a disparu, j'ai refais une installe du module mais sa ne la pas recrée, quelqu’un aurai la requète sql ? Merci Link to comment Share on other sites More sharing options...
OUTPOST Posted April 19, 2020 Author Share Posted April 19, 2020 Pour ceux qui on le même problème CREATE TABLE IF NOT EXISTS `PREFIX_mr_selected` ( `id_mr_selected` int(10) unsigned NOT NULL auto_increment, `id_customer` int(10) unsigned NULL, `id_method` int(10) unsigned NULL, `id_cart` int(10) unsigned NULL, `id_order` int(10) unsigned NULL, `MR_poids` varchar(7) NULL, `MR_Selected_Num` varchar(6) NULL, `MR_Selected_LgAdr1` varchar(36) NULL, `MR_Selected_LgAdr2` varchar(36) NULL, `MR_Selected_LgAdr3` varchar(36) NULL, `MR_Selected_LgAdr4` varchar(36) NULL, `MR_Selected_CP` varchar(10) NULL, `MR_Selected_Ville` varchar(32) NULL, `MR_Selected_Pays` varchar(2) NULL, `url_suivi` varchar(1000) NULL, `url_etiquette` varchar(1000) NULL, `exp_number` varchar(8) NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_mr_selected`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; Link to comment Share on other sites More sharing options...
Mediacom87 Posted April 19, 2020 Share Posted April 19, 2020 CREATE TABLE IF NOT EXISTS `PREFIX_mr_selected` ( N'oubliez pas de remplacer le PREFIX par celui correspondant à votre installation. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; Il serait préférable d'utiliser le moteur InnoDB à la place de MyISAM Link to comment Share on other sites More sharing options...
OUTPOST Posted April 19, 2020 Author Share Posted April 19, 2020 Yep, merci de le préciser pour les autres c'est ce que j’avais fait. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now