HEX
Server: Apache
System: Linux 185.122.168.184.host.secureserver.net 5.14.0-570.52.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Oct 15 06:39:08 EDT 2025 x86_64
User: barbeatleanalyti (1024)
PHP: 8.1.33
Disabled: NONE
Upload Files
File: /home/barbeatleanalyti/www/public_html/webmail/dev/sql/0.6to0.7.sql
SET @prefix = 'YOU_PREFIX'; #set you DBPrefix

SET @sql = CONCAT("CREATE TABLE IF NOT EXISTS ", @prefix, "eav_attributes_mediumblob (
	`id`        BIGINT(64) UNSIGNED NOT NULL AUTO_INCREMENT,
	`id_entity` BIGINT(64) UNSIGNED          DEFAULT NULL,
	`name`      VARCHAR(255)                 DEFAULT NULL,
	`value`     MEDIUMBLOB,
	PRIMARY KEY (`id`),
	UNIQUE KEY `idx_unique` (`id_entity`, `name`),
	KEY `fk_id_entity_idx` (`id_entity`),
	CONSTRAINT ", @prefix, "fk_eav_attributes_mediumblob_id_entity FOREIGN KEY (`id_entity`) REFERENCES ", @prefix, "eav_entities (`id`)
		ON DELETE CASCADE
		ON UPDATE NO ACTION
	)
	  ENGINE = InnoDB
	  AUTO_INCREMENT = 1
	  DEFAULT CHARSET = utf8;");

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SET @sql2 = CONCAT("CREATE TABLE IF NOT EXISTS ", @prefix, "eav_attributes_double (
	`id`        BIGINT(64) UNSIGNED NOT NULL AUTO_INCREMENT,
	`id_entity` BIGINT(64) UNSIGNED          DEFAULT NULL,
	`name`      VARCHAR(255)                 DEFAULT NULL,
	`value`     DOUBLE,
	PRIMARY KEY (`id`),
	UNIQUE KEY `idx_unique` (`id_entity`, `name`),
	KEY `fk_id_entity_idx` (`id_entity`),
	CONSTRAINT ", @prefix, "fk_eav_attributes_double_id_entity FOREIGN KEY (`id_entity`) REFERENCES ", @prefix, "eav_entities (`id`)
		ON DELETE CASCADE
		ON UPDATE NO ACTION
	)
	  ENGINE = InnoDB
	  AUTO_INCREMENT = 1
	  DEFAULT CHARSET = utf8;");

PREPARE stmt2 FROM @sql2;
EXECUTE stmt2;
DEALLOCATE PREPARE stmt2;