Drone server uses MySQL queries to initialize PostgreSQL database

Drone server cloned from GitHub, ref ab93fd2deff49fbf9e8261322f0ffb2a8e428af0

Database configuration:

DRONE_DATABASE_DRIVER=postgres
DRONE_DATABASE_SECRET=<some random string>
DRONE_DATABASE_DATASOURCE=postgres://drone:<password>@127.0.0.1:5432/drone?sslmode=disable

Server starts and connects to database, but fails to initialize it and stops.

Log:

{"error":"pq: syntax error at or near \"AUTOINCREMENT\"","level":"fatal","msg":"main: cannot initialize server","time":"2020-04-14T01:43:38+02:00"}

PostgreSQL uses SERIAL for automatic incrementation. AUTOINCREMENT is used by MySQL.

SQLite also uses AUTOINCREMENT, which may mean DRONE_DATABASE_DRIVER is ignored when creating tables.

hmm, we use drone + postgres at cloud.drone.io without issue. If there were issues with postgres integration or database configuration in general, I would expect these errors at cloud.drone.io and I would expect numerous reports from our community which has not been the case.

An audit of the postgres ddl code does not reveal AUTOINCREMENT being used. All columns that automatically increment use SERIAL

It must be something on my end then. Even when I changed the default value for DRONE_DATABASE_DRIVER from sqlite3 to postgres in code, it still tried to use AUTOINCREMENT. If everything is OK, we can close this issue.