CREATE TABLE "AUTOMATED_QUERIES" 
(
	"ID" NUMBER(10) NOT NULL,
	"STARTTIME" DATE, 
	"ENDTIME" DATE, 
	"CREATETIME" DATE DEFAULT sysdate NOT NULL, 
	"STATUS" VARCHAR2(30) DEFAULT 'ready' NOT NULL, 
	"TYPE" VARCHAR2(30) NOT NULL, 
	"RUN_SERIAL" NUMBER(10) DEFAULT 0 NOT NULL, 
	"EXEC_ORDER" NUMBER(10) DEFAULT 0,
	"QUERY_TEXT" VARCHAR2(4000) NOT NULL
);  

grant select on AUTOMATED_QUERIES to public;
~

