58 lines
1.3 KiB
MySQL
58 lines
1.3 KiB
MySQL
|
-----------------------------------------------------
|
|||
|
|
-- Export file for user NMS --
|
|||
|
|
-- Created by Administrator on 2015-1-27, 10:22:00 --
|
|||
|
|
-----------------------------------------------------
|
|||
|
|
|
|||
|
|
spool 111.log
|
|||
|
|
|
|||
|
|
prompt
|
|||
|
|
prompt Creating table PLUGIN_INFO
|
|||
|
|
prompt ==========================
|
|||
|
|
prompt
|
|||
|
|
create table PLUGIN_INFO
|
|||
|
|
(
|
|||
|
|
ID NUMBER not null,
|
|||
|
|
NAME VARCHAR2(100) not null,
|
|||
|
|
DES VARCHAR2(1000),
|
|||
|
|
FILE_NAME VARCHAR2(1000) not null,
|
|||
|
|
CREAT_USERID NUMBER,
|
|||
|
|
CREAT_TIME DATE,
|
|||
|
|
UPDATE_USERID NUMBER,
|
|||
|
|
UPDATE_TIME DATE
|
|||
|
|
)
|
|||
|
|
;
|
|||
|
|
comment on table PLUGIN_INFO
|
|||
|
|
is '<EFBFBD><EFBFBD><EFBFBD>Ź<EFBFBD><EFBFBD>߹<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ';
|
|||
|
|
comment on column PLUGIN_INFO.ID
|
|||
|
|
is 'id';
|
|||
|
|
comment on column PLUGIN_INFO.NAME
|
|||
|
|
is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|||
|
|
comment on column PLUGIN_INFO.DES
|
|||
|
|
is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD>';
|
|||
|
|
comment on column PLUGIN_INFO.FILE_NAME
|
|||
|
|
is '<EFBFBD>ļ<EFBFBD><EFBFBD><EFBFBD>';
|
|||
|
|
comment on column PLUGIN_INFO.CREAT_USERID
|
|||
|
|
is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|||
|
|
comment on column PLUGIN_INFO.CREAT_TIME
|
|||
|
|
is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>';
|
|||
|
|
comment on column PLUGIN_INFO.UPDATE_USERID
|
|||
|
|
is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|||
|
|
comment on column PLUGIN_INFO.UPDATE_TIME
|
|||
|
|
is '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>';
|
|||
|
|
alter table PLUGIN_INFO
|
|||
|
|
add constraint PK_PLUGIN_INFO primary key (ID);
|
|||
|
|
|
|||
|
|
prompt
|
|||
|
|
prompt Creating sequence SEQ_PLUGIN_INFO
|
|||
|
|
prompt =================================
|
|||
|
|
prompt
|
|||
|
|
create sequence SEQ_PLUGIN_INFO
|
|||
|
|
minvalue 1
|
|||
|
|
maxvalue 999999999999999999999999999
|
|||
|
|
start with 1
|
|||
|
|
increment by 1
|
|||
|
|
cache 20;
|
|||
|
|
|
|||
|
|
|
|||
|
|
spool off
|