summaryrefslogtreecommitdiff
path: root/util/dump.sql
AgeCommit message (Collapse)AuthorFilesLines
2009-03-28Fixed and re-organized tag<->vn calculationYorhel1-37/+33
Fixed major performance bug caused by referencing the wrong table, moved all intermediate views to tag_vn_calc() as temporary views (similar to update_vnpopularity()) and renamed tags_vn_stored to tags_vn_bayesian.
2009-03-22Fixed tiny SQL bugYorhel1-1/+1
2009-03-22Merge branch 'tagging' into betaYorhel1-5/+174
Conflicts: lib/VNDB/DB/Discussions.pm util/updates/update_2.3.sql
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
This would at least annoy the people who'll try to manipulate the rankings, and will make finding duplicate users a bit easier. (Not that it's really a problem at the moment)
2009-01-10Added VN popularity rankingYorhel1-1/+14
The following query should be run periodically to update the rankings: SELECT update_vnpopularity(); I'll fix Multi::Maintenance to do this automatically.
2009-01-04Added patch flag to releasesYorhel1-2/+4
TODO: update d3 and automatically convert all 'patch' media releases in the DB to use this flag.
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
Because I can't say no to a performance increase of 4 to 7ms for -every- pageview! Makes use of postgresql triggers and stored procedures.
2008-11-11Removed users.flags and used two boolean columns insteadYorhel1-0/+2
I wasn't planning on really touching the database in the rewrite, but oh well, I've always wanted to do this, anyway.
2008-11-11Cached each users change and vote counts in the users tableYorhel1-1/+29
And added triggers to keep these up to date, and made it possible to sort on the change and vote count on the userlist
2008-10-18Added original title field to VN entriesyorhel1-0/+1
git-svn-id: svn://vndb.org/vndb@112 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-27Added release link to screenshotsyorhel1-0/+2
git-svn-id: svn://vndb.org/vndb@103 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Fixed error when creating a new thread, changed type of threads_posts.num to ↵yorhel1-1/+2
smallint, and added (yet another) foreign key constraint to the threads table git-svn-id: svn://vndb.org/vndb@100 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-20Another internal database change: changes.causedby accepts NULL values and ↵yorhel1-1/+2
properly references changes.id git-svn-id: svn://vndb.org/vndb@99 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-18Stored relgraph image maps in the DB, instead of using plain text files in ↵yorhel1-2/+8
/data/rg/ git-svn-id: svn://vndb.org/vndb@93 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-15Converted smallints used as boolean to PostgreSQL's relatively new (8.1) ↵1.21yorhel1-14/+14
boolean type. git-svn-id: svn://vndb.org/vndb@90 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Added screenshots table to store the dimensions of all images, moved to AJAX ↵yorhel1-3/+11
for determining when a thumbnail has been generated after uploading a screenshot, and got rid of the javascript image preloader git-svn-id: svn://vndb.org/vndb@84 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-14Added screenshots (not entirely finished, still needs some tweaking and ↵yorhel1-1/+11
polishing) git-svn-id: svn://vndb.org/vndb@83 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-08-01Added wishlist feature and re-added "my profile" link to user menuyorhel1-0/+10
git-svn-id: svn://vndb.org/vndb@77 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-29- Added release list featureyorhel1-0/+12
- Added noindex tag to iid-ttag browser - Replaced last poster with age of last post on home page - Merged user vote lists into new vnlist - Removed 'hide votes' feature - Fixed users+1 stats bug - Fixed FF3 JS hack - Old VNList code is still present, need to decide what to do with that git-svn-id: svn://vndb.org/vndb@74 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-16Accounts can be deleted, home page now shows age of last post instead of ↵yorhel1-3/+4
user, removed the /u+/pending URL, and small bugfix in dump.sql git-svn-id: svn://vndb.org/vndb@69 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
2008-07-13Added an SQL script to initialize the database needed to run the site, and ↵yorhel1-0/+367
some minor code fixes git-svn-id: svn://vndb.org/vndb@67 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
generated by cgit v1.2.3 (git 2.25.1) at 2024-04-19 08:40:54 +0000