WordPress database error: [Specified key was too long; max key length is 1000 bytes]CREATE TABLE IF NOT EXISTS wp_qr_clients (
id bigint(20) NOT NULL AUTO_INCREMENT,
client_id varchar(255) NOT NULL UNIQUE,
name varchar(255) NOT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
KEY client_id (client_id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Specified key was too long; max key length is 1000 bytes]CREATE TABLE IF NOT EXISTS wp_qr_codes (
id bigint(20) NOT NULL AUTO_INCREMENT,
qr_id varchar(255) NOT NULL UNIQUE,
client_id varchar(255) NOT NULL,
tag varchar(255) NOT NULL,
base_url text NOT NULL,
utm_url text,
redirect_url text,
qr_file varchar(255),
clicks bigint(20) DEFAULT 0,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
KEY qr_id (qr_id),
KEY client_id (client_id),
KEY tag (tag)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
Bienvenido a WordPress. Esta es tu primera entrada. Edítala o bórrala, ¡luego empieza a escribir!
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
