· 4 years ago · Feb 14, 2021, 01:10 AM
1Executing (default): SELECT 1+1 AS result
2Executing (default): CREATE TABLE IF NOT EXISTS `users` (`id` BIGINT(255) auto_increment , `username` VARCHAR(255) NOT NULL, `password` VARCHAR(255) NOT NULL, `email` VARCHAR(255) DEFAULT '', `emailCode` VARCHAR(255) DEFAULT '', `tfaSecret` VARCHAR(255) DEFAULT '', `tfaType` VARCHAR(255) DEFAULT 'none', `vipLevel` NUMBER DEFAULT 0, `donateMoney` BIGINT(50) DEFAULT 0, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB;
3Успешное подключение к базе данных!
4[Model Sync] -> Error -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NUMBER DEFAULT 0, `donateMoney` BIGINT(50) DEFAULT 0, `createdAt` DATETIME NOT N' at line 1
5SequelizeDatabaseError: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NUMBER DEFAULT 0, `donateMoney` BIGINT(50) DEFAULT 0, `createdAt` DATETIME NOT N' at line 1
6 at Query.formatError (C:\Users\user\Desktop\Coding\BattleCraft\backend\node_modules\sequelize\lib\dialects\mysql\query.js:256:16)
7 at Query.run (C:\Users\user\Desktop\Coding\BattleCraft\backend\node_modules\sequelize\lib\dialects\mysql\query.js:68:18)
8 at processTicksAndRejections (internal/process/task_queues.js:97:5)
9
10
11
12
13
14
15
16
17
18
19
20
21
22