summaryrefslogtreecommitdiff
path: root/util/sql
AgeCommit message (Expand)AuthorFilesLines
2011-02-21chardb: char-by-trait lookup + trait usage count + tag-code sharingYorhel1-1/+35
2011-02-20chardb: Added "group" property to traitsYorhel1-1/+5
2011-02-19chardb: Added blood type + misc. fixes and improvementsYorhel1-2/+2
2011-02-18chardb: Implemented BWH/height/weight fieldsYorhel1-4/+2
2011-02-16chardb: Added image to character entriesYorhel1-0/+7
2011-02-16chardb: Added character add/edit form + misc. fixesYorhel1-5/+5
2011-02-15chardb: Added char entry tables and updated the basic revision frameworkYorhel1-0/+44
2011-02-14chardb: Made Multi aware of traitsYorhel1-1/+3
2011-02-13chardb: Added notes file and started implementing the traitsYorhel1-1/+1
2011-02-07Bugfix: don't generate listdel notify for the user who deletedYorhel1-1/+2
2011-02-04Added category field to tags (content/ero/technical)Yorhel2-1/+3
2011-01-03SQL: Added tags_vn.ignore column and updated queries to respect thisYorhel2-0/+2
2011-01-02SQL: Synchronised the language ENUM with the actual DBYorhel1-1/+1
2011-01-02Bugfix: allow a VN to be available for more than 7 platformsYorhel1-1/+1
2011-01-01More infrastructural changes to accomodate for the permanent filtersYorhel1-1/+1
2010-12-23Converted the notify_announce and notify_dbedit preferencesYorhel3-11/+9
2010-12-23Converted the show_list pref. to users_prefs and inverted the valueYorhel1-1/+0
2010-12-23Converted the show_nsfw preference to use the users_prefs tableYorhel1-1/+0
2010-12-23Added users_prefs table and removed users.(skin|customcss)Yorhel2-2/+10
2010-12-21Added notes field to the user VN listYorhel1-0/+1
2010-12-19SQL: Synchronised the current index definitions with schema.sqlYorhel1-0/+5
2010-12-19RFC-01: Code/DB cleanup and renamed some stuff for consistencyYorhel1-2/+1
2010-12-18RFC-01: Implemented (most) of the SQL partYorhel3-6/+67
2010-12-10Keep track of last modification date for tag<->vn linksYorhel1-0/+1
2010-11-28VN Filter Selector: Added "original language" filterYorhel2-1/+17
2010-11-14SQL: Removed CREATE LANGUAGE plpgsqlYorhel1-3/+0
2010-11-14SQL: Added ON DELETE clause to all foreign keys referencing users (id)Yorhel1-12/+12
2010-11-14SQL: Added WHEN clause to all TRIGGERs for which it was usefulYorhel2-152/+144
2010-11-14Improved performance of update_vnpopularity() on PostgreSQL 9.0Yorhel1-1/+3
2010-11-10Multi::RG: Use dotted line to indicate unofficial status in VN relationsYorhel1-1/+1
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel2-2/+3
2010-11-06Synchronised sql/schema.sql with the actual DBYorhel1-1/+2
2010-03-13Improved VN searchYorhel2-0/+49
2010-02-05Merge branch 'master' into betaYorhel1-2/+2
2010-02-05Notifications: Added 'announce' notificationYorhel3-2/+24
2010-02-05Notifications: Added 'dbedit' notificationYorhel3-4/+44
2010-02-04Notifications: Added notify for deletion of entries in (wish)listYorhel2-3/+38
2010-02-02SQL: Converted language columns to an ENUM typeYorhel3-5/+6
2010-02-02SQL: Improved query in edit_commit()Yorhel1-6/+4
2010-02-01Added notification for database deletions to users who contributedYorhel2-0/+36
2010-02-01SQL: Renamed the hidlock_update trigger namesYorhel1-3/+3
2010-02-01Cache the title and userid of the notificationsYorhel2-3/+6
2010-01-29SQL: Another try at fixing the tag spoiler calculationYorhel1-2/+2
2010-01-26SQL: Replaced sessions.expiration with sessions.addedYorhel1-1/+1
2010-01-26Keep track of when a session has last been usedYorhel1-0/+1
2010-01-26Made a start on the notification systemYorhel3-5/+64
2010-01-24Versioned the deleting and locking of database entriesYorhel3-11/+39
2010-01-23SQL: Don't DROP the temporary edit_* tablesYorhel1-39/+52
2010-01-09SQL: Split dump.sql into several files and merged update_2.10.sqlYorhel3-0/+1005