custdev/script/1creattable.sql

create table SM_NCDEVEXECLOG
(
  pk_log          CHAR(20) not null,
  src_pk_billtype VARCHAR2(50),
  src_pk_billname VARCHAR2(50),
  src_pk_bill     VARCHAR2(50),
  operation       VARCHAR2(200),
  senddata        CLOB,
  resultinfo      CLOB,
  errorinfo       CLOB,
  issuccess       CHAR(1),
  def1            VARCHAR2(100),
  def2            VARCHAR2(100),
  def3            VARCHAR2(100),
  def4            VARCHAR2(100),
  def5            VARCHAR2(100),
  def6            VARCHAR2(100),
  def7            VARCHAR2(100),
  def8            VARCHAR2(100),
  def9            VARCHAR2(100),
  ts              CHAR(19)  DEFAULT to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),
  dr              INTEGER DEFAULT 0
);


create table SM_DevFileDownLOG
(
  pk_log          CHAR(20) not null,
  filename VARCHAR2(512),
  downdate VARCHAR2(19),
  Downtype VARCHAR2(50),
  filetype      VARCHAR2(200),
  operation       VARCHAR2(200),
  senddata        CLOB,
  resultinfo      CLOB,
  errorinfo       CLOB,
  issuccess       CHAR(1),
  def1            VARCHAR2(100),
  def2            VARCHAR2(100),
  def3            VARCHAR2(100),
  def4            VARCHAR2(100),
  def5            VARCHAR2(100),
  def6            VARCHAR2(100),
  def7            VARCHAR2(100),
  def8            VARCHAR2(100),
  def9            VARCHAR2(100),
  ts              CHAR(19)  DEFAULT to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),
  dr              INTEGER DEFAULT 0
);