CREATE TABLE BTV_MAKEPROC (
	PS_VERSION	CHAR (20),
	PS_PID		INTEGER		NOT NULL,
	PS_PPID		INTEGER		NOT NULL,
	PS_DIR		TEXT,
	PS_CMDLINE	TEXT,
	PS_MAKELEVEL	INTEGER
);

CREATE INDEX IDX_PS_VERSION ON BTV_MAKEPROC (PS_VERSION, PS_MAKELEVEL);

CREATE TABLE BTV_FILE (
	FILE_NAME	CHAR (50),
	FILE_DIR	TEXT,
	PRIMARY KEY (FILE_NAME, FILE_DIR)
);

CREATE TABLE BTV_DIR (
	DIR_PARENT	TEXT	NOT NULL,
	DIR_CHILD	TEXT	NOT NULL,
	DIR_CHOOSED	BOOLEAN DEFAULT FALSE
);

CREATE INDEX IDX_DIR_CHILD ON BTV_DIR (DIR_CHILD) ;

CREATE TABLE BTV_FILEINST (
	INST_PROC	INTEGER,
	INST_FILE	INTEGER,
	INST_DBLCLN	INTEGER,
	INST_ISDBLCLN	SMALLINT	DEFAULT 0,
	INST_ISTARGET	SMALLINT	DEFAULT 0,
	INST_ISPHONY	SMALLINT	DEFAULT 0,
	INST_ISGOAL	SMALLINT	DEFAULT 0,
	INST_CMDSTXT	TEXT,
	INST_EXECMDS	TEXT,
	INST_NAME	TEXT,
	INST_DIR	TEXT,
	INST_VERSION	CHAR(20),
	INST_GOAL	TEXT,
	PRIMARY KEY (INST_PROC, INST_FILE, INST_DBLCLN, INST_GOAL)
);
CREATE INDEX IDX_INST_VERSION ON BTV_FILEINST (INST_VERSION);

CREATE TABLE BTV_CPID (
	CPID_FILEINST	INTEGER		NOT NULL,
	CPID_CPID	INTEGER		NOT NULL,
	CPID_VERSION	CHAR (20)
);
CREATE INDEX IDX_CPID_VERSION ON BTV_CPID (CPID_VERSION);
CREATE INDEX IDX_CPID_FILEINST ON BTV_CPID (CPID_FILEINST);

CREATE TABLE BTV_DEPENDENCY (
	DEP_TARGET	INTEGER		NOT NULL,
	DEP_SOURCE	INTEGER		NOT NULL,
	DEP_ORDER	INTEGER		DEFAULT 0,
	DEP_VERSION	CHAR (20)	
);
CREATE INDEX IDX_DEP_VERSION ON BTV_DEPENDENCY (DEP_VERSION);

CREATE TABLE BTV_VARIABLE (
	VAR_PROC	INTEGER,
	VAR_NAME	CHAR (50),
	VAR_VALUE	TEXT,
	VAR_SOURCE	SMALLINT,
	VAR_VERSION	CHAR (20),
	PRIMARY KEY (VAR_PROC, VAR_NAME)
);
CREATE INDEX IDX_VAR_VERSION ON BTV_VARIABLE (VAR_VERSION);

CREATE TABLE BTV_CALL (
	CALL_VERSION	CHAR (20),
	CALL_CALLER	INTEGER		NOT NULL,
	CALL_CALLEE	INTEGER		NOT NULL
);
CREATE INDEX IDX_CALL_VERSION ON BTV_CALL (CALL_VERSION);