SET
SQL DIALECT 3;
/* CREATE DATABASE 'H:\source*******.fdb' PAGE_SIZE 4096
DEFAULT CHARACTER SET NONE */
/* External Function declarations */
DECLARE EXTERNAL FUNCTION RDB$GET_CONTEXT
VARCHAR(80) CHARACTER SET NONE, VARCHAR(80) CHARACTER SET NONE
RETURNS VARCHAR(255) CHARACTER SET NONE FREE_IT
ENTRY_POINT 'get_context' MODULE_NAME 'system_module';
DECLARE EXTERNAL FUNCTION RDB$SET_CONTEXT
VARCHAR(80) CHARACTER SET NONE, VARCHAR(80) CHARACTER SET NONE, VARCHAR(255) CHARACTER SET NONE
RETURNS INTEGER BY VALUE
ENTRY_POINT 'set_context' MODULE_NAME 'system_module';
/* Table: db_company, Owner: SYSDBA */
CREATE TABLE "db_company"
(
"inr" INTEGER NOT NULL,
"f_company_name" CHAR(200) CHARACTER SET ISO8859_1 COLLATE DE_DE,
CONSTRAINT "PK_db_company" PRIMARY KEY ("inr")
);
/* Table: db_jobs, Owner: SYSDBA */
CREATE TABLE "db_jobs"
(
"inr" INTEGER NOT NULL,
"f_job_name" CHAR(200) CHARACTER SET ISO8859_1 COLLATE DE_DE,
"f_job_link" CHAR(500) CHARACTER SET ISO8859_1 COLLATE DE_DE,
"f_job_parameter" CHAR(10) CHARACTER SET ISO8859_1 COLLATE DE_DE,
CONSTRAINT "PK_db_jobs" PRIMARY KEY ("inr")
);
/* Table: db_zyklus, Owner: SYSDBA */
CREATE TABLE "db_zyklus"
(
"inr" INTEGER NOT NULL,
"f_company" INTEGER,
"f_job" INTEGER,
"f_zyklus" INTEGER,
"f_script" CHAR(500) CHARACTER SET ISO8859_1 COLLATE DE_DE,
"f_mode" INTEGER,
CONSTRAINT "PK_db_zyklus" PRIMARY KEY ("inr")
);
CREATE GENERATOR "NUMMERNPOOL";
/* Grant Roles for this database */
/* Grant permissions for this database */