admin/Database
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
Database/FCLT.NMK
Jos Groot Lipman a400748783 Merge 2025.1 DB50a patches 
svn path=/Database/trunk/; revision=68306
2025-03-06 14:54:32 +00:00

331 lines
11 KiB
Plaintext
Raw Permalink Blame History

###############################################################################
## MAK\SQL\FCLT.NMK
##
## Project: FACILITOR
##
## (c) 1996-2022 Aareon Nederland B.V.
##
## Auteur: Ir. P.G. Feij
## $Revision$
## $Id$
##
## Makefile for SQL-DDL scripts for Oracle/Facilitor
## Generates some scripts like FILE.SQL and FILE_.SQL
## where FILE is the (wrapped) runtime version
## and FILE_ is the unwrapped version to be archived
##
## Create intial scripts as well as the latest upgrade
##
###############################################################################
## REQUIRES:
##
## NMAKE.EXE (requires NMAKE.EXE)
## Microsoft (R) Program Maintainance Utility Version 1.11
## CL.EXE
## Microsoft (R) C Optimizing Compiler Version 6.00A
## -for precompiling only-
## WRAP.EXE (12.1.0.2.0 or better) from Oracle
## needs to be available in searchpath (by Oracle Client Installer)
##
## SED.EXE
## GNU sed version 4.2
## Copyright (C) 2003 Free Software Foundation, Inc.
##
## Some of these to be found in ..\MAKTOOLS
##
## Uses (external) defines: None
##
## Note: If new modules are added, all source have to be mentioned separately,
## which is quite obvious from the existing usage in this file..
##
## Note: For each new schema version (release) the from and to version must be
## mentioned explicitly, which is a pity but it makes sense too
##
###############################################################################
##
## Steps performed are:
## All files are preprocessed using intermediate temp files
## and then combined into final scripts.
#############
##
## Directories
##
#############
PROJSRC=.
PROJEXE=z:\Project\FACILITOR\BUILD
### SOURCE DEFINES (gets info from commandline) ###
##
## New style using schemanumbers
##
CURRENTVERSION=50
NEXTVERSION=51
FILEVERSION=a
NEXTROOT=DB$(NEXTVERSION)$(FILEVERSION)
CURRENTUPDATE=DB$(CURRENTVERSION)to$(NEXTVERSION)
UPROOT=$(PROJSRC)\_UP
SRCUPDATE=$(UPROOT)\$(CURRENTUPDATE)
SRCRECREA=$(UPROOT)\recreate
##
## PATH DEFINES
##
MAK=.
##
## Source rootdirectory
##
MSRC=$(PROJSRC)
INC=/I$(PROJSRC)
EXE=$(PROJEXE)
### TOOL DEFINES (gets info from OS-environment) ###
PRECOMP=$(MAKTOOLS)\CL
## WRAP1=$(MAKTOOLS)\WRAP.EXE
WRAP1=WRAP.EXE
PRECOMP_OPTIONS=/EP /D_VER=$(CURRENTUPDATE)$(FILEVERSION) /D_DBV=$(NEXTVERSION)$(FILEVERSION)
CLEANUP1=$(MAKTOOLS)\sedclean.bat
##
## DEPENDENCIES
##
.SUFFIXES: .SRC
##
## RESULTS
##
all: $(EXE)\$(NEXTROOT)\FCLT$(NEXTVERSION)$(FILEVERSION).SQL \
$(EXE)\$(NEXTROOT)\RECRE$(NEXTVERSION)$(FILEVERSION).SQL \
$(EXE)\$(NEXTROOT)\$(CURRENTUPDATE)$(FILEVERSION).SQL
##
## DEPENDENCIES AND ACTIONS
##
$(EXE)\$(NEXTROOT)\FCLT$(NEXTVERSION)$(FILEVERSION).SQL: \
$(MAK)\fclt.nmk \
$(MSRC)\fclt.src \
$(MSRC)\modules.h \
$(MSRC)\comsql.h \
$(MSRC)\adm\adm_tab.src \
$(MSRC)\adm\adm_pac.src \
$(MSRC)\alg\algsql.h \
$(MSRC)\ins\inssql.h \
$(MSRC)\alg\alg_ind.src \
$(MSRC)\alg\alg_ini.src \
$(MSRC)\alg\alg_pac.src \
$(MSRC)\alg\alg_seq.src \
$(MSRC)\alg\alg_tab.src \
$(MSRC)\alg\alg_tri.src \
$(MSRC)\alg\alg_vie.src \
$(MSRC)\aut\aut_ind.src \
$(MSRC)\aut\aut_seq.src \
$(MSRC)\aut\aut_tab.src \
$(MSRC)\aut\aut_tri.src \
$(MSRC)\aut\aut_ini.src \
$(MSRC)\bes\bes_ind.src \
$(MSRC)\bes\bes_ini.src \
$(MSRC)\bes\bes_pac.src \
$(MSRC)\bes\bes_seq.src \
$(MSRC)\bes\bes_tab.src \
$(MSRC)\bes\bes_tri.src \
$(MSRC)\bes\bes_vie.src \
$(MSRC)\bez\bez_ind.src \
$(MSRC)\bez\bez_ini.src \
$(MSRC)\bez\bez_pac.src \
$(MSRC)\bez\bez_seq.src \
$(MSRC)\bez\bez_tab.src \
$(MSRC)\bez\bez_tri.src \
$(MSRC)\bez\bez_vie.src \
$(MSRC)\bgt\bgt_ind.src \
$(MSRC)\bgt\bgt_ini.src \
$(MSRC)\bgt\bgt_pac.src \
$(MSRC)\bgt\bgt_seq.src \
$(MSRC)\bgt\bgt_tab.src \
$(MSRC)\bgt\bgt_tri.src \
$(MSRC)\bgt\bgt_vie.src \
$(MSRC)\cad\cad_ind.src \
$(MSRC)\cad\cad_ini.src \
$(MSRC)\cad\cad_pac.src \
$(MSRC)\cad\cad_seq.src \
$(MSRC)\cad\cad_tab.src \
$(MSRC)\cad\cad_tri.src \
$(MSRC)\cad\cad_vie.src \
$(MSRC)\cnd\cnd_tab.src \
$(MSRC)\cnd\cnd_pac.src \
$(MSRC)\cnd\cnd_tri.src \
$(MSRC)\cnd\cnd_vie.src \
$(MSRC)\cnt\cnt_ind.src \
$(MSRC)\cnt\cnt_ini.src \
$(MSRC)\cnt\cnt_pac.src \
$(MSRC)\cnt\cnt_seq.src \
$(MSRC)\cnt\cnt_tab.src \
$(MSRC)\cnt\cnt_tri.src \
$(MSRC)\cnt\cnt_vie.src \
$(MSRC)\ctr\ctr_ind.src \
$(MSRC)\ctr\ctr_ini.src \
$(MSRC)\ctr\ctr_pac.src \
$(MSRC)\ctr\ctr_seq.src \
$(MSRC)\ctr\ctr_tab.src \
$(MSRC)\ctr\ctr_tri.src \
$(MSRC)\ctr\ctr_vie.src \
$(MSRC)\ctr\ctr_lcl.src \
$(MSRC)\exc\exc_ind.src \
$(MSRC)\exc\exc_seq.src \
$(MSRC)\exc\exc_tri.src \
$(MSRC)\exc\exc_tab.src \
$(MSRC)\exc\exc_seq.src \
$(MSRC)\exc\exc_pac.src \
$(MSRC)\exc\exc_ini.src \
$(MSRC)\fac\fac_ind.src \
$(MSRC)\fac\fac_ini.src \
$(MSRC)\fac\fac_lcl.src \
$(MSRC)\fac\fac_lclhints.src \
$(MSRC)\fac\fac_set.src \
$(MSRC)\fac\fac_pac.src \
$(MSRC)\fac\fac_paca.src \
$(MSRC)\fac\fac_pacano.src \
$(MSRC)\fac\fac_pacx.src \
$(MSRC)\fac\fac_pacf.src \
$(MSRC)\fac\fac_pacl.src \
$(MSRC)\fac\fac_pacflex.src \
$(MSRC)\fac\fac_pacdel.src \
$(MSRC)\fac\fac_pactsk.src \
$(MSRC)\fac\fac_seq.src \
$(MSRC)\fac\fac_tab.src \
$(MSRC)\fac\fac_tri.src \
$(MSRC)\fac\fac_vie.src \
$(MSRC)\fac\fac_vieexp.src \
$(MSRC)\ini\ini_ind.src \
$(MSRC)\ini\ini_ini.src \
$(MSRC)\ini\ini_pac.src \
$(MSRC)\ini\ini_seq.src \
$(MSRC)\ini\ini_tab.src \
$(MSRC)\ini\ini_tri.src \
$(MSRC)\ini\fmis\fmis_ini.sql \
$(MSRC)\ini\itsm\itsm_ini.sql \
$(MSRC)\ini\plat\plat_ini.sql \
$(MSRC)\ins\ins_ind.src \
$(MSRC)\ins\ins_ini.src \
$(MSRC)\ins\ins_lcl.src \
$(MSRC)\ins\ins_pac.src \
$(MSRC)\ins\ins_seq.src \
$(MSRC)\ins\ins_tab.src \
$(MSRC)\ins\ins_tri.src \
$(MSRC)\ins\ins_vie.src \
$(MSRC)\kpi\kpi_ind.src \
$(MSRC)\kpi\kpi_ini.src \
$(MSRC)\kpi\kpi_pac.src \
$(MSRC)\kpi\kpi_seq.src \
$(MSRC)\kpi\kpi_tab.src \
$(MSRC)\kpi\kpi_tri.src \
$(MSRC)\kpi\kpi_vie.src \
$(MSRC)\mld\mld_ind.src \
$(MSRC)\mld\mld_ini.src \
$(MSRC)\mld\mld_lcl.src \
$(MSRC)\mld\mld_pac.src \
$(MSRC)\mld\mld_seq.src \
$(MSRC)\mld\mld_tab.src \
$(MSRC)\mld\mld_typ.src \
$(MSRC)\mld\mld_tri.src \
$(MSRC)\mld\mld_vie.src \
$(MSRC)\mrk\mrk_ind.src \
$(MSRC)\mrk\mrk_ini.src \
$(MSRC)\mrk\mrk_pac.src \
$(MSRC)\mrk\mrk_seq.src \
$(MSRC)\mrk\mrk_tab.src \
$(MSRC)\mrk\mrk_tri.src \
$(MSRC)\mrk\mrk_vie.src \
$(MSRC)\msg\msg_ind.src \
$(MSRC)\msg\msg_ini.src \
$(MSRC)\msg\msg_pac.src \
$(MSRC)\msg\msg_seq.src \
$(MSRC)\msg\msg_tab.src \
$(MSRC)\msg\msg_tri.src \
$(MSRC)\msg\msg_vie.src \
$(MSRC)\fin\fin_ind.src \
$(MSRC)\fin\fin_ini.src \
$(MSRC)\fin\fin_pac.src \
$(MSRC)\fin\fin_seq.src \
$(MSRC)\fin\fin_tab.src \
$(MSRC)\fin\fin_tri.src \
$(MSRC)\fin\fin_vie.src \
$(MSRC)\prj\prj_ind.src \
$(MSRC)\prj\prj_ini.src \
$(MSRC)\prj\prj_pac.src \
$(MSRC)\prj\prj_seq.src \
$(MSRC)\prj\prj_tab.src \
$(MSRC)\prj\prj_tri.src \
$(MSRC)\prj\prj_vie.src \
$(MSRC)\prs\prs_ind.src \
$(MSRC)\prs\prs_ini.src \
$(MSRC)\prs\prs_pac.src \
$(MSRC)\prs\prs_seq.src \
$(MSRC)\prs\prs_tab.src \
$(MSRC)\prs\prs_tri.src \
$(MSRC)\prs\prs_vie.src \
$(MSRC)\res\res_ind.src \
$(MSRC)\res\res_ini.src \
$(MSRC)\res\res_lcl.src \
$(MSRC)\res\res_pac.src \
$(MSRC)\res\res_seq.src \
$(MSRC)\res\res_tab.src \
$(MSRC)\res\res_tri.src \
$(MSRC)\res\res_vie.src \
$(MSRC)\web\web_ind.src \
$(MSRC)\web\web_ini.src \
$(MSRC)\web\web_pac.src \
$(MSRC)\web\web_seq.src \
$(MSRC)\web\web_tab.src \
$(MSRC)\web\web_tri.src \
$(MSRC)\web\web_vie.src
@IF NOT EXIST $(EXE)\$(NEXTROOT)\NUL mkdir $(EXE)\$(NEXTROOT)
$(PRECOMP) $(PRECOMP_OPTIONS) $(MSRC)\fclt.src>$(TEMP)\$(*B)_.sql
$(CLEANUP1) $(TEMP)\$(*B)_.sql
COPY $(TEMP)\$(*B)_.sql $(EXE)\$(NEXTROOT)\FCLT$(NEXTVERSION)$(FILEVERSION)_.SQL
$(WRAP1) iname=$(TEMP)\$(*B)_.sql oname=$(TEMP)\$(*B).sql
COPY $(TEMP)\$(*B).sql $(EXE)\$(NEXTROOT)\FCLT$(NEXTVERSION)$(FILEVERSION).SQL
$(MSRC)\fac\_fac_lclmdl.src: \
$(MSRC)\fac\fac_lclmdl.csv
cscript /nologo $(MSRC)\fac\parse_fac_lclmld.js $** >$@
##########################################################################
#### UPDATES CONSIST OF UPDATE AND RECREATE scripts
##########################################################################
$(EXE)\$(NEXTROOT)\$(CURRENTUPDATE)$(FILEVERSION).SQL: \
$(SRCUPDATE).src \
$(UPROOT)\prologue.inc \
$(UPROOT)\epilogue.inc \
$(MAK)\fclt.nmk \
$(MSRC)\fclt.src \
$(MSRC)\comsql.h \
$(EXE)\$(NEXTROOT)\FCLT$(NEXTVERSION)$(FILEVERSION).sql
@IF NOT EXIST $(EXE)\$(NEXTROOT)\NUL mkdir $(EXE)\$(NEXTROOT)
$(PRECOMP) $(PRECOMP_OPTIONS) $(SRCUPDATE).src>$(TEMP)\$(*B)_.sql
$(CLEANUP1) $(TEMP)\$(*B)_.sql
COPY $(TEMP)\$(*B)_.sql $(EXE)\$(NEXTROOT)\$(CURRENTUPDATE)$(FILEVERSION)_.SQL
$(WRAP1) iname=$(TEMP)\$(*B)_.sql oname=$(TEMP)\$(*B).sql
COPY $(TEMP)\$(*B).sql $(EXE)\$(NEXTROOT)\$(CURRENTUPDATE)$(FILEVERSION).SQL
$(EXE)\$(NEXTROOT)\RECRE$(NEXTVERSION)$(FILEVERSION).SQL: \
$(SRCRECREA).src \
$(SRCRECREA).inc \
$(MAK)\fclt.nmk \
$(MSRC)\fclt.src \
$(MSRC)\comsql.h \
$(MSRC)\fac\fac_lcl.src \
$(MSRC)\fac\fac_lclhints.src \
$(EXE)\$(NEXTROOT)\FCLT$(NEXTVERSION)$(FILEVERSION).sql
@IF NOT EXIST $(EXE)\$(NEXTROOT)\NUL mkdir $(EXE)\$(NEXTROOT)
$(PRECOMP) $(PRECOMP_OPTIONS) $(SRCRECREA).src>$(TEMP)\$(*B)_.sql
$(CLEANUP1) $(TEMP)\$(*B)_.sql
COPY $(TEMP)\$(*B)_.sql $(EXE)\$(NEXTROOT)\RECRE$(NEXTVERSION)$(FILEVERSION)_.SQL
$(WRAP1) iname=$(TEMP)\$(*B)_.sql oname=$(TEMP)\$(*B).sql
COPY $(TEMP)\$(*B).sql $(EXE)\$(NEXTROOT)\RECRE$(NEXTVERSION)$(FILEVERSION).SQL
## END-OF-FILE
Reference in New Issue View Git Blame Copy Permalink