-- Create table
create table ERP_SERVERCONFIG
(
id NUMBER not null,
servicename VARCHAR2(500),
serviceip VARCHAR2(100),
lasttime DATE,
passminute NUMBER,
second NUMBER
)
tablespace ERPTEST_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
next 8
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column ERP_SERVERCONFIG.id
is '自增ID';
comment on column ERP_SERVERCONFIG.servicename
is '服务名称';
comment on column ERP_SERVERCONFIG.serviceip
is '服务IP';
comment on column ERP_SERVERCONFIG.lasttime
is '最后操作时间';
comment on column ERP_SERVERCONFIG.passminute
is '通过执行时间，每隔此时间检查服务是否运行';
comment on column ERP_SERVERCONFIG.second
is '服务定时执行间隔时间';
-- Create/Recreate indexes
create index IDX_ERP_SERVICECONFIG_NAME on ERP_SERVERCONFIG (SERVICENAME)
tablespace ERPTEST_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table ERP_SERVERCONFIG
add primary key (ID)
using index
tablespace ERPTEST_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);