Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'file_software' already exists (SQ...

[sentry-io]

Sentry Issue: FORTRABBIT-N

PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'file_software' already exists
  File "/database/migrations/2021_06_15_034642_add_files_to_software_table.php", line 23, in AddFilesToSoftwareTable::up
    });
  File "/artisan", line 37
    new Symfony\Component\Console\Output\ConsoleOutput
...
(27 additional frame(s) were not displayed)

Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'file_software' already exists (SQL: create table `file_software` (`file_id` bigint unsigned not null, `software_id` bigint unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
  File "/database/migrations/2021_06_15_034642_add_files_to_software_table.php", line 23, in AddFilesToSoftwareTable::up
    });
  File "/artisan", line 37
    new Symfony\Component\Console\Output\ConsoleOutput
...
(25 additional frame(s) were not displayed)

[djaiss]

@asbiin this is because we need to update the SQL file that fills the demo account with the new table structure every time we change it.

How can I update it myself?

[asbiin]

@djaiss see https://github.com/officelifehq/demosql/blob/main/generate.sh the sql file is on the same repo