--- a
+++ b/dist/restore/restore-standard.bat
@@ -0,0 +1,42 @@
+@echo off
+rem bbou@ac-toulouse.fr
+rem 25/11/2013 
+
+set /P DB="Enter database name:"
+set DBTYPE=standard
+set MODULES=wn legacy vn bnc sumo xwn glf ilfwn logs
+
+call :dbexists
+if not %DBEXISTS%==0 call :createdb
+for %%M in (%MODULES%) do call :process %DBTYPE%-%%M-schema.sql schema %DB%
+for %%M in (%MODULES%) do call :process %DBTYPE%-%%M-data.sql data %DB%
+for %%M in (%MODULES%) do call :process %DBTYPE%-%%M-constrain.sql constrain %DB% --force
+for %%M in (%MODULES%) do call :process %DBTYPE%-%%M-views.sql views %DB%
+goto :eof
+
+:process
+setlocal
+if not exist %1 goto :endprocess
+echo process %2
+:endprocess
+endlocal
+goto :eof
+
+:dbexists
+setlocal
+endlocal & set DBEXISTS=1 
+goto :eof
+
+:deletedb
+setlocal
+echo "delete %DB%"
+endlocal
+goto :eof
+
+:createdb
+setlocal
+echo "create %DB%"
+endlocal
+goto :eof
+
+:eof