path: root/util/dump.sql
AgeCommit message (Expand)AuthorFilesLines
2009-07-19Notify Multi::Image via PostgreSQL for new screenshotsYorhel1-0/+12
2009-07-19Converted and renamed screenshots.status (int) to processed (bool)Yorhel1-1/+1
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/+15
2009-07-18Automatically insert rows into anime table for new vn_anime.aid itemsYorhel1-0/+12
2009-07-18Modified definition of the anime tableYorhel1-7/+7
2009-07-14Removed old and unused table/column definitions from dump.sqlYorhel1-11/+0
2009-07-08Keep track of users who requested tagsYorhel1-1/+3
2009-07-04Implemented support for multilingual releasesYorhel1-4/+12
2009-05-23Animation fields for releasesYorhel1-1/+3
2009-05-23Added freeware and doujin information to releasesYorhel1-1/+3
2009-05-22Voiced field for releasesYorhel1-1/+2
2009-05-22Added resolution field to release entriesYorhel1-1/+2
2009-05-09Don't consider VNs with AVG(vote) < 0 on tag pagesYorhel1-2/+2
2009-03-28Fixed and re-organized tag<->vn calculationYorhel1-37/+33
2009-03-22Fixed tiny SQL bugYorhel1-1/+1
2009-03-22Merge branch 'tagging' into betaYorhel1-5/+174
2009-03-22Incorporated update_2.3.sql into dump.sql and updated the dbgrapher scriptYorhel1-5/+174
2009-02-21Aliases field to producer entriesYorhel1-1/+2
2009-02-12Catalog number field to release entriesYorhel1-1/+2
2009-01-25Random quote featureYorhel1-0/+10
2009-01-10Limit account creation to one account a day per IPYorhel1-1/+2
2009-01-10Added VN popularity rankingYorhel1-1/+14
2009-01-04Added patch flag to releasesYorhel1-2/+4
2008-12-23Fixed syntax error in dump.sqlYorhel1-2/+2
2008-12-23Added skin selector to profile pageYorhel1-0/+1
2008-12-112 Bugfixes with user registrationYorhel1-1/+1
2008-11-29Caching the global database statisticsYorhel1-6/+74
2008-11-11Removed users.flags and used two boolean columns insteadYorhel1-0/+2
2008-11-11Cached each users change and vote counts in the users tableYorhel1-1/+29
2008-10-18Added original title field to VN entriesyorhel1-0/+1
2008-08-27Added release link to screenshotsyorhel1-0/+2
2008-08-20Fixed error when creating a new thread, changed type of threads_posts.num to ...yorhel1-1/+2
2008-08-20Another internal database change: changes.causedby accepts NULL values and pr...yorhel1-1/+2
2008-08-18Stored relgraph image maps in the DB, instead of using plain text files in /d...yorhel1-2/+8
2008-08-15Converted smallints used as boolean to PostgreSQL's relatively new (8.1) bool...1.21yorhel1-14/+14
2008-08-14Added screenshots table to store the dimensions of all images, moved to AJAX ...yorhel1-3/+11
2008-08-14Added screenshots (not entirely finished, still needs some tweaking and polis...yorhel1-1/+11
2008-08-01Added wishlist feature and re-added "my profile" link to user menuyorhel1-0/+10
2008-07-29- Added release list featureyorhel1-0/+12
2008-07-16Accounts can be deleted, home page now shows age of last post instead of user...yorhel1-3/+4
2008-07-13Added an SQL script to initialize the database needed to run the site, and so...yorhel1-0/+367