summaryrefslogtreecommitdiff
path: root/sql/schema.sql
AgeCommit message (Expand)AuthorFilesLines
2024-03-22User: Add self-service account deletion functionYorhel1-1/+2
2024-03-20Add support for account soft-deletion and email opt-out listYorhel1-2/+9
2024-03-08Add Belarusian languageYorhel1-1/+1
2024-03-01Misc::Reports: Use a proper log table, fix log formattingYorhel1-1/+10
2024-02-26VN::Quotes: Remove approval system, adjust submission & editing limitsYorhel1-2/+3
2024-02-23Expand VN quotes feature a bitYorhel1-3/+23
2024-01-08Add some SQL comments to the database dumpsYorhel1-79/+83
2023-12-03SQL: Rename staff.aid to staff.mainYorhel1-6/+3
2023-12-03Staff: Add a bunch more external linksYorhel1-3/+20
2023-10-14DRM: Initial implementationYorhel1-0/+33
2023-09-21User: Patch all email address enumeration vectorsYorhel1-0/+6
2023-09-17Wikidata: Add Lutris & Wine linksYorhel1-1/+3
2023-09-15SQL/quotes: Add "approved" flag and improve randomisationYorhel1-0/+2
2023-08-09ExtLinks: Unbreak the J-List price fetcherYorhel1-1/+0
2023-07-11Remove popularity rating + adjust bayesian averageYorhel1-1/+0
2023-06-19VN::Page: Add tag vote counts to /v+/tagsYorhel1-0/+1
2023-05-05SQL: Fix syntax error in schema.sql + fix devdumpYorhel1-1/+1
2023-05-03SQL: Rename columns that are SQL keywordsYorhel1-12/+12
2023-04-19Track who uploaded an images + add filter to image flagging browserYorhel1-1/+2
2023-04-19ExtLinks: Add JAST USA price fetcherYorhel1-0/+9
2023-04-17Tracing fixes and other pointless stuffYorhel1-1/+1
2023-04-05ExtLinks: Add Patreon & SubscribeStar links to releasesYorhel1-2/+8
2023-04-03ExtLinks: add BOOTH links to releasesYorhel1-2/+4
2023-03-30SQL import + devdump fixesYorhel1-1/+1
2023-03-24Search backend changes: faster results with trigram index + rankingYorhel1-13/+22
2023-03-20Also swap staff name/originalYorhel1-7/+7
2023-03-20Swap chars name/original as wellYorhel1-7/+7
2023-03-20Swap producer name/original to be consistent with VN/release titlesYorhel1-5/+5
2023-03-09TitlePrefs: Also apply prefs to character namesYorhel1-1/+9
2023-03-09SQL: Add chars.c_lang cache columnYorhel1-1/+2
2023-02-21Users::Prefs: Separate highlighting from tag&trait overrides + custom color s...Yorhel1-2/+4
2023-02-20Fix staff searchYorhel1-1/+1
2023-02-20Also apply title preferences to staff namesYorhel1-2/+13
2023-02-19Rework passing around entry titles + add proper HTML5 'lang' attrsYorhel1-8/+11
2023-02-04TitlePrefs: Also apply preferences to producer namesYorhel1-2/+8
2023-02-02Refactor part 2: get rid of temporary vnt/releasest viewsYorhel1-8/+23
2023-02-01Refactor: langpref -> titleprefs + use more strict schemaYorhel1-3/+40
2023-01-17API2: Add listwrite permission & list management APIYorhel1-0/+1
2023-01-08Add Cherokee languageYorhel1-1/+1
2022-12-19SQL: Also use MERGE for traits_chars_calc()Yorhel1-1/+2
2022-12-18SQL: Experiment with MERGE to perform in-place updates for tags_vn_calc()Yorhel1-2/+4
2022-12-17SQL: Reorder columns for efficiency + add a few docsYorhel1-91/+103
2022-12-13Add timezone option to user preferencesYorhel1-1/+2
2022-11-29API2: Implement token-based authentication + GET /authinfoYorhel1-2/+4
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 flagYorhel1-9/+15
2022-10-27Chars: add lie flag for traitsYorhel1-1/+4
2022-10-22AdvSearch: Add option to exclude lie tagsYorhel1-1/+2
2022-10-16ExtLinks: Add Playstation (HK) + Nintendo (EN/JP/HK)Yorhel1-2/+10
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-20 13:31:43 +0000