Sha256: 5de9093686acbe1857b6065615e8f54f4de77a25c9e61dfb929708ffcad7186d
Contents?: true
Size: 622 Bytes
Versions: 5
Compression:
Stored size: 622 Bytes
Contents
CREATE TABLE `composite_primary_key_with_varchar_columns` ( `id` bigint NOT NULL AUTO_INCREMENT, `shop_id` bigint NOT NULL, `owner_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `owner_id` bigint NOT NULL, `namespace` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', `key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '', PRIMARY KEY (`shop_id`,`owner_type`,`owner_id`,`namespace`,`key`), UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC
Version data entries
5 entries across 5 versions & 1 rubygems