diff options
| author | Ran <[email protected]> | 2021-07-15 14:28:44 -0700 |
|---|---|---|
| committer | Ran <[email protected]> | 2021-07-15 14:28:44 -0700 |
| commit | db46fa5319d009f28d0b2ded18dd2ee6bcd3bb26 (patch) | |
| tree | 5f4374bb4be905572650b1fe2bf07de435b8563d | |
| parent | 9b9bc7e2e84ff1d66c7fb01c1cadd022b983a2f6 (diff) | |
| download | coinos-server-db46fa5319d009f28d0b2ded18dd2ee6bcd3bb26.tar.gz coinos-server-db46fa5319d009f28d0b2ded18dd2ee6bcd3bb26.zip | |
modify instead of add..
| -rw-r--r-- | db/init/update.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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; |