1<?php
2/**
3 * Copyright since 2007 PrestaShop SA and Contributors
4 * PrestaShop is an International Registered Trademark & Property of PrestaShop SA
5 *
6 * NOTICE OF LICENSE
7 *
8 * This source file is subject to the Open Software License (OSL 3.0)
9 * that is bundled with this package in the file LICENSE.md.
10 * It is also available through the world-wide-web at this URL:
11 * https://opensource.org/licenses/OSL-3.0
12 * If you did not receive a copy of the license and are unable to
13 * obtain it through the world-wide-web, please send an email
14 * to license@prestashop.com so we can send you a copy immediately.
15 *
16 * DISCLAIMER
17 *
18 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
19 * versions in the future. If you wish to customize PrestaShop for your
20 * needs please refer to https://devdocs.prestashop.com/ for more information.
21 *
22 * @author    PrestaShop SA and Contributors <contact@prestashop.com>
23 * @copyright Since 2007 PrestaShop SA and Contributors
24 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
25 */
26
27function category_product_index_unique()
28{
29    $res = true;
30    $key_exists = Db::getInstance()->executeS('SHOW INDEX
31		FROM `'._DB_PREFIX_.'category_product`
32		WHERE Key_name = "category_product_index"');
33    if ($key_exists) {
34        $res &= Db::getInstance()->execute('ALTER TABLE
35		`'._DB_PREFIX_.'category_product`
36		DROP INDEX `category_product_index`');
37    }
38    $res &= Db::getInstance()->execute('ALTER TABLE
39	`'._DB_PREFIX_.'category_product`
40	ADD UNIQUE `category_product_index` (`id_category`, `id_product`)');
41
42    return $res;
43}
44