-- Create sequence 
create sequence SQE_LOGID
minvalue 1
maxvalue 99999999999
start with 41
increment by 1
cache 20;
--CREATE TRIGGER
CREATE OR REPLACE TRIGGER "WATDB"."TRIGGER_LOGID" 
  before insert on sys_log
  for each row
declare
  -- local variables here
begin
  select sqe_logid.nextval into :new.id from dual;
end Trigger_logid;

/
ALTER TRIGGER "WATDB"."TRIGGER_LOGID" ENABLE;

--create table
CREATE TABLE "WATDB"."SYS_LOG" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"DATES" DATE, 
	"LEVELS" VARCHAR2(20), 
	"LOGGER" VARCHAR2(200), 
	"CLIENTUSER" VARCHAR2(100), 
	"CLIENTIP" VARCHAR2(20), 
	"REQUESTURL" VARCHAR2(500), 
	"ACTION" VARCHAR2(20), 
	"MESSAGE" VARCHAR2(4000), 
	"EXCEPTION" VARCHAR2(4000), 
	 CONSTRAINT "PK_SYSLOG_ID" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "WATDB"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "WATDB" ;
 
  CREATE UNIQUE INDEX "WATDB"."PK_SYSLOG_ID" ON "WATDB"."SYS_LOG" ("ID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "WATDB" ;
 
  ALTER TABLE "WATDB"."SYS_LOG" ADD CONSTRAINT "PK_SYSLOG_ID" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "WATDB"  ENABLE;
 
  ALTER TABLE "WATDB"."SYS_LOG" MODIFY ("ID" NOT NULL ENABLE);
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."ID" IS '主键递增';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."DATES" IS '创建时间';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."LEVELS" IS '日志等级';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."LOGGER" IS '日志调用';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."CLIENTUSER" IS '使用用户';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."CLIENTIP" IS '访问IP';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."REQUESTURL" IS '访问来源';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."ACTION" IS '操作动作';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."MESSAGE" IS '消息';
 
   COMMENT ON COLUMN "WATDB"."SYS_LOG"."EXCEPTION" IS '异常信息';
 
   COMMENT ON TABLE "WATDB"."SYS_LOG"  IS '系统日志类';