- Phalcon 3.2.2
- Phalcon Devtools 3.2.3
- PostgreSQL 9.5
- Ubuntu 16.04
Hello!
I've created a migration using devtools and now i'm trying to run it on a clean database.
I'm using a cli interface:
phalcon migration --action=run
After that I have an exception output:
1507010432.9594: CREATE TABLE "printtime"."rbac" ( DEFAULT true"id" SERIAL NOT NULL, "code" CHARACTER VARYING(20) NOT NULL, "description" CHARACTER VARYING(255) NOT NULL, "is_role" BOOLEAN NOT NULL, "children" CHARACTER VARYING(1), CONSTRAINT "rbac_pkey" PRIMARY ("id") );ERROR: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "DEFAULT" LINE 2: DEFAULT true"id" SERIAL NOT NULL,
You see, there's a wrong sql command DEFAULT true"id" SERIAL NOT NULL, there's no backspace and presents an unneeded command DEFAULT true.
Here's the morph part of my migration: https://pastebin.com/4c9enRQw
What's going wrong?