Changeset View
Changeset View
Standalone View
Standalone View
swh/indexer/sql/30-schema.sql
Show All 30 Lines | create table content_mimetype ( | ||||
indexer_configuration_id bigint not null | indexer_configuration_id bigint not null | ||||
); | ); | ||||
comment on table content_mimetype is 'Metadata associated to a raw content'; | comment on table content_mimetype is 'Metadata associated to a raw content'; | ||||
comment on column content_mimetype.mimetype is 'Raw content Mimetype'; | comment on column content_mimetype.mimetype is 'Raw content Mimetype'; | ||||
comment on column content_mimetype.encoding is 'Raw content encoding'; | comment on column content_mimetype.encoding is 'Raw content encoding'; | ||||
comment on column content_mimetype.indexer_configuration_id is 'Tool used to compute the information'; | comment on column content_mimetype.indexer_configuration_id is 'Tool used to compute the information'; | ||||
-- Language metadata | |||||
create table content_language ( | |||||
id sha1 not null, | |||||
lang languages not null, | |||||
indexer_configuration_id bigint not null | |||||
); | |||||
comment on table content_language is 'Language information on a raw content'; | |||||
comment on column content_language.lang is 'Language information'; | |||||
comment on column content_language.indexer_configuration_id is 'Tool used to compute the information'; | |||||
-- ctags information per content | |||||
create table content_ctags ( | |||||
id sha1 not null, | |||||
name text not null, | |||||
kind text not null, | |||||
line bigint not null, | |||||
lang ctags_languages not null, | |||||
indexer_configuration_id bigint not null | |||||
); | |||||
comment on table content_ctags is 'Ctags information on a raw content'; | |||||
comment on column content_ctags.id is 'Content identifier'; | |||||
comment on column content_ctags.name is 'Symbol name'; | |||||
comment on column content_ctags.kind is 'Symbol kind (function, class, variable, const...)'; | |||||
comment on column content_ctags.line is 'Symbol line'; | |||||
comment on column content_ctags.lang is 'Language information for that content'; | |||||
comment on column content_ctags.indexer_configuration_id is 'Tool used to compute the information'; | |||||
create table fossology_license( | create table fossology_license( | ||||
id smallserial, | id smallserial, | ||||
name text not null | name text not null | ||||
); | ); | ||||
comment on table fossology_license is 'Possible license recognized by license indexer'; | comment on table fossology_license is 'Possible license recognized by license indexer'; | ||||
comment on column fossology_license.id is 'License identifier'; | comment on column fossology_license.id is 'License identifier'; | ||||
comment on column fossology_license.name is 'License name'; | comment on column fossology_license.name is 'License name'; | ||||
▲ Show 20 Lines • Show All 73 Lines • Show Last 20 Lines |