· 8 years ago · Aug 25, 2018, 08:50 AM
1CREATE TABLE IF NOT EXISTS permissions ( /* <<<< line 16 */
2 account_id INT UNSIGNED NOT NULL,
3 channel_id INT UNSIGNED, NOT NULL,
4 permission TINYINT UNSIGNED NOT NULL,
5 FOREIGN KEY (account_id) REFERENCES accounts (id) ON DELETE CASCADE,
6 FOREIGN KEY (channel_id) REFERENCES channels (id) ON DELETE CASCADE
7);
8
9---
10
11ERROR 1064 (42000) at line 16: 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 'NOT NULL,
12 permission INT NOT NULL,
13 FOREIGN KEY (acc' at line 3