summaryrefslogtreecommitdiff
path: root/util
AgeCommit message (Expand)AuthorFilesLines
2009-08-12Synchronised a NOT NULL constraint in dump.sql with the actual DBYorhel1-1/+1
2009-08-09Converted changes.added to timestamptzYorhel2-3/+9
2009-08-08Converted tags.added to timestamptzYorhel2-1/+7
2009-08-08Converted users.registered to timestamptzYorhel2-1/+7
2009-08-08Converted votes.date to timestamptz and use NOW() as defaultYorhel2-1/+7
2009-08-08Converted threads_posts.date and edited to timestamptzYorhel2-2/+13
2009-08-08Converted wlists.added and rlists.added to timestamptzYorhel2-3/+14
2009-08-08Convert old category relations to tags and remove vn_categoriesYorhel2-11/+52
2009-08-06Use timestamptz data type instead of timestampYorhel2-4/+4
2009-08-05Removed last traces of the shared memory processing queueYorhel1-8/+0
2009-08-05Multi::IRC: Reimplemented notifications using PgSQL LISTEN/NOTIFYYorhel2-0/+38
2009-07-31Use bytea data type to store session tokensYorhel2-2/+2
2009-07-30Added sessions table to dbgraph.plYorhel1-1/+1
2009-07-30Fixed syntax error in update_2.6.sql and removed leading spaces in dump.sqlYorhel2-4/+4
2009-07-30Merge branch 'auth' of git://3decibels.net/vndb into betaYorhel2-1/+24
2009-07-29Changed sessions.expiration column to timestamp3dB2-5/+5
2009-07-28Multiple bugfixes to authorization system & sql tweaks3dB2-3/+13
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 triggerYorhel2-0/+72
2009-07-20Synchronised dbgraph.pl with the recent DB changesYorhel1-3/+3
2009-07-19Removed DEFERRED property on most foreign key constraintsYorhel2-43/+130
2009-07-19Added 1024x600 and 1600x1200 screen resolutionsYorhel1-1/+6
2009-07-19Notify Multi::Image via PostgreSQL for new screenshotsYorhel2-0/+26
2009-07-19Converted and renamed screenshots.status (int) to processed (bool)Yorhel2-1/+10
2009-07-18Notify Multi::Image for new cover images via LISTEN/NOTIFYYorhel2-0/+26
2009-07-18Use PostgreSQL's LISTEN/NOTIFY to notify Multi::Anime for new animeYorhel2-0/+28
2009-07-18Automatically insert rows into anime table for new vn_anime.aid itemsYorhel2-0/+27
2009-07-18Modified definition of the anime tableYorhel2-7/+42
2009-07-16Made a start on the Multi-rewriteYorhel1-56/+1
2009-07-14Removed old and unused table/column definitions from dump.sqlYorhel1-11/+0
2009-07-08Keep track of users who requested tagsYorhel2-1/+9
2009-07-04Implemented support for multilingual releasesYorhel2-4/+73
2009-06-07Merge branch 'beta'2.4Yorhel2-3/+108
2009-05-31Batch edit releases which are likely to have a doujin or freeware flagYorhel1-0/+53
2009-05-27Fixed typo on 404 pageYorhel1-1/+1
2009-05-23Animation fields for releasesYorhel2-1/+6
2009-05-23Added freeware and doujin information to releasesYorhel2-1/+6
2009-05-22Voiced field for releasesYorhel2-3/+5
2009-05-22Added resolution field to release entriesYorhel2-1/+8
2009-05-09Don't consider VNs with AVG(vote) < 0 on tag pagesYorhel2-2/+35
2009-03-30Tiny bugfix in the tag<->vn calculationYorhel1-1/+1
2009-03-28Fixed and re-organized tag<->vn calculationYorhel2-68/+64
2009-03-22Fixed tiny SQL bugYorhel2-2/+2
2009-03-22Merge branch 'tagging' into betaYorhel3-6/+365
2009-03-22Incorporated update_2.3.sql into dump.sql and updated the dbgrapher scriptYorhel2-6/+176
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