播放/光滑/ SQLite演化不起作用

Question

我从终端在Ubuntu中创建了这样一个Ubuntu数据库：

$ sqlite users.db

然后，我将users.db文件移动到projectDir/conf/application.conf。

后来，我编写了一个演化，但是当我通过users.db查看数据库时，它没有应用到我的DBeaver数据库中。

这是我的application.conf文件

play.http.secret.key = "changeme"

play.i18n {
  langs = [ "en" ]

}
play.filters {
  enabled += filters.ExampleFilter

}

play.evolutions.db.default {
  enabled = true
  autoApply = true
  autoApplyDowns = true
}

slick.dbs.default {
  profile = "slick.jdbc.SQLiteProfile$"
  driver = "slick.driver.SQLiteDriver$"
  db.driver = "org.sqlite.JDBC"
  db.url = "jdbc:sqlite:/home/saad/play-scala-starter-example/conf/users.db"
}

play.assets {
  path = "/public"
  urlPrefix = "/assets"
}

这是我的build.sbt

name := """play-scala-starter-example"""

version := "1.0-SNAPSHOT"

lazy val root = (project in file(".")).enablePlugins(PlayScala)

resolvers += Resolver.sonatypeRepo("snapshots")

scalaVersion := "2.12.7"

crossScalaVersions := Seq("2.11.12", "2.12.7")

libraryDependencies += guice
libraryDependencies += "org.scalatestplus.play" %% "scalatestplus-play" % "3.1.2" % Test
libraryDependencies += "com.typesafe.slick" %% "slick" % "3.2.0"
libraryDependencies += "com.typesafe.slick" %% "slick-codegen" % "3.2.3"

libraryDependencies += evolutions
libraryDependencies ++= Seq(
  "com.typesafe.play" %% "play-slick" % "3.0.0",
  "com.typesafe.play" %% "play-slick-evolutions" % "3.0.0"
)
libraryDependencies ++= Seq(
  cache,
  javaWs,
  "org.xerial" % "sqlite-jdbc" % "3.23.1"
)

这是我的1.sql文件，我已经测试了代码，没有错误。

# --- !Ups

CREATE TABLE IF NOT EXISTS Users(
ID INTEGER PRIMARY KEY AUTOINCREMENT,
LastName varchar(255) NOT NULL,
FirstName varchar(255) NOT NULL,
Password varchar(255) NOT NULL,
Email varchar(255) NOT NULL UNIQUE,
Authenticated boolean
);

INSERT INTO Users(LastName, FirstName, Password, Email, Authenticated) VALUES ('Saad', 'Ali', 'spadsdditcom', 'asdasdasd', 1);

# --- !Downs

DROP TABLE IF EXISTS Users

在我完成sbt run之后，index页面将打开，没有错误，但是从DBeaver中也可以看出，进化也没有应用。

我的问题是，我做错了什么？

Answer 1

我想明白了，我把1.sql放在conf/default.evolution而不是conf/default/evolution中。