path: root/util/sql/func.sql
AgeCommit message (Expand)AuthorFilesLines
2020-04-04SQL reorg: Move util/sql/ to sql/ as a top-level dirYorhel1-749/+0
2020-03-26imgflag for public: Add link, bias weights to chars, show vote statsYorhel1-3/+9
2020-03-16imgflag: Initial schema + UI for image flaggingYorhel1-0/+67
2020-01-08ulist: Display vote stats for public votes even when "Vote" label is privateYorhel1-5/+6
2019-12-30Minor refactor: Move all trigger functions and declarations to separate fileYorhel1-262/+14
2019-12-27ulists: Update devdump.plYorhel1-13/+13
2019-12-19ulist: Update user list with vnlist/votes/wishlist statsYorhel1-9/+21
2019-12-17ulist: Synchronize changes between rlists and ulist_vnsYorhel1-30/+26
2019-12-16ulist: Convert vn.c_* vote stat updating to use ulist_vns tableYorhel1-13/+29
2019-12-16ulist: Integrate update script into SQL + update notify_listdel()Yorhel1-4/+33
2019-10-07SQL: Improve performance of update_vnpopularity()Yorhel1-15/+12
2019-10-07SQL: Perform incremental updates on traits_chars when characters are editedYorhel1-8/+20
2019-10-07SQL: Perform incremental updates on tags_vn_inherit when tags are modifiedYorhel1-9/+19
2019-10-07SQL: Adjust tag_vn_inherit and trait_chars calculationsYorhel1-48/+41
2019-10-03Disallow changing email address to one already used by another accountYorhel1-2/+2
2019-10-03Require email confirmation when changing email addressYorhel1-6/+24
2019-10-03SQL: Add session types + use sessions for password reset tokensYorhel1-18/+25
2019-10-03SQL: Change sessions.lastused into sessions.expiresYorhel1-8/+5
2019-10-03SQL: Get rid of the users_prefs table, store preferences in users tableYorhel1-3/+3
2019-09-17Don't send db edit notifications for changes made by MultiYorhel1-0/+1
2019-08-15Minor util/sql/ reorganization + Make devdump more robustYorhel1-0/+16
2019-08-09Replace Wikipedia links with Wikidata IDsYorhel1-0/+11
2019-06-28SQL: Use schema-qualified strip_bb_tags() in bb_tsvector()Yorhel1-1/+1
2019-06-26Traits: Split "meta" field into "searchable" and "applicable"Yorhel1-7/+6
2019-06-26Tags: Split "meta" field into "searchable" and "applicable"Yorhel1-6/+6
2018-10-01Lower the average vote requirement for tag spoilers a bitYorhel1-1/+1
2018-09-29Add default spoiler level to tags and use it in spoiler calculationYorhel1-10/+14
2018-02-08Store d+ pages in the DB as versioned entries + use markdownYorhel1-0/+3
2017-12-29SQL: Don't inherit trait/tag childs if parent is mentioned directlyYorhel1-2/+7
2016-11-27SQL: Use separate role for Multi2.26Yorhel1-1/+1
2016-11-27SQL: Use separate role for the website + disallow access to user dataYorhel1-0/+108
2016-07-03Generalize substring search relevance + apply to most dropdown searchesYorhel1-0/+15
2015-10-24Improve several discussion board SQL queriesYorhel1-0/+8
2015-10-21SQL: Fix editing + func.sql + triggers.sql + autocreate editing funcsYorhel1-535/+225
2015-10-12SQL: Split constraints/indices/triggers in new file + use idempotent SQLYorhel1-1/+0
2015-09-07Handler::Discussions: Use ts_headline() to format search resultsYorhel1-1/+7
2015-09-07Implement discussion board search functionYorhel1-0/+6
2015-01-12staff: Add notifications for staff edits/deletesYorhel1-2/+8
2015-01-12staff: Remove some remnants of the staff imagesYorhel1-3/+3
2015-01-04staff: Add some link fields and guidelinesmorkt1-3/+3
2014-12-28More progress on the staff + cast DBmorkt1-1/+6
2014-12-22Initial implementation of a staff/seiyuu databasemorkt1-2/+52
2014-12-02Completely drop l_vnn column from VN infoYorhel1-2/+2
2014-10-13SQL: Use enum to represent platformsYorhel1-2/+3
2014-09-15Change normalization factor in popularity ranking calculationYorhel1-1/+1
2013-01-05Don't use Multi for processing screenshotsYorhel1-7/+0
2013-01-05Don't use Multi for processing character imagesYorhel1-7/+0
2013-01-05Don't use Multi for processing VN cover imagesYorhel1-7/+0
2011-12-29Maintain VN search cache for hidden entries as wellYorhel1-9/+5
2011-05-01Bugfix in update_stats_cache() resulting in a 500Yorhel1-1/+1