0005 Could not create migrations table: pq: type "migrations_status" already exists

• 0005 Could not create migrations table: pq: type "migrations_status" already exists

原因:用beego框架,然后没事把自带的migrations表给删了! 然后再执行数据迁移的时候,就会出现这种情况!

搜了网上,没有解决办法!看到有人在beego里提了issue 然后这哥们自己把这个 migrations_status 给删了!

不过我发现一个解决的办法!

我全局搜索,搜索到了这个!

在migrate.go文件里

MYSQLMigrationDDL = `
CREATE TABLE migrations (
    id_migration int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'surrogate key',
    name varchar(255) DEFAULT NULL COMMENT 'migration name, unique',
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'date migrated or rolled back',
    statements longtext COMMENT 'SQL statements for this migration',
    rollback_statements longtext COMMENT 'SQL statment for rolling back migration',
    status ENUM('update', 'rollback') COMMENT 'update indicates it is a normal migration while rollback means this migration is rolled back',
    PRIMARY KEY (id_migration)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
`
    // POSTGRESMigrationDDL Postgres migration SQL
    POSTGRESMigrationDDL = `
CREATE TYPE migrations_status AS ENUM('update', 'rollback');

CREATE TABLE migrations (
    id_migration SERIAL PRIMARY KEY,
    name varchar(255) DEFAULT NULL,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    statements text,
    rollback_statements text,
    status migrations_status
)`

然后我数据类型是 postgresql

所以 我连接我的数据库! 然后 复制上面后面的这个

然后执行!

ok,建好了!

然后继续执行命令!表建成功啦!

---

欢迎转载,但请附上原文地址哦,尊重原创,谢谢大家 本文地址: http://www.iphpt.com/detail/105/

---