summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
AgeCommit message (Expand)AuthorFilesLines
2015-01-28sql: Merge staff changes into /util/sql/ and rename staff.sql2.24Yorhel1-0/+58
2014-12-02Completely drop l_vnn column from VN infoYorhel1-1/+0
2014-10-15Use scrypt for new password hashesYorhel1-1/+7
2014-10-15SQL: Merge users.(passwd|salt) in one column + document valuesYorhel1-1/+9
2014-10-13SQL: Use enum to represent platformsYorhel1-2/+2
2014-10-11SQL: Convert login_throttle.timeout to a timestamptzYorhel1-1/+1
2014-08-29Throttle failed login attempts (10/day)Yorhel1-0/+6
2013-01-05Screenshot uploader: Load stuff synchronously + removed processing flagYorhel1-1/+0
2012-06-05schema.sql: Fix order of some columns + remove useless DEFAULT NULLYorhel1-4/+4
2012-06-04schema.sql: Fix creation of anime tableYorhel1-2/+2
2012-01-07SQL: Added two indicesYorhel1-0/+2
2011-08-23Added email confirmation to registration processYorhel1-1/+2
2011-04-30Replaced user ranks with a permission systemYorhel1-1/+1
2011-04-29affiliates: +data column, hide hidden links, better browser, Multi fixesYorhel1-1/+2
2011-04-09affiliates: Added very basic support for sponsored "buy now" linksYorhel1-0/+15
2011-03-19chardb: Synchronized DB changes with util/sql/* and dbgraph.plYorhel1-2/+95
2011-02-13chardb: Added notes file and started implementing the traitsYorhel1-1/+1
2011-02-04Added category field to tags (content/ero/technical)Yorhel1-1/+2
2011-01-03SQL: Added tags_vn.ignore column and updated queries to respect thisYorhel1-0/+1
2011-01-02Bugfix: allow a VN to be available for more than 7 platformsYorhel1-1/+1
2010-12-23Converted the notify_announce and notify_dbedit preferencesYorhel1-3/+1
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)Yorhel1-2/+9
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 partYorhel1-0/+12
2010-12-10Keep track of last modification date for tag<->vn linksYorhel1-0/+1
2010-11-28VN Filter Selector: Added "original language" filterYorhel1-1/+2
2010-11-14SQL: Added ON DELETE clause to all foreign keys referencing users (id)Yorhel1-12/+12
2010-11-10Started on adding an "official" flag to vn<->vn relationsYorhel1-0/+1
2010-11-06Synchronised sql/schema.sql with the actual DBYorhel1-1/+2
2010-02-05Notifications: Added 'announce' notificationYorhel1-1/+2
2010-02-05Notifications: Added 'dbedit' notificationYorhel1-1/+2
2010-02-02SQL: Converted language columns to an ENUM typeYorhel1-3/+3
2010-02-01Cache the title and userid of the notificationsYorhel1-1/+4
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 systemYorhel1-3/+15
2010-01-24Versioned the deleting and locking of database entriesYorhel1-1/+3
2010-01-09SQL: Split dump.sql into several files and merged update_2.10.sqlYorhel1-0/+388