Changeset View
Changeset View
Standalone View
Standalone View
sql/upgrades/137.sql
- This file was added.
-- SWH DB schema upgrade | |||||
-- from_version: 136 | |||||
-- to_version: 137 | |||||
-- description: Add comment columns to all tables | |||||
insert into dbversion(version, release, description) | |||||
values(137, now(), 'Work In Progress'); | |||||
-- comment for columns of dbversion table | |||||
comment on column dbversion.version is 'Current version for sql schema'; | |||||
comment on column dbversion.release is 'Release date and time for current version'; | |||||
zack: SQL (uppercase)
there are a few other instances of this below, please fix all of them | |||||
comment on column dbversion.description is 'Description for current release'; | |||||
Done Inline Actionsnot release, but deployment vlorentz: not release, but deployment | |||||
-- comment for columns of content table | |||||
comment on column content.sha1 is 'Sha1 checksum of file content'; | |||||
comment on column content.sha1_git is 'Git id of sha1 checksum'; | |||||
comment on column content.sha256 is 'Sha256 checksum of file content'; | |||||
comment on column content.blake2s256 is 'Blake2s checksum of file content'; | |||||
comment on column content.length is 'Length of file content'; | |||||
comment on column content.ctime is 'Time of file creation'; | |||||
comment on column content.status is 'Status of content (absent, visible, hidden)'; | |||||
comment on column content.object_id is 'File content identifier'; | |||||
-- comment for columns of skipped_content | |||||
comment on column skipped_content.sha1 is 'Sha1 checksum of skipped content'; | |||||
comment on column skipped_content.sha1_git is 'Git id of sha1 checksum'; | |||||
comment on column skipped_content.sha256 is 'Sha256 checksum of skipped content'; | |||||
comment on column skipped_content.blake2s256 is 'Blake2s checksum of skipped content'; | |||||
comment on column skipped_content.length is 'Length of skipped content'; | |||||
comment on column skipped_content.ctime is 'Time of file creation'; | |||||
comment on column skipped_content.status is 'Status of skipped content (absent, visible, hidden)'; | |||||
comment on column skipped_content.reason is 'Reason for skipping content'; | |||||
comment on column skipped_content.origin is 'Foreign key for origin table'; | |||||
comment on column skipped_content.object_id is 'Skipped content identifier'; | |||||
-- comment for columns of fetch_history | |||||
comment on column fetch_history.id IS 'Identifier for fetch history'; | |||||
comment on column fetch_history.origin IS 'Foreign key for origin table'; | |||||
comment on column fetch_history."date" IS 'Date of entry'; | |||||
comment on column fetch_history.status IS 'True indicates successful fetch'; | |||||
comment on column fetch_history."result" IS 'Detailed return values, times etc'; | |||||
comment on column fetch_history.stdout IS 'Console output of fetch'; | |||||
comment on column fetch_history.stderr IS 'Error message for fetch'; | |||||
comment on column fetch_history.duration IS 'Time taken to complete fetch, NULL if ongoing'; | |||||
Done Inline ActionsThe db fields do not give information to add comments. Can you give some information about what is being stored. Specially fields like date offset. twitu: The db fields do not give information to add comments. Can you give some information about what… | |||||
Done Inline ActionsWhat to add here for date offset. twitu: What to add here for date offset. | |||||
Done Inline ActionsIs there a better comment than "Primary key" for this field. twitu: Is there a better comment than "Primary key" for this field. | |||||
Done Inline ActionsThe dev comment says
Does this comment convey the meaning? twitu: The dev comment says
> identifier across which we're bucketing objects
Does this comment… | |||||
Done Inline ActionsNot sure what to write here. Is is the complete revision history of a software origin? twitu: Not sure what to write here. Is is the complete revision history of a software origin? | |||||
Done Inline ActionsShould also mention that it's the "raw" name for most CVSs vlorentz: Should also mention that it's the "raw" name for most CVSs |
SQL (uppercase)
there are a few other instances of this below, please fix all of them