WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

SPOOL SYS_ANALYTICS_CUSTOMIZE.log

PROMPT
PROMPT CREATING TABLE SYS_ANALYTICS_CUSTOMIZE
PROMPT ===================================
PROMPT
WHENEVER SQLERROR CONTINUE
  DROP TABLE SYS_ANALYTICS_CUSTOMIZE;
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

-- Create table
create table SYS_ANALYTICS_CUSTOMIZE
(
  id        NUMBER not null,
  num       NUMBER not null,
  screen    VARCHAR2(100) not null,
  enabled   VARCHAR2(10) not null,
  callback  VARCHAR2(100),
  companyid NUMBER,
  userid    NUMBER
);
-- Create/Recreate primary, unique and foreign key constraints 
alter table SYS_ANALYTICS_CUSTOMIZE
  add primary key (ID)
  using index ;

SPOOL OFF

EXIT


