juaniyyo

<?php

namespace Valet\Drivers\Custom;

use Valet\Drivers\ValetDriver;

class PrestaShopValetDriver extends ValetDriver
{
    public static $ps_exclusions = ['ajax.php', 'dialog.php', 'ajax_products_list.php', 'autoupgrade/', 'filemanager/'];

juaniyyo

INSERT INTO `ps_state` (`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES(15, 17,'Açores','PT-AC','0','1'),
(15, 17,'Aveiro','PT-AV','0','1'),
(15, 17,'Beja','PT-BE','0','1'),
(15, 17,'Braga','PT-BR','0','1'),
(15, 17,'Bragança','PT-BA','0','1'),
(15, 17,'Castelo Branco','PT-CB','0','1'),
(15, 17,'Coimbra','PT-CO','0','1'),
(15, 17,'Évora','PT-EV','0','1'),
(15, 17,'Faro','PT-FA','0','1'),
(15, 17,'Guarda','PT-GU','0','1'),

juaniyyo

# Cache, temp and personal files

/.htaccess
*.log
npm-debug.log.*
.sass-cache/
/cache/*
download/*
/img/*
/log/*

juaniyyo

SELECT id_feature_value FROM `ps_feature_product` WHERE `id_product` = product_id;

DELETE FROM `ps_feature_value_lang` WHERE id_feature_value IN 
  (SELECT id_feature_value FROM `ps_feature_product` WHERE `id_product` = product_id);
  

DELETE FROM `ps_feature_value` WHERE `id_feature_value` IN 
  (SELECT id_feature_value FROM `ps_feature_product` WHERE `id_product` = product_id);
 
 

juaniyyo

SELECT * FROM `ps_feature_value` WHERE id_feature_value IN (
	SELECT id_feature_value FROM ps_feature_product WHERE id_product = 1592
)

DELETE FROM `ps_feature_product` WHERE `id_product` = 1592;

juaniyyo

CREATE TABLE `ps_cliente_temporal` (
  `id_customer` int(10) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `siret` varchar(14) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `ps_cliente_temporal` ADD PRIMARY KEY (`id_customer`);

juaniyyo

version: '3'

services:
  db:
    image: mysql:latest
    volumes:
      - ./db_data:/var/lib/mysql
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: somewordpress

juaniyyo

DROP PROCEDURE IF EXISTS _tmp_update_orders;
DELIMITER $$
CREATE PROCEDURE _tmp_update_orders()
BEGIN
   DECLARE cursor_List_isdone BOOLEAN DEFAULT FALSE;
   DECLARE cur_id_order INT;

   DECLARE cursor_List CURSOR FOR 
      SELECT id_order FROM ps_orders
    ;

juaniyyo

SELECT auto_increment + 1 AS NEXT_ID
FROM   `information_schema`.`tables`
WHERE  table_name = "table_name" AND table_schema = "database_name"

juaniyyo

certbot certonly \
--manual \
--preferred-challenges=dns \
--email mail@mail.com \
--server https://acme-v02.api.letsencrypt.org/directory \
--agree-tos \
-d "domain.com.es, *domain.com.es"