php bin/console doctrine:migrations:migrate

 

 

$ 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

微信公众号: