@echo off

REM *************************************************************
REM                        ATTENTION !!!                        
REM  Do not run this script if your M4 tables contain valuable
REM  data. The script deletes all M4 tables!
REM                                                             
REM  Furthermore, the script installs a functions and stored
REM  procedures into the business data schema:						     
REM
REM                          PL/SQL:                            
REM  - procedure dbWindow                                       
REM  - procedure EMA                                            
REM  - procedure SMA                                            
REM  - procedure WMA                                            
REM  - procedure SimpleSTSP                                     
REM
REM  - function column_datatype
REM  - function m4_date_to_timestamp
REM  - function mm_add
REM  - function mm_divide
REM  - function time_interv_to_cat
REM  - function num_interv_to_cat
REM  - function Get_Type                                
REM  - function Get_Type2                                       
REM  - function M4RandomNr                                      
REM  - function M4RandomSelect                                  
REM                                                             
REM  Java Classes: package name "miningmart"
REM                                                             
REM  Please  make sure, that no PL/SQL functions/procedures     
REM  or JAVA classes are overwritten in the business data       
REM  schema !!                                                  
REM *************************************************************

REM Please set user,password and SID before running the script:

REM M4 schema:
set M4USER=
set M4PASS=
set M4SID=

REM Business data schema:
set BDUSER=
set BDPASS=
set BDSID=

REM *************************************************************

REM How to run SQLPlus? In some cases you might have to set
REM this variable to the absolute path.
set SQL_PLUS=

REM How to run the loadjava command? In some cases you might
REM have to set this variable to the absolute path.
set LOAD_JAVA=

REM *************************************************************

echo "M4 schema: Installing M4 tables!"
%SQL_PLUS% %M4USER%/%M4PASS%@%M4SID% @CreateM4Tables.sql

echo "M4 schema: Installing M4 operator information!"
%SQL_PLUS% %M4USER%/%M4PASS%@%M4SID% @Operators.sql

echo "M4 schema: Installing a sequence!"
%SQL_PLUS% %M4USER%/%M4PASS%@%M4SID% @MM_Sequence.sql

echo "Business Data Schema: Installing Java Stored Procedures!" 
%LOAD_JAVA% -user %BDUSER%/%BDPASS%@%BDSID% JavaStoredProc\*.java

echo "Business Data Schema: Installing embedding PL/SQL functions/procedures for Java procedures!"
%SQL_PLUS% %BDUSER%/%BDPASS%@%BDSID% @MM_Functions.sql

echo "Done."
