PAdventures Comments - Answer Overflow

PAdventures

Explore posts from servers

DIAdiscord.js - Imagine an app DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

Did the latest drizzle-kit update try to fix this issue? if not please ignore me. If so, I've updated my drizzle and nothing changed

15 replies

DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

so all of those queries are not necessary

15 replies

DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

If you are making a fix for this. i just looked and all of these queries are being run when the table already is in those configuations

15 replies

DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

Ok, thank you for the advice.

15 replies

DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

Is there anything I can do to work around this, or is this a bug that must be fixed?

15 replies

DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

Looks like the newest version may not have fixed the pk droping and creating for planetscale maybe? idk

15 replies

DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

^ those are my versions

15 replies

DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

[email protected] [email protected]

15 replies

DTDrizzle Team

•Created by PAdventures on 12/19/2023 in #help

Dizzle Kit: Push altering unchanged column

also it keeps trying to do this when i dont change things and i can see that these have been done in my planetscale insights

ALTER TABLE `economy_profiles` DROP PRIMARY KEY;
ALTER TABLE `levels` DROP PRIMARY KEY;
ALTER TABLE `logs` DROP PRIMARY KEY;
ALTER TABLE `rolesToUsers` DROP PRIMARY KEY;
ALTER TABLE `tickets` DROP PRIMARY KEY;
ALTER TABLE `users` DROP PRIMARY KEY;
ALTER TABLE `economy_profiles` MODIFY COLUMN `bank_level` tinyint unsigned NOT NULL;
ALTER TABLE `economy_profiles` MODIFY COLUMN `safe_level` tinyint unsigned NOT NULL;
ALTER TABLE `shops` MODIFY COLUMN `items` tinyint unsigned NOT NULL;
ALTER TABLE `shops_config` MODIFY COLUMN `max_allowed` tinyint unsigned NOT NULL DEFAULT 2;
ALTER TABLE `shops_config` MODIFY COLUMN `max_items` tinyint unsigned NOT NULL DEFAULT 10;
ALTER TABLE `tickets` MODIFY COLUMN `rating` tinyint unsigned;
ALTER TABLE `tickets_config` MODIFY COLUMN `max_open` tinyint unsigned NOT NULL;
ALTER TABLE `economy_profiles` ADD PRIMARY KEY(`member_id`,`guild_id`);
ALTER TABLE `levels` ADD PRIMARY KEY(`member_id`,`guild_id`);
ALTER TABLE `logs` ADD PRIMARY KEY(`guild_id`,`channel_id`,`log_type`,`log_sub_type`);
ALTER TABLE `rolesToUsers` ADD PRIMARY KEY(`guild_id`,`role_id`,`user_id`);
ALTER TABLE `tickets` ADD PRIMARY KEY(`id`,`guild_id`);
ALTER TABLE `users` ADD PRIMARY KEY(`id`,`guild_id`);

ALTER TABLE `economy_profiles` DROP PRIMARY KEY;
ALTER TABLE `levels` DROP PRIMARY KEY;
ALTER TABLE `logs` DROP PRIMARY KEY;
ALTER TABLE `rolesToUsers` DROP PRIMARY KEY;
ALTER TABLE `tickets` DROP PRIMARY KEY;
ALTER TABLE `users` DROP PRIMARY KEY;
ALTER TABLE `economy_profiles` MODIFY COLUMN `bank_level` tinyint unsigned NOT NULL;
ALTER TABLE `economy_profiles` MODIFY COLUMN `safe_level` tinyint unsigned NOT NULL;
ALTER TABLE `shops` MODIFY COLUMN `items` tinyint unsigned NOT NULL;
ALTER TABLE `shops_config` MODIFY COLUMN `max_allowed` tinyint unsigned NOT NULL DEFAULT 2;
ALTER TABLE `shops_config` MODIFY COLUMN `max_items` tinyint unsigned NOT NULL DEFAULT 10;
ALTER TABLE `tickets` MODIFY COLUMN `rating` tinyint unsigned;
ALTER TABLE `tickets_config` MODIFY COLUMN `max_open` tinyint unsigned NOT NULL;
ALTER TABLE `economy_profiles` ADD PRIMARY KEY(`member_id`,`guild_id`);
ALTER TABLE `levels` ADD PRIMARY KEY(`member_id`,`guild_id`);
ALTER TABLE `logs` ADD PRIMARY KEY(`guild_id`,`channel_id`,`log_type`,`log_sub_type`);
ALTER TABLE `rolesToUsers` ADD PRIMARY KEY(`guild_id`,`role_id`,`user_id`);
ALTER TABLE `tickets` ADD PRIMARY KEY(`id`,`guild_id`);
ALTER TABLE `users` ADD PRIMARY KEY(`id`,`guild_id`);

15 replies

DTDrizzle Team

•Created by PAdventures on 12/10/2023 in #help

ExecutedQuery data question

i cant see anything about this in the docs

2 replies

Gaming

Programming