· 10 years ago · Sep 09, 2016, 11:16 AM
1Executing SQL script in server
2ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NULL DEFAULT CURRENT_TIMESTAMP,
3 `last_activity` DATETIME NULL DEFAULT NULL,
4 ' at line 6
5SQL Code:
6 CREATE TABLE IF NOT EXISTS `topas`.`user` (
7 `id` INT(255) NOT NULL AUTO_INCREMENT,
8 `username` VARCHAR(50) NOT NULL,
9 `email` VARCHAR(80) NULL DEFAULT NULL,
10 `password` VARCHAR(250) NOT NULL,
11 `created_at` NULL DEFAULT CURRENT_TIMESTAMP,
12 `last_activity` DATETIME NULL DEFAULT NULL,
13 UNIQUE INDEX `username_UNIQUE` (`username` ASC),
14 UNIQUE INDEX `email_UNIQUE` (`email` ASC),
15 UNIQUE INDEX `id_UNIQUE` (`id` ASC),
16 PRIMARY KEY (`id`))
17 ENGINE = InnoDB
18 DEFAULT CHARACTER SET = utf8
19
20SQL script execution finished: statements: 3 succeeded, 1 failed
21
22Fetching back view definitions in final form.
23Nothing to fetch