· 8 years ago · Jul 02, 2018, 04:10 PM
1ERROR: syntax error at or near "("
2LINE 2: id int(11) auto_increment PRIMARY KEY,
3
4drop table if exists users;
5create table users (
6 id int(11) auto_increment PRIMARY KEY,
7 name varchar(100),
8 email varchar(100),
9 username varchar(30),
10 password varchar(100),
11 register_date timestamp not null
12);
13
14mike@mike-thinks:~/Programing/Rasa/myflaskapp$ heroku pg:psql < schema.sql--> Connecting to postgresql-clean-86569
15NOTICE: table "users" does not exist, skipping
16DROP TABLE
17ERROR: syntax error at or near "("
18LINE 2: id int(11) auto_increment PRIMARY KEY,
19 ^
20NOTICE: table "articles" does not exist, skipping
21DROP TABLE
22ERROR: syntax error at or near "("
23LINE 2: id int(11) PRIMARY KEY,
24 ^