path: root/sql
AgeCommit message (Expand)AuthorFilesLines
6 hoursAPI2: Also update last used date on first useYorhel1-1/+1
3 daysAPI2: Implement token-based authentication + GET /authinfoYorhel2-8/+33
2022-11-11Add Serbian languageYorhel1-1/+1 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 linksYorhel1-1/+1
2022-04-19SQL: Adjust default VN popularity rank to 10MYorhel1-1/+1
2022-04-05Releases: Add "has ero" flagYorhel1-2/+4
2022-04-01Add user traits featureYorhel3-0/+10
2022-03-29Add new release animation fieldsYorhel1-4/+38
2022-03-29VN length voting: support private votesYorhel2-2/+3
2022-03-23VN length voting: remove ignore flag and allow speed=NULL for uncounted votesYorhel2-3/+2
2022-02-21Fix syntax error in schema.sqlYorhel1-1/+1
2022-02-19Use special "vnt.sorttitle" column for sorting & alphabet filteringYorhel1-7/+7
2022-02-15Search normalization: Convert just "disc" instead of "fandisc"Yorhel1-1/+1
2022-02-12Add Traditional & Simplified Chinese languagesYorhel1-1/+1
2022-02-10Add title language user preferenceYorhel1-1/+3
2022-02-08VN: Add support for multiple titles in different languagesYorhel4-21/+52