From db46fa5319d009f28d0b2ded18dd2ee6bcd3bb26 Mon Sep 17 00:00:00 2001 From: Ran Date: Thu, 15 Jul 2021 14:28:44 -0700 Subject: modify instead of add.. --- db/init/update.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'db/init/update.sql') diff --git a/db/init/update.sql b/db/init/update.sql index 27aec9d3..49997c76 100644 --- a/db/init/update.sql +++ b/db/init/update.sql @@ -111,9 +111,9 @@ ALTER TABLE payments modify `tip` double NOT NULL DEFAULT 0; ALTER TABLE orders DROP a1; ALTER TABLE orders DROP a2; -ALTER TABLE users modify `unit` varchar(255) DEFAULT NULL; +ALTER TABLE users MODIFY `unit` varchar(255) DEFAULT NULL; ALTER TABLE users ADD `authyId` varchar(255) DEFAULT NULL; -ALTER TABLE users ADD `subscriptions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL; +ALTER TABLE users MODIFY `subscriptions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL; ALTER TABLE users DROP symbol; -- cgit v1.2.3