db/init/oracle/schema.sql [2450:2504]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
create table tag
(
    id            VARCHAR2(128) not null,
    name          VARCHAR2(255) not null,
    tag_desc      VARCHAR2(255) not null,
    parent_tag_id VARCHAR2(128) not null,
    ext           VARCHAR2(1024) not null,
    date_created  timestamp(3) default SYSDATE not null,
    date_updated  timestamp(3) default SYSDATE not null,
    PRIMARY KEY (id)
);
-- Add comments to the columns
comment
on column TAG.id
  is 'primary key id';
comment
on column TAG.name
  is 'tag name';
comment
on column TAG.tag_desc
  is 'tag desc';
comment
on column TAG.parent_tag_id
  is 'parent tag id';
comment
on column TAG.ext
  is 'extension info';
comment
on column TAG.date_created
  is 'create time';
comment
on column TAG.date_updated
  is 'update time';


create table tag_relation
(
    id                VARCHAR2(128) not null,
    api_id            VARCHAR2(128) not null,
    tag_id            VARCHAR2(128) not null,
    date_created      timestamp(3) default SYSDATE not null,
    date_updated      timestamp(3) default SYSDATE not null,
    PRIMARY KEY (id)
);
-- Add comments to the columns
comment on column TAG_RELATION.id
  is 'primary key id';
comment on column TAG_RELATION.api_id
  is 'api_id';
comment on column TAG_RELATION.tag_id
  is 'parent tag id';
comment on column TAG_RELATION.date_created
  is 'create time';
comment on column TAG_RELATION.date_updated
  is 'update time';
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



db/upgrade/2.5.0-upgrade-2.5.1-oracle.sql [451:504]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
create table tag
(
    id            VARCHAR2(128) not null,
    name          VARCHAR2(255) not null,
    tag_desc      VARCHAR2(255) not null,
    parent_tag_id VARCHAR2(128) not null,
    ext           VARCHAR2(1024) not null,
    date_created  timestamp(3) default SYSDATE not null,
    date_updated  timestamp(3) default SYSDATE not null,
    PRIMARY KEY (id)
);
-- Add comments to the columns
comment
    on column TAG.id
    is 'primary key id';
comment
    on column TAG.name
    is 'tag name';
comment
    on column TAG.tag_desc
    is 'tag desc';
comment
    on column TAG.parent_tag_id
    is 'parent tag id';
comment
    on column TAG.ext
    is 'extension info';
comment
    on column TAG.date_created
    is 'create time';
comment
    on column TAG.date_updated
    is 'update time';

create table tag_relation
(
    id                VARCHAR2(128) not null,
    api_id            VARCHAR2(128) not null,
    tag_id            VARCHAR2(128) not null,
    date_created      timestamp(3) default SYSDATE not null,
    date_updated      timestamp(3) default SYSDATE not null,
    PRIMARY KEY (id)
);
-- Add comments to the columns
comment on column TAG_RELATION.id
    is 'primary key id';
comment on column TAG_RELATION.api_id
    is 'api_id';
comment on column TAG_RELATION.tag_id
    is 'parent tag id';
comment on column TAG_RELATION.date_created
    is 'create time';
comment on column TAG_RELATION.date_updated
    is 'update time';
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



