Sha256: 30bbbf2305a4b335e8c6ea81eb45030615550bbe5fc54a37c3c006a6a4789445

Contents?: true

Size: 627 Bytes

Versions: 6

Compression:

Stored size: 627 Bytes

Contents

CREATE TABLE `composite_primary_key_with_varchar_columns_dest` (
  `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

6 entries across 6 versions & 1 rubygems

Version Path
lhm-shopify-4.5.0 spec/fixtures/composite_primary_key_with_varchar_columns_dest.ddl
lhm-shopify-4.4.2 spec/fixtures/composite_primary_key_with_varchar_columns_dest.ddl
lhm-shopify-4.4.1 spec/fixtures/composite_primary_key_with_varchar_columns_dest.ddl
lhm-shopify-4.4.0 spec/fixtures/composite_primary_key_with_varchar_columns_dest.ddl
lhm-shopify-4.3.0 spec/fixtures/composite_primary_key_with_varchar_columns_dest.ddl
lhm-shopify-4.2.3 spec/fixtures/composite_primary_key_with_varchar_columns_dest.ddl