summaryrefslogtreecommitdiff
path: root/util/updates
AgeCommit message (Expand)AuthorFilesLines
2009-09-18Fixed bug with excluding AVG(vote) < 0 VNs from tag pagesYorhel1-0/+33
2009-09-10Batch edit downloadable trial releases to add freeware statusYorhel1-0/+42
2009-08-15Improved VN relationsYorhel1-0/+12
2009-08-12Added global user votes ignore listYorhel1-0/+21
2009-08-09Converted changes.added to timestamptzYorhel1-0/+6
2009-08-08Converted tags.added to timestamptzYorhel1-0/+6
2009-08-08Converted users.registered to timestamptzYorhel1-0/+6
2009-08-08Converted votes.date to timestamptz and use NOW() as defaultYorhel1-0/+6
2009-08-08Converted threads_posts.date and edited to timestamptzYorhel1-0/+11
2009-08-08Converted wlists.added and rlists.added to timestamptzYorhel1-1/+12
2009-08-08Convert old category relations to tags and remove vn_categoriesYorhel1-2/+52
2009-08-06Use timestamptz data type instead of timestampYorhel1-2/+2
2009-08-05Multi::IRC: Reimplemented notifications using PgSQL LISTEN/NOTIFYYorhel1-0/+19
2009-07-31Use bytea data type to store session tokensYorhel1-1/+1
2009-07-30Fixed syntax error in update_2.6.sql and removed leading spaces in dump.sqlYorhel1-2/+2
2009-07-30Merge branch 'auth' of git://3decibels.net/vndb into betaYorhel1-0/+13
2009-07-29Changed sessions.expiration column to timestamp3dB1-3/+3
2009-07-28Multiple bugfixes to authorization system & sql tweaks3dB1-2/+2
2009-07-27Applied small adjustments and reorganized DB library code.3dB1-1/+1
2009-07-24Checkin of auth rewrite progress.3dB1-0/+14
2009-07-23Implemented relgraph notify from PgSQL triggerYorhel1-0/+36
2009-07-19Removed DEFERRED property on most foreign key constraintsYorhel1-0/+89
2009-07-19Added 1024x600 and 1600x1200 screen resolutionsYorhel1-1/+6
2009-07-19Notify Multi::Image via PostgreSQL for new screenshotsYorhel1-0/+14
2009-07-19Converted and renamed screenshots.status (int) to processed (bool)Yorhel1-0/+9
2009-07-18Notify Multi::Image for new cover images via LISTEN/NOTIFYYorhel1-0/+13
2009-07-18Use PostgreSQL's LISTEN/NOTIFY to notify Multi::Anime for new animeYorhel1-0/+13
2009-07-18Automatically insert rows into anime table for new vn_anime.aid itemsYorhel1-0/+15
2009-07-18Modified definition of the anime tableYorhel1-0/+35
2009-07-08Keep track of users who requested tagsYorhel1-0/+6
2009-07-04Implemented support for multilingual releasesYorhel1-0/+61
2009-05-31Batch edit releases which are likely to have a doujin or freeware flagYorhel1-0/+53
2009-05-23Animation fields for releasesYorhel1-0/+3
2009-05-23Added freeware and doujin information to releasesYorhel1-0/+3
2009-05-22Voiced field for releasesYorhel1-2/+3
2009-05-22Added resolution field to release entriesYorhel1-0/+6
2009-05-09Don't consider VNs with AVG(vote) < 0 on tag pagesYorhel1-0/+33
2009-03-30Tiny bugfix in the tag<->vn calculationYorhel1-1/+1
2009-03-28Fixed and re-organized tag<->vn calculationYorhel1-31/+31
2009-03-22Fixed tiny SQL bugYorhel1-1/+1
2009-03-22Merge branch 'tagging' into betaYorhel1-0/+189
2009-03-21Replacing all occurences of 'discussion tags' with 'discussion boards'Yorhel1-0/+5
2009-03-14Separated table for tag aliases + proper checking of unique aliases and namesYorhel1-1/+5
2009-03-14Added tag states for pending/deleted/acceptedYorhel1-13/+7
2009-03-08Added caching of tags_vn_bayesian and the VN count for tagsYorhel1-16/+20
2009-03-08Tag stats on user pages and listYorhel1-0/+32
2009-03-07Hiding spoilers on tag pagesYorhel1-1/+1
2009-03-07Adding list of VNs to tag pagesYorhel1-1/+1
2009-03-01Wrote some SQL magic to fetch a list of VNs related to a tagYorhel1-0/+63
2009-02-22Renaming tags.aliases to tags.aliasYorhel1-1/+1