Dizzle Kit: Push altering unchanged column
CREATE TABLE `economy_profiles` (
`member_id` bigint unsigned NOT NULL,
`guild_id` bigint unsigned NOT NULL,
`wallet` int unsigned NOT NULL,
`bank` int unsigned NOT NULL,
`safe` int unsigned NOT NULL,
- `bank_level` tinyint unsigned NOT NULL DEFAULT '0',
- `safe_level` tinyint unsigned NOT NULL DEFAULT '0',
+ `bank_level` tinyint unsigned NOT NULL,
+ `safe_level` tinyint unsigned NOT NULL,
`created_at` date NOT NULL,
`updated_at` date NOT NULL,
PRIMARY KEY (`member_id`, `guild_id`),
UNIQUE KEY `economy_profiles_member_id_guild_id_unique` (`member_id`, `guild_id`),
UNIQUE KEY `member_id_guild_id_idx` (`member_id`, `guild_id`)
) ENGINE InnoDB,
CHARSET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;CREATE TABLE `economy_profiles` (
`member_id` bigint unsigned NOT NULL,
`guild_id` bigint unsigned NOT NULL,
`wallet` int unsigned NOT NULL,
`bank` int unsigned NOT NULL,
`safe` int unsigned NOT NULL,
- `bank_level` tinyint unsigned NOT NULL DEFAULT '0',
- `safe_level` tinyint unsigned NOT NULL DEFAULT '0',
+ `bank_level` tinyint unsigned NOT NULL,
+ `safe_level` tinyint unsigned NOT NULL,
`created_at` date NOT NULL,
`updated_at` date NOT NULL,
PRIMARY KEY (`member_id`, `guild_id`),
UNIQUE KEY `economy_profiles_member_id_guild_id_unique` (`member_id`, `guild_id`),
UNIQUE KEY `member_id_guild_id_idx` (`member_id`, `guild_id`)
) ENGINE InnoDB,
CHARSET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;I will push this to planetscale. I run the push again without doing anything and this happens:
CREATE TABLE `economy_profiles` (
`member_id` bigint unsigned NOT NULL,
`guild_id` bigint unsigned NOT NULL,
`wallet` int unsigned NOT NULL,
`bank` int unsigned NOT NULL,
`safe` int unsigned NOT NULL,
- `bank_level` tinyint unsigned NOT NULL,
- `safe_level` tinyint unsigned NOT NULL,
+ `bank_level` tinyint unsigned NOT NULL DEFAULT '0',
+ `safe_level` tinyint unsigned NOT NULL DEFAULT '0',
`created_at` date NOT NULL,
`updated_at` date NOT NULL,
PRIMARY KEY (`member_id`, `guild_id`),
UNIQUE KEY `economy_profiles_member_id_guild_id_unique` (`member_id`, `guild_id`),
UNIQUE KEY `member_id_guild_id_idx` (`member_id`, `guild_id`)
) ENGINE InnoDB,
CHARSET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;CREATE TABLE `economy_profiles` (
`member_id` bigint unsigned NOT NULL,
`guild_id` bigint unsigned NOT NULL,
`wallet` int unsigned NOT NULL,
`bank` int unsigned NOT NULL,
`safe` int unsigned NOT NULL,
- `bank_level` tinyint unsigned NOT NULL,
- `safe_level` tinyint unsigned NOT NULL,
+ `bank_level` tinyint unsigned NOT NULL DEFAULT '0',
+ `safe_level` tinyint unsigned NOT NULL DEFAULT '0',
`created_at` date NOT NULL,
`updated_at` date NOT NULL,
PRIMARY KEY (`member_id`, `guild_id`),
UNIQUE KEY `economy_profiles_member_id_guild_id_unique` (`member_id`, `guild_id`),
UNIQUE KEY `member_id_guild_id_idx` (`member_id`, `guild_id`)
) ENGINE InnoDB,
CHARSET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;