disgo
disgo copied to clipboard
Table creation fails on Postgres
2014-08-27 14:54:00 GMT LOG: connection received: host=10.148.42.215 port=44910
2014-08-27 14:54:00 GMT LOG: connection authorized: user=disgouser database=disgo
2014-08-27 14:54:00 GMT ERROR: syntax error at or near "(" at character 59
2014-08-27 14:54:00 GMT STATEMENT:
CREATE TABLE IF NOT EXISTS comments (
Id bigint(20) NOT NULL AUTO_INCREMENT,
Created bigint(20) DEFAULT NULL,
Email varchar(255) DEFAULT NULL,
Name varchar(255) DEFAULT NULL,
Body text,
Url varchar(255) DEFAULT NULL,
ClientIp varchar(255) DEFAULT NULL,
Approved tinyint(1) DEFAULT NULL,
PRIMARY KEY (Id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
Thanks for reporting! It's time to move to migrations that automatically handle MySQL and Postgres. I created issue #8 to tackle that.