summaryrefslogtreecommitdiff
path: root/sql/triggers.sql
AgeCommit message (Expand)AuthorFilesLines
2024-02-24VN::Quotes: Fix removal of final vote + minor guidelines updateYorhel1-1/+1
2024-02-23Expand VN quotes feature a bitYorhel1-0/+16
2022-10-31SQL: Merge ulist_vns_labels into ulist_vns as array + cache private flagYorhel1-7/+4
2021-11-19Use new search for VNs; remove search cache updating from MultiYorhel1-9/+0
2021-11-07Add mod option to set deletion reason for forum postsYorhel1-4/+4
2021-09-26Cache VN length + add to browser UI + reduce max length a bitYorhel1-0/+13
2021-03-23Traits: Convert to vndbids + add edit historyYorhel1-18/+5
2021-03-11Tags: Convert to vndbids + add edit historiesYorhel1-6/+3
2020-11-24SQL: Add workaround for Postgres bug re DISTINCT ON triggers with custom typesYorhel1-1/+1
2020-10-07notifications: Add backend for subscriptions and new notification typesYorhel1-0/+14
2020-10-05notifications: Consolidate and simplify creation of notificationsYorhel1-83/+4
2020-09-05Notifications: Add notifications for thread posts and review commentsYorhel1-1/+58
2020-09-05Notifications: Modernize SQL schemaYorhel1-5/+5
2020-08-31Multi::IRC: Support review ids and notificationsYorhel1-1/+4
2020-08-25SQL/reviews: Two rather stupid fixups on reviews_postsYorhel1-1/+1
2020-08-19reviews: Cache vote & post statsYorhel1-0/+31
2020-08-06Discussions: Allow discontinuous post numbers + ignore hidden posts in counts...Yorhel1-0/+18
2020-08-06SQL: Use vndbid for thread identifiersYorhel1-3/+3
2020-04-25imgflag: Add moderator vote overrulingYorhel1-1/+1
2020-04-16imgflag: Fix uid integrity + properly handle user account deletionYorhel1-1/+2
2020-04-09Stop keeping track of users/threads/posts count cacheYorhel1-26/+2
2020-04-06Delete old relation graph generating and caching machineryYorhel1-42/+0
2020-04-04SQL reorg: Move util/sql/ to sql/ as a top-level dirYorhel1-0/+353