@echo off
SETLOCAL
call settings.bat

echo.
echo +++ db_maintenance.bat: Start +++

%DB_TOOL% %DB% < create_empty_db.sql

%DB_TOOL% %DB% < create_blacklist.sql

%DB_TOOL% %DB% < error_list_%PAR_CC%.sql

if exist %UT_TMP%\create_blacklist.tmp (
  del %UT_TMP%\create_blacklist.tmp
)

echo .mode csv>> %UT_TMP%\create_blacklist.tmp
echo .import --skip 1 %CONFIG_PATH_SQL%\\module_size_plan.csv module_size_plan>> %UT_TMP%\create_blacklist.tmp

echo .mode csv>> %UT_TMP%\create_blacklist.tmp
echo .import --skip 1 %CONFIG_PATH_SQL%\\file_to_module.csv file_to_module>> %UT_TMP%\create_blacklist.tmp

echo .mode csv>> %UT_TMP%\create_blacklist.tmp
echo .import --skip 1 %CONFIG_PATH_SQL%\\section_to_memory.csv section_to_memory>> %UT_TMP%\create_blacklist.tmp

%DB_TOOL% %DB% < %UT_TMP%\create_blacklist.tmp

echo +++ db_maintenance.bat: Done +++