LCN 分布式T_LOGGER oracle下建表

LCN分布式数据库在oracle下运行，建表。

-- Create table T_LOGGER
--DROP TABLE T_LOGGER;
create table T_LOGGER
(
    id NUMBER(20) NOT NULL,
  group_id VARCHAR2(64 BYTE) NOT NULL,
  unit_id VARCHAR2(32 BYTE) NOT NULL,
  tag VARCHAR2(50 BYTE) NOT NULL,
  content VARCHAR2(1024 BYTE) NOT NULL,
  create_time VARCHAR2(30 BYTE) NOT NULL,
  app_name VARCHAR2(128 BYTE) NOT NULL
);

alter table T_LOGGER
  add primary key (id);

---自增序列
--DROP SEQUENCE T_LOGGER_SEQ;
CREATE SEQUENCE T_LOGGER_SEQ
MINVALUE 1 
NOMAXVALUE 
INCREMENT BY 1 
START WITH 1 NOCACHE ;

--创建触发器
-- DROP TRIGGER T_LOGGER_id_TRIGGER;
create or replace trigger T_LOGGER_id_TRIGGER
  before insert on T_LOGGER  
  for each row
begin
  select T_LOGGER_SEQ.nextval into :new.id from dual;
end T_LOGGER_id_TRIGGER;

-- INSERT data
INSERT INTO T_LOGGER ( group_id, unit_id, tag, content, create_time, app_name )
VALUES
    (  'a', 'b', 'c', 'd', 'e', 'f' );
commit;
   
--SELECT
SELECT * from T_LOGGER;