]> Git — Sourcephile - gargantext.git/history - devops/postgres/schema.sql
[ngrams] remove materialized view, some refactorings
[gargantext.git] / devops / postgres / schema.sql
2023-06-06 Przemysław Kaminski[ngrams] remove materialized view, some refactorings
2023-06-02 Alexandre DelanoëMerge remote-tracking branch 'origin/199-dev-materializ...
2023-06-02 Przemysław Kaminski[db] fixes for context_node_ngrams_view materialized...
2023-06-01 Alexandre DelanoëMerge remote-tracking branch 'origin/506-dev-search...
2023-05-12 Alexandre DelanoëMerge remote-tracking branch 'origin/203-dev-corpus...
2023-05-12 Alexandre Delanoë[FILES] ressources for upgrade
2023-03-09 qlobbeMerge branch 'dev-phylo' of https://gitlab.iscpif.fr...
2023-03-06 Alexandre Delanoë[MERGE]
2022-12-06 Alexandre DelanoëMerge remote-tracking branch 'origin/445-dev-doc-upload...
2022-11-30 Alexandre DelanoëMerge remote-tracking branch 'origin/jobqueue-test...
2022-11-30 Alexandre DelanoëMerge remote-tracking branch 'origin/469-dev-email...
2022-11-28 Przemek KaminskiMerge branch 'dev' into 151-dev-pubmed-api-key
2022-11-24 Alexandre DelanoëMerge remote-tracking branch 'origin/145-dev-graph...
2022-11-24 Przemek Kaminski[postgres] fix doc_count to be 0 by default
2022-11-16 Przemek KaminskiMerge branch 'dev' into 145-dev-graph-explorer-search...
2022-10-28 Przemek KaminskiMerge branch '145-graphExplorerSearch' into 145-dev...
2022-10-27 Przemek Kaminski[ngrams] first version of ngrams counting in docs
2022-09-26 Alexandre DelanoëMerge remote-tracking branch 'origin/438-dev-team-node...
2022-09-19 Alexandre DelanoëMerge remote-tracking branch 'origin/dev-phylo' into...
2022-09-09 Alexandre DelanoëMerge remote-tracking branch 'origin/debug-nans' into dev
2022-09-08 Przemek Kaminski[nodeStory] add version to node_story_archive_history
2022-09-08 Przemek KaminskiMerge branch 'dev' into 141-dev-node-stories-db-optimiz...
2022-09-08 Przemek Kaminski[postgres] fix 0.0.6.0 script name, sorting is better
2022-09-08 Alexandre Delanoë[FIX] schema.sql needs upgrade too.
2022-08-24 Alexandre DelanoëMerge remote-tracking branch 'origin/405-dev-lost-passw...
2022-08-24 Alexandre Delanoë[FEAT] Score Column
2022-08-23 Alexandre Delanoë[ADMIN] schema updated with Node Story tables
2022-07-24 Karen KonouMerge branch 'dev' into 396-dev-team-management
2022-07-02 Karen KonouMerge branch 'dev' into 405-dev-lost-password-design
2022-06-30 Przemek KaminskiMerge branch 'dev' into 131-dev-ngrams-table-db-connect...
2022-06-27 Alexandre Delanoë[FIX] Column name
2022-06-24 Alexandre Delanoë[FIX] database upgrade for lost password feature
2022-04-12 Przemek KaminskiMerge branch '97-dev-istex-search' of ssh://gitlab...
2022-04-12 Przemek KaminskiMerge branch 'dev' into 97-dev-istex-search
2022-03-22 Alexandre DelanoëMerge branch '104-dev-john-snow-nlp' of ssh://gitlab...
2022-03-22 Alexandre DelanoëMerge branch '106-dev-ngrams-score-fix' of ssh://gitlab...
2022-03-18 Alexandre DelanoëMerge branch 'dev-pairing' into dev
2022-03-18 Alexandre Delanoë[FEAT] Annuaire <-> Corpus pairing (WIP)
2022-02-03 Przemek KaminskiMerge branch 'dev' into 97-dev-istex-search
2022-01-20 Alexandre Delanoë[MIGRATION] upgrade script (WIP)
2022-01-20 Alexandre Delanoë[FIX] Counts in NgramsTable and context_node_ngrams...
2022-01-20 Alexandre Delanoë[Backup][WIP]
2022-01-20 Alexandre Delanoë[WIP] backup during the vacations
2021-10-08 Przemek KaminskiMerge branch 'dev' into 86-dev-graphql
2021-10-07 Alexandre DelanoëMerge branch '81-dev-zip-upload' of ssh://gitlab.iscpif...
2021-10-04 Przemek KaminskiMerge branch 'dev-ilike-search-fix' into dev-corpora...
2021-10-04 Przemek Kaminski[search] remove search_title in favor of the (previous...
2021-09-30 Przemek KaminskiMerge branch 'dev' into dev-corpora-from-write-nodes
2021-09-30 Alexandre Delanoë[Merge] and fix conflicts
2021-09-30 Alexandre DelanoëMerge branch 'dev-ilike-search-fix' of ssh://gitlab...
2021-09-30 Alexandre DelanoëMerge branch 'dev-merge' into dev
2021-09-28 Przemek Kaminski[schema.sql] fix with IF NOT EXISTS
2021-09-28 Alexandre DelanoëMerge branch 'dev-ilike-search-fix' of ssh://gitlab...
2021-09-28 Przemek Kaminski[search_title] tsvector query fix for v11
2021-09-28 Alexandre DelanoëMerge branch 'dev-ilike-search-fix' of ssh://gitlab...
2021-09-27 Przemek Kaminski[postgres] remove node_pos index which is not immutable
2021-09-25 Przemek KaminskiMerge branch 'dev' into dev-ilike-search-fix
2021-09-22 Alexandre DelanoëRevert "[search] implement ts_query search"
2021-09-18 Przemek Kaminski[postgres] attempt to fix the tsvector issue
2021-09-15 Przemek Kaminski[search] implement ts_query search
2021-03-24 qlobbemerge with dev
2021-03-22 Alexandre DelanoëMerge branch 'dev-distributional' of ssh://gitlab.iscpi...
2021-01-22 Alexandre DelanoëMerge branch 'dev-ngrams-table-online' of ssh://gitlab...
2021-01-20 Alexandre Delanoë[FIX] clean groups + handling duplicates (TODO inside)
2021-01-19 Alexandre DelanoëMerge branch 'dev' into dev-ngrams-groups
2021-01-19 Alexandre DelanoëMerge branch 'dev' of ssh://gitlab.iscpif.fr:20022...
2021-01-14 Alexandre DelanoëMerge branch 'dev' into dev-ngrams-groups
2021-01-05 Alexandre DelanoëMerge branch 'dev' into dev-ngrams-groups
2021-01-04 Alexandre Delanoëmerge
2020-12-21 Alexandre Delanoë[FEAT] SQL fun to insert postagging
2020-12-21 Alexandre Delanoë[DATABASE] New Table for postagging
2020-09-27 David Chavalarias[phylo] filter threshold change
2020-09-14 qlobbeMerge branch 'dev-phylo-merge' of https://gitlab.iscpif...
2020-09-11 Alexandre Delanoë[Merge] dev -> dev-phylo ready
2020-09-08 Alexandre DelanoëMerge branch 'dev' of ssh://gitlab.iscpif.fr:20022...
2020-09-07 Alexandre Delanoë[DB] triggers ok
2020-09-05 Alexandre Delanoë[DB] Trigger for sha256sum (WIP)
2020-09-04 Alexandre Delanoë[DB SCHEMA] adding hash_id column to nodes
2020-07-27 Przemek KaminskiMerge branch 'dev' into dev-doc-annotation-issue
2020-07-22 Alexandre Delanoë[DB] clean and instance insertDB
2020-07-22 Alexandre Delanoë[Database.Schema] NodeNode_NodeNode table
2020-07-22 Alexandre Delanoë[Community] specs + database schema adapted to link...
2020-04-03 Alexandre DelanoëMerge branch 'patch-1' of ssh://gitlab.iscpif.fr:20022...
2020-02-20 qlobbeMerge branch 'dev' into dev-phylo
2020-02-20 Alexandre DelanoëMerge branch 'dev-phylo' into dev
2020-02-20 Alexandre DelanoëMerge branch 'dev-phylo' of ssh://gitlab.iscpif.fr...
2020-02-06 Przemek KaminskiMerge branch 'dev' into dev-getting-started-readme
2020-02-01 Alexandre Delanoë[DB][OPTIM] index (wip).
2020-01-23 Alexandre DelanoëMerge branch 'dev-db' into dev
2020-01-23 Alexandre Delanoë[DB] Optim Select Table sort by date.
2020-01-21 Alexandre Delanoë[DB] Optim Indexes (DELETE)
2020-01-20 Alexandre DelanoëMerge branch 'dev' into dev-db-schema
2020-01-17 Alexandre Delanoë[DB][OPTIM] WIP
2020-01-17 Alexandre Delanoë[DB][Optim] Cooc without groups (wip).
2020-01-17 Alexandre Delanoë[DB] Master User Texts
2020-01-17 Alexandre Delanoë[DB] Node_NodeNgrams_NodeNgrams insertion in flowList...
2020-01-14 Alexandre DelanoëMerge branch 'testing'
2020-01-10 Alexandre Delanoë[DB][OPTIM] WIP
2020-01-09 Alexandre Delanoë[DB][Optim] Cooc without groups (wip).
2020-01-09 Alexandre Delanoë[DB] Master User Texts
next