Copy the code below into the SQL window.
--These are the SQL commands to set up the back-end tables for the Freezer Monitoring hands-on exercise.
CREATE COLUMN TABLE "SYSTEM"."ACTIVITY_HIST"
( "MACHINEID" VARCHAR(15),
"EVENT_TIME" TIMESTAMP,
"EVENT_NAME" VARCHAR(20),
"EVENT_DESCRIPTION" VARCHAR(30),
"EVENT_VALUE" VARCHAR(30)
);
CREATE COLUMN TABLE "SYSTEM"."DASHBOARD"
( "MACHINEID" VARCHAR(15) NOT NULL ,
"POWER_STATUS" VARCHAR(30),
"CURR_TEMP" DECIMAL(4,2),
PRIMARY KEY ("MACHINEID")
);
CREATE COLUMN TABLE "SYSTEM"."MACHINE_REF"
( "MACHINEID" VARCHAR(15) NOT NULL ,
"MACHINETYPE" VARCHAR(15),
"MAX_TEMP" DECIMAL(4,2),
"MIN_TEMP" DECIMAL(4,2),
"LOCATION" VARCHAR(25),
"TEMP_UNIT" VARCHAR(2),
PRIMARY KEY ("MACHINEID")
);
CREATE COLUMN TABLE "SYSTEM"."POWER_OUTAGES"
( "MACHINEID" VARCHAR(15),
"POWER_OFF_TIME" LONGDATE,
"POWER_ON_TIME" LONGDATE,
"DURATION_MIN" DOUBLE CS_DOUBLE
);
INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '2DDDBW3TP','VEND',50,35,'WALG31','F');
INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( 'EKM49RTXK','COOL',50,35,'FRI7','F');
INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( 'RB82KMY3S','VEND',50,35,'JRB235','F');
INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '4CBH7792RN','COOL',50,35,'WALG33','F');
INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( 'JMD51RTKK','VEND',10,2,'BP762','C');
INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( 'GGR23RTXK','FREEZE',32,0,'HIN88','F');
INSERT INTO "SYSTEM"."MACHINE_REF"("MACHINEID", "MACHINETYPE", "MAX_TEMP", "MIN_TEMP", "LOCATION", "TEMP_UNIT") VALUES
( '8HRT4WX2','VEND',50,35,'ORD311','F');