Changeset View
Changeset View
Standalone View
Standalone View
sql/swh-indexes.sql
Show All 26 Lines | |||||
-- revision_metadata | -- revision_metadata | ||||
create unique index revision_metadata_pkey on revision_metadata(id, indexer_configuration_id); | create unique index revision_metadata_pkey on revision_metadata(id, indexer_configuration_id); | ||||
alter table revision_metadata add primary key using index revision_metadata_pkey; | alter table revision_metadata add primary key using index revision_metadata_pkey; | ||||
alter table revision_metadata add constraint revision_metadata_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; | alter table revision_metadata add constraint revision_metadata_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; | ||||
alter table revision_metadata validate constraint revision_metadata_indexer_configuration_id_fkey; | alter table revision_metadata validate constraint revision_metadata_indexer_configuration_id_fkey; | ||||
-- origin_intrinsic_metadata | |||||
moranegg: didn't we call the table origin_intrinsic_metadata so it won't have ambiguous connotation with… | |||||
Not Done Inline Actionscool you changed the name. pinging @zack on this question. moranegg: cool you changed the name.
Now the question is about the PKEY, is it only the origin_id or not? | |||||
Done Inline Actions
Yes, it is.
We decided we wouldn't vlorentz: > Now the question is about the PKEY, is it only the origin_id or not?
Yes, it is.
> Do we… | |||||
create unique index origin_intrinsic_metadata_pkey on origin_intrinsic_metadata(id, indexer_configuration_id); | |||||
alter table origin_intrinsic_metadata add primary key using index origin_intrinsic_metadata_pkey; | |||||
alter table origin_intrinsic_metadata add constraint origin_intrinsic_metadata_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; | |||||
alter table origin_intrinsic_metadata validate constraint origin_intrinsic_metadata_indexer_configuration_id_fkey; | |||||
-- content_mimetype | -- content_mimetype | ||||
create unique index content_mimetype_pkey on content_mimetype(id, indexer_configuration_id); | create unique index content_mimetype_pkey on content_mimetype(id, indexer_configuration_id); | ||||
alter table content_mimetype add primary key using index content_mimetype_pkey; | alter table content_mimetype add primary key using index content_mimetype_pkey; | ||||
alter table content_mimetype add constraint content_mimetype_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; | alter table content_mimetype add constraint content_mimetype_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; | ||||
alter table content_mimetype validate constraint content_mimetype_indexer_configuration_id_fkey; | alter table content_mimetype validate constraint content_mimetype_indexer_configuration_id_fkey; | ||||
-- content_language | -- content_language | ||||
Show All 15 Lines |
didn't we call the table origin_intrinsic_metadata so it won't have ambiguous connotation with the main db table origin_metadata?