Edit History

creer une table ps_tmnavcmsblockinfo_shop

fait une requette via php my admin (onglet SQL)

 CREATE TABLE ps_tmnavcmsblockinfo_shop` (
                `id_tmnavcmsblockinfo` INT UNSIGNED NOT NULL,
                `id_shop` int(10) unsigned NOT NULL ,
                PRIMARY KEY (`id_tmnavcmsblockinfo`, `id_shop`));

et on modifie l'install

 public function installDB()
    {
        $return = true;
        $return &= Db::getInstance()->execute('
                CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'tmnavcmsblockinfo` (
                `id_tmnavcmsblockinfo` INT UNSIGNED NOT NULL AUTO_INCREMENT,
                `id_shop` int(10) unsigned DEFAULT NULL,
                PRIMARY KEY (`id_tmnavcmsblockinfo`)
            ) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 ;'
        );

        $return &= Db::getInstance()->execute('
                CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'tmnavcmsblockinfo_lang` (
                `id_tmnavcmsblockinfo` INT UNSIGNED NOT NULL,
                `id_lang` int(10) unsigned NOT NULL ,
                `id_shop` int(10) unsigned NOT NULL ,
                `text` text NOT NULL,
                PRIMARY KEY (`id_tmnavcmsblockinfo`, `id_lang`)
            ) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 ;'
        );
        $return &= Db::getInstance()->execute('
                CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'tmnavcmsblockinfo_shop` (
                `id_tmnavcmsblockinfo` INT UNSIGNED NOT NULL,
                `id_shop` int(10) unsigned NOT NULL ,
                PRIMARY KEY (`id_tmnavcmsblockinfo`, `id_shop`)
            ) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 ;'
        );

        return $return;
    }