summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
AgeCommit message (Expand)AuthorFilesLines
2016-11-27SQL: Use separate role for the website + disallow access to user dataYorhel1-4/+1
2016-07-31SQL: Improve trait cache update from 206 to 16 secondsYorhel1-2/+5
2015-11-11Misc poll improvementsYorhel1-25/+20
2015-11-10Merge branch 'master' into pollmorkt1-164/+366
2015-11-01Removed support for sha256-hashed passwordsYorhel1-3/+0
2015-10-25Staff: Add error msg when removing used alias + fix bug in alias editingYorhel1-2/+2
2015-10-21SQL: Fix editing + func.sql + triggers.sql + autocreate editing funcsYorhel1-10/+16
2015-10-18discussion board polls.morkt1-0/+24
2015-10-17SQL: Convert all item-tables to a different schemaYorhel1-156/+355
2015-10-12SQL: Split constraints/indices/triggers in new file + use idempotent SQLYorhel1-92/+0
2015-10-11SQL: Convert producers_rev.type into enumYorhel1-1/+1
2015-09-06SQL: Convert threads_board.type to ENUMYorhel1-1/+1
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