CREATE TABLE SyncLogRecord (
a bigint(20) unsigned NOT NULL /*T![auto_rand] AUTO_RANDOM(5) */,
b bigint(20) NOT NULL,
c datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
d datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
e varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘video’,
f int(11) NOT NULL,
g int(11) NOT NULL,
h int(11) NOT NULL,
i varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
j varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
k varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
l varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
m varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
n varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
o int(11) NOT NULL,
p int(11) NOT NULL,
q text COLLATE utf8mb4_general_ci NOT NULL,
r varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
s int(11) NOT NULL,
t varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’,
u varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’,
v varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’,
w varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’,
x varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’,
y varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT ‘’,
z text COLLATE utf8mb4_general_ci NOT NULL,
aa smallint(6) NOT NULL DEFAULT ‘0’,
ab int(11) DEFAULT NULL,
ac varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
ad varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
ae int(11) NOT NULL DEFAULT ‘0’,
af tinyint(1) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (a) /*T![clustered_index] CLUSTERED */,
KEY logrecord_b (b),
KEY logrecord_c (c),
KEY logrecord_g (g),
KEY logrecord_h (h),
KEY logrecord_l (l),
KEY logrecore_i (i)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;