-- Create table
create table SYS_APPFEATURE
(
  APPFEATURE_ID         NUMBER(10) not null,
  APPFEATURE_CODE       VARCHAR2(25) not null,
  APPFEATUREDESC        VARCHAR2(200),
  APP_CODE              VARCHAR2(20) not null,
  HIERARCHYLEVEL        NUMBER(10) not null,
  MENUNAME              VARCHAR2(50),
  ISMENUITEM            VARCHAR2(1),
  ISMENULINK            VARCHAR2(1),
  ISVALID               VARCHAR2(1),
  PARENTAPPFEATURE_CODE VARCHAR2(20),
  PAGE_ID               NUMBER(20),
  STATUS_CODE           VARCHAR2(20),
  UPDATEDATE            DATE,
  UPDATEBYUSER_CODE     VARCHAR2(20),
  ORDER_SEQ             NUMBER(10) default 0 not null
)
tablespace SYSINFO
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table SYS_APPFEATURE
  add primary key (APPFEATURE_CODE)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table SYS_APPFEATURE
  add unique (APPFEATURE_ID)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes 
create index B_APPFEATURE_N1 on SYS_APPFEATURE (PARENTAPPFEATURE_CODE)
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 80K
    minextents 1
    maxextents unlimited
  );