A
Size: a a a
A
AO
AO
IZ
IZ
AO
IZ
IZ
IZ
A
CREATE TABLE product (
id int NOT NULL AUTO_INCREMENT,
category_id int DEFAULT NULL,
title longtext COLLATE utf8mb4_unicode_ci,
url longtext COLLATE utf8mb4_unicode_ci NOT NULL,
sku varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
description json DEFAULT NULL,
created_at datetime NOT NULL,
updated_at datetime DEFAULT NULL,
images json DEFAULT NULL,
update_error longtext COLLATE utf8mb4_unicode_ci,
variants json DEFAULT NULL,
html longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (id),
KEY IDX_D34A04AD12469DE2 (category_id),
CONSTRAINT FK_D34A04AD12469DE2 FOREIGN KEY (category_id) REFERENCES category (id)
) ENGINE=InnoDB AUTO_INCREMENT=7018017 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Прост
по дефолту же id - AI + PKIZ
CREATE TABLE product (
id int NOT NULL AUTO_INCREMENT,
category_id int DEFAULT NULL,
title longtext COLLATE utf8mb4_unicode_ci,
url longtext COLLATE utf8mb4_unicode_ci NOT NULL,
sku varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
description json DEFAULT NULL,
created_at datetime NOT NULL,
updated_at datetime DEFAULT NULL,
images json DEFAULT NULL,
update_error longtext COLLATE utf8mb4_unicode_ci,
variants json DEFAULT NULL,
html longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (id),
KEY IDX_D34A04AD12469DE2 (category_id),
CONSTRAINT FK_D34A04AD12469DE2 FOREIGN KEY (category_id) REFERENCES category (id)
) ENGINE=InnoDB AUTO_INCREMENT=7018017 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Прост
по дефолту же id - AI + PKAO
A
IZ
[mysqld]
wait_timeout=600
max_allowed_packet=1000M
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
default_authentication_plugin=mysql_native_password
max_binlog_size=500M
expire_logs_days=1
skip-log-bin
innodb_buffer_pool_size=15G
slow_query_log=/var/log/mysql/mysql-slow.log
long_query_time=1
IZ
CREATE TABLE product (
id int NOT NULL AUTO_INCREMENT,
category_id int DEFAULT NULL,
title longtext COLLATE utf8mb4_unicode_ci,
url longtext COLLATE utf8mb4_unicode_ci NOT NULL,
sku varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
description json DEFAULT NULL,
created_at datetime NOT NULL,
updated_at datetime DEFAULT NULL,
images json DEFAULT NULL,
update_error longtext COLLATE utf8mb4_unicode_ci,
variants json DEFAULT NULL,
html longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (id),
KEY IDX_D34A04AD12469DE2 (category_id),
CONSTRAINT FK_D34A04AD12469DE2 FOREIGN KEY (category_id) REFERENCES category (id)
) ENGINE=InnoDB AUTO_INCREMENT=7018017 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Прост
по дефолту же id - AI + PKIZ
A
IZ