title: Laravel application and PHPUnit using sqlite, after executing the test database tables are dropped
body: <p>I'm creating a Laravel7 application. </p>
  
  <p>Laravel application and PHPUnit are using sqlite as database.</p>
  
  <p>For the development in my local I have configured as follows</p>
  
  <pre><code>// .env
  DB_CONNECTION=sqlite
  DB_DATABASE=/path/to/db.sqlite
  </code></pre>
  
  <pre><code>// phpunit.xml
  &lt;server name="DB_CONNECTION" value="sqlite"/&gt;
  &lt;server name="DB_DATABASE" value=":memory:"/&gt;
  </code></pre>
  
  <p>Step 1: Register a new user and able to successfully login</p>
  
  <p>Step 2: Execute the test and it executes successfully</p>
  
  <p>Step 3: Again login to application but it shows <code>SQLSTATE[HY000]: General error: 1 no such table: users (SQL: select * from "users" where "id" = 1 limit 1)</code></p>
  
  <p>After executing the tests the existing tables are removed from the sqlite database even though the test's database is in <code>memory</code> </p>
  
  <p>Note: In all my test classes I have <code>use DatabaseMigrations;</code> to include the trait.</p>
  
  <p>How can I solve this issue?</p>