summaryrefslogtreecommitdiff
path: root/util/updates
AgeCommit message (Expand)AuthorFilesLines
2010-11-14SQL: Added ON DELETE clause to all foreign keys referencing users (id)Yorhel1-0/+135
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-0/+6
2010-11-03Use newlines to separate VN aliasesYorhel1-0/+5
2010-11-01Added Apple iProduct platformYorhel1-0/+1
2010-10-31Added 1024x576 and 1280x800 screen resolutionsYorhel1-0/+5
2010-03-13Improved VN searchYorhel1-0/+9
2010-02-05Notifications: Added 'announce' notificationYorhel1-1/+3
2010-02-05Notifications: Added 'dbedit' notificationYorhel1-1/+6
2010-02-04SQL: Alter the default of sessions.added in the update scriptYorhel1-0/+1
2010-02-04Notifications: Added notify for deletion of entries in (wish)listYorhel1-1/+3
2010-02-02Differentiate between pt-PT and pt-BR in the languagesYorhel1-5/+6
2010-02-02SQL: Converted language columns to an ENUM typeYorhel1-0/+13
2010-02-01Added notification for database deletions to users who contributedYorhel1-4/+8
2010-02-01SQL: Renamed the hidlock_update trigger namesYorhel1-3/+3
2010-02-01Cache the title and userid of the notificationsYorhel1-3/+5
2010-01-26SQL: Replaced sessions.expiration with sessions.addedYorhel1-0/+3
2010-01-26Keep track of when a session has last been usedYorhel1-0/+4
2010-01-26Made a start on the notification systemYorhel1-2/+31
2010-01-24Versioned the deleting and locking of database entriesYorhel1-0/+54
2010-01-09SQL: Split dump.sql into several files and merged update_2.10.sqlYorhel1-357/+17
2010-01-01SQL: Revision insertion abstraction for producer entriesYorhel1-0/+39
2010-01-01SQL: Revision insertion abstraction for release entriesYorhel1-1/+63
2010-01-01SQL: Made a start on revision insertion abstractionYorhel1-0/+110
2009-12-28SQL: Fixed bug in producer_relgraph_notify()Yorhel1-5/+2
2009-12-05SQL: Removed changes.causedbyYorhel1-0/+11
2009-12-05SQL: Call update_vncache() in a triggerYorhel1-1/+16
2009-12-05SQL: Don't allow argument of update_vncache() to be 0Yorhel1-0/+43
2009-12-05SQL: Removed the use of CONSTRAINT TRIGGERsYorhel1-0/+67
2009-11-29SQL: Replace index on tags_vn_inherit (tag) with an index on (tag,vid)Yorhel1-2/+2
2009-11-29Tags: Replaced tag_tree() with WITH .. SELECT queries, and removed /g/debugYorhel1-1/+3
2009-11-29SQL: Rewrote tag_vn_calc() to use a WITH RECURSIVE .. SELECT queryYorhel1-13/+32
2009-11-27Changed VN score on tags pages to display plain averagesYorhel1-0/+38
2009-11-15SQL: Improved performance of update_vnpopularity()Yorhel1-1/+1
2009-11-15SQL: Fixed bug in bayesian rating calculationYorhel1-1/+1
2009-11-14SQL: Allow NULL for vn.c_popularityYorhel1-0/+20
2009-11-14SQL: Don't count users with ign_votes in bayesian ratingYorhel1-2/+2
2009-11-14SQL: Cached bayesian VN rating and vote countsYorhel1-5/+7
2009-11-14Added bayesian rating and vote count to the VN listYorhel1-0/+10
2009-11-14Added wikipedia links for producersYorhel1-0/+4
2009-11-14SQL/L10N: Allow NULL for releases_rev.minage and make the values translatableYorhel1-0/+8
2009-11-02SQL: Fixed another bug with the tags_vn_bayesian.spoiler calculationYorhel1-0/+32
2009-10-24Removed update_rev() function and monthly revcache cronYorhel1-0/+4
2009-10-24Added Spawned <> Originated from producer relationYorhel1-1/+1
2009-10-21SQL: Send relgraph notify when needed for producer entriesYorhel1-0/+25
2009-10-21Added relation graphs for producersYorhel1-0/+1
2009-10-21SQL: Renamed vn_graphs to relgraphs and synced dbgraph.plYorhel1-2/+2
2009-10-21SQL: Synced update_2.8.sql into dump.sqlYorhel1-6/+0
2009-10-21Started on the producer relationsYorhel1-0/+16
2009-10-18SQL: Fixed calculation of tags_vn_bayesian.spoilerYorhel1-0/+34
2009-10-17SQL: Converted releases_rev.type to an ENUM data typeYorhel1-0/+62