summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Expand)AuthorFilesLines
2023-02-02Refactor part 2: get rid of temporary vnt/releasest viewsYorhel2-39/+145
2023-02-01Refactor: langpref -> titleprefs + use more strict schemaYorhel1-3/+40
2023-01-17API2: Add listwrite permission & list management APIYorhel2-4/+5
2023-01-08Add Cherokee languageYorhel1-1/+1
2022-12-19SQL: Also use MERGE for traits_chars_calc()Yorhel4-18/+23
2022-12-19SQL: Fix indices to use "NULLS NOT DISTINCT" instead of coalesce-hackYorhel1-5/+5
2022-12-18SQL: Experiment with MERGE to perform in-place updates for tags_vn_calc()Yorhel4-51/+56
2022-12-17SQL: Reorder columns for efficiency + add a few docsYorhel1-91/+103
2022-12-15SQL: Fix permissions for Multi to clean up expired sessionsYorhel1-1/+1
2022-12-13Add timezone option to user preferencesYorhel1-1/+2
2022-12-02API2: Also update last used date on first useYorhel1-1/+1
2022-11-29API2: Implement token-based authentication + GET /authinfoYorhel2-8/+33
2022-11-11Add Serbian languageYorhel1-1/+1
2022-10-31dbdump.pl: Improve performance of dumping ulist_vnsYorhel1-0/+1
2022-10-31SQL: Merge ulist_vns_labels into ulist_vns as array + cache private flagYorhel6-28/+76
2022-10-27Chars: add lie flag for traitsYorhel2-5/+9
2022-10-22AdvSearch: Add option to exclude lie tagsYorhel2-6/+7
2022-10-16ExtLinks: Add Playstation (HK) + Nintendo (EN/JP/HK)Yorhel1-2/+10
2022-10-08SQL: Reduce size of images table + set a max of 15 votesYorhel2-13/+18
2022-09-28SQL: Multi needs read access to releases_titles_histYorhel1-0/+1
2022-09-28Allow non-main release titles to be emptyYorhel1-3/+3
2022-09-28WIP add language-specific titles to releasesYorhel4-36/+61
2022-09-27sql: Fix definition of foreign key constraintYorhel1-1/+1
2022-08-30Also add trait overridesYorhel3-0/+12
2022-08-30Rename users_prefs_tags.tag -> tid, add update scriptYorhel1-2/+2
2022-08-29Add tag spoiler & highlight preferencesYorhel3-0/+12
2022-08-28Add Basque languageYorhel1-1/+1
2022-08-26SQL: Add formatting function for ipinfo valuesYorhel1-0/+12
2022-08-25Move loading custom CSS to separate request + increase maximum sizeYorhel1-1/+2
2022-08-25Staff editionsYorhel3-6/+33
2022-08-24Use libloc to add IP location information to the DBYorhel1-3/+14
2022-08-04AdvSearch: Also add option to not match child traitsYorhel1-0/+1
2022-08-03Add tags_vn_direct cache tableYorhel4-21/+46
2022-08-03Allow length votes on in-dev VNs + always display uncounted votesYorhel1-2/+2
2022-07-31Add VN development status fieldYorhel1-2/+4
2022-06-25SQL: add permissions to public schema as wellYorhel1-0/+2
2022-06-21VN/tags: add support for flagging tags as "false"Yorhel1-1/+2
2022-06-21Some improvements to the patrolling systemYorhel1-1/+1
2022-06-20Add changes patrolling mod featureYorhel3-0/+10
2022-06-19Move & streamline VN release expanding settingsYorhel1-2/+5
2022-06-18Users/prefs: Move prodrelexpand setting from cookie to user settingsYorhel1-1/+2
2022-06-16Debloat users table my moving some columns to other tablesYorhel4-20/+35
2022-06-13Include trait group in object "title"Yorhel1-2/+4
2022-05-10Exclude unofficial releases when determining VN release dateYorhel1-0/+1
2022-04-29SQL: Move utility functions to separate util.sqlYorhel4-106/+104
2022-04-29SQL: Add NFKC normalization to search functionsYorhel2-1/+71
2022-04-23Add Inuktitut languageYorhel1-1/+1
2022-04-21ExtLinks: Remove Erogetrailers.com linksYorhel1-1/+1
2022-04-19SQL: Adjust default VN popularity rank to 10MYorhel1-1/+1
2022-04-05Releases: Add "has ero" flagYorhel1-2/+4
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-20 02:49:55 +0000