$ php bin/console doctrine:migrations:migrate
XinXiBundleMigrations
WARNING! You are about to execute a database migration that could result in sche
ma changes and data lost. Are you sure you wish to continue? (y/n)y
Migrating up to 20170114070228 from 0
++ migrating 20170114070228
-> CREATE SEQUENCE xinxi_member_id_seq INCREMENT BY 1 MINVALUE 1 START 1
-> CREATE SEQUENCE company_id_seq INCREMENT BY 1 MINVALUE 1 START 1
-> CREATE TABLE xinxi_member (id INT NOT NULL, username VARCHAR(180) NOT NU
LL, username_canonical VARCHAR(180) NOT NULL, email VARCHAR(180) NOT NULL, email
_canonical VARCHAR(180) NOT NULL, enabled BOOLEAN NOT NULL, salt VARCHAR(255) DE
FAULT NULL, password VARCHAR(255) NOT NULL, last_login TIMESTAMP(0) WITHOUT TIME
ZONE DEFAULT NULL, confirmation_token VARCHAR(180) DEFAULT NULL, password_reque
sted_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, roles TEXT NOT NULL, PRIMAR
Y KEY(id))
-> CREATE UNIQUE INDEX UNIQ_2D40B5C392FC23A8 ON xinxi_member (username_cano
nical)
-> CREATE UNIQUE INDEX UNIQ_2D40B5C3A0D96FBF ON xinxi_member (email_canonic
al)
-> CREATE UNIQUE INDEX UNIQ_2D40B5C3C05FB297 ON xinxi_member (confirmation_
token)
-> COMMENT ON COLUMN xinxi_member.roles IS '(DC2Type:array)'
-> CREATE TABLE company (id INT NOT NULL, name VARCHAR(255) NOT NULL, phone
VARCHAR(255) NOT NULL, address VARCHAR(255) NOT NULL, industries VARCHAR(255) N
OT NULL, member VARCHAR(255) NOT NULL, remark VARCHAR(255) NOT NULL, status BOOL
EAN NOT NULL, enabled BOOLEAN NOT NULL, created TIMESTAMP(0) WITHOUT TIME ZONE N
OT NULL, modified TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))
++ migrated (0.89s)
------------------------
++ finished in 0.89s
++ 1 migrations executed
++ 8 sql queries
微信公众号: